Contribution Margin Format Example: Volume XX Sales XX Variable Costs (Listed) XX Variable Costs (Total) XX...

Contribution Margin Format Example:

Volume		XX
Sales		XX
Variable Costs (Listed)	XX
Variable Costs (Total)		XX
Contribution Margin		XX
Fixed Costs (Listed)	XX
Fixed Costed (Total)		XX
Operating Income		XX

Vroom-Vroom manufactures ride-on cars for toddlers and young children. They have a fiscal year of January through December. When they were preparing their budget, they couldn’t decide if a static or flexible budget would be best for their company – so they did both. It is now March, and their accounting department is catching up on analyzing variances for both January and February. Vroom-Vroom would like to use this opportunity to determine whether they would be better off with a static or flexible budget going forward. They want to choose which budget and related variance analysis provides them the best information for decision-making.

Monthly Budget Data:

Price per unit	$79	per each
Raw material costs	$27	per each
Packaging costs	$15	per each
Electricity	$4	per each
Waste and other costs	$6	per each
Salary and wage 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

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

Actual results in Jan. and Feb.:

Actual Data	January	February
Production (Units)	245,000	187,000
Revenue (Sales)	$19,345,000	$14,888,000
Raw Materials	$6,545,000	$4,996,000
Packaging Materials	$3,688,000	$2,897,000
Electricity	$975,000	$742,000
Waste and other costs	$1,537,000	$1,242,000
Wages	$560,000	$575,000
Fringe Benefits	$280,000	$287,500
Rent	$750,000	$750,000
Insurance	$52,000	$52,000
Depreciation	$370,000	$340,000

Question: 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 the 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

a & b			Static Budget	Actutual	Difference (Actual - Budgeted)
			January	January
	Volume (Units)		200000	245000
	Sales		15800000	19345000	3545000	Favourable
	Variable cost:
	Raw material cost	5400000		6545000	1145000	Unfavourable
	Pacakage cost	3000000		3688000	688000	Unfavourable
	Electricity expenses	800000		975000	175000	Unfavourable
	Waste and other cost	1200000		1537000	337000	Unfavourable
	Variable Costs (Total)		10400000	12745000
	Contribution Margin		5400000	6600000
	Fixed Costs :
	Salary and wages	560000		560000	0	Unfavourable
	Fringe benefits	280000		280000	0	Unfavourable
	Rent	750000		750000	0	Unfavourable
	Insurance cost	50000		52000	2000	Unfavourable
	Depreciation	370000		370000	0	Unfavourable
	Fixed Costed (Total)		2010000	2012000
	Operating Income		3390000	4588000

c	Raw material
	Price variance	=(actual rate - standard rate) actual qty		Actual rate	=(6545000/245000)
		=(26.71-27)245000			26.71428571
		-71050	favourable
	Reason: Prices of raw material might have reduced due to effective purchasing.

	Volume variance	=(Actual qty - standard qty ) standard rate
		=(245000-200000)27
		1215000	Unfavourable

	Reaoson: More quantity of material consumed

	Packaging cost
	Price variance	=(actual rate - standard rate) actual qty		Actual rate	=(3688000/245000)
		=(15.05-15)245000			15.05306122
		12250	Unfavourable

	Reason: Pirce of packaging might have increased.

	Volume variabce	=(Actual qty - standard qty ) standard rate
		=(245000-200000)15
		675000	Unfavourable

	Reason: More quantity used for per unit production

d			Static Budget	Actutual	Difference (Actual - Budgeted)
			Feb	Feb
	Volume (Units)		200000	187000
	Sales		15800000	14888000	-912000	Unfavourable
	Variable cost:
	Raw material cost	5400000		4996000	-404000	favourable
	Pacakage cost	3000000		2897000	-103000	favourable
	Electricity expenses	800000		742000	-58000	favourable
	Waste and other cost	1200000		1242000	42000	Unfavourable
	Variable Costs (Total)		10400000
	Contribution Margin		5400000	14888000
	Fixed Costs :
	Salary and wages	560000		575000	15000	Unfavourable
	Fringe benefits	280000		287500	7500	Unfavourable
	Rent	750000		750000	0
	Insurance cost	50000		52000	2000	Unfavourable
	Depreciation	370000		340000	-30000	favourable
	Fixed Costed (Total)		2010000	2004500
	Operating Income		3390000	12883500

ekkarill92 answered 2 years ago

Contribution Margin Format Example: Volume &n

Contribution Margin Format Example: Volume XX Sales XX Variable Costs (Listed) XX Variable Costs (Total) XX Contribution Margin XX Fixed Costs (Listed) XX Fixed Costs (Total) XX Operating Income XX Data for all questions: Stuckie produces white school glue. Their glue bottles are primarily sold at department stores across the country. The cost of manufacturing and marketing their glue, at their normal factory volume of 20,000,000 bottles of glue per month, is shown in the table below. Stuckie sells...

1). Contribution Margin is: a). Sales - Total Variable expenses b). Sales - Total variable expenses...

1). Contribution Margin is: a). Sales - Total Variable expenses b). Sales - Total variable expenses - Total fixed expenses c). Sales revenue per unit x Sales quantity d). Variable expense per unit x Sales quantity 2). When preparing segmented income statements fixed expense are separated into the following categories: a). Traceable and common b).Fixed and Variable c).Direct and indirect d).Product and period 3).A Co. reported: Sales $125000; Contribution margin $62000; Total fixed expenses $42000; Common fixed expenses $15000. How...

Question 1: CVP relation Sales volume in units 100 Revenue $7,000 Variable costs $4,000 Contribution margin...

Question 1: CVP relation Sales volume in units 100 Revenue $7,000 Variable costs $4,000 Contribution margin $3,000 Fixed costs $1,800 Profit $1,200 a) Compute the following items: price= unit VC= unit CM= b) Write down the CVP relation. Profit = ___________ * volume - __________ (e.g., if Profit=4*volume-1000, enter 4 in the first box and 1000 in the second box). c) Predict profit at sales volume of 120 units: d) Your boss gave you a profit target...

Contribution Margin Analysis: We calculate contribution margin by taking our sales revenue less our variable costs....

Contribution Margin Analysis: We calculate contribution margin by taking our sales revenue less our variable costs. This basically tells us the portion of our sales that are available to cover the fixed cost of the business. Contribution margin per unit is especially useful. We compute this by taking our sales revenues per unit less our variable cost per unit. With this, we can easily compute our break-even point. Dog Day Care Pricing at $18 per dog per day, you can...

What are the advantages of the contribution margin format based on variable costing compared to the...

What are the advantages of the contribution margin format based on variable costing compared to the traditional format based on full absorption costing?

Please format answer into a table Calculate gross sales, variable costs, and gross margin (profit) for...

Please format answer into a table Calculate gross sales, variable costs, and gross margin (profit) for each product and for an entire company. Calculate break-even sales dollars for a company. Determine the relevant cash flows for a planned asset purchase. Madison Company produces four lines of accessories for major U.S. combine manufacturers. The lines are known by the code letters A, B, C, and D. The current sales mix for Madison Company and the contribution margin ratio for these product...

Sales (10,000units) $ 70,000 Less variable costs (35,000) Contribution margin $ 35,000 Less fixed costs (32,500)...

Sales (10,000units) $ 70,000 Less variable costs (35,000) Contribution margin $ 35,000 Less fixed costs (32,500) Net income $ 2,500 Requirements: 1. Compute Break-even point in units and explain what the number that you calculated means. 2. Compute break-even point in sales volume (in dollar) and explain what the number that you calculated means. 3. How much sales should be in order to earn a before tax profit of $15000.

Total Per Unit Sales $ 318,000 $ 20 Variable expenses 222,600 14 Contribution margin 95,400 $...

Total Per Unit Sales $ 318,000 $ 20 Variable expenses 222,600 14 Contribution margin 95,400 $ 6 Fixed expenses 72,600 Net operating income $ 22,800 Required: 1. What is the monthly break-even point in unit sales and in dollar sales? 2. Without resorting to computations, what is the total contribution margin at the break-even point? 3-a. How many units would have to be sold each month to attain a target profit of $39,600? 3-b. Verify your answer by preparing a...

Contribution Margin Variance, Contribution Margin Volume Variance, Sales Mix Variance Kingston Company provides management services for...

Contribution Margin Variance, Contribution Margin Volume Variance, Sales Mix Variance Kingston Company provides management services for apartments and rental units. In general, Kingston packages its services into two groups: basic and complete. The basic package includes advertising vacant units, showing potential renters through them, and collecting monthly rent and remitting it to the owner. The complete package adds maintenance of units and bookkeeping to the basic package. Packages are priced on a perrental unit basis. Actual results from last year...

Contribution Margin Variance, Contribution Margin Volume Variance, Sales Mix Variance Haysbert Company provides management services for...

Contribution Margin Variance, Contribution Margin Volume Variance, Sales Mix Variance Haysbert Company provides management services for apartments and rental units. In general, Haysbert packages its services into two groups: basic and complete. The basic package includes advertising vacant units, showing potential renters through them, and collecting monthly rent and remitting it to the owner. The complete package adds maintenance of units and bookkeeping to the basic package. Packages are priced on a per-rental unit basis. Actual results from last year...

Question