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
A cosmetic manufacturer wants to understand why users shop online versus in store, and how they might take better advantage of the online channel; the manufacturer wants to make improvements to the company’s website. The manufacturer also wants to find out why Nordstrom.com (a competitor’s website) appeals to cosmetic consumers versus other websites. The cosmetic manufacturer also wants to find ways to improve consumers’ in-store experience. Further, the manufacturer wants to produce a three (3) month sales forecast based on the data produced from the research.
Objectives:
Why users shop online versus in store
How to take advantage of the online channel
How to improve the company’s website
Why does Nordstrom.com (their competitor) appeal to cosmetic consumers versus other websites.
Ways to improve consumers’ in-store experience
Requireed: Produce fictitious findings, chart and dat analysis that relate back to the objectives.
What is differ from SMA (Simple moving average), WMA (Weighted moving average), SLR (Single linear regression), and ESM ( Exponential smoothing model).
Assume that Young Corporation is introducing a new heartburn relief medication as an over the counter treatment. Young's marketing team used data to determine how to meet the minimum sales goals. The team determined that switching to an online marketing plan would be the best to maximize sales. This is an example of using
Question 8 options:
a)
descriptive analytics
b)
diagnostic analytics
c)
predictive analytics
d)
prescriptive analytics
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
- The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?arrow_forwardThe file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?arrow_forwardThe file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?arrow_forward
- Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence this stock price are return on average equity (X1) and annual dividend rate (X2). The stock price, returns on equity, and dividend rates on a randomly selected day for 16 electric utility stocks are provided in the file P13_15.xlsx. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.arrow_forwardA pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales duringthe last 15 days wereDay: 1 2 3 4 5 6 7 8 9Number sold: 36 38 42 44 48 49 50 49 52Day: 10 11 12 13 14 15Number sold: 48 52 55 54 56 57a. Which method would you suggest using to predict future sales—a linear trend equation or trendadjustedexponential smoothing? Why?b. If you learn that on some days the store ran out of the specific pain reliever, would that knowledgecause you any concern? Explain.c. Assume that the data refer to demand rather than sales. Using trend-adjusted smoothing with aninitial forecast of 50 for week 8, an initial trend estimate of 2, and .3, develop forecastsfor days 9 through 16. What is the MSE for the eight forecasts for which there are actual data?arrow_forwardMovieFlix - Advertising and Subscriptions Year 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 Advertising Expenditure $ 000 51 58 62 65 68 75 77 78 78 84 85 76 Membership Subscriptions (1) Plot the scattergraph for the data. 62 68 66 66 欲 72 73 72 78 73 75 67 76 (ii) Use the data, to develop a regression equation relating advertisi. expenditure to membership. (iii) Estimate the membership if $40 000 is spent on advertising. (iv) How much must be spent on advertising to obtain a membership of 80 (000)? (v) What is the nature of the relationship between advertising expenditure and membership? (vi) Forecast 2024 membership using an alternative method, clearly explaining the limitations of your selected method. (vii) What are the limitations of the method used in (iii)?arrow_forward
- A marketing director would like to estimate the effect of advertising expenditures on the quantity of his product sold controlling for the effects of price and average household income in the area. The dependent variable in this regression should be: A) price B) average household income C) quantity sold D) advertising expenditurearrow_forwardThe number of sales invoice checked is an example of? 1.qualitative data 2.continuous data 3.discrete data 4.temporal dataarrow_forwardDescibe and analyze how the Trend Approach in data analysis is the monitoring of variables to see how they change over time and how they can be used to predict future variable values. Discuss trend analysis in depth and the reasons companies rely on such strategy in their business operations. Discuss how Trend Analytics may encourage awareness and help a brand to grow. What are three examples of Trend Analysis that can be offered, that may help an organization gain a competitive edge in the industry in which it operates? Please utilize relevant Digital Marketing Analytics in the response.arrow_forward
- Tip Top Toys is a relatively small division of Worldwide Enterprises. Worldwide has nine other divisions, which include insurance, health-care products, and financial planning services, to name a few. The corporate marketing director for Worldwide has requested Tip Top’s customer shopping data to target people who might be likely to purchase items or services from other Worldwide divisions. The database manager is not totally comfortable with this and pointed out Tip Top’s web privacy policy, which states “Tip Top Toys, a division of Worldwide Enterprises, will not share personal data with other companies without a customer’s consent.” The marketing director replied that the statement only applies to outside companies— not other Worldwide divisions. He said he checked with the corporate legal department, and they agreed. The database manager replied, “Even if it is legally OK, it’s not the right thing to do. Many people take our statement to mean that their data does not leave Tip Top.…arrow_forwardTip Top Toys is a relatively small division of Worldwide Enterprises. Worldwide has nine other divisions, which include insurance, health-care products, and financial planning services, to name a few. The corporate marketing director for Worldwide has requested Tip Top’s customer shopping data to target people who might be likely to purchase items or services from other Worldwide divisions. The database manager is not totally comfortable with this and pointed out Tip Top’s web privacy policy, which states “Tip Top Toys, a division of Worldwide Enterprises, will not share personal data with other companies without a customer’s consent.” The marketing director replied that the statement only applies to outside companies— not other Worldwide divisions. He said he checked with the corporate legal department, and they agreed. The database manager replied, “Even if it is legally OK, it’s not the right thing to do. Many people take our statement to mean that their data does not leave Tip Top.…arrow_forwardÉ Salespersons use the direct comparison approach to estimate the value of a property. Whlch of the following is a disadvantage when estimating value using this approach? O select one answer. It is generally accepted by the courts and the public. It avoids various problems associated with estimating and forecasting, such as depreciation. Consumers generally understand and use it. Data is historical in nature.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License