Your second project will be Case Study $1$: Planning an Advertising Campaign in Chapter $9$ the textbook. You will read the case study and begin thinking about the questions posed. Then, you will write a case report. Your completed case report should have the following three parts:Executive Summary: This is where you answer the questions of the case. You could do this in paragraph form, with bullet points, or simply by using a$.)$ b$.)$ c$.)$ etc. Note that you are answering the questions listed under the Managerial Report heading in the case. You only need to provide answers to Questions $1,2,4,$ and $5$; you should skip Question $3.$ For Question $5,$ a table allowing you to compare the outcomes of Questions $1$ and $4$ would be a proper way to present your findings.Mathematical Model$($s$)$: Recall that this will require three pieces:Complete descriptions of the decision variablesStatement of the objective functionAll of the constraintsYou only need to list the entire model for Part $1$ of the case. Subsequent parts of the case will require minor adjustments to the base model. You need only list the change$($s$)$ that you made in each part.The Excel Output Sheets: You need to provide the Excel output for the base model $($Part $1).$ You just need to provide the spreadsheet, not an answer report or sensitivity report. You also need to provide the spreadsheet for each change that you make to the model as you work through the case. These sheets should be labeled as Part $2$ and Part $4.$Your final project report should be typed in Microsoft Word or a similar word processing program; no hand$-$written reports will be accepted. Any supporting references $($even from the textbook$)$ should be cited in APA format.