GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration treatment as a low-cost extra service option, which it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of $4 (in thousands)is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns has obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media: S-2R2-12M2-9RM+20R+37M, Where S = total sales R= amount spent on radio advertising M = amount spent on direct-mail advertising GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to the restriction provided by the media budget. The problem is formulated as below: Max -2R2-12M²-9RM+20R+37M s.t. 1R+1M<=4 R,M>=0 Using Excel Solver, solve the above nonlinear optimization model. (a) What is the amount spent on radio advertising? (Just type the value without the dollar sign) (b) What is the amount spent on direct-mail advertising?(Just type the value without the dollar sign) (c) What is the total sales(Just type the value without the dollar sign)
GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration treatment as a low-cost extra service option, which it hopes will help attract new customers. Management is planning to promote this new service in two media: radio and direct-mail advertising. A media budget of $4 (in thousands)is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns has obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media: S-2R2-12M2-9RM+20R+37M, Where S = total sales R= amount spent on radio advertising M = amount spent on direct-mail advertising GreenLawns would like to develop a promotional strategy that will lead to maximum sales subject to the restriction provided by the media budget. The problem is formulated as below: Max -2R2-12M²-9RM+20R+37M s.t. 1R+1M<=4 R,M>=0 Using Excel Solver, solve the above nonlinear optimization model. (a) What is the amount spent on radio advertising? (Just type the value without the dollar sign) (b) What is the amount spent on direct-mail advertising?(Just type the value without the dollar sign) (c) What is the total sales(Just type the value without the dollar sign)
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter9: Decision Making Under Uncertainty
Section: Chapter Questions
Problem 46P
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 6 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing