This is the sum of the beginning inventory and the cost of goods sold for the month of February. The calculation of purchases needs to include ending inventory, as well. Furthermore, the inventory formula is Beginning Inventory + Purchases ? Cost of Sales = Ending Inventory Beginning inventory and cost of goods sold are not summed when using the inventory formula. Cost of goods sold represents the cost of the products that were sold during the period, so that amount is a deduction from inventory. This is the February cost of goods sold. This amount is used in the calculation of the purchases for February, but it is not the February purchases. Beginning and ending inventory for February must also be considered in determining the amount to be purchased during the month. This answer results from using the February ending inventory as the beginning inventory and the beginning inventory as the ending inventory when calculating the amount of purchases. Karmee's objective is to maintain a target inventory equal to 30% of the next month's sales in units. Since we do not have any unit sales information, we must work with data in dollars, instead. This means that beginning inventory in February is expected to be 30% of February's sales and February's ending inventory is expected to be 30% of March's sales. The cost of goods sold averages 40% of sales. The beginning inventory in February is $78,000 (30% × February sales of $650,000 × 40%), and the ending inventory in February is $84,000 (30% × March sales of $700,000 × 40%). The cost of sales is expected to be $260,000 in February (February sales of $650,000 × 40%). Now we can determine the cost of goods purchased using this formula: Beginning Inventory + Purchases ? Cost of Sales = Ending Inventory $78,000 + Purchases ? $260,000 = $84,000 Solving for Purchases, we get Purchases of $266,000.
|