Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,590 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 should all be entered aspositive numbers. 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:
Direct Materials $
Direct Labor
(Click to select)Interest payableInterest expenseManufacturing overheadVariable overheadRent payable

Total variable manufacturing costs $
(Click to select)Add: Fixed manufacturing overheadLess: Fixed manufacturing overheadSalaries expenseDirect materialDepreciation expenses

Total cost of finished goods manufactured $


(Click to select)Selling cost per unitInterest expenseRent payableContribution margin per unitManufacturing cost per unit $



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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Transportation Division Department Of Commerce Report On Preliminary Performance Audit Survey

Authors: Montana. Legislature. Office Of The Legi

1st Edition

1245445294, 978-1245445290

More Books

Students also viewed these Accounting questions

Question

and then

Answered: 1 week ago