Spreadsheet Analysis Using ExcelAt January 1, 2008, the accounting records of Bronco Bouti...

Spreadsheet Analysis Using Excel

At January 1, 2008, the accounting records of Bronco Boutique had the following balances:

During January, Bronco Boutique entered into five cash transactions:

1. Purchased 120 units of inventory @ $16 each.

2. Purchased 160 units of inventory @ $I7 each.

3. Sold 330 units of inventory (a $30 each.

4. Incurred $ 1,700 of operating expenses.

5. Paid income tax at the rate of 30 percent of income before taxes.

Required

a. Set up rows 1 through 10 of the following spreadsheet to compute cost of goods sold and ending inventory, assuming (1) FIFO. (2) LIFO, and (3) weighted-average cost flows. Notice that the FIFO cost flow has already been completed for you. Use columns O through W to complete the LIFO and weighted-average cost flow computations. Be sure to use formulas for all calculations.

b. In rows 13 through 31, compute the amount of net income and net cash flow from operations under FIFO, LIFO, and weighted average. The FIFO column has been provided as an example.