Statistics for Business & Economics, Revised (MindTap Course List)
12th Edition
ISBN: 9781285846323
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17, Problem 46SE
The Mayfair Department Store in Davenport, Iowa, is trying to determine the amount of sales lost while it was shut down during July and August because of damage caused by the Mississippi River flood. Sales data for January through June follow.
| Month | Sales ($1000s) |
| January | 185.72 |
| February | 167.84 |
| March | 205.11 |
| April | 210.36 |
| May | 255.57 |
| June | 261.19 |
- a. Use exponential smoothing, with α = .4, to develop a forecast for July and August. (Hint: Use the forecast for July as the actual sales in July in developing the August forecast.) Comment on the use of exponential smoothing for forecasts more than one period into the future.
- b. Use trend projection to forecast sales for July and August.
- c. Mayfair’s insurance company proposed a settlement based on lost sales of $240,000 in July and August. Is this amount fair? If not, what amount would you recommend as a counteroffer?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
No need to answer everything! Just plot the actual visitors and the forecasts. Compare the accuracy of the forecasts in the 1985 to 1990 period with those subsequent to that period.
For the data given, use the arithmetic average of the first six months of data as a baseline to initialize the exponential smoothing.a. Determine the one-step-ahead exponential smoothing forecasts for Augustthrough December, assuming a = .20.b. Compare the accuracy of the forecasts obtained in part (a) with the one-stepahead six-month moving-average forecasts determined in the problem below.c. Comment on the reasons for the result you obtained in part (b).
Compute the one-step-ahead three-month and six-month moving-average forecasts for July through December. What effect does increasing N from 3 to 6 have on the forecasts?
Cynthia’s Design Studios had sales in the last four months of $12,700, $14,500, $19,100, and $15,800. Sales are related to how many designers Cynthia has on duty. The sales forecast helps her decide on the proper staffing levels.
What is the forecast for the fifth month using a two-period moving average?
What is the forecast for the fifth month using = 0.8 in an exponential smoothing model with A4 = $15,800 and F4 = $17,913 to get things started.
Chapter 17 Solutions
Statistics for Business & Economics, Revised (MindTap Course List)
Ch. 17.2 - Consider the following time series data. Week 1 2...Ch. 17.2 - Refer to the time series data in exercise 1. Using...Ch. 17.2 - Exercises 1 and 2 used different forecasting...Ch. 17.2 - Consider the following time series data. Month 1 2...Ch. 17.3 - Consider the following time series data. Week 1 2...Ch. 17.3 - Consider the following time series data. Month 1 2...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Refer again to the gasoline sales time series data...Ch. 17.3 - With the gasoline time series data from Table...Ch. 17.3 - With a smoothing constant of = .2, equation...
Ch. 17.3 - For the Hawkins Company, the monthly percentages...Ch. 17.3 - Corporate triple-A bond interest rates for 12...Ch. 17.3 - The values of Alabama building contracts (in ...Ch. 17.3 - The following time series shows the sales of a...Ch. 17.3 - Ten weeks of data on the Commodity Futures Index...Ch. 17.3 - The U.S. Census Bureau tracks the median price for...Ch. 17.4 - Consider the following time series data. a....Ch. 17.4 - Prob. 18ECh. 17.4 - Consider the following time series. a. Construct a...Ch. 17.4 - Prob. 20ECh. 17.4 - Prob. 21ECh. 17.4 - Prob. 22ECh. 17.4 - The president of a small manufacturing firm is...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Automobile unit sales at B. J. Scott Motors, Inc.,...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - Prob. 27ECh. 17.5 - Consider the following time series. a. Construct a...Ch. 17.5 - Consider the following time series data. a....Ch. 17.5 - The quarterly sales data (number of copies sold)...Ch. 17.5 - Air pollution control specialists in southern...Ch. 17.5 - South Shore Construction builds permanent docks...Ch. 17.5 - Prob. 33ECh. 17.5 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Consider the following time series data. a....Ch. 17.6 - Refer to exercise 35. a. Deseasonalize the time...Ch. 17.6 - The quarterly sales data (number of copies sold)...Ch. 17.6 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Air pollution control specialists in southern...Ch. 17.6 - Electric power consumption is measured in...Ch. 17 - The weekly demand (in cases) for a particular...Ch. 17 - The following table reports the percentage of...Ch. 17 - United Dairies. Inc., supplies milk to several...Ch. 17 - Prob. 44SECh. 17 - Prob. 45SECh. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Canton Supplies, Inc., is a service firm that...Ch. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Hudson Marine has been an authorized dealer for CD...Ch. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise 53....Ch. 17 - Refer to the Hudson Marine data in exercise 53. a....Ch. 17 - Forecasting Food and Beverage Sales The Vintage...Ch. 17 - Forecasting Lost Sales The Carlson Department...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- Table 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?arrow_forwardTable 2 shows a recent graduate’s credit card balance each month after graduation. a. Use exponential regression to fit a model to these data. b. If spending continues at this rate, what will the graduate’s credit card debt be one year after graduating?arrow_forwardThe US. import of wine (in hectoliters) for several years is given in Table 5. Determine whether the trend appearslinear. Ifso, and assuming the trend continues, in what year will imports exceed 12,000 hectoliters?arrow_forward
- The U.S. Census tracks the percentage of persons 25 years or older who are college graduates. That data forseveral years is given in Table 4[14]. Determine whether the trend appears linear. If so, and assuming the trendcontinues. in what year will the percentage exceed 35%?arrow_forwardA pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were Day: 1 Number sold: 36 2 38 Day: 10 11 Number sold: 48 52 3 2 12 55 MSE 42 Click here for the Excel Data File 4 44 13 54 5 48 14 56 6 49 15 57 79 50 8 49 9 52 a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 50 for Day 8, an initial trend estimate of 2, and a = B = .3, develop demand forecasts for Days 9 through 16. Then compute the resultant MSE using the error values from Days 8 through 15. (Round your intermediate period-by-period forecast and error values to 3 decimal places. Round your final MSE answer to 3 decimal places.)arrow_forwardthe table shows the percent of households with internet access for selected years from 2009 and projected through 2015. Year Percent of households 2009 67 2010 70 2011 72.5 2012 75 2013 76.5 2014 77.2 2015 78 Use the model to predict the percent of households with internet access in 2022.arrow_forward
- Use regression analysis to estimate a linear trend line for annual sales.arrow_forwardThe data below are the monthly sales of jeans at a local department store. The buyer would like to forecast sales of jeans for the next month, July. i. Forecast sales of jeans for March through June using the naive method, a two-period moving average, and exponential smoothing with an a=0.2. (Use naive to start the exponential smoothing process) ii. Compare the forecasts using MAD and decide which is best. iii. Using your method of choice, make a forecast for the month of July. Month Sales Jan 45 Feb 30 March 40 April 50 May 55 June 47arrow_forwardPlease show all working.arrow_forward
- 10. Household Income The following table shows the median income, in thousands of dollars, of Ameri- can families for 2003 through 2008. Year Income (thousands of dollars) 2003 52.68 2004 54.06 2005 56.19 2006 58.41 2007 61.36 2008 61.52arrow_forwardIf you made a forecast for Week 7 using the exponential smoothing forecasting approach, employing a smoothing constant of a = 0.20, how much would your forecast be different from the actual jobless claims? Week Income 1 2 3 4 5 16 7 18 19 10 980 1040 1100 1020 860 960 1080 1360 1380 1100 Approximately 23.9 Approximately 65.4 Approximately 43.2 Approximately 39.7arrow_forwardplease answer within 30 minutes.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
Publisher:Cengage Learning
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY