Question

In: Finance

GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special aeration...

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,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:

S = -2R212M29RM + 18R + 33M,

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 $2,000 is spent on radio advertising and $2,000 is spent on direct-mail advertising? Enter amounts in thousands i. e. $1,012, should be written as $1,012.
$
(b) Formulate an optimization problem that can be solved to maximize sales subject to the media budget of spending no more than $4,000 on total advertising. If the constant is "1" it must be entered in the box. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300). If your answer is zero enter “0”.
Max   R 2 +   M 2 +   RM +   R +   M
s.t
  R +   M - Select your answer -≤≥<>=Item 9
R, M - Select your answer -≤≥<>=Item 11
(c) Determine the optimal amount to spend on radio and direct-mail advertising. How much in sales will be generated? Enter amounts in thousands i. e. $1,012, should be written as $1,012. If your answer is zero enter “0”.
Amount spent on radio advertising = $
Amount spent on direct-mail advertising = $
Total Sales = $

Solutions

Expert Solution

a.

The given sales function is S = -2R2− 12M2− 9RM + 18R + 33M

and where R is thousand of dollar spent on radio advertising

and M is thousand of dollar spent on mail advertising

If $2000 is spent on radio advertisement and $2000 is spent on mail advertisement then the sales achieved is

S = -2(2)2 -12(2)2 -9(2)(2)+18(2)+33(2)

S = 10

The sale generated is $10,000

b.

The optimization model is as follows:

MAX S =  -2R2− 12M2− 9RM + 18R + 33M

s.t.

R+M < or equal to 4

R,M > or equal to 0

c.

Define the decision variables and objective function as shown in the screenshot:

Define the constraint by using =sum( ) function. The screenshot is shown below:

All the inputs have been done; hence click on solve icon. A dailogue box will appear. In the target cell box, input B4, where final result of NET PRESENT value will appear. Also, select the MAX option box. In the text box, "by changing cell" update the cell names where actual numbers are to be updated. add the constraints. the screenshot is shown below

Now click on ok button

Click on Solve button and Solver dailogue box will appear saying that the solutiong has been found. the screenshot is as shown below.

If the keep solver solution option button is clicked, the value of the decision table will be updated automatically. the screenshot is as shown below,

From the solution it can be seen that the company should spend $4000 on radio advertisement and $0 on direct mail advertisement. The maximum sales achieved is $40,000


Related Solutions

Tom and Jerry opened a new lawn service. They provide three types of services: mowing, fertilizing,...
Tom and Jerry opened a new lawn service. They provide three types of services: mowing, fertilizing, and planting trees. The cost of mowing is $35.00 per 5000 square yards, fertilizing is $30.00 per application, and planting a tree is $50.00. Write an algorithm that prompts the user to enter the area of the lawn, the number of fertilizing applications, and the number of trees to be planted. The algorithm then determines the billing amount. Include: Equations Example Data IPO Chart...
You are the owner of a lawn service company (LawnCo) which provides grounds and maintenance services...
You are the owner of a lawn service company (LawnCo) which provides grounds and maintenance services to a range of corporate customers. Customers are expected to pay on the first of each month, in advance of receiving services. One of your corporate customers is an eldercare facility whose grounds you have maintained for many years. The customer has not paid for the last three months of services (from Oct.–Dec. 2020); nevertheless, to maintain a positive relationship, your company continued to...
Yvette’s Yard Service (YYS) is a company that provides lawn mowing services. Suppose that the only...
Yvette’s Yard Service (YYS) is a company that provides lawn mowing services. Suppose that the only way to mow one lawn is for one worker to use one lawn mower for one day. Two workers with one lawn mower, or one worker with two lawn mowers, can still only mow one lawn per day. Draw the one-unit isoquant for YYS. Assuming that YYS’ production technology exhibits constant returns to scale, draw several more isoquants. Assuming that YYS rents lawn mowers...
You are the owner of a lawn service company (LawnCo) which provides grounds and maintenance services...
You are the owner of a lawn service company (LawnCo) which provides grounds and maintenance services to a range of corporate customers. Customers are expected to pay on the first of each month, in advance of receiving services. One of your corporate customers is an eldercare facility whose grounds you have maintained for many years. The customer has not paid for the last three months of services (from Oct.–Dec. 2020); nevertheless, to maintain a positive relationship, your company continued to...
You are the owner of a lawn service company (LawnCo) which provides grounds and maintenance services...
You are the owner of a lawn service company (LawnCo) which provides grounds and maintenance services to a range of corporate customers. Customers are expected to pay on the first of each month, in advance of receiving services. One of your corporate customers is an eldercare facility whose grounds you have maintained for many years. The customer has not paid for the last three months of services (from Oct.–Dec. 2020); nevertheless, to maintain a positive relationship, your company continued to...
The Green and Grow Lawn Service mows its customers’ lawns and provides lawn maintenance starting in...
The Green and Grow Lawn Service mows its customers’ lawns and provides lawn maintenance starting in the months of March through October. During the winter months, the owners, Jack and Jill Hill, find part-time jobs. They are considering the possibility of adding a snow removal service during the winter. A snow blower and a shovel would cost $700. They estimate their cost per job would be $10.00. They are considering a charge of $55 to clear a normal-size home driveway....
Change in Estimate versus Error Correction- LandCo is a lawn service company which provides grounds and...
Change in Estimate versus Error Correction- LandCo is a lawn service company which provides grounds and maintenance services to a range of corporate customers. Customers are expected to pay on the first of each month, in advance of receiving services. One of LandCo’s corporate customers is an eldercare facility whose grounds the company has maintained for many years. The customer has not paid for the last three months of service (from October – December 2019); nevertheless, to maintain a positive...
A. The 802.11 LLC unacknowledged connectionless service provides no flow control or error control. TRUE or...
A. The 802.11 LLC unacknowledged connectionless service provides no flow control or error control. TRUE or FALSE B. An 802.11 extended service set (ESS) consists of two or more BSS’ interconnected by a distribution system (DS). TRUE or FALSE C. The 802.11 "integration service" performs address translation during a logical connection between the WLAN and external 802.x LANs. TRUE or FALSE
BugKillers provides a quarterly pest control service for $106 a quarter. Its variable costs per service...
BugKillers provides a quarterly pest control service for $106 a quarter. Its variable costs per service call are $17. Customers can cancel the service at any time, and the firm has a quarterly attrition rate of 2%. Marketing spends $40 per year on customer retention. If the annual discount rate is 13%, what is the CLV of an existing customer? Please post the Excel formulas
Describe the service TCP provides with respect to flow control and explain the mechanisms it uses...
Describe the service TCP provides with respect to flow control and explain the mechanisms it uses to overcome the deficiencies of IP.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT