Question: For ColPal Products in Problem 5, modify the data in the model to create a problem with each of the following. a. alternative optimal solutions

For ColPal Products in Problem 5, modify the data in the model to create a problem with each of the following.

a. alternative optimal solutions

b. an unbounded solution

c. infeasibility

Data from Problem 5

A brand manager for ColPal Products must determine how much time to allocate between radio and television advertising during the next month. Market research has provided estimates of the audience exposure for each minute of advertising in each medium, which it would like to maximize. Costs per minute of advertising are also known, and the manager has a limited budget of $25,000. The manager has decided that because television ads have been found to be much more effective than radio ads, at least 75% of the time should be allocated to television. Suppose that we have the following data:

Type of Ad Radio TV Exposure/Minute 350 800 Cost/Minute $400 $2,000

Step by Step Solution

★★★★★

3.47 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Maximize Exposure Max 350 R 800 T Limited Budget of 25000 ... View full answer

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 Business Analytics Data Questions!

For Valencia Products in Problem 4, modify the data in the model to create a problem with each of the following. a. alternative optimal solutions b. an unbounded solution c. infeasibility Data from...

Suppose a hospital wants to create a database with the star schema structure. What dimensions and facts might it store?

An embedded option associated with each of the following instruments potentially alters the rate sensitivity of the underlying instrument. Indicate when the option is typically exercised and how it...

through c . Maximize Profit = , 1 2 2 L + 1 3 6 S , , 1 7 L + 1 2 S 3 0 0 0 ( C o m p o n e n t A ) , 6 L + 9 S 2 5 0 0 ( C o m p o n e n t B ) , L 0 and S 0 , a . Modify the data in the model to...

13. For ColPal Products in Problem 2, modify the data in the model to create a problem with each of the following a. alternative optimal solutions b. an unbounded solution c. infeasibility

through C . Maximize Profit = 1 2 4 L + 1 3 8 S 1 8 L + 1 3 S 5 0 0 0 ( C o m p o n e n t A ) 6 L + 8 S 4 5 0 0 ( C o m p o n e n t B ) L 0 and S 0 ( Component B a . Modify the data in the model to...

use the same electronic components. Two of these can be obtained only from a single supplier. For the next month, the supply of these is limited to 4,000 of component A and 3,500 of component B. The...

12. For Valencia Products in Problem 1, modify the data in the model to create a problem with each of the following. a. alternative optimal solutions b. an unbounded solution c. infeasibility

Problem 12 Chpt 13: Implement the liner optimization model that you developed cor ColPal Products in problem 5 on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer...

Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the same electronic components. Two of these...

According to a survey by Pew Internet, 79% of teens own an iPod or other MP3 player. If the probability that both a teen and his or her parent own an iPod or other MP3 player is 0.430, what is the...

What are the risks common to financial institutions: liquidity, exchange, underwriting, and operations?

answer this Multiple Select Question Select all that apply The two roles of financial accounting are to: report cost accounting information for internal decisions. measure business activities of the...

Using Confidence Intervals to Test Hypotheses When analyzing the last digits of telephone numbers in Port Jefferson, it is found that among 1000 randomly selected digits, 119 are zeros. If the digits...

It can be argued that regression analysis and DA both use a set of independent variables to predict the value of a dependent variable. What, then, is the difference between regression analysis and DA?

The director of the MBA program at Salterdine University wants to use DA to determine which applicants to admit to the MBA program. The director believes that an applicants undergraduate grade point...

The manager of the commercial loan department for a bank wants to develop a rule to use in determining whether or not to approve various requests for loans. The manager believes that three key...

Charlene is evaluating a capital budgeting project that should last for 4 years. The project requires $200,000 of equipment and is eligible for 100% bonus depreciation, she is unsure whether...

Efrin Inc. currently creates $345,000 of sales from the energy efficient light bulbs. A new campaign is expected to increase next years sales by 8% and the company projects to lower their average...

Money Market Hedge on Receivables Assume that Parker Company will receive 200,000 Canadian dollars in 360 days. Assume the following interest rates: Assume the forward rate of the Canadian dollar is...