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 340 units @ $130 per unit. | |
| 8 | Purchased 435 units @ $140 per unit. | ||
| 12 | Sold 260 units. | ||
| 17 | Sold 130 units. | ||
| 23 | Purchased 110 units @ $160 per unit. | ||
| 25 | Purchased 160 units @ $170 per unit. | ||
| 30 | Sold 110 units. | 
  | 
  | 
  | 
Ending Inventory Units = 340+435-260-130+110+160-110 = 545 units
LIFO Periodic
Ending Inventory
| Date | Activity | Units | Unit Price | Amount | 
| Sep-01 | Beginning Inventory | 340 | $ 130.00 | $ 44,200 | 
| Sep-08 | Purchases | 205 | $ 140.00 | $ 28,700 | 
| Total | 545 | $ 72,900 | 
| Schedule of Cost of Goods Sold | |
| Finished Goods Inventory, Beginning | $ 44,200 | 
| Add: Cost of Goods Manufactured | $ 1,05,700 | 
| Cost of Goods Available for sale | $ 1,49,900 | 
| Deduct : Finished Goods Inventory, Ending | $ 72,900 | 
| Cost of goods sold | $ 77,000 | 
FIFO Perpetual
Sales units = 260+130+110 = 500 units
Cost of Goods Sold
| Date | Activity | Units | Unit Price | Amount | 
| Sep-01 | Beginning Inventory | 340 | $ 130.00 | $ 44,200 | 
| Sep-08 | Purchases | 160 | $ 140.00 | $ 22,400 | 
| Total | 500 | $ 66,600 | 
Ending Inventory
| Date | Activity | Units | Unit Price | Amount | 
| Sep-08 | Purchases | 275 | $ 140.00 | $ 38,500 | 
| Sep-23 | Purchases | 110 | $ 160.00 | $ 17,600 | 
| Sep-25 | Purchases | 160 | $ 170.00 | $ 27,200 | 
| Total | 545 | $ 83,300 | 
LIFO Perpetual
Cost of Goods Sold
| Date | Activity | Units | Unit Price | Amount | 
| Sep-08 | Purchases | 390 | $ 140.00 | $ 54,600 | 
| Sep-25 | Purchases | 110 | $ 170.00 | $ 18,700 | 
| Total | 500 | $ 73,300 |