In: Accounting
During the month of September 2015, Emily Company had the
following information regarding the buying and selling of its
inventory.
| Sept. | 1 | Beginning inventory of 350 units @ $120 per unit. | |
| 8 | Purchased 425 units @ $130 per unit. | ||
| 12 | Sold 260 units. | ||
| 17 | Sold 140 units. | ||
| 23 | Purchased 100 units @ $150 per unit. | ||
| 25 | Purchased 150 units @ $160 per unit. | ||
| 30 | Sold 100 units. | 
Compute the value of the ending inventory at the end of September
under the FIFO perpetual cost flow assumption. (Do not
use dollar signs ($) when entering amounts. To see comma-formatted
numbers reflected in your final answers, you must enter your
answers with commas.)
| Date | Number of Units | Cost/Unit | Total | |||
| 
 Sept. 1Sept. 8Sept. 12Sept. 17Sept. 23Sept. 25Sept. 30  | 
||||||
| 
 Sept. 1Sept. 8Sept. 12Sept. 17Sept. 23Sept. 25Sept. 30  | 
||||||
| 
 Sept. 1Sept. 8Sept. 12Sept. 17Sept. 23Sept. 25Sept. 30  | 
$ | $ | ||||
| Ending Inventory | $ | 
The value of the ending inventory at the end of September under the FIFO perpetual cost is calculated below:
| Date | Purchase | Sale | Ending Inventory | |
|---|---|---|---|---|
| 2015 | 350 Units* $120 = $42,000 | |||
| Sept.1 | ||||
| Sept. 8 | Purchase | 425 Units*$130 = $55,250 | 350 Units* $120 = $42,000 | |
| 425 Units*$130 = $55,250 | ||||
| Sept.12 | Sale | 260 Units* $120 = $31,200 | 90 Units* $120 = $10,800 | |
| 425 Units*$130 = $55,250 | ||||
| Sept.14 | Sale | 90 Units* $120 = $10,800 | 375 Units*$130 =$ 48,750 | |
| 50 Units*$130 = $6,500 | ||||
| Sept.23 | Purchase | 100 Units* $150= $15,000 | 375 Units*$130 =$ 48,750 | |
| 100 Units* $150= $15,000 | ||||
| Sept.25 | Purchase | 150 Units* $160= $24,000 | 375 Units*$130 =$ 48,750 | |
| 100 Units* $150= $15,000 | ||||
| 150 Units* $160= $24,000 | ||||
| Sept. 30 | Sale | 100 Units* $130 = $13,000 | 275 Units*$130 =$ 35,750 | |
| 100 Units* $150= $15,000 | ||||
| 150 Units* $160= $24,000 | ||||
| Ending Inventory | 525 units = $74,750 | 
Ending Inventory = $74,750
The value of the ending inventory at the end of September under the FIFO perpetual cost is $74,750.