In: Accounting
The Boxwood Company sells blankets for $60 each. The following was taken from the inventory records during May. The company had no beginning inventory on May 1.
Date | Blankets | Units | Cost |
May 3 | Purchase | 5 | $30 |
10 | Sale | 3 | |
17 | Purchase | 10 | $34 |
20 | Sale | 6 | |
23 | Sale | 3 | |
30 | Purchase | 10 | $40 |
Assuming that the company uses the perpetual inventory system,
determine the gross profit for the sale of May 23 using the average
inventory cost method.
Solution : | |||||||||||
Average Cost Method | |||||||||||
COST OF GOODS AVAILABLE FOR SALE | COST OF GOODS SOLD | ENDING INVENTORY | |||||||||
Date | Particulars | No. of Units | Cost Per unit | Total | No. of Units | Cost Per unit | Cost of Goods Sold | No. of Units | Cost Per unit | Ending invetory | |
May.03 | Purchases | 5 | $ 30.00 | $150 | 5 | $ 30.00 | $150 | ||||
May.10 | Sales | 3 | $ 30.00 | $90 | 2 | $ 30.00 | $60 | ||||
May.17 | Purchases | 10 | $ 34.00 | $340 | 12 | $ 33.33 | $400 | ||||
May.20 | Sales | 6 | $ 33.33 | $200 | 6 | $ 33.33 | $200 | ||||
May.23 | Sales | 3 | $ 33.33 | $100 | 3 | $ 33.33 | $100 | ||||
May.30 | Purchases | 10 | $ 40.00 | $400 | 13 | $ 38.46 | $500 | ||||
Total / Ending Balance | 25 | $890 | 12 | $390 | 13 | $ 38.46 | $500 | ||||
CALCULATION OF GROSS PROFIT FOR SALE OF MAY 23 | |||||||||||
Sales (3 units X $ 60) | $ 180 | ||||||||||
Less: Cost of Good Sold | $ 100 | ||||||||||
Gross Profit | $ 80 | ||||||||||
Answer = Gross Profit = $ 80 | |||||||||||