American auto is evaluating their marketing plan

Reference no: EM13321791

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

Questions Cloud

Creative in reducing cost and make suggestions : CEO Ben Johnson wants his Executive team to be creative in reducing cost and make suggestions on how to increase profits at the Correctal Company.

Reduce the defection rate : Today, companies are increasingly concerned about customer defection. There are three main steps a company can take to reduce the defection rate. Characterize those three steps.

Use the database for marketing efforts : Assume that a marketing manager of a small company is in the process of implementing the use of a database to assist his or her company in its marketing efforts. Considering the information found in the text, list and describe five ways that the mark..

Compute the manufacturing overhead rate for the year : Edwards Company applies manufacturing overhead to jobs on the basis of machine hours used. Overhead costs are expected to total $1,200,000 for the year, and machine usage is estimated at 200,000 hours.

American auto is evaluating their marketing plan : 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%..

Effective implementation-objective appraisal of resources : In relation to the four characteristics of successful strategies (clear, consistent, long-term objectives; profound understanding of the environment; objective appraisal of resources; and effective implementation), assess the US strategy towards Iraq..

What is lens income tax and use the percentage method : Len Mast earned $3,100 for the last two weeks. He is married, is paid biweekly, and claims 3 exemptions. What is Len’s income tax? Use the percentage method. (Use Table 9.1 and Table 9.2).

Amount imported-consumer surplus and producer surplus : Solve for the amount imported, consumer surplus, and producer surplus. Suppose a per unit tariff of $10 is imposed by the government, solve for the consumer surplus, producer surplus, government revenue and total surplus with the tariff.

Solve for consumer surplus and producer surplus : a. Solve for the new equilibrium quantity (Q**), the sellers price (PS), and the consumer's price (P**). Solve for consumer surplus, producer surplus, government revenue and total surplus with the tax.

User Account

All Pages