In: Accounting
Inventory information for Part 311 of Bramble Corp. discloses
the following information for the month of June.
| 
 June 1  | 
 Balance  | 
303 units @ $14 | 
 June 10  | 
 Sold  | 
201 units @ $34 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
| 
 11  | 
 Purchased  | 
798 units @ $17 | 
 15  | 
 Sold  | 
498 units @ $35 | |||||
| 
 20  | 
 Purchased  | 
497 units @ $18 | 
 27  | 
 Sold  | 
 299 units @ $38  | 
Assuming that the perpetual inventory method is used and costs are computed at the time of each withdrawal, what is the gross profit if the inventory is valued at FIFO?
| BRAMBLE CORP. | |||||||||
| FIFO METHOD | |||||||||
| Date | Cost of Goods Available for Sale | Cost of Goods Sold | Inventory Balance | ||||||
| Number of Units | Cost per Unit | Cost of Goods Available for Sale | Number of Units Sold | Cost per Unit | Cost of Goods Available for Sale | Number of Units in ending inventory | Cost per Unit | Ending Inventory | |
| Jun-01 | 303 | $ 14 | $ 4,242 | 303 | $ 14 | $ 4,242 | |||
| Jun-10 | 201 | $ 14 | $ 2,814 | 102 | $ 14 | $ 1,428 | |||
| Jun-11 | 798 | $ 17 | $ 13,566 | 102 | $ 14 | $ 1,428 | |||
| 798 | $ 17 | $ 13,566 | |||||||
| Jun-15 | 102 | $ 14 | $ 1,428 | ||||||
| 396 | $ 17 | $ 6,732 | 402 | $ 17 | $ 6,834 | ||||
| Jun-20 | 497 | $ 18 | $ 8,946 | 402 | $ 17 | $ 6,834 | |||
| 497 | $ 18 | $ 8,946 | |||||||
| Jun-27 | 299 | $ 17 | $ 5,083 | 103 | $ 17 | $ 1,751 | |||
| 497 | $ 18 | $ 8,946 | |||||||
| 1295 | $ 26,754 | 998 | $ 16,057 | 600 | $ 10,697 | ||||
Main Answer:
Gross Profit = Sales - Cost of Goods Sold
= $ 35,626 - $ 16,057
=$ 19,569
Cost of Goods Sold = Beginning Inventory Cost + Purchased Cost - Ending Inventory Cost
= $ 4,242 + $ 22,512 - $ 10,697
= $ 16,057
Alternatively,
Cost of Goods Sold = Cost of Goods Available for Sale - Ending Inventory Cost
= $ 26,754 - $ 10,697
= $ 16,057
Working Note:
Total Sales:
| Date | Units | Per Unit | Sales | 
| Jun-10 | 201 | $ 34 | $ 6,834 | 
| Jun-15 | 498 | $ 35 | $ 17,430 | 
| Jun-27 | 299 | $ 38 | $ 11,362 | 
| Total Sales | 998 | $ 35,626 |