Please, show your work. Mountaineer Company expects to sell 4,000 units for $170
ID: 2456224 • Letter: P
Question
Please, show your work.
Mountaineer Company expects to sell 4,000 units for $170 each for a total of $680,000 in January and 3,200 units for $225 each for a total of $720,000 in February. The company expects cost of goods sold to average 60% of sales revenue, and the company expects to sell 4,700 units in March for $250 each. Mountaineer's target ending inventory is $10,000 plus 60% of the next month's cost of goods sold. Prepare Mountaineer's inventory, purchases, and cost of goods sold budget for January and February.
Mountaineer Company
Inventory, Purchases, and Cost of Goods Sold Budget
Two months Ended January 31 and February 28
January
February
Cost of goods sold
Plus: Desired ending merchandise inventory
Total merchandise inventory required
Less: Beginning merchandise inventory
Budgeted purchases
Please, show your work.
Mountaineer Company
Inventory, Purchases, and Cost of Goods Sold Budget
Two months Ended January 31 and February 28
January
February
Cost of goods sold
Plus: Desired ending merchandise inventory
Total merchandise inventory required
Less: Beginning merchandise inventory
Budgeted purchases
Explanation / Answer
Mountaineer Company Inventory, Purchases, and Cost of Goods Sold Budget Two months Ended January 31 and February 28 January February Marach Sales in units 4,000 3,200 4,700 Sales price $170 $225 $250 Sales in dollars $6,80,000 $7,20,000 $11,75,000 Percentage of cost of goods sold 60% 60% 60% Cost of goods sold 4,08,000 4,32,000 7,05,000 Plus: Desired ending merchandise inventory 2,69,200 4,33,000 Total merchandise inventory required 6,77,200 8,65,000 Less: Beginning merchandise inventory 2,54,800 2,69,200 Budgeted purchases 4,22,400 5,95,800