In: Accounting
During the year, TRC Corporation has the following inventory transactions. Date Transaction Number of Units Unit Cost Total Cost Jan. 1 Beginning inventory 60 $ 52 $ 3,120 Apr. 7 Purchase 140 54 7,560 Jul. 16 Purchase 210 57 11,970 Oct. 6 Purchase 120 58 6,960 530 $ 29,610 For the entire year, the company sells 450 units of inventory for $70 each.
1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
2. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit.
| STATEMENT SHOWING INVENTORY RECORD UNDER PERIODIC FIFO METHOD | |||||||||
| RECIEPTS | COST OF GOODS SOLD | BALANCE | |||||||
| DATE | UNITS | RATE | AMOUNT $ | UNITS | RATE | AMOUNT $ | UNITS | RATE | AMOUNT $ |
| 1-Jan | 60 | 52 | 3120 | 60 | 52 | 3120 | |||
| Purchasse | |||||||||
| 7-Apr | 140 | 54 | 7560 | 140 | 54 | 7560 | |||
| 16-Jul | 210 | 57 | 11970 | 210 | 57 | 11970 | |||
| 6-Oct | 120 | 58 | 6960 | 40 | 58 | 2320 | 80 | 58 | 4640 |
| TOTAL | 530 | 29610 | 450 | 24970 | 80 | 4640 | |||
| STATEMENT SHOWING INVENTORY RECORD UNDER PERIODIC LIFO METHOD | |||||||||
| RECIEPTS | COST OF GOODS SOLD | BALANCE | |||||||
| DATE | UNITS | RATE | AMOUNT $ | UNITS | RATE | AMOUNT $ | UNITS | RATE | AMOUNT $ |
| 1-Jan | 60 | 52 | 3120 | 60 | 52 | 3120 | |||
| Purchasse | |||||||||
| 7-Apr | 140 | 54 | 7560 | 120 | 54 | 6480 | 20 | 54 | 1080 |
| 16-Jul | 210 | 57 | 11970 | 210 | 57 | 11970 | |||
| 6-Oct | 120 | 58 | 6960 | 120 | 58 | 6960 | |||
| TOTAL | 530 | 29610 | 450 | 25410 | 80 | 4200 | |||
| FIFO | LIFO | ||||||||
| Ending inventory | 4640 | 4200 | |||||||
| Cost of goods sold | 24970 | 25410 | |||||||
| Sales revenue (450*70) | 31500 | 31500 | |||||||
| Gross Profit (Sales-COGS) | 6530 | 6090 | |||||||