Please Solve for all images DSS case thank you

DSS for Marketing Mix In this assignment, you will use the Excel Decision Support System to help Lifetime Fitness's marketing management decide how to conduct an effective marketing campaign. The question is: What mix of media should be used to maximize the net income? The decision variables are the number of ad spots for each media type. You will perform three exercises in this assignment: 1. What if analysis. Change the number of ads manually (in the Interface worksheet) and observe the changes in total cost and net income. Note that there are constraints on the variables. Your input must be valid. Find out the net income resulting from each strategy suggested by Lifetime Fitness Center (in the case document). Can you find a strategy that results in more profit than any of those strategies suggested by LFC? 2. Optimization: Use Excel Solver (add-in) to find the optimal solution for this problem. In other words, what is the right mix of number of ads that results in the maximum profit? 3. Goal seeking: Given that the company wants to achieve $400,000 net income, what should be the input values? (Solver, set the Objective to Value of 400,000) Create an answer worksheet in which you list the answers to the three analyses above. Document your analysis in a business memo addressed to Ellen Goldstein, VP of Marketing at LFC. Note that you need to submit both this Excel file with the Excel Solver setup and the memo. DSS for Marketing Mix Strategies (Enter number of ads in column D) Ready ix Accessibility: Investigate DSS for Marketing Mix In this assignment, you will use the Excel Decision Support System to help Lifetime Fitness's marketing management decide how to conduct an effective marketing campaign. The question is: What mix of media should be used to maximize the net income? The decision variables are the number of ad spots for each media type. You will perform three exercises in this assignment: 1. What if analysis. Change the number of ads manually (in the Interface worksheet) and observe the changes in total cost and net income. Note that there are constraints on the variables. Your input must be valid. Find out the net income resulting from each strategy suggested by Lifetime Fitness Center (in the case document). Can you find a strategy that results in more profit than any of those strategies suggested by LFC? 2. Optimization: Use Excel Solver (add-in) to find the optimal solution for this problem. In other words, what is the right mix of number of ads that results in the maximum profit? 3. Goal seeking: Given that the company wants to achieve $400,000 net income, what should be the input values? (Solver, set the Objective to Value of 400,000) Create an answer worksheet in which you list the answers to the three analyses above. Document your analysis in a business memo addressed to Ellen Goldstein, VP of Marketing at LFC. Note that you need to submit both this Excel file with the Excel Solver setup and the memo. DSS for Marketing Mix Strategies (Enter number of ads in column D) Ready ix Accessibility: Investigate