Constraints in simple verbal expressions

Assignment Help Business Economics
Reference no: EM133064252

1. 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 70% of the time should be
allocated to television.

Suppose that we have the following data:

a. Identify the decision variables, objective function, and constraints in simple verbal expressions.

b. Mathematically formulate a linear optimization model.

2. Implement the linear optimization model that you developed for ColPal Products in Excel and use Solver to find an optimal solution.

3. Ensure that the number of minutes of each type of ad are integer valued. How much
difference is there between the optimal integer solution and the linear optimization solution? Would rounding the continuous solution have provided the optimal integer solution?

Reference no: EM133064252

Questions Cloud

Hedge economic or translation exposure : 1. There is an advantage to using equity rather than debt financing because dividend payments are tax deductible. State True or False and briefly explain why?
What amount should the company report as net cash : Creative Sound Systems also purchased treasury stock, equipment, and a patent for $215 million, $25.5 million, What amount should the company report as net cash
Clean claims impact health care organizations : How do clean claims impact health care organizations? What are the risks to the billing process if claims are not clean? Provide examples.
Explain the appropriate interest rate : Tyrella Jackson is buying a used car. Alternative A is an American built compact. It has an initial cost of $8900 and operating costs of 9c/km, excluding deprec
Constraints in simple verbal expressions : 1. A brand manager for ColPal Products must determine how much time to allocate between radio and television advertising during the next month. Market research
Consumers fee to fund emissions controls : Should governments make retailers and manufacturers charge consumers a fee to fund emissions controls? Explain your reasoning.
Which statistics are available on domestic violence : Which laws have been approved in Argentina to protect women against domestic violence? Are these laws enforced?
Methods for improving communication skills : Discuss if you agree with your classmates' identification of problematic aspects and methods for improving their communication skills.
Participant in the product production : In many countries, the "straw" has utilization needs by cafes, hotels, bars, restaurants, and individuals at home. Plastic straw manufacturing consists of three

Reviews

Write a Review

Business Economics Questions & Answers

  Cash flow streams

Which of these cash flow streams has the higher present value if the discount rate is 6 percent? If the discount rate is 22 percent?

  Find the consumer-producer and total surpluses

Consider the following market QD= 15-2P   QS= 5P-2.5, with the government imposing a tax of 1.4 dollars per unit. Find the consumer, producer and total surpluses. What is the tax burden for each of the market participant?

  Staff estimates that the market price elasticity of demand

Your operations research staff estimates that the market price elasticity of demand is -2. The MC is constant at $150, and ATC at the current production rate is $225. If you compete against a large number of other firms all producing the same product..

  Percentage of the pie chart for the data

What will be the prime time viewing percentage of the pie chart for the following data? How do I answer this question?

  Monetary growth rule or monetarism

The Fed moved away from Milton Friedman's monetary growth rule or monetarism because: Although Sigmund Freud’s research was carried out in the Victorian era, it clearly revealed that.

  What is the probability he or she is a steroid user

If a randomly selected individual tests negative, what is the probability he or she is a steroid user?

  Attractive features of the position

Recommend one (1) of the career options. Identify the most attractive features of the position.

  Public in their roles as workers-consumers and taxpayers

When medical care is reimbursed through employer provided insurance whose welfare is ultimately affected when cost of medical care rises: the owners of the firm that pays the premiums, the government whose revenues are reduced because insurance benef..

  The average weight of the entire batch of the boxes

The average weight of the entire batch of the boxes of cereal filled today was 20.15 ounces. A random sample of four boxes was selected with the following weights: 20.05, 20.56, 20.72, and 20.43. The sampling error for this sample is _______.

  Dissertation and methodological choice

For each dissertation and methodological choice prepare a discussion that includes:

  About the including tax and insurance

An engineering student bought a car at a local used lot. Including tax and insurance, the total price was $3000. He is to pay for the car in 12 equal monthly payments, beginning with the first payment immediately.

  Marginal tax rate and a cost of capital

Assume straight-line depreciation, a 34% marginal tax rate and a cost of capital of 15%. Should Builtrite D purchase the machine?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd