Mathematics, 12.08.2020 04:01 bobbykemp300

Refer to question. Implement a spreadsheet model for this problem and solve it using Solver. Question

American Auto is evaluating its marketing plan for the sedans, SUVs, and trucks the company produces. A TV ad featuring this SUV has been developed. The company estimates 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 on 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 by 2%, 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 an LP model for this problem.

b. Sketch the feasible region.

c. What is the optimal solution?

Answers: 1

Show answers

Other questions on the subject: Mathematics

Mathematics, 21.06.2019 19:30, sb6998

Michelle and julie work at a catering company. they need to bake 264 cookies for a birthday party that starts in a little over an hour and a half. each tube of cookie dough claims to make 36 cookies, but michelle eats about 1/5 of every tube and julie makes cookies that are 1.5 times as large as the recommended cookie size. it takes about 8 minutes to bake a container of cookies, but since julie's cookies are larger, they take 12 minutes to bake. a. how many tubes should each girl plan to bake? how long does each girl use the oven? b. explain your solution process what did you make? c. what assumptions did you make?

Answers: 1

continue

Mathematics, 21.06.2019 21:00, villanuevajose95

A. s.a.! this is a similarity in right triangles. next (solve for x)a.) 12b.) 5c.) 12.5d.) [tex] 6\sqrt{3} [/tex]

Answers: 2

continue

Mathematics, 21.06.2019 23:00, freebyyy7032

Unaware that 35% of the 10000 voters in his constituency support him, a politician decides to estimate his political strength. a sample of 200 voters shows that 40% support him. a. what is the population? b. what is the parameter of interest? state its value c. what is the statistics of the interest? state its value d. compare your answers in (b) and (c) is it surprising they are different? if the politician were to sample another 200 voters, which of the two numbers would most likely change? explain

Answers: 2

continue

Mathematics, 21.06.2019 23:00, nick974

Eden has a part time job. she is paid ? 7.20 an hour the week she worked 18 and a half hours how much is she paid

Answers: 1

continue

You know the right answer?

Refer to question. Implement a spreadsheet model for this problem and solve it using Solver. Questi...