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.
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...
icon
Related questions
Question
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)
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-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)
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 6 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.