Marge Manufacturing has the following information available for the month: • Budgeted production is 400,000 units and the firm’s selling price per unit is $25. • Each unit produced is budgeted to require 2 ounces of material B at a cost of $2 per ounce and 0.25 direct labor hours at a cost of $30 per hour
Instead of just giving an answer, it would be great if you can explain how to do it/why
b. How many ounces of material B does the firm plan to purchase during the month?
c. What is the firm’s budgeted breakeven point (in units)?
d. What is budgeted total overhead?
a) For calculating budgeted revenue for the month we need to calculate budgeted sales for the month which is shown as follows:-
Calculation of Budgeted Revenue for the Month (in units)
Beginning Inventory of Finished Goods | 30,000 |
Add: Budgeted Production | 400,000 |
Total units available | 430,000 |
Less: Budgeted Ending Inventory of Finished Goods | 40,000 |
Budgeted Sales in units | 390,000 |
Budgeted Selling price per unit | $25 |
Budgeted Revenue for the Month (390,000 units*$25) | $9,750,000 |
Therefore budgeted revenue for the month is $9,750,000.
b) Total ounces of material required for production = Budgeted production*Ounces required per unit
= 400,000 units*2 ounces = 800,000 ounces
Calculation of material B required to be purchase (in ounces)
Material required for production | 800,000 |
Add: Budgeted Ending Inventory for Material B | 200,000 |
Total material required | 1,000,000 |
Less: Beginning Inventory for Material B | 100,000 |
Material required to purchase | 900,000 |
Therefore 900,000 ounces of material B required to purchase during the month.
c) Budgeted breakeven point (in units) = Total Budgeted Fixed Cost/Budgeted Contribution Margin per unit
Calculation of Total Budgeted Fixed Cost (Amounts in $)
Budgeted Fixed Overhead | 100,000 |
Budgeted Fixed Selling and Administration exp | 500,000 |
Total Budgeted Fixed Cost | 600,000 |
Calculation of Budgeted Contribution Margin per unit (Amounts in $)
Selling Price per unit | 25.00 |
Variable cost per unit: | |
Material B (2 ounces per unit*$2) | (4.00) |
Direct Labor cost (0.25 hrs*$30) | (7.50) |
variable Overhead cost | (3.50) |
Contribution Margin per unit | 10.00 |
Budgeted break even point (in units) = $600,000/10.00 = 60,000 units
Therefore firm's budgeted break even point (in units) is 60,000 units.
d) Total Variable Overhead = Units produced*Variable overhead cost per unit
= 400,000 units*$3.50 = $1,400,000
Budgeted Total Overheads = Fixed Overhead+Variable Overhead
= $100,000+$1,400,000 = $1,500,000
Marge Manufacturing has the following information available for the month: • Budgeted production is 400,000 units...
The following data are given for Harry Company: Budgeted production 1,054 units Actual production 937 units Materials: Standard price per ounce $1.919 Standard ounces per completed unit 11 Actual ounces purchased and used in production 10,616 Actual price paid for materials $21,763 Labor: Standard hourly labor rate $14.76 per hour Standard hours allowed per completed unit 4.3 Actual labor hours worked 4,826 Actual total labor costs $78,423 Overhead: Actual and budgeted fixed overhead $1,025,000 Standard variable overhead rate $24.00 per...
The following data are given for Stringer Company: Budgeted production 909 units Actual production 1,036 units Materials: Standard price per ounce $1.82 Standard ounces per completed unit 12 Actual ounces purchased and used in production 12,805 Actual price paid for materials $26,250 Labor: Standard hourly labor rate $14.95 per hour Standard hours allowed per completed unit 4.4 Actual labor hours worked 5,335.4 Actual total labor costs $81,365 Overhead: Actual and budgeted fixed overhead $1,110,000 Standard variable overhead rate $28.00 per...
Flagstaff Company has budgeted production units of 9,800 for July and 10,000 for August. The direct materials requirement per unit is 3 ounces (oz.). The company has determined that it wants to have safety stock of direct materials on hand at the end of each month to complete 25% of the units of budgeted production in the following 13 month. There was 7,350 ounces of direct material in inventory at the start of July. The total cost of direct materials...
Please prepare a production budget with the following master budget information: Projected unit sales for each quarter for 2013 are as follows: Quarter 1 60,000 Quarter 2 70,000 Quarter 3 80,000 Quarter 4 65,000 The selling price is $500 per unit. All sales are on credit (no cash sales). 70% of all sales are collected within the quarter they are sold. The other 30% are collected in the following quarter. There are no bad debts. There is no beginning inventory...
High End Crockery Corp makes pottery bowls. The following information is available: Budgeted Selling Price $200 each Budgeted Unit Sales December 4,000 January 3,500 February 2,500 March 2,000 April 1,800 Desired ending finished goods inventory 15% of next month's sales Pounds of clay needed per bowl 4 Price per pound of clay $2.50 Desired ending inventory direct materials 30% of next month's production needs December purchases for direct materials $37,525 Direct labor hours per bowl...
Play Now has a budgeted (expected) output of 100,000 sliding boards and an actual output of 90,000 sliding boards. The following data from last year is available:Selling price = $100 per unitStandard direct labor hours per unit = 1 hour per unitActual direct labor cost per unit = 1.1 hours per unit x $11 per hourBudgeted total direct labor cost = $1,000,000Budgeted fixed manufacturing overhead = $1,900,000Actual fixed manufacturing overhead = $2,178,000Budgeted variable manufacturing overhead = $1,000,000Actual variable manufacturing overhead = $940,500Budgeted...
A manufacturing company has budgeted production of 940 units for them. Each unit requires $1.25 in variable overhead cost. The budget fixed cost is $950 per month. The total budgeted overhead costs will be?
Jolly Company has the following budgeted sales in units for the next three months: Budgeted Sales in Units May 2,900 units June 6,300 units July 4,100 units Past experience has shown that the ending finished goods inventory for each month should be equal to 38% of the next month's expected sales in units. Additionally, it is known that every unit produced requires 2.5 direct labor hours to make and Jolly Company pays its direct labor workers $17.50 per hour. Calculate...
Norwall Company's budgeted variable manufacturing overhead cost iS $1.95 per machine-hour and its budgeted fixed manufacturing overhead is $51,336 per month. The following information is available for a recent month: a. The denominator activity of 28,520 machine-hours is used to compute the predetermined overhead rate b. At a denominator activity of 28,520 machine-hours, the company should produce 12,400 units of product. C. The company's actual operating results were Number of units produced Actual machine-hours Actual variable manufacturing overhead cost Actual...
High End Crockery Corp makes pottery bowls. The following information is available: Budgeted Selling Price $200 each Budgeted Unit Sales December 4,000 January 3,500 February 2,500 March 2,000 April 1,800 Desired ending finished goods inventory 15% of next month's sales Pounds of clay needed per bowl 4 Price per pound of clay $2.50 Desired ending inventory direct materials 30% of next month's production needs December purchases for direct materials $37,525 Direct labor hours per bowl...