Lp problems in a spreadsheet

Assignment Help Business Management

Reference no: EM1366445

LP problems in a spreadsheet

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 estimates 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 in various 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. Format a LP model for this question. 2. What is the optimal solution? Implement a spreadsheet model for this problem and solve it using solver.

Reference no: EM1366445

Questions Cloud

Mission-vision : The plan includes how resources are to be used, when they'll be used, how much in resources are needed, etc. '

Performance management and employee services : Describe the employee programs that have helped this organization make the Top 100 list and explain how the effectiveness of these programs can be measured.

Concept of transparency relate to the crime : How does the concept of transparency relate to the crime of insider trading and please give an example of each

Mentors - questions about job shadowing : Mentors - questions about job shadowing - Describe what you might learn by job shadowing that will make you a stronger candidate to enter the business world.

Lp problems in a spreadsheet : Format a LP model for this question and what is the optimal solution? Implement a spreadsheet model for this problem and solve it using solver.

Sustainable approach towards business : Why might management resist choosing to go green? What reasons might there be for or against utilizing a more sustainable approach towards business?

Multi-factor productivity - dulac box plant : Analyze implications of changes in the parameters of the productivity calculation and evaluate application of productivity concept in terms of the firm's business operational goals and requirements.

Universal studios to design a research study : Whom, within the family, would you interview and what kind of questions would you ask?

Training and development-discuss individual development plan : Research this topic and back up your recommendations for creating and evaluating IDPs and write the full text of your speech as a Word document with citations in APA format.

User Account

All Pages