![Essentials of Business Analytics (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781305627734/9781305627734_largeCoverImage.gif)
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:
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 $1,000 is spent on direct-mail advertising?
- b. 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.
- c. Determine the optimal amount to spend on radio and direct-mail advertising. How much in sales will be generated?
a.
![Check Mark](/static/check-mark.png)
To find the amount of sales generated when $2,000 and $1,000 is spend on radio and direct-mail advertising.
Explanation of Solution
To find the amount of sales generated, substitute $2,000 and $1,000 is spend on radio and direct-mail advertising in the below relationship equation.
Therefore, sales of $36,000 will be generated with the budget allocated for promotion.
b.
![Check Mark](/static/check-mark.png)
To formulate optimization problem to maximize sales when total advertising cost is not more than $3,000.
Explanation of Solution
The formulation is for the problem is shown below,
c.
![Check Mark](/static/check-mark.png)
To solve and find the optimal amount to be spend on advertising to determine the amount of sales generated.
Explanation of Solution
Formula:
Solver:
Output:
The solution is R = $2,500 and M = $500 with Sales of $37,000
Want to see more full solutions like this?
Chapter 13 Solutions
Essentials of Business Analytics (MindTap Course List)
- Compare the primary types of forecasting methods used to determine demand.arrow_forwardA mail-order catalog business that sells personal computer supplies, software, and hardware maintains a centralized warehouse for the distribution of products ordered. Management is currently examining the process of distribution from the warehouse and has the business objective of determining the factors that affect warehouse distribution costs. Currently, a handling fee is added to the order, regardless of the amount of the order. Data that indicate the warehouse distribution costs and the number of orders received have been collected over the past 24 months and can be seen below: Months Distribution Cost ($thousands) Number of Orders 1 52.95 4015 2 71.66 3806 3 85.58 5309 4 63.69 4262 5 72.81 4296 6 68.44 4097 7 52.46 3213 8 70.77 4809 9 82.03 5237 10 74.39 4732 11 70.84 4413 12 54.08 2921 13 62.98 3977 14 72.30 4428 15 58.99 3964 16 79.38 4582…arrow_forwardYou are on the board of directors for Sew and Tell, an up and coming apparel brand focusing on producing t-shirts with a positive message. The company is looking to ramp up production and has hired an independent consulting group to evaluate the profitability of either a medium or large scale expansion. Your boss, the company president Jack Pott, has sent you the following email: Board of Directors Member, The consulting group has completed the analysis. The following table breaks down the results with us pursuing either a medium or large scale expansion. It gives low, medium, and high projections, the associated amount of profits (in thousands of $), and the probability of each outcome happening. Medium-Scale Expansion Profit 50 Large-Scale Expansion Profit Probability Probability Low .2 .2 Medium 150 .5 100 .5 High 200 .3 300 .3 Personally, I would love to hit the jackpot and reach a profit of $300,000, but our goal as a company is to maximum profit in the least risky way. Taking…arrow_forward
- Jensen Tire & Auto is deciding whether to purchase a maintenance contract for its newcomputer wheel alignment and balancing machine. Managers feel that maintenance expenseshould be related to usage, and they collected the following information on weeklyusage (hours) and annual maintenance expense (in hundreds of dollars). a. Develop a scatter chart with weekly usage hours as the independent variable. Whatdoes the scatter chart indicate about the relationship between weekly usage and annualmaintenance expense?b. Use the data to develop an estimated regression equation that could be used to predictthe annual maintenance expense for a given number of hours of weekly usage. Whatis the estimated regression model? c. Test whether each of the regression parameters b0 and b1 is equal to zero at a 0.05level of significance. What are the correct interpretations of the estimated regressionparameters? Are these interpretations reasonable?d. How much of the variation in the sample values of…arrow_forwardPlease answer ASAP. Thank you!arrow_forwardDetermine if the following scenarios involve an observational study or an experiment. Make sure your answers are legible and spelled correctly. A team of ecologists determines the different species of frogs that live in the local swamplands. A medical researcher divides patients into a treatment group and a control group to determine the effect of a new drug on overall cholesterol levels in patients. A medical insurance company determines the average cost to cover a tooth extraction procedure over the past 3 years. As part of a medical study to determine the effectiveness of a new technique for abdominal surgery, patients undergo the surgery with the new technique or with a traditional technique. The recovery time from surgery is then compared for the two different techniques. The general manager of a baseball team determines the on-base percentage (OBP) for his players over the past two seasons. A dietitian examined the effectiveness of a weight-loss program by randomly…arrow_forward
- Briefly explain how the organization forecast sales for its products.a. Using historical sales data, choose a quantitative technique to forecast sales for thatorganisation for the next sales period. Comment on the appropriateness of thetechnique used.b. Describe three strategies that the organization uses to compete and comment on theappropriateness of these strategiesarrow_forwardMyrtle Air Express decided to offer direct service from Cleveland to Myrtle Beach. Management must decide between a full-price service using the company’s new fleet of jet aircraft and a discount service using smaller capacity commuter planes. It is clear that the best choice depends on the market reaction to the service Myrtle Air offers. Management developed estimates of the contribution to profit for each type of service based upon two possible levels of demand for service to Myrtle Beach: strong and weak. The following table shows the estimated quarterly profits (in thousands of dollars): Demand for Service Service Strong Weak Full price $960 -$490 Discount $670 $320 1. Suppose that the probability of strong demand is 0.8 and the probability of weak demand is 0.2. What is the optimal decision using the expected value approach?Optimal Decision: Use graphical sensitivity analysis to determine the range of demand probabilities for which each of the decision…arrow_forwardMyrtle Air Express decided to offer direct service from Cleveland to Myrtle Beach. Management must decide between a full-price service using the company’s new fleet of jet aircraft and a discount service using smaller capacity commuter planes. It is clear that the best choice depends on the market reaction to the service Myrtle Air offers. Management developed estimates of the contribution to profit for each type of service based upon two possible levels of demand for service to Myrtle Beach: strong and weak. The following table shows the estimated quarterly profits (in thousands of dollars): Demand for Service Service Strong Weak Full price $960 -$490 Discount $670 $320 d. Suppose that the probability of strong demand is 0.8 and the probability of weak demand is 0.2. What is the optimal decision using the expected value approach?Optimal Decision: e. Use graphical sensitivity analysis to determine the range of demand probabilities for which each of the decision…arrow_forward
- You may need to use the appropriate appendix table or technology to answer this question. Advertisers contract with internet service providers and search engines to place ads on websites. They pay a fee based on the number of potential customers who click on their ad. Unforțunately, click fraud-the practice of someone clicking on an ad solely for the purpose of driving up advertising revenue–has become a problem. Businessweek reports that 4C percent of advertisers claim they have been a victim of click fraud. Suppose a simple random sample of 390 advertisers will be taken to learn more about how they are affected by this practice. (Round your answers to four decimal places.) (a) What is the probability that the sample proportion will be within ±0.04 of the population proportion experiencing click fraud? (b) What is the probability that the sample proportion will be greater than 0.45?arrow_forwardLovely Lawns, Inc., intends to use sales of lawn fertilizer to predict lawn mower sales. The store manager estimates a probable six- week lag between fertilizer sales and mower sales. The pertinent data are: Fertilizer Number of Fertilizer Number of Sales Mowers Sold Sales Mowers Sold Period (tons) (six-week lag) Period (tons) (six-week lag) 1 1.6 10 8. 1.3 7 1.3 8 1.7 10 3 1.8 11 10 1.2 6. 4 2.0 12 1.9 11 2.2 12 12 1.4 1.6 9. 13 1.7 10 7 1.5 14 1.6 a. Determine the correlation between the two variables. Does it appear that a relationship exists between these variables will yield good predictions? (Do not round intermediate calculations and round your answer to 3 decimal places.) it appears that a positive v relationship exists between these variables. b. Obtain a linear regression line for the data. (Negative values should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 3 decimal places.) Y = O Xi + c. Predict expected lawn mower sales…arrow_forwardCharity Navigator is America's leading independent charity evaluator. The following data show the total expenses (), the percentage of the total budget spent on administrative expenses, the percentage spent on fundraising expenses, and the percentage spent on program expenses for supersized charities. Administrative expenses include overhead, administrative staff and associated costs, and organizational meetings. Fundraising expenses are what a charity spends to raise money, and program expenses are what the charity spends on the programs and services it exists to deliver. The sum of the three percentages does not add to because of rounding. # Charity Total Expenses($) AdministrativeExpenses(%) FundraisingExpenses(%) ProgramExpenses(%) 1 American Red Cross 3,354,177,445 3.9 3.8 92.1 2 World Vision 1,205,887,020 4.0 7.5 88.3 3 Smithsonian Institution 1,080,995,083 23.5 2.6 73.7 4 Food For The Poor 1,050,829,851 0.7 2.4 96.8 5 American…arrow_forward
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
![Text book image](https://www.bartleby.com/isbn_cover_images/9780079039897/9780079039897_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781680331141/9781680331141_smallCoverImage.jpg)