Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Mercury Bag Company produces cases of grocery bags. The managers at Mercury are

ID: 2518055 • Letter: M

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 been gathered. Projected sales in units Selling price per case Inventory at the beginning of the quarter Target inventory at the end of the quarter Direct labor hours needed to produce one case Direct labor vages Direct materials cost per case Variable manufacturing overhead cost per case Fixed overhead costs for the upcoming quarter 1,990 cases $ 240 150 casers 100 cases 2 hours 10 per hour $220,000 a. Using the above information, develop Mercury's sales forecast in dollars and production schedule in units. s 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? Complete this question by entering your answers in the tabs below Required A Required B Required C Required D Using the above information, develop Mercury's sales forecast in dollars and production schedule in units. Budgeted sales (in dollars) Planned production (cases) Required B

Explanation / Answer

Answer:-1)- Budgeted sales (in dollars):-Projected sales in units*Selling price per case

=1990 cases*$240 per case

=$477600

2)-Planned production (cases):-Budgeted sales unit + Closing inventory at the end of quarter- Inventory at the beginning of the quarter

=1990 cases+ 100 cases- 150 cases

=1940 cases