Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Assignment # 4 - CVP Analysis Vice President for Sales and Marketing Sam Totter is trying to plan for the coming year in terms

image text in transcribed Excel Assignment \# 4 - CVP Analysis Vice President for Sales and Marketing Sam Totter is trying to plan for the coming year in terms of production needs to meet the sales demand. He is also trying to determine ways in which the company's profits might be increased in the coming year. Instructions (Do all parts): Northern Illinois Manufacturing markets a simple water control and timer that it massproduces. During last year, the company sold 701,000 units at an average selling price of 4.20 per unit. The variable expenses were $1,857,650 and the fixed expenses were $646,450. 1. What is the product's contribution margin ratio? (Round to nearest whole percentage.) 2. What is the company's break-even point in units and in dollars for this product? 3. What is the margin of safety, both in dollars and as a ratio? What is the company's degree of operating leverage? (Round to nearest whole percentage.) 4. If management wanted to increase its net operating income from this product by 10%, how many additional units would have to be sold to reach this income level? 5. If sales increase by 51,000 units and the cost behaviors do not change, how much will net operating income increase on this product? 6. Northern Illinois' management believes that increased advertising would increase unit sales by 10%. If management wants to increase its operating income by $50,000, how much could the company spend on additional advertising to reach its goal? 7. Using last year's data as the starting point, assume the company can increase sales by 5% by just continuing its current marketing program. What would the company's net operating income by next year using the DOL

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

No Nonsense Project Auditing A Practical Guide For The PMO

Authors: Lisa Nash

1st Edition

0993403522, 978-0993403521

More Books

Students also viewed these Accounting questions