please show work!

Excel Assignment # 4 - CVP Analysis 9 ti lp Summer 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 mass- produces. 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. 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? 2. 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