Answer to Question #222545 in Excel for joe

Question

a) Formulate a linear programming model for this problem. EV (10marks)

 

b) Use solver to find optimal solution and sensitivity report.           CR (5marks)

 

c) Management have asked you to determine the optimal solution. Write your answer in a form of a report to be submitted to the management.         AN (5marks)

Advice the management about objective function value corresponding to your answer in (b).           

Answer 1

Let use the following problem as an example:

Number of radio advertisements = 350

Number of TV advertisements = 67

Number of newspaper advertisements = 272

Maximum number of audience per sport by this combination = 86000