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: 2374255 • 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:

  

Prepare Mercury's manufacturing cost budget. (Round your cost per unit answer to 2 decimal places. Omit the "$" sign in your response.)

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.)

  Projected sales in units 1,430 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

Explanation / Answer

Unit to produce

= Projected sales in units + Target inventory at the end of the quarter - Inventory at the beginning of the quarter

= 1430+100-150

= 1380


Direct labor Cost (1380*2*10) 27,600

Direct Material Cost (1380*8) 11,040

Variable manufacturing (1380*6) 8,280

Total variable Cost 46,920

Add: Fixed Manufacturing OVerhead 220,000

Total cost of finished goods manufactured 266,920


Manufacturing Cost Per Unit (266920/1380) 193.42


Ending Inventory Value = (193.42*100) 19,342