Question: please help me put this in excel and solve GreenLawns provides a lawn fertilizer and weed control service. The company is adding a special aeration

please help me put this in excel and solve
please help me put this in excel and solve
GreenLawns provides a lawn fertilizer 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 directmail advertising. A media budget of $3000 is available for this promotional campaign. Based on past experience in promoting its other services, GreenLawns obtained the following estimate of the relationship between sales and the amount spent on promotion in these two media: S=2R210M28RM+18R+34M where S= total sales in thousands of dollars R= thousands of dollars spent on radio advertising M= thousands 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. a. What is the value of sales if $2000 is spent on radio advertising and $1000 is spent on direct-mail advertising? b. Formulate an optimization problem that can be solved to maximize sales subject to the media budget. c. Determine the optimal amount to spend on radio and direct-mail advertising. How much money will be generated in sales

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!