Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
error_outline
This textbook solution is under construction.
Students have asked these similar questions
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 direct-mail advertising. A media budget of $2,500 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 = −2R2 − 10M2 − 8RM + 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 (in dollars) if $1,500 is spent on radio advertising and $1,000 is…
The market research team at AdRight is assigned the task
The market research team at AdRight is assigned the task to identify the profile of the typical customer for each tread-mill product offered by CardioGood Fitness.
1. Create a customer profile for each CardioGood Fitness treadmill product line by developing appropriate tables and charts.
2. Write a report to be presented to the management of Car-dioGood Fitness detailing your findings.
The market research team at AdRight is assigned the task
Football Association of Zambia (FAZ) has developed a new sports drink and is planning to launch it at the soon coming Charity Shield tournament. FAZ’s advertising agency can purchase one, two or three 30 second commercials advertising the drink and estimates that the return will be based on the viewership per game. Viewership, in turn, is based on fans’ perception of whether the game is “dull”, “average”, “above average”, or “exciting”.
The advertising agency has constructed the following payoff table, giving its estimate of the expected profit resulting from purchasing one, two, or three advertising slots. (Another possible decision, of course, is for FAZ not to advertise at all during the games).
No. of Ads
Perceived Game Excitement
Dull
Average
Above Average
Exciting
One
-2
4
9
18
Two
-5
7
14
23
Three
-9
6
15
27
Required:
Identify the decision alternatives and uncertain conditions surrounding them?
What is the optimal decision…
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- 3. The marketing group for a cell phone manufacturer plans to conduct a telephone survey to determine consumer attitudes toward a new cell phone that is currently under development. In order to have a sufficient sample size to conduct the analysis, they need to contact at least 100 young males (under age 40), 150 older males (over age 40), 120 young females (under age 40), and 200 older females (over age 40). It costs $1 to make a daytime phone call and $1.50 to make an evening phone call (due to higher labor costs). This cost is incurred whether or not anyone answers the phone. The table below shows the likelihood of a given customer type answering each phone call. Assume the survey is conducted with whoever first answers the phone. Also, because of limited evening staffing, at most one-third of phone calls placed can be evening phone calls. How should the marketing group conduct the telephone survey so as to meet the sample size requirements at the lowest possible cost? Who Answers?…arrow_forwardPicturearrow_forwardFollowing are two weekly forecasts made by two different methods for the number of gallons of gasoline, in thousands, demanded at a local gasoline station. Also shown are actual demand levels, in thousands of gallons: Week 1 2 3 4 Forecast Method 1 0.85 1.05 0.95 1.22 Actual Demand 0.70 1.05 0.96 0.97 Week 1 2 3 4 The mean squared error (MSE) for Method 2 = Forecast Method 2 0.82 1.19 0.92 1.17 Actual Demand 0.70 1.05 0.96 0.97 The MAD for Method 1 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 1= thousand gallons² (round your response to three decimal places). The MAD for Method 2 = thousand gallons (round your response to three decimal places). thousand gallons (round your response to three decimal places).arrow_forward
- Below is a table that shows the Freshmen Enrollment of the New Texas Elementary School during the 1a Semesters of the past ten (10) Academic Years (AY), AY 2013-2014 2014-2015 2015-2016 2016-02017 2017-2018 Freshmen Enrollees AY 200 220 235 270 315 4. For the Weighted Moving Averages model, use: a weight of 0.40 for the most recent data; a weight of 0.35 for the second most recent data; and a weight of 0.25 for the third most recent data. You are the Principal of New Texas Elementary School. You are interested to know the forecast of freshmen enrolment for the next academic year (AY2023-2024), in order to plan ahead the necessary resources: faculty, classroom, library holdings, physical facilities, student services, furniture and fixtures, etc.). These are the requirements: AT 2013-2014 1. Calculate the forecast using 5 forecasting techniques/methodologies/models namely: Naïve Model, Unweighted and Weighted Moving Averages, Exponential Smoothing, and Time-Series Regression. Follow and…arrow_forwardsniparrow_forwardSolve the problem using the answer sheet (Problem 1) SOLVE STEP BY STEP PLEASEarrow_forward
- The table below shows the sales figures for a brand of shoe over the last 12 months.Months SalesJanuary 69February 75March 86April 92May 95June 100July 108August 115September 125October 131November 140December 150 Using the following, forecast the sales for the months up to January the following year:- 1. Use exponential Smoothing when α= .6 and the forecast for March is 350.2. Determine which of the three forecasting technique is the most accurate using Mean Absolute Deviation MADarrow_forwardThe president of a small chain of women’s clothing stores was concerned about a four-year trend of decreasing profits. The stores have been characterized as being rather conservative over the years with respect to their product line, store decor, and advertising. They have consistently avoided trendy clothes, for example. Their market is now becoming extremely competitive because several aggressive fashion stores are expanding and are aiming at the young, fashion-conscious buyer. As a result of this competition and the disappointing profit trend, the president is considering making the product line appear less conservative and more oriented toward the young buyer. Before making such a risky change, the president feels it prudent to conduct some marketing research to learn the exact status of his chain. What should be the research purpose? Compose a set of research questions that would be helpful.arrow_forwardIn the grocery industry, managers typically need to know how best to use pricing, coupons, and advertising strategies to influence sales. Grocers often study the relationship of sales volume to these strategies by conducting controlled experiments to identify the relationship between them and sales volumes. That is, they implement different combinations of pricing, coupons, and advertising, observe the sales that result, and use analytics to develop a predictive model of sales as a function of these decision strategies.arrow_forward
- Dr. Lillian Fok, a New Orleans psychologist, spe-cializes in treating patients who are agoraphobic (i.e., afraid to leave their homes). The following table indicates how manypatients Dr. Fok has seen each year for the past 10 years. It alsoindicates what the robbery rate was in New Orleans during thesame year: Using trend (linear regression) analysis, predict the number ofpatients Dr. Fok will see in years 11 and 12 as a function of time.How well does the model fit the data?arrow_forwardMichael is the marketing executive of SHOPEE and he is planning to launch the 2.2.22 online SALE through price discounts, either 40% off or 20% off. He also learned that SHOPEE closest competitor LAZADA , is planning to promote also a 2.22.22 online SALE with price discounts , either 50% off or 30% off. If SHOPEE launches the 40% off, it will gain nothing. If LAZADA launches the 50% off or gain 8,000,000 if LAZADA launches the 30% off. If SHOPEE launches the 20% off, it will lose 2,000,000 if LAZADA launches the 50% off or lose 5,000,000 if LAZADA launches the 30% off. 1.Which strategy is dominated by SHOPEE depending on strategy of LAZADA? A. 50% OFF B. 40% OFF C. 20% OFF D. 30% OFF E. NONE 2.What should be the strategy of LAZADA? A. 50% OFF B. 40% OFF C. 30% OFF D. 20% OFFarrow_forwardThe Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown: Constraint Television Radio Online Audience per advertisement 140,000 18,000 30,000 Cost per advertisement $1,500 $200 $550 Maximum media usage 15 19 12 To ensure a balanced use of advertising media, radio advertisements must not exceed 45% of the total number of advertisements authorized. In addition, television should account for at least 15% of the total number of advertisements authorized. (a) If the promotional budget is limited to $24,100, how many commercial messages should be run on each medium to maximize total audience contact? If your answer is zero enter "0". No of commercial Advertisement Alternatives messages Television Radio Online What is the allocation of the budget…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill EducationManagement (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSONSpreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
- Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSONBusiness Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSONFundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON