Question: There is one problem to be solved. You are not required to submit any answer report or sensitivity report for question. Define your decision variables

There is one problem to be solved. You are not required to submit any answer report or sensitivity report for question. Define your decision variables clearly.

The LP formulation and corresponding Excel Sensitivity Report for a media selection problem are provided below.

T = number of commercials on TV

M = number of advertisements in magazines

R = number of commercials on radio

I = number of advertisements on Instagram

Maximize Exposures = 1200T + 600M + 900R + 600I subject to

300T + 155M + 200R + 160I 5,000 (ad budget)

100T + 45M + 60R + 40I 2,000 (planning budget)

600M + 600I 12,000 (min. requirement of exposure from Magazine and Instagram ads)

T 3 (min TV spots) R 10 (max Radio spots T, M, R, I 0.

There is one problem to be solved. You are not Show your calculations clearly and provide the number(s) for your answers wherever possible.

a. If the objective function coefficient of magazine ads increases by 50 units, will the optimal solution change? What about the value of the objective function?

b. What should be the objective function coefficient of Instagram ads so that it can be part of the optimal solution?

c. We can decrease the exposure requirement by 200 units while increasing the ad budget by 4 units. Is it worth the effort? Find the impact on total exposure.

d. If the objective function coefficient of radio spots decreases by 50 units and the objective function coefficient of magazine ads increases by 40 units, what will be the impact on total exposure?

Variable Cells Cell Name SBS14 Number of TV Spots SCS14 Number of Magazine Ads SDS14 Number of Radio Spots SES14 Number of Instagram Ads Constraints Cell Name SFS6 Ad Budget SFS7 Planning Budget SFS8 Exposure Requirement SFS9 Min TV Spots SFS10 Max Radio Spots Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 3 0 1200 150 20 0 600 97.5 5 0 900 1E+30 0 -22.50 600 22.5 Final Shadow Constraint Allowable Value Price R.H. Side Increase 4.5 0 -0.1625 -150 0 5000 1500 12000 3 5 5000 2000 12000 3 10 1000 1E+30 3870.97 3.33 1E+30 1E+30 22.5 100 1E+30 Allowable Decrease 1000 500 3870.97 3 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

There is one problem to be solved. You are not required to submit any answer report or sensitivity report for question. Define your decision variables clearly. The LP formulation and corresponding...

There is one problem to be solved. You are not required to submit any answer report or sensitivity report for question. Define your decision variables clearly. The Sun Company has three plants (X, Y,...

There is one problem to be solved. Define your decision variables clearly. You are not required to submit any answer report or sensitivity report for any question. Yoda Company produces chairs,...

QUESTION 1 Refer to the Kelson Sporting Equipment problem (Chapter 2, Problem 24 in your textbook). Let R = number of regular gloves C = number of catcher's mitts leads to the following formulation:...

There is one problem to be solved. Define your decision variables clearly. You are not required to submit any answer report or sensitivity report for any question. Emergency room of a hospital is...

There is one problem to be solved. Define your decision variables clearly. You are not required to submit any answer report or sensitivity report for any question. Bambina bakery has two special...

Answer questions after reading the below case carefully. 1. Solve the simple LP problem "Wood Products company manufacturing" using Excel Solver LP Simplex. Submit the Answer Report and Sensitivity...

1) Solve the simple LP problem "Wood Products company manufacturing" using Excel Solver LP Simplex. Submit the Answer Report and Sensitivity Analysis Report available from Solver. Allow the answers...

Red River Hot Tubs manufactures and sells two models of hot tubs: the Aqua-Spa and the Hydro-Lux. Chris Jones, the owner and manager of the company, needs to decide how many of each type of hot tub...

The best thing for users of annual accounts is to steer clear of foreign companies.' Discuss.

Can you think of an explanation for the existence of both the anomalies and efficient markets?

True or false : general ledger accounting systems are software programs that integrate the various accounting functions related to sales, purchases, cash receipts, and payroll

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...