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 = -2R² 12M²-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-12M2-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 = -2R² 12M²-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-12M2-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.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
6
Transcribed Image Text: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 = -2R²-12M²-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)
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 3 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.