In: Accounting
Martinez Company uses the gross profit method to estimate inventory for monthly reporting purposes. Presented below is information for the month of May.
Inventory, May 1 | $ 175,600 | |
Purchases (gross) | 617,400 | |
Freight-in | 31,700 | |
Sales revenue | 973,200 | |
Sales returns | 68,100 | |
Purchase discounts | 12,900 |
Part 1
Correct answer iconYour answer is correct.
Compute the estimated inventory at May 31, assuming that the gross profit is 20% of net sales.
The estimated inventory at May 31 |
$enter the dollar amount of the estimated inventory at May 31 |
$87,720 (I got correct, but not part 2)
Part 2
Incorrect answer iconYour answer is incorrect.
Compute the estimated inventory at May 31, assuming that the gross profit is 20% of cost. (Round percentage of sales to 2 decimal places, e.g. 78.74% and final answer to 0 decimal places, e.g. 6,225.)
The estimated inventory at May 31 |
$enter the dollar amount of the estimated inventory at May 31 |
1 | Compute the estimated inventory at May 31, assuming that the gross profit is 20% of net sales. | |||
Cost of Goods sold is computed as follows:- | ||||
Sales revenue | $ 973,200 | |||
Less | Sales returns | $ 68,100 | ||
Net Sales | $ 905,100 | |||
Less: | Gross Profit (20% of net sales) | $ 181,020 | ||
Cost of Goods sold | $ 724,080 | |||
Estimated ending inventory of Finished Goods (May 31) is computed as follows:- | ||||
Beginning inventory of Finished Goods | $ 175,600 | |||
Add: | Net Purchases | |||
Purchases (gross) | $ 617,400 | |||
Add:Freight-in | $ 31,700 | |||
Less:Purchase discounts | $ 12,900 | $ 636,200 | ||
[42] | Cost of Goods available for sale | $ 811,800 | ||
Less: | Cost of Goods sold | $ 724,080 | ||
Estimated ending inventory of Finished Goods (May 31) | $ 87,720 | |||
2 | Compute the estimated inventory at May 31, assuming that the gross profit is 20% of cost. | |||
Gross Profit on cost | 20.00% | |||
Gross Profit on sales (20/(100+20)*100) | 16.67% | |||
Cost of Goods sold is computed as follows:- | ||||
Sales revenue | $ 973,200 | |||
Less | Sales returns | $ 68,100 | ||
Net Sales | $ 905,100 | |||
Less: | Gross Profit (16.67% of net sales) | $ 150,880 | ||
Cost of Goods sold | $ 754,220 | |||
Estimated ending inventory of Finished Goods (May 31) is computed as follows:- | ||||
Beginning inventory of Finished Goods | $ 175,600 | |||
Add: | Net Purchases | |||
Purchases (gross) | $ 617,400 | |||
Add:Freight-in | $ 31,700 | |||
Less:Purchase discounts | $ 12,900 | $ 636,200 | ||
[42] | Cost of Goods available for sale | $ 811,800 | ||
Less: | Cost of Goods sold | $ 754,220 | ||
Estimated ending inventory of Finished Goods (May 31) | $ 57,580 | |||
Feel free to ask any clarification, if required. Kindly provide feedback by thumbs up, if satisfied. It will be highly appreciated. Thank you.