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

Another question on Mathematics

Mathematics, 21.06.2019 15:30

State whether weight is a function of height for the six students and explain. a. yes, height is a function of weight because two students weigh 165 pounds but have different heights. b. no, height is not a function of weight because two students weigh 165 pounds but have different heights. c. yes, weight is a function of height because for each value of height there is one corresponding value of weight. d. no, weight is not a function of height because there is not enough data to determine a function.

Answers: 1

Answer

Mathematics, 21.06.2019 16:40

Identify an equation in point slope form for the line perpendicular to y=3x+5 that passes through (4,-1)

Answers: 2

Answer

Mathematics, 21.06.2019 19:00

Two times a number plus three times another number equals 4. three times the first number plus four times the other number is 7. find the numbers

Answers: 1

Answer

Mathematics, 21.06.2019 20:30

On a cm grid, point p has coordinates (3,-1) and point q has coordinates (-5,6) calculate the shortest distance between p and q give your answer to 1 decimal place

Answers: 2

Answer

You know the right answer?

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

Questions

Mathematics, 29.07.2021 01:50

Which of the steps will cause the rectangle to map onto itself? A. Reflect across the x-axis, then shift 6 units up B. Reflect across the...

Mathematics, 29.07.2021 01:50

The least-squares regression equation y = 3 + 1.16x can be used to predict the height of a plant (in centimeters) after x weeks. Suppose the height o...

Mathematics, 29.07.2021 01:50

I have a fashion class so if your fashion is really bad or your really bad at art I could give you a class and the class time is really until I see yo...