In: Accounting
The Soft Touch Company sells leather furniture. The following schedule relates to the company's inventory for the month of April:
COST SALES
April 1 ---------- Beginning Inventory---------------- 75 units ---------------- $45,000
April 3 ---------- Purchase ------------------------------50 units -----------------$31,250
April 5-----------Sale -------------------------------------30 units-------------------------------------- $33,000
April 11----------Purchase ------------------------------25 units------------------$16,250
April 15 ---------Sale--------------------------------------55 units --------------------------------------$68,750
April 22----------Sale-------------------------------------40 units----------------------------------------$48,000
April 28----------Purchase------------------------------50 units-------------------$33,750
Soft Touch uses the perpetual inventory system
a.) Calculate Soft Touch Company's cost of goods sold, gross margin, and ending inventory using: i.) FIFO ii.) Weighted Average
b.) Which cost formula produced the higher gross margin?
| Please hit LIKE button if this helped. For any further explanation, please put your query in comment, will get back to you. | |||||||||||
| Part 1: | FIFO | ||||||||||
| Purchase | Sale | Ending Inventory | |||||||||
| Date | Units | Rate | Cost | Units | Rate | Cost | Units | Rate | Cost | ||
| Apr 1 | 75 | $600.000 | $45,000.00 | ||||||||
| Apr 3 | 50 | $625.000 | $31,250 | 75 | $600.000 | $45,000.00 | |||||
| 50 | $625.000 | $31,250.00 | |||||||||
| Apr 5 | 30 | $ 600.000 | $ 18,000 | 45 | $600.000 | $27,000.00 | |||||
| 50 | $625.000 | $31,250.00 | |||||||||
| Apr 11 | 25 | $650.000 | $16,250 | 45 | $600.000 | $27,000.00 | |||||
| 50 | $625.000 | $31,250.00 | |||||||||
| 25 | $650.000 | $16,250.00 | |||||||||
| Apr 15 | 45 | $ 600.000 | $ 27,000 | 40 | $625.000 | $25,000.00 | |||||
| 10 | $ 625.00 | $ 6,250 | 25 | $ 650.00 | $16,250.00 | ||||||
| Apr 22 | 40 | $ 625.00 | $ 25,000 | 25 | $ 650.00 | $16,250.00 | |||||
| Apr 28 | 50 | $675.000 | $33,750 | 25 | $ 650.00 | $16,250.00 | |||||
| 50 | $ 675.00 | $33,750.00 | |||||||||
| Total | $76,250.00 | $50,000.00 | |||||||||
| Endning Inventory | $ 50,000.00 | ||||||||||
| COGS | $ 76,250.00 | ||||||||||
| Sales | $ 149,750 | ||||||||||
| Cost of Goods Sold | $ 76,250 | ||||||||||
| Gross Margin | $ 73,500 | ||||||||||
| Part -2 | Weighted Average | ||||||||||
| Purchase | Sale | Ending Inventory | |||||||||
| Date | Units | Rate | Cost | Units | Rate | Cost | Units | Rate | Cost | ||
| Apr 1 | 75 | $600.000 | $45,000.00 | ||||||||
| Apr 3 | 50 | $625.000 | $31,250 | 125 | $610.000 | $76,250.00 | |||||
| Apr 5 | 30 | $ 610.000 | $ 18,300 | 95 | $610.000 | $57,950.00 | |||||
| Apr 11 | 25 | $650.000 | $16,250 | 120 | $618.333 | $74,200.00 | |||||
| Apr 15 | 55 | $ 618.333 | $ 34,008 | 65 | $618.333 | $40,191.67 | |||||
| Apr 22 | 40 | $ 618.333 | $ 24,733 | 25 | $618.333 | $15,458.33 | |||||
| Apr 28 | 50 | $675.000 | $33,750 | 75 | $656.111 | $49,208.33 | |||||
| Total | $ 77,042 | $49,208.33 | |||||||||
| Endning Inventory | $ 49,208.33 | ||||||||||
| COGS | $ 77,041.67 | ||||||||||
| Sales | $ 149,750 | ||||||||||
| Cost of Goods Sold | $ 77,042 | ||||||||||
| Gross Margin | $ 72,708 | ||||||||||