please take a excel
Painter Format Clipboard Formatting Table- Font Number AutoSave O 4 A GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration treatment as a low-cost extra service option that 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 $3,000 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 12 13 14 15 16 S-total ales in thousasds of dollars Rthoasaads of doilars spest on redio advertising Mthoasands of dollars 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. 18 1.What is the value of sales if $2,000 is spent on radio advertising and $1,000 is spent on direct-mail advertising? 21 2.Formulate an optimization problem that can be solved to maximize sales subject to the media budget of spending no more than $3,000 on total advertising 23 24 3.Determine the optimal amount to spend on radio and direct-mail advertising. How much in sales will be generated? Chapter 12 dwestion 5 2 hapte 13 P Chapter 12 Question 5 | Chapter 13 Problem #1 | Painter Format Clipboard Formatting Table- Font Number AutoSave O 4 A GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration treatment as a low-cost extra service option that 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 $3,000 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 12 13 14 15 16 S-total ales in thousasds of dollars Rthoasaads of doilars spest on redio advertising Mthoasands of dollars 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. 18 1.What is the value of sales if $2,000 is spent on radio advertising and $1,000 is spent on direct-mail advertising? 21 2.Formulate an optimization problem that can be solved to maximize sales subject to the media budget of spending no more than $3,000 on total advertising 23 24 3.Determine the optimal amount to spend on radio and direct-mail advertising. How much in sales will be generated? Chapter 12 dwestion 5 2 hapte 13 P Chapter 12 Question 5 | Chapter 13 Problem #1 |
