Formulate a linear optimization model

Assignment Help Business Management
Reference no: EM133046350

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 moremeffective 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: EM133046350

Questions Cloud

Prepare the journal entry Philcorp would make : On June 30, 2020, Philcorp sold 2,500 shares for cash consideration of $60 per share on open market. Prepare the journal entry Philcorp would make
Lvmh in china-building its empire of desire : In July 2012, Louis Vuitton, the flagship brand of France's Moët Hennessy Louis Vuitton S. A., better known as LVMH, opened its 16th global "Maison" at Shanghai
Calculate the clv using the simple formula : Please calculate the CLV using the simple formula based on the following information: (Please show your calculations)
Calculate the residual income of each distribution channel : Calculate the residual income of each distribution channel assuming it purchases the new customer relationship management system
Formulate a 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
Small businesses to cope with the external factors : Looking back now on the past 2 years and everything with society went through, do you think there was anyway for small businesses to cope with the external fact
Why customer relationship has endured for so long : Discuss how this business/product first became a favorite and explain why this customer relationship has endured for so long.
What is the net cash received over the life of the bond : The straight line method of amortization is used for both premiums & discounts. What is the net cash received over the life of the bond
What is restated amount of the sales : Entity A has total sales revenue of P1,200,000 before restatement on December 31, 20x1. What is restated amount of the sales

Reviews

Write a Review

Business Management Questions & Answers

  Single precision-double precision floating point numbers

What are the differences between using single precision vs. double precision floating point numbers in how numbers (size, accuracy, etc.) can be represented?

  Write a paper bad debt expense under the allowance method

Write a paper Bad debt expense under the Allowance method, Percentage of sales method and Direct write-off method.

  Elasticity of imports in the usa in the short run

What happens to the Current Account Balance in the US if the Exchange Rate goes from Yen=$1/100 to Yen=$1/50?

  Deep downturn in economic activities

During the years 2008 and 2009, the U.S. economy and many other major economies around the world experienced a financial crisis

  What is the daily breakeven number of customers required

What is the daily breakeven number of customers required. Givens considers two paths for Wednesday night entertainment: league bowling and exclusive brand rights

  Describe the type of projects

Name the profession/field of study and describe the type of projects you choose.

  Highly competitive market conditions

Suppose that a firm is operating under highly competitive market conditions and that the going price for its product is p=$300 adn that the firms short tun

  Pay for solutions in which they are then incorrect

If i submit and pay for solutions in which they are then incorrect, and I have to do it anyway, do I receive any compensation?

  Explain planning is everything

Explain PLANNING IS EVERYTHING and How can IMC principles move us up the pyramid

  What is globalization

What is globalization, and how does it affect different countries?

  Why leader must be people centric in order to create an edge

Discuss the nature and types of challenges facing leader in the 21st century; Explain why leader must be people centric in order to create a completive edge.

  Navigate a challenging organizational landscape

-When Mulcahy became COO, in what ways did she use EQ and AL to navigate a challenging organizational landscape? Explain your reasoning.

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