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 in 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 is 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 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 $F$10 Max Radio Spots Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 3 0 1200 150 0 600 97 5 5 0 900 1E 30 0 22 50 600 225 Final Shadow Constraint Allowable Value Price R H Side Increase 5000 45 5000 1500 0 2000 12000 0 1625 12000 3 150 3 5 0 10 20 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 in 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 is 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?

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 $F$10 Max Radio Spots Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 3 0 1200 150 0 600 97.5 5 0 900 1E+30 0 -22.50 600 225 Final Shadow Constraint Allowable Value Price R.H. Side Increase 5000 45 5000 1500 0 2000 12000 -0.1625 12000 3 -150 3 5 0 10 20 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...

3.A 5-kg cart moving to the right with a speed of 6 m/s collides with a concrete wall and rebounds with a speed of 2 m/s. What is the change in momentum of the cart? (a) 0 (b) 40 kg.m/s (c) -40...

Assume you are a CPA working with ABC audit firm. Explain how risk of material misstatement should he assessed and what effect that assessment will have on detection risk for the following audit...

e inherent risk that accounts payable may be omitted or otherwise understated typically is Multiple Choice indeterminate. moderate. high. low. Pley 1 of 1 0 Next

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