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.