Posted: February 25th, 2021

American auto is 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 estimates   each showing of this commercial will coss $500,000 and increase sales of SUVs   by 3% but reduces sales of trucks by 1% and have no effect of the sales of   sedans. The company also has a print ad campaign developed that it can run in   various nationally distributed magazines at a cost of $750,000 per title. It   is estimated that each magazine title the ad runs in will increase the sales   of sedans, SUVs, and trucks by2 %, 1%, and 4%, respectively. The company   desires to increase sales of sedans, SUVs, and trucks by at least 3%, 14%,   and 4$, respectively, in the least costly manner.      A. Formulate and LP model for   this problem using excel   B. B. What is the optimal   solution    

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price: