Answer:
1. We have:
Inventory on March 31 = $1,010,625
Cost of merchandise sold for the three-month period = $10,891,875
2. We have:
Inventory on March 31 = $881,250
Cost of merchandise sold for the three-month period = $11,021,250
3. We have:
Inventory on March 31 = $980,975.27
Cost of merchandise sold for the three-month period = $10,921,524.73
4. We have:
Details FIFO LIFO Weighted Average
$ $ $
Sales 19,875,000 19,875,000 19,875,000
Cost of Goods sold <u> (10,891,875) </u> <u> (11,021,250) </u> <u> (10,921,525) </u>
Gross Profit <u> 8,983,125 </u> <u> 8,853,750 </u> <u> 8,953,475 </u>
Inventory, March 31 1,010,625 881,250 980,975
Explanation:
1. Determine the inventory on March 31 and the cost of merchandise sold for the three-month period, using the first-in, first-out method and the periodic inventory system.
Note: See part 1 of the attached excel file for the determined inventory on March 31 and the cost of merchandise sold for the three-month period, using the first-in, first-out method and the periodic inventory system.
From the part 1 of the attached excel file, we have:
Inventory on March 31 = $1,010,625
Cost of merchandise sold for the three-month period = $10,891,875
2. Determine the inventory on March 31 and the cost of goods sold for the three-month period, using the last-in, first-out method and the periodic inventory system.
Note: See part 2 of the attached excel file for the determined inventory on March 31 and the cost of merchandise sold for the three-month period, using the last-in, first-out method and the periodic inventory system.
From the part 2 of the attached excel file, we have:
Inventory on March 31 = $881,250
Cost of merchandise sold for the three-month period = $11,021,250
3. Determine the inventory on March 31 and the cost of goods sold for the three-month period, using the weighted average cost method and the periodic inventory system.
Note: See part 3 of the attached excel file for the determined inventory on March 31 and the cost of merchandise sold for the three-month period, using the weighted average cost method and the periodic inventory system.
From the part 3 of the attached excel file, we have:
Inventory on March 31 = $980,975.27
Cost of merchandise sold for the three-month period = $10,921,524.73
4. Compare the gross profit and the March 31 inventories, using the following column headings.
Details FIFO LIFO Weighted Average
$ $ $
Sales 19,875,000 19,875,000 19,875,000
Cost of Goods sold <u> (10,891,875) </u> <u> (11,021,250) </u> <u> (10,921,525) </u>
Gross Profit <u> 8,983,125 </u> <u> 8,853,750 </u> <u> 8,953,475 </u>
Inventory, March 31 1,010,625 881,250 980,975