Effect of variable cost on planned contribution margin

Reference no: EM1340274

Budget Project

Plan Actual Actual
Sales 1000000 1 1200000 1 800000 1

Variable Costs
Cost of Sales 600000 0.60 720000 0.60 480000 0.60
Commissions 50000 0.05 60000 0.05 40000 0.05
Delivery 10000 0.01 12000 0.01 8000 0.01
Bonus 50000 0.05 60000 0.05 40000 0.05
Total 710000 0.71 852000 0.71 568000 0.71
Contribution Margin 290000 0.29 348000 0.29 232000 0.29

Fixed Costs
Salaries-Management 20000 0.02 20000 0.017 20000 0.025
Salaries-Staff 6667 0.007 6667 0.006 6667 0.008
Advertising 40000 0.04 40000 0.033 40000 0.050
Rent 5000 0.005 5000 0.004 5000 0.006
Total 71667 0.07 71667 0.06 71667 0.09

Net Income 218333 0.22 276333 0.23 160333 0.20

Budget Project Questions

1. What are breakeven sales in dollars for the month of December?

2. What is the margin of safety in dollars?

3. What effect would a 3 percent decrease in variable cost have on planned contribution margin?

4. What effect would a 3 percent increase in selling price have on planned contribution margin?

5. What if any changes would you institute and why if you would, why not if you wouldn't?

Reference no: EM1340274

Questions Cloud

Effects of cold war american culture : What effect did the Cold War have on American culture? What about effects with regard to anti-communism?

Elucidate unequivocally why the foundation of trade : Elucidate unequivocally why the foundation of trade has nothing to do with absolute advantage and only the law of comparative advantage is relevant.

Computing the earned value completed : Compute the earned value completed and the total planned cost for the project at completion.

Nafta was a best decision for the us : If the United States lost hundreds of thousands of jobs, how is it that NAFTA was a best decision for the US also probably not for Mexico and Canada

Effect of variable cost on planned contribution margin : What effect would a 3 percent decrease in variable cost have on planned contribution margin?

A cross between pure red tomato and yellow tomato : Cross between pure red tomato and yellow tomato made all red F1 progeny. From the F2 progeny of 400 plants, 90 were yellow. Hypothesize that a single pair of allele is involved such that Y- = Red and yy = Yellow. Test this hypothesis using Chi squ..

Journalists and construction of history : What is socially/politically compelling about the topic these journalists discuss? What possible solutions do each of these journalists offer?

Characteristic of a defined benefit retirement plan : Determine characteristic of a defined benefit retirement plan.

Explain how do markets determine the payments : Explain how do markets determine the payments to the various factors of production. How do markets determine the distribution of income.

User Account

All Pages