Question: Using solver, set up Table 9.1 identify your objective, and your constraints The data on quality of exposure in Table 9.1 show that each daytime

Using solver, set up Table 9.1 identify your objective, and your constraints

Using solver, set up Table 9.1 identify your

The data on quality of exposure in Table 9.1 show that each daytime TV (DTV) advertisement is rated at 65 exposure quality units. Thus, an advertising plan with DTV advertisements will provide a total of 65DTV exposure quality units. Continuing with the data in Table 9.1, we find evening TV (ETV) rated at 90 exposure quality units, website banner ads (W) rated at 40 exposure quality units, Sunday newspaper (SN) rated at 60 exposure quality units, and radio (R) rated at 20 exposure quality units. With the objective of maximizing the total exposure quality units for the overall media selection plan, the objective function becomes

(I am aware that i will have to use simplex in order to obtain the sensitivity variable but, i have issues with the steps to take to generate the table and the constraints. thanks from scratch)

there is no data missing. We need to used the given sensitivity and work in reverse to find the original program,

Pretty much, what program would give you this sensitivity report

Figure 9.1 Sensitivity Report for the Relax-and-Enjoy Lake Development Corporation Problem Variable Cell: Allowabl Model Final Reduce Objective Allowable Variable Name Value d Cost Coefficient Increase Decrease DTV Ads Placed DTV 10.000 0.000 65.000 25.000 65.000 EVT Ads Placed ETV 0.000 -65.000 90.000 65.000 1E+30 W Ads Placed W 25.000 16.000 40.000 1E+30 16.000 SN Ads Placed SN 2.000 0.000 60.000 40.000 16.667 R Ads Placed R 30.000 14.000 20.000 1E+30 14.000 Constraints Allowabl Constrain Final Shadow Constraint Allowable t Number Name Value Price R.H. Side Increase Decrease 1 Budget 30000.00 0.060 30000.000 2000.000 2000.000 0 2 Num TV Ads 10.000 -25.000 10.000 1.333 1.333 3 TV Budget 15000.00 0.000 18000.000 1E+30 3000.000 0 4 Customers Reached 61500.00 0.000 50000.000 11500.000 1E+30 0 Figure 9.1 Sensitivity Report for the Relax-and-Enjoy Lake Development Corporation Problem Variable Cell: Allowabl Model Final Reduce Objective Allowable Variable Name Value d Cost Coefficient Increase Decrease DTV Ads Placed DTV 10.000 0.000 65.000 25.000 65.000 EVT Ads Placed ETV 0.000 -65.000 90.000 65.000 1E+30 W Ads Placed W 25.000 16.000 40.000 1E+30 16.000 SN Ads Placed SN 2.000 0.000 60.000 40.000 16.667 R Ads Placed R 30.000 14.000 20.000 1E+30 14.000 Constraints Allowabl Constrain Final Shadow Constraint Allowable t Number Name Value Price R.H. Side Increase Decrease 1 Budget 30000.00 0.060 30000.000 2000.000 2000.000 0 2 Num TV Ads 10.000 -25.000 10.000 1.333 1.333 3 TV Budget 15000.00 0.000 18000.000 1E+30 3000.000 0 4 Customers Reached 61500.00 0.000 50000.000 11500.000 1E+30 0

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!

The optimal value of the objective function is 2370 per Month of an QUESTION 1: LP Formulation and Sensitivity Analysis (24 points) Data for this month's advertising problem for a certain company is...

-Please show work on excel. Thanks :) R. Saltzman DS 412 LP Excel Assignment Operations Management Name Due Date: March 12, 2020 In this assignment, you'll enter the Media Selection Problem below...

D F H Daytime TV DT 0.0 65 C Evening TV ET 0.0 90 Daily Newspaper DN 0.0 40 No times run Exposure quality units G Total Expected EQUS Sunday Newspaper SN 0.0 60 Radio RA 0.0 20 0 RHS 30,000 s 2 s 2 5...

Times New Roman 10 V E [L 2 Wrap Text General V V ilil III Paste BIU V . V E HI V Merge & Center $ % NG A B D E F G L 8 Advertising firm Night & Day, Inc. (NDI) has been hired to conduct an ad...

Data for this months advertising problem for a certain company is described in the table below: Media Type Number of Customers Reached per time unit of an Advertisement Cost ($) per time unit of an...

per Month of an Data for this month's advertising problem for a certain company is described in the table below: Media Type Number of Cost (S) per Maximum Exposure Customers time unit of an Time...

Data for this month's advertising problem for a certain company is described in the table below: Media Type Number of Cost ($) per Maximum Exposure Customers time unit of an Time Quality Units...

Please show step by step with formula (=SUMPRODUCT) in Excel In this assignment, you'll enter the Media Selection Problem below into an Excel worksheet and then use Excel's Solver add-in to optimally...

In this assignment, you'll enter the Media Selection Problem below into an Excel worksheet and then use Excel's Solver add-in to optimally solve the linear program. Additional instructions are given...

Responsibility Center Presentation Imagine you have been selected by your manager to present a training session to a group of new employees. The new hires do not have accounting backgrounds and have...

You can use location based tools to help you find your car or the closest gas station. However, some people see location-based tools as an invasion of privacy. Discuss the pros and cons of...

Evaluate: Society does not need laws outlawing monopolization and monopoly. Inevitably, monopoly causes its own self-destruction since its high profit is the lure for other firms or entrepreneurs to...

Use the letter matrix generated in the previous programming exercise as a starting point for this program. Generate a single random four-by-four letter matrix in which each letter has a 50%...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...