In: Accounting
Widget Tek’s original accountant accepted a position with another firm and left in early March. You have been asked to review the subsidiary inventory ledger record for Widget Tek’s main product for March.
| Date | 
 Inventory  | 
||
|---|---|---|---|
| Quantity | Unit Cost | Total Cost | |
| Mar. 1 | 850 | $98.00 | $83,300 | 
| 1,275 | $95.00 | $121,125 | |
| Mar. 8 | 650 | $98.00 | $63,700 | 
| Mar. 11 | 325 | $98.00 | $31,850 | 
| Mar. 14 | 325 | $98.00 | $31,850 | 
| 780 | $103.00 | $80,340 | |
| Mar. 22 | 260 | $98.00 | $25,480 | 
| Mar. 25 | 260 | $98.00 | $25,480 | 
| 1,600 | $99.00 | $158,400 | |
Study the inventory record for March and answer the questions that follow.
| 1. | Assuming that the product sells for $165 and that 70% of sales are on account, determine the gross profit from sales for March. _____? | 
| 2. | Making the same assumptions as in (1), determine the ending inventory cost for March. $183,880 | 
| 3. | Which inventory method is being used? LIFO | 
| Units Purchased | 6325 | 
| Units Sold | 4465 | 
| Ending Units | 1860 | 
| Calculation of Cost of Goods Sold | |||
| Date | Quantity | Unit Cost | Total Cost | 
| Mar. 1 | 850 | $ 98.00 | $ 83,300.00 | 
| 1275 | $ 95.00 | $ 121,125.00 | |
| Mar. 8 | 650 | $ 98.00 | $ 63,700.00 | 
| Mar. 11 | 325 | $ 98.00 | $ 31,850.00 | 
| Mar. 14 | 325 | $ 98.00 | $ 31,850.00 | 
| 780 | $ 103.00 | $ 80,340.00 | |
| Mar. 22 | 260 | $ 98.00 | $ 25,480.00 | 
| 4465 | $ 437,645.00 | ||
a)
| Calculation of Gross Profit | |||
| Units | Rate | Amount | |
| Sale | 4465 | $ 165.00 | $ 736,725.00 | 
| Less: Cost of Goods Sold | $ 437,645.00 | ||
| Gross Profit | $ 299,080.00 | ||
b)
| Calculation of Ending inventory | |||
| Mar. 25 | 260 | $ 98.00 | $ 25,480.00 | 
| 1600 | $ 99.00 | $ 158,400.00 | |
| 1860 | $ 183,880.00 | ||
c) FIFO method
Dear Student,
Best effort has been made to give quality and correct answer. But if you find any issues please comment your concern. I will definitely resolve your query.