Lp problems in a spreadsheetamerican auto is evaluating

Assignment Help Business Management

Reference no: EM13369083

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: EM13369083

Questions Cloud

Mission-visioncan you comment on belowits hard to what to : mission-visioncan you comment on below?its hard to what to do if you dont know where youre going or why. this is why

Important information about performance management and : important information about performance management and employee servicesyou know that many factors affect the overall

How does the concept of transparency relate to the crime of : how does the concept of transparency relate to the crime of insider trading? please give an example of each.please

Mentors - questions about job shadowing1 describe what you : mentors - questions about job shadowing1. describe what you might learn by job shadowing that will make you a stronger

Lp problems in a spreadsheetamerican auto is evaluating : lp problems in a spreadsheetamerican auto is evaluating their marketing plan for the sedans suvs and trucks they

Sustainable approach towards businesswhy might management : sustainable approach towards businesswhy might management resist choosing to go green? what reasons might there be for

Multi-factor productivity - dulac box plantoperations : multi-factor productivity - dulac box plantoperations managementthe dulac box plant produces wooden packaging boxes to

Universal studios to design a research study investigating : universal studios to design a research study investigating how families make vacation decisions.whom within the family

Training and development discuss individual development : training and development discuss individual development plans idpsyou have been asked to speak to your local training

User Account

All Pages