Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SOLVE THIS QUESTION (part a and b) BY EXCEL and provide the formula you use to solve for each part You are a financial analyst
SOLVE THIS QUESTION (part a and b) BY EXCEL and provide the formula you use to solve for each part
You are a financial analyst supporting the marketing organization of your company. You need to provide a forecast to the VP of Sales for his sales plan for next year. Your company relies heavily on advertising spend to drive sales. Build a regression model and provide a nonlinear forecast for the advertising spend (highlighted in yellow) Due to budget constraints the VP of Marketing is asking you for an advertising number is order to support a sales plan of $81250, 000 for 2018. How much in advertising should the VP of Marketing budget for next year? Advertising spend Gross Sales $2, 000, 000 $50000000 S4, 250, 000 $85000, 000 $3, 200, 000 $75000, 000 $2, 800, 000 $63, 250, 000 $2155500 $57, 000, 500 $2, 000, 000 $45000, 000 $1, 857, 500 $35, 000, 000 $2, 005, 000 $42500, 000 $3, 800, 000 $75, 000, 000 $2, 750, 000 $62, 000, 000 $5, 100, 000 $98, 000, 000 $7, 500, 000 $6, 500, 000 S7, 500, 000 S6, 250, 000 S5, 500, 000 $4, 500, 000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started