View the step-by-step solution to:

Case 1 2 3 4 5 Variable Cost per Selling unit Price per Unit $25 $10 $6 $20 $15 $30 $20 $9 Total Contribution Total Margin Units sold 120,000

My calculations keep getting returned from my professor. Can you please fill out the excel and compare with my results so that I can understand what I am doing wrong? I have attached a blank version and a copy with my ansers. Thanks

Case 1 $25 120,000 $720,000 $640,000 2 $10 $6 100,000 $320,000 3 $20 $15 $100,000 $15,000 4 $30 $20 70,000 $12,000 5 $9 80,000 $160,000 $110,000 1a Selling Price $25 1b Total CM $720,000 Var cost $19 Fixed Cost $640,000 CM per unit $6 Profit $80,000 Units sold 120,000 Total CM $720,000 2a Selling Price $10 2b Total CM $400,000 Var cost $6 Fixed Cost $320,000 CM per unit $4 Profit $80,000 Units sold 100,000 Total CM $400,000 3a Selling Price $20 2b Total CM $100,000 Var cost $15 Fixed Cost $85,000 CM per unit $5 Profit $15,000 Units sold 20,000 Total CM $100,000 4a Selling Price $30 4b Total CM $700,000 Var cost $20 Fixed Cost $688,000 CM per unit $10 Profit $12,000 Units sold 70,000 Total CM $700,000 5a Selling Price $11 5b Total CM $160,000 Var cost $9 Fixed Cost $110,000 CM per unit $2 Profit $50,000 Units sold 80,000 Total CM $160,000 Selling Price per Unit Variable Cost per unit Total Units sold Total Contribution Margin Total Fixed Cost Net Income
Background image of page 1
Ssim-Tech has the following information: Current Sales Per Unit Selling Price $257.00 Variable Expenses $152.00 Per Month Fixed Cost per month $33,500.00 Number of units sold 425 $10,000.00 550 520 I expect to see formulas in each of the cells highlighted in yellow. Part A Perform an analysis to determine if the advertising budget should be increased with an expected unit sales of 550. Current Sales Difference Sales $- Variable Expenses $- Contribution Margin $- $- $- Fixed Expenses $- Net Operating Income $- $- $- Should we increase the sales budget? Your answer>>>>>> Part B Perform an analysis to determine if the advertising budget should be increased with an expected unit sales of 520. Current Sales Difference Sales $- Variable Expenses $- Contribution Margin $- $- $- Fixed Expenses $- Net Operating Income $- $- $- Should we increase the sales budget? Your answer>>>>>> Proposed Increase in Advertising budget: Expected number of Units sold if the advertising budget is increased Sales with Increased Advertising Budget Sales with Increased Advertising Budget
Background image of page 2
Show entire document

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question