Units | Unit Price | Total | ||
01-Sep | Beginning Inventory | 120 | 1 | 120 |
10-Sep | Purchase | 150 | 2 | 300 |
15-Sep | Purchase | 180 | 3 | 540 |
17-Sep | Sales | -390 | 5 | -1950 |
20-Sep | Purchase | 195 | 4 | 780 |
26-Sep | Sales | -180 | 6 | -1080 |
28-Sep | Purchase | 210 | 5 | 1050 |
Ending Inventory | 285 |
Total Sales ($) | 3030 |
Total Purchase + Beginning Inventory ($) | 2790 |
FIFO | |||
Ending Inventory ($) | |||
Unit | Unit Price | Total | |
210 | 5 | 1050 | |
75 | 4 | 300 | |
285 | 1350 | ||
Cost of Goods Sold ($) | 1440 | ||
[2790-1350] | |||
Profit ($) | 1590 | ||
(Sales - Cost of Goods Sold] | [3030-1440] |
LIFO : | |||
Ending Inventory ($) | |||
Unit | Unit Price | Total | |
120 | 1 | 120 | |
150 | 2 | 300 | |
15 | 3 | 45 | |
285 | 465 | ||
Cost of Goods Sold ($) | 2325 | ||
[2790-1350] | |||
Profit ($) | 705 | ||
(Sales - Cost of Goods Sold] | [3030-2325] |
Weighted Average: | |
Ending Inventory ($) | |
Total Purchase + Beginning Inventory ($) | 2790 |
Total Purchase + Beginning Inventory (Units) | 855 |
Average Price Per Unit | 3.26 |
Ending Inventory (Units) | 285 |
Ending Inventory ($) | 930 |
Cost of Goods Sold ($) | 1860 |
[2790-930] | |
Profit ($) | 1170 |
(Sales - Cost of Goods Sold] | [3030-1860] |
Anderson Company uses the periodic inventory method and recorded the following purchase sale of inventory during...
Hamilton Company uses a periodic inventory Hamilton Company uses a periodic Inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the flowing information for product Units 1320 Cost 55 Inventory, December 31.pro year For the current year Purchase March 21 Purchase August 1 ventory December 31. Current year 5.120 4 100 Required: Compute ending inventory and cost of goods sold under FIFO UFO, and average contentory costing (Round "Average...
FIFO, LIFO and average cost method in periodic inventory system. Angelo Plc uses a periodic inventory system. The beginning balance of inventory and purchases made by the company during the month of July, 2016 are given below: July 1: Beginning inventory, 500 units @ $20 per unit. July 18: Inventory purchased, 800 units @ $24 per unit. July 25: Inventory purchased, 700 units @ $26 per unit. The company sold 1,400 units during the month of July. Required: Compute inventory...
The Foxworthy Corporation uses a periodic inventory system and the LIFO inventory cost method for its one product. Beginning inventory of 40,000 units consisted of the following, listed in chronological order of acquisition: 24,000 units at a cost of $6.00 per unit = $144,000 16,000 units at a cost of $7.00 per unit =112,000 During 2019, inventory quantity declined by 19,000 units. All units purchased during 2016 cost $8.00 per unit. 1c. Calculate the before-tax LIFO liquidation profit or loss...
Easton Company uses the periodic inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 140 $10 5/5 Purchase 210 $12 5/15 Purchase 340 $14 5/25 Purchase 310 $16 Sales were 480 units at $20. Using the FIFO method, determine the dollar value of Cost of Goods Sold for the month of May.
Easton Company uses the periodic inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 140 $10 5/5 Purchase 210 $12 5/15 Purchase 340 $14 5/25 Purchase 290 $16 Sales were 420 units at $20. Using the FIFO method, determine the dollar value of Cost of Goods Sold for the month of May.
Montoure Company uses a perpetual inventory system. It entered into the following calendar year purchases and sales transactions Units Acquired at Cost Units Sold at Retail 660 units @ $35 per unit 330 units@ $32 per unit 110 units @ $20 per unit Date Activities Jan. 1 Beginning inventory Feb. 10 Purchase Mar. 13 Purchase Mar. 15 Sales Aug. 21 Purchase Sept. 5 Purchase Sept. 10 Sales Totals 760 units @ $75 per unit 180 units @ $40 per unit...
Warnerwoods Company uses a periodic inventory system. It entered into the following purchases and sales transactions for March Date Units Sold at Retail Units Acquired at Cost 135 units @ $70 per unit 435 units @ $75 per unit 455 units @ $105 per unit Activities Mar. 1 Beginning inventory Mar. 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Totals 190 units @ $80 per unit 270 units @ $82 per unit 230 units...
Altira Corporation uses a periodic inventory system. The following information related to its merchandise inventory during the month of August 2016 is available: Aug.1 Inventory on hand—10,500 units; cost $8.80 each. 8 Purchased 30,000 units for $7.50 each. 14 Sold 21,000 units for $14.00 each. 18 Purchased 16,000 units for $7.00 each. 25 Sold 20,000 units for $13.00 each. 31 Inventory on hand—15,500 units. Required: Determine the inventory balance Altira would report in its August 31, 2016, balance sheet and...
hapter 610) Consider the following information for Maynor Company, which uses a periodic inventory system Total Cost Unit Cost $ 60 January 1 March 28 August 22 October 14 Goods Available for Sale Transaction Beginning Inventory Purchase Purchase Purchase 1,320 1.400 $5,220 The company sold 25 units on May 1 and 20 units on October 28 Required: Calculate the company's ending inventory and cost of goods sold using the each of following inventory costing methods. (Round the per unit cost...
1) Easton Company uses the periodic inventory system and had the following inventory & sales activity for the month of May 2019: Date Activity Quantity Unit Price 5/1 Beginning Inventory 120 $10 5/5 Purchase 190 $12 5/15 Purchase 260 $14 5/25 Purchase 270 $16 Sales were 480 units at $20. Using the FIFO method, determine the dollar value of Cost of Goods Sold for the month of May. 2)Easton Company uses the periodic inventory system and had the following inventory &...