Show the optimal solution and optimal value

Assignment Help Other Subject
Reference no: EM131876113

Question: GMW Auto manufactures luxury cars and trucks. The company believes that its most likely customers are high-income women and men. To reach these groups, GMW Auto has embarked on an ambitious TV advertising campaign and has decided to purchase commercial spots on two types of programs: Drama show and Super Bowl game. A drama show commercial's length is 1.4-minutes and each drama show commercial is seen by 12 million high-income women and 8 million high-income men. A Super Bowl commercial's length is 0.5-minute and each Super Bowl commercial is seen by 11 million high-income women and 16 million high-income men. GMW Auto has 4.7-minutes of commercial spots available. A 1.4-minutes drama show ad costs $246,000, and a 0.5-minute Super Bowl ad costs $457,000. GMW would like the commercials to be seen by at least 47 million high-income women and 35 million high-income men.

a) Formulate a linear programming model to determine how GMW Auto can meet its advertising requirements at minimum cost. (Write the complete model for the problem. Make sure to give clear definitions of your decision variables).

b) Solve the problem by using Excel Solver (Hand-in the value and formulas printouts for the problem). Show the optimal solution and optimal value in your printouts.

Reference no: EM131876113

Questions Cloud

What is the expected return on such an asset : Based on the CAPM, what is the expected return on such an asset? Is it possible that a risky asset could have a negative beta?
What types of companies might peta affect politically : Go to the website of People for the Ethical Treatment of Animals (PETA). How far should advocacy groups go in promoting their causes?
Calculate the expected value and standard deviation : Senior management of Nancy's Nooks (NN) has determined that there is a 20 percent chance EPS will be $4.50 next year.
Stock currently sells-what is the required return : If the stock currently sells for $55 per share, what is the required return?
Show the optimal solution and optimal value : Solve the problem by using Excel Solver (Hand-in the value and formulas printouts for the problem). Show the optimal solution and optimal value in your printout
Calculate amount of interest that mason should capitalize : On January 1, 2013, the company obtained a $3 million construction loan with a 10% interest rate. Calculate the amount of interest that Mason should capitalize
What is the purpose of the website : Go to this company's website and answer these questions about their website. The company is New Standard.
Jim to spend on monthly mortgage payment : Given the back end DTI constraint, what is the most they will allow Jim to spend on a monthly mortgage payment?
What is the probability of making a type i error : What is the probability of making a Type I error? How did you determine this?

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

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