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 16:00

What is the value of x in the diagram below?

Answers: 2

Answer

Mathematics, 21.06.2019 20:00

James is playing his favorite game at the arcade. after playing the game 3 times, he has 8 tokens remaining. he initially had 20 tokens, and the game costs the same number of tokens each time. the number t of tokens james has is a function of g, the number of games he plays. write the function’s formula? t=

Answers: 1

Answer

Mathematics, 21.06.2019 22:20

Which of the following describes how to translate the graph y = |x| to obtain the graph of y = |x+1|+1? shift 1 unit left and 1 unit down shift 1 unit left and 1 unit up shift 1 unit night and 1 unit down shift 1 unit nght and 1 unit up

Answers: 1

Answer

Mathematics, 22.06.2019 01:20

1. why is a frequency distribution useful? it allows researchers to see the "shape" of the data. it tells researchers how often the mean occurs in a set of data. it can visually identify the mean. it ignores outliers. 2. the is defined by its mean and standard deviation alone. normal distribution frequency distribution median distribution marginal distribution 3. approximately % of the data in a given sample falls within three standard deviations of the mean if it is normally distributed. 95 68 34 99 4. a data set is said to be if the mean of the data is greater than the median of the data. normally distributed frequency distributed right-skewed left-skewed

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