Mercury Bag Company produces cases of grocery bags. The managers at Mercury are trying to develop budgets for the upcoming quarter. The following data have been gathered:
Projected sales in units . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1,500 cases
Selling price per case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $300
Inventory at the beginning of the quarter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200 cases
Target inventory at the end of the quarter . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 400 cases
Direct labor hours needed to produce one case . . . . . . . . . . . . . . . . . . . . . . . . 1.5 hours
Direct labor wages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $8 per hour
Direct materials cost per case . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . $15
Variable manufacturing overhead cost per case . . . . . . . . . . . . . . . . . . . . . . . . $5
Fixed overhead costs for the upcoming quarter . . . . . . . . . . . . . . . . . . . . . . . . $294,100
a. Using the above information, develop Mercury's sales forecast in dollars and production schedule in units.
b. What is Mercury's budgeted variable manufacturing cost per case?
c. Prepare Mercury's manufacturing cost budget.
d. What is the projected ending value of the Inventory account?