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 Show your calculations clearly and provide the number(s) for your answers wherever possible What are the optimal solution and the total exposure represented by the objective function What is the impact on total exposure if we increase the ad budget by 200 units What is the impact on total exposure if we decrease the planning budget by 400 units What is the impact on total exposure if we decrease the planning budget by 600 units 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 What should be the objective function coefficient of Instagram ads so that it can be part of the optimal solution 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 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

The Answer is in the image, click to view ...

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.

What are the optimal solution and the total exposure represented by the objective function?
What is the impact on total exposure if we increase the ad budget by 200 units?
What is the impact on total exposure if we decrease the planning budget by 400 units?
What is the impact on total exposure if we decrease the planning budget by 600 units?
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?
What should be the objective function coefficient of Instagram ads so that it can be part of the optimal solution?
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.
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...

What is a cost management system, and how does it differ from a financial accounting system?

The Shotz Brewery produces an ale, which it stores in barrels in its warehouse and supplies to its distributors on demand. The demand for ale is 1800 barrels per day. The brewery can produce 3000...

Which of the following measures would most Ekely appear in the Leaming and Growth perspective of a company's balanced sconecard? Whaple Croice Arevige training hews per employee Delierey cyde Ene...

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...