STATISTICS F/BUSINESS+ECONOMICS-TEXT
13th Edition
ISBN: 9781305881884
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
Chapter 17, Problem 47SE
a.
To determine
Construct the time series plot.
Explain type of pattern.
b.
To determine
Calculate the linear trend equation for data.
Calculate the forecast values for next two months’ cash requirements.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
The Seneca Children’s Fund (SCC) is a local charity that runs a summer camp for disadvantagedchildren. The fund’s board of directors has been working very hard over recentyears to decrease the amount of overhead expenses, a major factor in how charities arerated by independent agencies. The following data show the percentage of the money SCChas raised that was spent on administrative and fund-raising expenses over the last sevenyears.
a. Construct a time series plot. What type of pattern exists in the data?b. Use simple linear regression analysis to find the parameters for the line that minimizesMSE for this time series.c. Forecast the percentage of administrative expenses for year 8.d. If SCC can maintain its current trend in reducing administrative expenses, how longwill it take SCC to achieve a level of 5 percent or less?
the costello Music company has been in business for five years. during that time, salesof pianos increased from 12 units in the first year to 76 units in the most recent year. Fredcostello, the firm’s owner, wants to develop a forecast of piano sales for the coming year.the historical data follow.Year 1 2 3 4 5Sales 12 28 34 50 76a. construct a time series plot. What type of pattern exists in the data?b. develop the linear trend equation for the time series. What is the average increase insales that the firm has been realizing per year?c. Forecast sales for years 6 and 7.
the values of alabama building contracts (in $ millions) for a 12-month period follow.240 350 230 260 280 320 220 310 240 310 240 230a. construct a time series plot. What type of pattern exists in the data?
Chapter 17 Solutions
STATISTICS F/BUSINESS+ECONOMICS-TEXT
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 - The Seneca Childrens Fund (SCF) is a local charity...Ch. 17.4 - The following table shows Googles annual revenue...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Quarterly revenue ( millions) for Twitter for the...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 - The data contained in the DATAfile named CrudeCost...Ch. 17 - Annual retail store revenue for Apple from 2007 to...Ch. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Prob. 47SECh. 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
- canton Supplies, inc., is a service firm that employs approximately 100 individuals.Managers of canton Supplies are concerned about meeting monthly cash obligations andwant to develop a forecast of monthly cash requirements. Because of a recent changein operating policy, only the past seven months of data that follow are considered to berelevant.Month 1 2 3 4 5 6 7Cash Required ($1000s) 205 212 218 224 230 240 246a. construct a time series plot. What type of pattern exists in the data?b. Using Minitab or excel, develop a linear trend equation to forecast cash requirementsfor each of the next two months.arrow_forwardIn retail, a store manager uses time series models to understand shopping trends. Review the scatter plot of the store’s sales from 2010 through 2021 to answer the questions. See attached as image. Here is the data for Fiscal Year and Sales: Fiscal Year Sales 2010 $260,123.00 2011 $256,853.00 2012 $274,366.00 2013 $290,525.00 2014 $322,318.00 2015 $380,921.00 2016 $541,925.00 2017 $909,050.00 2018 $1,817,521.00 2019 $3,206,564.00 2020 $4,921,005.00 2021 $5,686,338.00 Time series decomposition seeks to separate the time series (Y) into 4 components: trend (T), cycle (C), seasonal (S), and irregular (I). What is the difference between these components? The model can be additive or multiplicative. When do you use each? Review the scatter plot of the exponential trend of the time series data. Do you observe a trend? If so, what type of trend do you observe? What predictions might you make about the store’s annual sales over the next few years?arrow_forwardUnited Dairies, Inc., supplies milk to several independent grocers throughout DadeC ounty, Florida. Managers at United Dairies want to develop a forecast of the number ofhalf gallons of milk sold per week. Sales data for the past 12 weeks are: a. Construct a time series plot. What type of pattern exists in the data?b. Use exponential smoothing with a 5 0.4 to develop a forecast of demand for week 13.What is the resulting MSE?arrow_forward
- After its move in 1990 to La Junta, Colorado, and its new initiatives, the DeBourgh Manufacturing Company began an upward climb of record sales. Suppose the figures shown here are the DeBourgh monthly sales figures from January 2001 through December 2009 (in $1,000s). a) Produce a time series plot. Are there any trends evident in the data? Does DeBourgh have a seasonal component to its sales? b) Deseasonalize the data using Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add a trendline. c) Forecast the sales from January to December of the year 2010. d) Include a discussion of the general direction of sales and any seasonal tendencies that might be occurrinG Month 2001 2002 2003 2004 2005 2006 2007 2008 2009 January 139.7 165.1 177.8 228.6 266.7 431.8 381 431.8 495.3 February 114.3 177.8 203.2 254 317.5 457.2 406.4 444.5 533.4 March 101.6 177.8 228.6 266.7 368.3 457.2 431.8 495.3 635 April 152.4 203.2…arrow_forwardThe values of Alabama building contracts (in millions of dollars) for a 12-month period follow. (a) Construct a time series plot. 400 350 300 250 200+ O 1 2 3 4 Month 5 6 What type of pattern exists in the data? 7 240 340 220 260 280 310 8 9 150- 100 The data appear to follow a seasonal pattern. The data appear to follow a cyclical pattern. The data appear to follow a trend pattern. O The data appear to follow a horizontal pattern. 10 50 0 11 12 01 2 400 350 300 250 200- 150 100 50 0 0 1 2 3 4 5 34 5 6 7 8 9 10 11 12 13 Month Time Series Value (in $ millions) 240 340 (b) Compare the three-month moving average forecast with the exponential smoothing forecast using a = 0.2. (Round your answers to two decimal places.) 220 260 280 310 210 320 250 6 320 7 Month 230 220 210 320 250 320 230 220 de 8 9 10 11 12 13 r 3-Month Moving Average Forecast (in $ millions) 400 350+ 300 250 200+ 150- 100+ 50+ 0 01010101000 400 T 350 300 0 1 2 3 4 250+ 200+ 150+ 100+ α = 0.2 Forecast (in $ millions) 50…arrow_forwardFor the Texas Shipping Company, the monthly percentages of all shipments received on time over the past 12 months are 82, 86, 87, 89, 84, 85, 84, 86, 75, 95, 90, and 92. a. Construct a time series plot (you can include it in the work file question at the end, not here). Identify what type of pattern, if any, exists in the data? Compare the three-month moving average forecast with an exponential smoothing forecast for alpha= 0.25 and answer the following: b. MSE for 3-month moving average method c. MSE for exponential-smoothing method : d. Which method should be preferred? Answer "3-month MA" or "Exponential Smoothing": e. What is the forecast for next month using the preferred method?arrow_forward
- the data contained in the datafile named crudecost shows the U.S. refiner acquisition cost of crude oil in dollars per barrel (energy information administration website,February 3, 2014).a. construct a time series plot. What type of pattern exists in the data?arrow_forwardFor the hawkins company, the monthly percentages of all shipments received on timeover the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83.a. construct a time series plot. What type of pattern exists in the data?b. compare the three-month moving average approach with the exponential smoothing approach for a = .2. Which provides more accurate forecasts using MSe as themeasure of forecast accuracy?arrow_forwardIn Colorado, sales of medical marijuana began in November 2012; however, the Department of Revenue did not report tax collection data until February of 2014. The accompanying data file includes monthly revenue from medical and retail marijuana tax and fee collections as posted in the Colorado state accounting system. Use the linear trend model (no seasonality) to forecast the tax revenue for November and December of 2018. Date Revenue February/14 3,519,756 March/14 4,092,575 April/14 4,980,992 May/14 5,273,355 June/14 5,715,707 July/14 6,522,085 August/14 7,407,450 September/14 7,741,167 October/14 7,232,870 November/14 7,642,800 December/14 7,465,568 January/15 8,558,141 February/15 8,802,295 March/15 9,099,395 April/15 9,979,643 May/15 10,617,311 June/15 11,326,452 July/15 10,856,584 August/15 12,811,437 September/15 13,181,758 October/15 11,656,736 November/15 11,290,012 December/15 12,231,410 January/16 13,247,434 February/16…arrow_forward
- Phillip Cane, the managing editor of Your Life Magazine, needs to develop a forecasting system for monthly newsstand sales in order to schedule press runs. Sales in thousands of copies for the last eight months of 2020 (the first year of publication) were: Month (2020) Sales May 50 June 45 July 60 August 52 September 69 October 60 November 47 December 53 Phillip does not believe there is a seasonal pattern. Make the forecast using the following techniques for the first six months of 2021: 3-month moving average 3-month weighted moving average (weights are 3,2,1 : the highest for the most recent past month data)arrow_forwardA construction company builds permanent docks and seawalls along the southern shore of Long Island, New York. Although the firm has been in business only five years, revenue has increased from $298,000 in the first year of operation to $1,079,000 in the most recent year. The following data show the quarterly sales revenue in thousands of dollars. Quarter Year 1 O 500 450 400 350 (a) Construct a time series plot. 200 1 2 150 3 300+ 250- 100 4 50 20 95 175 Year 2 quarter 2 forecast quarter 3 forecast quarter 4 forecast 37 131 245 21 Year 3 75 150 326 500- 450 400- 350 300 250 200 Mm WW NU 150- 100- 50 0 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 Year 3 Year 4 Year 5 Year/Quarter Year 1 Year 2 Year 1 Year 2 Year 4 Year 5 Year 3 Year/Quarter 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 Year 1 Year 2 Year 3 Year 4 Year 5 Year/Quarter 43 Year 4 92 197 384 thousand thousand 77 thousand thousand Year 5 176 277 445 181 500 450 400+ 350 300- 250- 200- What type of…arrow_forwardConsider the following time series data. Quarter Year 1 1 De- 2 3 4 3 1 4 6 Year 2 quarter 3 forecast quarter 4 forecast 5 2 6 8 Year 3 6 5 7 (a) Construct a time series plot. What type of pattern exists in the data? O The time series plot shows a horizontal pattern and no seasonal pattern in the data. The time series plot shows a linear trend and no seasonal pattern in the data. O The time series plot shows a linear trend and a seasonal pattern in the data. O The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. 9 (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. (Round your numerical values to three decimal places.) x₁ = 1 If quarter 1, 0 otherwise; x₂ = 1 If quarter 2, 0 otherwise; x₂ = 1 If quarter 3, 0 otherwise (c) Compute the quarterly forecasts for the next year based on the model you developed in part (b). (Round your answers to two decimal…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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