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
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
Show entire document

### 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