Question
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
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,290 | cases | |
Selling price per case | $ | 240 | |
Inventory at the beginning of the quarter | 150 | cases | |
Target inventory at the end of the quarter | 100 | cases | |
Direct labor hours needed to produce one case | 2 | hours | |
Direct labor wages | $ | 10 | per hour |
Direct materials cost per case | $ | 8 | |
Variable manufacturing overhead cost per case | $ | 6 | |
Fixed overhead costs for the upcoming quarter | $ | 220,000 | |
a. | Using the above information, develop Mercury's sales forecast in dollars and production schedule in units. (Amounts to be deducted should be indicated with a minus sign. Omit the "$" sign in your response.) |
Sales forecast: | |
Budgeted sales (in cases) | $ |
Selling price per case | |
Budgeted sales (in dollars) | $ |
| |
Production schedule: | |
Budgeted sales (cases) | $ |
Target ending inventory | |
Cases budgeted to be available for sale | |
Less: Beginning inventory | |
Planned production(cases) | $ |
| |
b. | What is Mercury's budgeted variable manufacturing cost per case? (Omit the "$" sign in your response.) |
Total variable cost per case | $ |
c. | Prepare Mercury's manufacturing cost budget. (Round your cost per unit answer to 2 decimal places. Omit the "$" sign in your response.) |
Variable manufacturing costs: | |
$ | |
Total variable manufacturing costs | $ |
Total cost of finished goods manufactured | $ |
| |
$ | |
| |
d. | What is the projected ending value of the Inventory account? (Round intermediate calculations to 2 decimal places and your final answer to the nearest dollar amount. Omit the "$" sign in your response.) |
Ending inventory value | $ |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started