Evaluating their marketing plan for the sedans

Reference no: EM13321829

American auto is evaluating their marketing plan for the sedans,SUVs and trucks they produce. A TV ad featuring this SUV has been developed. The company estimate that each showing of this commercial will cost $500,000 and increase sales of SUVs by 3%,but reduce sales of trucks by 1%,and have no effect of the sales of sedans. The company also has a print ad campaign developed that they can run various in nationally distributed magazines at a cost of $750,000 per title. It is estimated that each magazine title that the ads runs will increase the sale of sedans, SUVs, and trucks by 2%,1%,and 4%,respectivity. The company desires to increase sales of sedans, SUVs, and trucks by at least 3%,14% and 4%, respectably, in the least cost manner. 1.Fomat a LP model for this question. 2. what is the optimal solution? I am trying to Implement a spreadsheet model for this problem and solve it using solver.

Reference no: EM13321829

Questions Cloud

Survey research over traditional survey research : what are the advantages of web based survey research over traditional survey research?

Example of parallel structure : Which of the following is Not an example of parallel structure?

Law versus ethics : Plaintiff-appellant John McGann (McGann) filed this suit under … the Employee Retirement Income Security Act of 1974, [citation] (ERISA), against defendants-appellees H & H Music Company (H &H Music), Brook Mays Music Company (Brook Mays) and General..

Study strategy effectively to self-regulate their learning : Of someone using the ABC Brainstorming study strategy effectively to self-regulate their learning(i.e. what they know about task at hand, their final goals for the task, their choices and usage of the particular strategy, and the monitorvand adapt in..

Evaluating their marketing plan for the sedans : American auto is evaluating their marketing plan for the sedans,SUVs and trucks they produce. A TV ad featuring this SUV has been developed. The company estimate that each showing of this commercial will cost $500,000 and increase sales of SUVs by 3%..

Aggressive role in reshaping the health care system : Should the government take a more aggressive role in reshaping the health care system or should the economy be allowed to continue exerting market-driven reforms?

Religious pluralism and the interfaith movement : What effect do you think religious pluralism and the interfaith movement will have on the future of organized religion?

Naturalist worldview and christian worldview : How would the decision making process regarding money and career differ between someone with a Naturalist Worldview and someone with a Christian Worldview?

Personal learning style : What are the advantages to knowing your personal learning style? How might this improve your academic experience? How might this impact the methods you employ to achieve your personal and professional life purpose?

User Account

All Pages