Implement the linear optimization model

Assignment Help Business Economics
Reference no: EM133065374

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. (Attach excel file)

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: EM133065374

Questions Cloud

What is the project net present value : Casey Nelson is a divisional manager for Pigeon Company. His annual pay raises are largely determined by his division's return on investment (ROI), which has be
Leadership styles effect global organizational culture : The briefing to John and the board of directors was a success. How can leadership styles effect global organizational culture?
Discuss the optimal method for procuring inputs : Discuss the optimal method for procuring inputs that have well-defined and measurable quality specifications and require highly specialized investments.
Calculate the revenue to be recognised by Elliot Ltd : Calculate the revenue to be recognised by Elliot Ltd for the year ended 30 June 2021 and prepare the journal entries related to the revenue
Implement the linear optimization model : 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
Development of better management plans : A comprehensive model of critical success factors for IT projects permits the development of better management plans, processes, and metrics,
Determine the efficient capacity of the park : If a City has a public park and the annual demand for picnics at the city owned park is QD = 10 - 3P (in this example, if the price of renting the park was $1,
Calculating the maximum revenue : A university has determined that its students fall into two categories when it comes to room and board demand. University planners call these two typesSleepers
Family and medical leave act : Some employers must provide unpaid leave for family- and medical-related reasons under the Family and Medical Leave Act (FMLA).

Reviews

Write a Review

Business Economics Questions & Answers

  Elucidate the resulting paint cost per gallon

Illustrate what percentage of G1 can be mixed with G2 and still satisfy the customers. Elucidate the resulting paint cost per gallon.

  Q1 determine whether the justice department would challenge

q1. determine whether the justice department would challenge a merger between two firms in an industry with 10

  Explain difference between inferior goods and normal goods

Explain the theory that education acts as a signaling device' How does this contrast to the theory of education as an investment in human capital? Explain the difference between inferior goods and normal goods' As a developing economy experiences inc..

  Goods that this person buys and that bread is free

Suppose also that ham and cheese are the only goods that this person buys and that bread is free.

  Long-run effects of rise in safe-haven capital inflow

In the five years ending 2011, Switzerland enjoyed a fiscal surplus that averaged 1.3% of GDP, a trade surplus that averaged 2.6% of GDP, and a government debt to GDP ratio that averaged 40%. Use the appropriate graphs for a small open economy to ill..

  What is the total cost-savings from trading

Find the equilibrium permit price. Hint: The two conditions for a permit price equilibrium will allow you to solve for the emissions levels for each firm after trading. What is the total cost-savings from trading?

  Explain why exchange-rate quotations stated

Explain why exchange-rate quotations stated in different financial centers tend to be consistent with one another.

  Negligence rule is necessarily vague

“If the legal standard of care in a negligence rule is necessarily vague, the court should set it below the level of efficient precaution.” Explain the economic argument in favor of this proposition. Doctors are liable when their negligence injures p..

  Source of profit

Which of the following in NOT a source of profit?

  Price of good leads to increase in total revenue

Holding all other forces constant, if decreasing the price of a good leads to an increase in total revenue, then the demand for the good must be:

  What do you understand by the term critical juncture

What do you understand by the term “ Critical Juncture?” Use your understanding of this term to discuss how Third World countries can use critical juncture experiences to create socio-economic and political change.

  Negative effects of a higher success rate of innovation

What are the positive and negative effects of a higher success rate of innovation on the relative size of a research sector?

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