In: Accounting
Henderson Company uses the gross profit method to estimate
ending inventory and cost of goods sold when preparing monthly
financial statements required by its bank. Inventory on hand at the
end of July was $125,000. The following information for the month
of August was available from company records:
Purchases | $ | 224,000 | |
Freight-in | 5,700 | ||
Sales | 355,000 | ||
Sales returns | 9,500 | ||
Purchases returns | 4,800 | ||
In addition, the controller is aware of $12,000 of inventory that
was stolen during August from one of the company’s
warehouses.
Required:
1. Calculate the estimated inventory at the end of
August, assuming a gross profit ratio of 25%.
2. Calculate the estimated inventory at the end of
August, assuming a markup on cost of 25%.
1 | Beginning Inventory | 125000 | |||
Plus: Net purchases | 219200 | ||||
Freight In | 5700 | ||||
Cost of goods available for sale | 349900 | ||||
Less: Cost of goods sold | |||||
Net sales | 345500 | ||||
Less: Estimated gross profit | 86375 | ||||
Estimated cost of goods sold | 259125 | ||||
Estimated cost of inventory before theft | 90775 | ||||
Less: Stolen Inventory | 12000 | ||||
Estimated ending Inventory | 78775 | ||||
2 | Beginning Inventory | 125000 | |||
Plus: Net purchases | 219200 | ||||
Freight In | 5700 | ||||
Cost of goods available for sale | 349900 | ||||
Less: Cost of goods sold | |||||
Net sales | 345500 | ||||
Less: Estimated gross profit | 69100 | (345500/125)*25 | |||
Estimated cost of goods sold | 276400 | ||||
Estimated cost of inventory before theft | 73500 | ||||
Less: Stolen Inventory | 12000 | ||||
Estimated ending Inventory | 61500 | ||||