Question

In: Accounting

Monthly Budget Data Selling price per Unit $79 per unit Raw Materials Cost $27 per unit...

Monthly Budget Data
Selling price per Unit	$79 per unit
Raw Materials Cost	$27 per unit
Packaging Costs	$15 per unit
Electricity	$4 per unit
Waste and Other Costs	$6 per unit
Salary and Wages Costs	$560,000 per month
Fringe Benefits	50% of salaries
Rent Costs	$750,000 per month
Insurance Costs	$50,000 per month
Depreciation Costs	$370,000 per month

Actual Data	January	February
Production (Units)	245000	187000
Revenue	$ 19,345,000.00	$ 14,888,000.00
Raw Materials	$ 6,545,000.00	$ 4,996,000.00
Package Materials	$ 3,688,000.00	$ 2,897,000.00
Electricity	$ 975,000.00	$ 742,000.00
Waste and Other Costs	$ 1,537,000.00	$ 1,242,000.00
Wages	$ 560,000.00	$ 575,000.00
Fringe Benefits	$ 280,000.00	$ 287,500.00
Rent	$ 750,000.00	$ 750,000.00
Insurance	$ 52,000.00	$ 52,000.00
Depreciation	$ 370,000.00	$ 340,000.00

Vroom-Vroom estimated sales/production will be between 100,000 and 300,000 cars per month. Their static budget is based on 200,000 cars sold per month. Assume that all units produced in a month are also sold in that month. Vroom-Vroom’s unit of production/sale is a car (unit/each).

Prepare a static budget in Excel for Vroom-Vroom based on 200,000 units produced. (36 points)

Show the static budget for January in Contribution Margin Income Statement format.
Compare January’s static budget to January’s actual results. Specify which line items are favorable or unfavorable and how much.
For Raw Material Costs and Packaging Costs, break out the Price and Volume Variances for January. Provide potential explanations for each one. Note: Saying that an item was above or below budget is NOT an explanation. You need to include potential (made-up) reasons.
Show the static budget for February in Contribution Margin Income Statement format.
Compare February’s static budget to February’s actual results. Specify which line items are favorable or unfavorable and how much.
For Raw Material Costs and Packaging Costs, break out the Price and Volume Variances for February. Provide potential explanations for each one. Note: Saying that an item was above or below budget is NOT an explanation. You need to include potential (made-up) reasons.

Expert Solution

Answer : -

Static Budget for 200,000 units

Production ( units)	200,000
Revenue (200,000 * $79 per unit)	$1,58,00,000
Raw material (200,000 * $27 per unit)	($54,00,000)
Packaging cost (2,00,000 * $15)	($30,00,000)
Electricity (2,00,000 * $4 )	($8,00,000)
Waste and other cost(200,000 *$6 per unit)	($12,00,000)
Wages	($5,60,000)
Fringe benefits (50% * $5,60,000)	($2,80,000)
Rent	($7,50,000)
Insurance	($50,000)
Depreciation	($3,70,000)
Profit	$33,90,000

a) January Static budget in Contribution margin income statement format

	January (Budgeted)	Jaunary (Actual)	Variance	Type of variance
Production (units)	2,00,000	2,45,000
Revenue	$1,58,00,000	19,345,000	3,545,000	Favorable
Less : Variable cost (Raw material)	($54,00,000)	($65,45,000)	(11,45,000)	Unfavorable
Package material	($30,00,000)	($36,88,000)	($6,88,000)	Unfavorable
Electricity	($8,00,000)	($9,75,000)	($1,75,000)	Unfavorable
Waste and other costs	($12,00,000)	($15,37,000)	($3,37,000)	Unfavorable
Contribution margin	$54,00,000	$66,00,000	$12,00,000	Favorable
Less: Fixed cost (Salary and wages costs)	($5,60,000)	($5,60,000)	0
Fringe benefits (50% * $5,60,000)	($2,80,000)	($2,80,000)	0
Rent	($7,50,000)	($7,50,000)	0
Insurance	($50,000)	($52,000)	($2,000)	Unfavorable
Depreciation	($3,70,000)	($3,70,000)	0
Profit	$33,90,000	$45,88,000

b.) Break up of Price and Volume variance for Raw material cost and Packging cost

Raw material Price variance = (Actual price - Standard price) * Actual quantity

($26.71 - $27) * 245000 = $70,000 favorable

Raw material Volume variance = (Standard quanity - Actual quantity) * Standard price

($200000 - 245000) * 27 = $12,15,000 Unfavorable

Packging cost Price variance = (15.05306 - 15) * 245000 = $13,000 unfavorable

Packging cost volume variance = (2,00,000 - 2,45,000) * 15 = $6,75,000 unfavorable

c.)

	February (Budgeted)	February (Actual)	Variance	Type of variance
Production (units)	2,00,000	1,87,000
Revenue	$1,58,00,000	$148,88,000	($9,12,000)	Unfavorable
Less : Variable cost (Raw material)	($54,00,000)	($49,96,000)	$4,04,000	Favorable
Package material	($30,00,000)	($28,97,000)	$1,03,000	Favorable
Electricity	($8,00,000)	($7,42,000)	$58,000	Favorable
Waste and other costs	($12,00,000)	($12,42,000)	($42,000)	Unfavorable
Contribution margin	$54,00,000	$50,11,000	$3,89,000	Unfavorable
Less: Fixed cost (Salary and wages costs)	($5,60,000)	($5,75,000)	($15,000)	Unfavorable
Fringe benefits (50% * $5,60,000)	($2,80,000)	($2,87,500)	($7,500)	Unfavorable
Rent	($7,50,000)	($7,50,000)
Insurance	($50,000)	($52,000)	($2,000)	Unfavorable
Depreciation	($3,70,000)	($3,40,000)	$30,000	Favorable
Profit	$33,90,000	$3,00,6500

d.)

Break up of Price and Volume variance for Raw material cost and Packging cost

Raw material Price variance = (Actual price - Standard price) * Actual quantity

Actual price = $49,96,000 / 1,87,000 = $26.72

($26.7165 - $27) *1,87,000 = $53,000 Favorable

Raw material Volume variance = (Standard quanity - Actual quantity) * Standard price

(2,00,000 - 1,87,000) * 27 = $3,51,000 Favorable

Packging cost Price variance =

Acutal price = $28,97,000 / 1,87,000 = $15.49 per unit

($15.49 - $15) * 1,87,000 = $92,000 Unfavorable

Packging cost volume variance = (2,00,000 - 1,87,000 ) * 15 = $1,95,000 Favorable

ekkarill92 answered 2 years ago

Data Selling price per unit $50 Manufacturing costs: Variable per unit produced: Direct materials $11 Direct...

Data Selling price per unit $50 Manufacturing costs: Variable per unit produced: Direct materials $11 Direct labor $6 Variable manufacturing overhead $3 Fixed manufacturing overhead per year $120,000 Selling and administrative expenses: Variable per unit sold $4 Fixed per year $70,000 Year 1 Year 2 Units in beginning inventory 0 Units produced during the year 10,000 6,000 Units sold during the year 8,000 8,000 Enter a formula into each of the cells marked with a ? below Review Problem 1:...

Data: Selling price $275 Manufacturing Cost: Variable per unit produced: Direct materials $104 Direct labor 63...

Data: Selling price $275 Manufacturing Cost: Variable per unit produced: Direct materials $104 Direct labor 63 Variable manufacturing overhead 33 Fixed manufacturing overhead per year $113,400 Selling and Administrative expenses: Variable per unit sold $4 Fixed per year 58,000 Year 1 Year 2 Units in beginning inventory 0 Units produced during the year 2,700 2,100 Units sold during the year 2,300 2,300 1. What is the net operating income (loss) in Year 2 under absorption costing? 2. Make a...

Shah incorporated manufactures a product with a selling price of $50 per unit. unit and monthly...

Shah incorporated manufactures a product with a selling price of $50 per unit. unit and monthly cost data follow:(20POINT) Variable: Selling and administrative $ 0.4 per unit sold Direct material $10 per unit manufacture Direct Laboure $10 per unit manufacture Variable manufacturing overhead $ 5-unit manufacture Fixed: Selling and admirative $ 15000 per month Manufacturing (including depreciation of $10,000) ……30,000 per month The company pays 75% of the bill in the month incurred and 25% in the following month. All...

Sales (in units) 60,000 Selling price per unit $25 Manufacturing costs per unit: Materials 5 Direct...

Sales (in units) 60,000 Selling price per unit $25 Manufacturing costs per unit: Materials 5 Direct labor 4 Overhead Variable 4 Fixed 6 Total $19 Gross margin 6 Selling and admin. Expenses per unit 2 Operating income $4 A company in a foreign market offer to buy and the offer specifies the following data units to be sold 10,000 price per unit $12 The incremental profit should be

Alex Incorporated manufactures a product with a selling price of $50 per unit. Units and monthly...

Alex Incorporated manufactures a product with a selling price of $50 per unit. Units and monthly cost data follow: (20 points) Variable: Selling and administrative . . . . . . . . . . . . . . . . . . $ 0.4 per unit sold Direct materials . . . . . . . . . . . . . . . . . . . . . . . . . . 10 per unit manufactured...

Jacobs Incorporated manufactures a product with a selling price of $55 per unit. Units and monthly...

Jacobs Incorporated manufactures a product with a selling price of $55 per unit. Units and monthly cost data follow: Variable: • Selling and administrative: $4.60 per unit • Direct materials: $15.25 per unit manufactured • Direct labor: $12.50 per unit manufactured • Variable manufacturing overhead: $7.00 per unit manufactured Fixed: • Selling and administrative: $60,000 per month • Manufacturing (including depreciation of $10,000): 45,000 per month Jacobs Incorporated pays all bills in the month incurred. All sales are on account...

A project has the following estimated data: price = $79 per unit; variable costs = $41.87...

A project has the following estimated data: price = $79 per unit; variable costs = $41.87 per unit; fixed costs = $6,900; required return = 9 percent; initial investment = $10,000; life = six years. Ignore the effect of taxes. a. What is the accounting break-even quantity? b. What is the cash break-even quantity? c. What is the financial break-even quantity? d. What is the degree of operating leverage at the financial break-even level of output?

Given the following Selling Price: 50$ per unit Variable Cost: 40$ per unit Fixed Cost: 80,000$...

Given the following Selling Price: 50$ per unit Variable Cost: 40$ per unit Fixed Cost: 80,000$ per unit Calculate: A. Contribution margin as well as the contribution margin ratio B. Profit(loss) if 7,200 units are sold C. Margin of safety if 10,100 units are sold D. Break even point in dollars

Given: the following information Variable cost per unit = $1.25 Selling price per unit = $1.00...

Given: the following information Variable cost per unit = $1.25 Selling price per unit = $1.00 Fixed Cost/Month = $40,000 Solve for: A.) How many units per month must be produced to break-even (Q)? Given: The following information: Variable cost per unit = $1.25 Q = Breakeven quantity units per month solved in part a . Fixed Cost/Month = $40,000 New selling price = ?? (Solve for) Solve for: B.) What should the new selling price must be in order to make...

1 If your variable cost per unit INCREASED, then your A selling price per unit would...

1 If your variable cost per unit INCREASED, then your A selling price per unit would decrease. B break-even units would decrease. C selling price per unit would increase. D break-even units would increase. 2 Which of the following explains the key difference between a traditional income statement and a contribution margin income statement? A Only the traditional income statement can correctly compute net income. B Only the contribution margin income statement can correctly compute net income. C Only the...