FIFO | Cost of Goods Available for Sale | Cost of Goods Sold | Ending Inventory | |||||||
Quantity | Unit Cost | Amount | Quantity | Unit Cost | Amount | Quantity | Unit Cost | Amount | ||
Oct-02 | Purchase | 9600 | $ 13.00 | $ 124,800 | 9600 | $ 13.00 | $ 124,800 | |||
Oct-15 | Purchase | 16000 | $ 15.00 | $ 240,000 | 9600 | $ 13.00 | $ 124,800 | |||
16000 | $ 15.00 | $ 240,000 | ||||||||
Oct-29 | Sales | 9600 | $ 13.00 | $ 124,800 | ||||||
11800 | $ 15.00 | $ 177,000 | 4200 | $ 15.00 | $ 63,000 | |||||
COGS | $ 301,800 | Ending Inventory | $ 63,000 |
Average | Cost of Goods Available for Sale | Cost of Goods Sold | Ending Inventory | |||||||
Quantity | Unit Cost | Amount | Quantity | Unit Cost | Amount | Quantity | Unit Cost | Amount | ||
Oct-02 | Purchase | 9600 | $ 13.00 | $ 124,800 | 9600 | $ 13.00 | $ 124,800 | |||
Oct-15 | Purchase | 16000 | $ 15.00 | $ 240,000 | 25600 | $ 14.25 | $ 364,800 | |||
21400 | $ 14.25 | $ 304,950 | 4200 | $ 14.25 | $ 59,850 | |||||
COGS | $ 304,950 | Ending Inventory | $ 59,850 |
FIFO | Average | |
Sales | $ 523,000 | $ 523,000 |
Cost of Goods Sold | $ 301,800 | $ 304,950 |
Gross Profit | $ 221,200 | $ 218,050 |
Operating Expenses | $ 191,000 | $ 191,000 |
Income before income tax | $ 30,200 | $ 27,050 |
Income tax expense (30%) | $ 9,060 | $ 8,115 |
Net Income | $ 21,140 | $ 18,935 |
(1) Currently as shown in (a) above, FIFO results in a higher net income than the average cost formula. This is anticipated when the costs are increasing. If instead costs are decreasing, the use of FIFO cost formula will result in lower net income compared to average cost.
If costs remain stable, the two cost formulas will produce same net incomes
Ayayai Inc. is trying to determine whether to use the FIFO or average cost formula. The...
Concord Limited uses the FIFO cost formula in a perpetual inventory system. Fill in the missing amounts for items [1] to [18] in the following perpetual inventory schedule: (Round all answers to nearest whole dollar e.g 5,212.) Your answer is partially correct. Try again. Concord Limited uses the FIFO cost formula in a perpetual inventory system. Fill in the missing amounts for items [1] to (18) in the following perpetual inventory schedule: (Round all answers to nearest whole dollar e.g...
Brief Exercise 6-5 Martinez Limited uses the average cost formula in a perpetual inventory system. Fill in the missing amounts for items [1] to [13] in the following perpetual inventory schedule. (Round per unit cost and total cost to 2 decimal places, e.g. 15.23.) Balance Cost of Goods Sold Purchases Total Cost Units Total Cost Total Units Cost Units Date $2,580 $172 15 April 1 [3] $ [4] $ 28 1] [2] $5,404 [8] $ 25 [5] [9] $ [71...
Splish Brothers Inc. had a beginning inventory of 135 units of Product RST at a cost of $7 per unit. During the year, purchases were: Feb.20 650 units at $8 May 5 500 units at $9 Aug, 12 420 units at $10 Dec.8 135 units at $11 Splish Brothers uses a periodic inventory system. Sales totaled 1,520 units. Determine the cost of goods available for sale. The cost of goods available for sale $ 16330 Calculate Average Cost. (Round answer...
Date Explanation Units Unit Cost Total Cost June 1 Inventory 123 $ 615 Purchases 2,106 Purchases 1,358 Inventory Calculate weighted average unit cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted average unit cost $ e Textbook and Media Compute the cost of the ending inventory and the cost of goods sold under FIFO, LIFO, and average-cost. (Round answers to 0 decimal places, e.g. 125.) FIFO LIFO Average-cost The cost of the ending inventory The cost of goods sold
Kingbird, Inc. had a beginning inventory of 105 units of Product RST at a cost of $7 per unit. During the year, purchases were: Feb. 20 May 5 670 units at $8 505 units at $9 Aug, 12 Dec. 8 490 units at $10 105 units at $11 Kingbird uses a periodic inventory system. Sales totaled 1,500 units. Your answer is correct. Determine the cost of goods available for sale. The cost of goods available for sale $ 16695 Calculate...
Question B, please. Marigold Inc. uses a perpetual inventory system. Its records show the following for the month of May. Unit Total Date Explanation Units Cost Cost May 1 Inventory 29 $9 $261 May 15 Purchase 24 10 240 May 18 Sale (49) May 24 Purchase 38 11 418 Total 42 $919 42 $919 Your answer is correct. Calculate the cost of goods sold for May and the ending inventory at May 31 using the FIFO formula. Cost of goods...
Oriole Company had a beginning inventory of 115 units of Product RST at a cost of $7 per unit. During the year, purchases were: Feb. 20 660 units at $8 Aug. 12 430 units at $10 May 5 520 units at $9 Dec. 8 115 units at $11 Oriole uses a periodic inventory system. Sales totaled 1,600 units. Determine the cost of goods available for sale. The cost of goods available for sale $ Calculate Average Cost. (Round answer to...
Determine cost of goods sold and ending inventory using FIFO, LIFO, and average-cost with analysis. Financial Accounting, 8th Edition by Weygandt, Kieso, and Kimmel Primer on Using Microsoft Excel in Accounting by Rex A Schildhouse Problem: Doom's Day Distribution markets CDs of the performing artist Marilynn. At...
Compute the cost assigned to ending inventory using (a) FIFO, (b) LIFO, (c) weighted average, and (d) specific identification. For specific identification, units sold consist of 600 units from beginning inventory, 380 from the February 10 purchase, 120 from the March 13 purchase, 130 from the August 21 purchase, and 205 from the September 5 purchase. (Round your average cost per unit to 2 decimal places.) Montoure Company uses a perpetual inventory system. It entered into the following calendar-year purchases...
help me find FIFO and LIFO and AVERAGE COST in part B2 Problem 6-3A (Part Level Submission) Windsor, Inc. had a beginning inventory on January 1 of 120 units of Product 4-18-15 at a cost of $22 per unit. During the year, the following purchases were made. Mar. 15 July 20 320 units 200 units at at $25 $26 Sept. 4 Dec. 2 280 units 80 units at at $28 $31 800 units were sold. Windsor, Inc. uses a periodic...