A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 440 units. Ending inventory at January 31 totals 170 units.
Required:
Assume the perpetual inventory system is used and then determine the costs assigned to ending inventory when costs are assigned
based on the FIFO method.
Calculation of Ending Inventory: FIFO | ||||||||||
Date | Goods Purchased | Cost of Goods Sold | Inventory Balance | |||||||
Units | PU | Total Cost | Units | PU | Total Cost | Units | PU | Total Cost | ||
Beginning Inventory | 400 | 3.9 | 1560 | |||||||
09-Jan | 90 | 4.1 | 369 | 400 | 3.9 | 1560 | ||||
90 | 4.1 | 369 | ||||||||
1929 | ||||||||||
25-Jan | 120 | 4.2 | 504 | 400 | 3.9 | 1560 | ||||
90 | 4.1 | 369 | ||||||||
120 | 4.2 | 504 | ||||||||
2433 | ||||||||||
26-Jan | 400 | 3.90 | 1560 | 50 | 4.10 | 205 | ||||
40 | 4.10 | 164 | 120 | 4.2 | 504 | |||||
Totals | 610 | 2433 | 440 | 1,724 | 170 | 709 | ||||
Date | Goods Purchased | Cost of Goods Sold | Inventory Balance | ||||||
1/1 | 380 | @ $3.70 = | $ | 1,406 | |||||
1/9 | 90 @ $3.90 | 380 | @ $3.70 | ||||||
90 | @ $3.90 = | $ | 1,757 | ||||||
1/25 | 120 @ $4.00 | 380 | @ $3.70 | ||||||
90 | @ $3.90 | ||||||||
120 | @ $4.00 = | $ | 2,237 | ||||||
1/26 | 380 | @ $3.70 = | $ | 1,406 | 50 | @ $3.90 | |||
40 | @ $3.90 = | 156 | 120 | @ $4.00 = | $ | 675 | |||
$ | 1,562 | ||||||||
A company reports the following beginning inventory and two purchases for the month of January.
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 420 units. Ending inventory at January 31 totals 170 units. Beginning inventory on January 1 Purchase on January 9 Purchase on January 25 Units 380 90 120 Unit Cost $ 3.70 3.90 4.00 Required: Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the FIFO method. Required: Assume...
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 250 units. Ending inventory at January 31 totals 130 units. Units Unit Cost Beginning inventory on January 1 230 $ 2.00 Purchase on January 9 50 2.20 Purchase on January 25 100 2.34 Required: Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the FIFO method. Perpetual FIFO:
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 310 units. Ending inventory at January 31 totals 130 units. Units Unit Cost Beginning inventory on January 1 280 $ 2.60 Purchase on January 9 60 2.80 Purchase on January 25 100 2.94 Required: Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the FIFO method.
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 330 units. Ending inventory at January 31 totals 140 units. Units Unit Cost Beginning inventory on January 1 300 $ 2.80 Purchase on January 9 70 3.00 Purchase on January 25 100 3.14 Required: Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the FIFO method.
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 420 units. Ending inventory at January 31 totals 170 units. Units Unit Cost Beginning inventory on January 1 380 $ 3.70 Purchase on January 9 90 3.90 Purchase on January 25 120 4.00 Required: Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the weighted average method. (Round...
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 300 units. Ending inventory at January 31 totals 130 units. Beginning inventory on January 1 Purchase on January 9 Purchase on January 25 Units 270 60 100 Unit Cost $ 2.50 2.70 2.84 Required: Assume the perpetual inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the FIFO method. Perpetual FIFO:...
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 450 units. Ending inventory at January 31 totals 245 units. Units Unit Cost Beginning inventory on January 1 400 $ 3.00 Purchase on January 9 120 5.00 Purchase on January 25 175 4.00 rev: 10_22_2018_QC_CS-142492 Required: Assume the perpetual inventory system is used and then determine the costs assigned to ending inventory when costs are assigned based on...
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 430 units. Ending inventory at January 31 totals 170 units. Required: Assume the periodic inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the LIFO method. A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 430 units. Ending inventory...
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 330 units. Ending inventory at January 31 totals 140 units. Units Unit Cost Beginning inventory on January 1 300 $ 2.80 Purchase on January 9 70 3.00 Purchase on January 25 100 3.14 Required: Assume the periodic inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the FIFO method.
A company reports the following beginning inventory and two purchases for the month of January. On January 26, the company sells 450 units. Ending inventory at January 31 totals 170 units. Assume the periodic inventory system is used. Determine the costs assigned to ending inventory when costs are assigned based on the weighted average method. (Round per unit costs to 3 decimal places. Amounts to be deducted should be indicated with a minus sign.) A company reports the following beginning...