STATISTICS F/BUSINESS+ECONOMICS-TEXT
13th Edition
ISBN: 9781305881884
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 17, Problem 51SE
Refer to the Costello Music Company time series in exercise 49.
- a. Deseasonalize the data and use the deseasonalized time series to identify the trend.
- b. Use the results of part (a) to develop a quarterly forecast for next year based on trend.
- c. Use the seasonal indexes developed in exercise 50 to adjust the forecasts developed in part (b) to account for the effect of season.
50. Refer to the Costello Music Company problem in exercise 49.
- a. Using time series decomposition, compute the seasonal indexes for the four quarters.
- b. When does Costello Music experience the largest seasonal effect? Does this result appear reasonable? Explain.
49. Consider the Costello Music Company problem in exercise 48. The quarterly sales data follow.
Year | Quarter I | Quarter 2 | Quarter 3 | Quarter 4 | Total Yearly Sales |
1 | 4 | 2 | 1 | 5 | 12 |
2 | 6 | 4 | 4 | 14 | 28 |
3 | 10 | 3 | 5 | 16 | 34 |
4 | 12 | 9 | 7 | 22 | 50 |
5 | 18 | 10 | 13 | 35 | 76 |
- a. Use the following dummy variables to develop an estimated regression equation to account for any seasonal and linear trend effects in the data: Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; and Qtr3 = 1 if Quarter 3, 0 otherwise.
- b. Compute the quarterly forecasts for next year.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
John Kittle, an independent insurance agent, uses a five-year moving average to forecast the number of claims made in a single year for one of the large insurance companies he sells for. He has just discovered that a clerk in his employ incorrectly entered the number of claims made four years ago as 1,400 when it should have been 1,200.a. What adjustment should Mr. Kittle make in next year’s forecast to take into account the corrected value of the number of claims four years ago?b. Suppose that Mr. Kittle used simple exponential smoothing with a = .2instead of moving averages to determine his forecast. What adjustment is now required in next year’s forecast? (Note that you do not need to know the value of the forecast for next year in order to solve this problem.)
In 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…
Use the most accurate method to forecast the revenues of licenses, permits, and fees in Years 9, 10, and 11. Use the Year 8 actual figure instead of the forecast figure (Year 8 was $23,210,218). Also, consider three incremental changes in forecasting.
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
- Find the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forwardPlease help with the corrected answers in details: The following time series shows the sales of a particular product over the past 12 months. Month Sales 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 What type of pattern exists in the data? The data appear to follow a trend pattern. The data appear to follow a horizontal pattern. The data appear to follow a cyclical pattern.The data appear to follow a seasonal pattern. (b) Use ? = 0.2 to compute the exponential smoothing values for the time series. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 (c) Use a smoothing constant of ? = 0.4 to compute the exponential smoothing forecasts. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135…arrow_forwardMazars is an integral player in auditing, accounting, tax and advisory services in South Africa. A seasonal analysis was done on their sales for the period between 2009 and 2014 and the Median Seasonal Index's and the Adjusted Seasonal index's was calculated for each quarter as reflected below. Median seasonal Index Adjusted seasonal index Quarter 1 79.5660 79.0886 Quarter 2 85.3333 84.8213 Quarter 3 135.9855 135.1696 Quarter 4 101.5385 100.9293 Total 400.00 Each adjusted seasonal index measures the magnitude of seasonal influence on the actual values of the time series for a given period within the year. Interpret the seasonal analysis results for Quarter 1arrow_forward
- 6. The annual population of Afghanistan is available in the global economy data set. a. Plot the data and comment on its features. Can you observe the effect of the Soviet- Afghan war? b. Fit a linear trend model and compare this to a piecewise linear trend model with knots at 1980 and 1989. c. Generate forecasts from these two models for the five years after the end of the data, and comment on the results.arrow_forwardYour new store opened for business on September 1. Assuming you plan to forecast sales using a 6- month Simple Moving Average approach, what is the first month you could create a forecast? January October February April O Marcharrow_forwardConsider the following time series: Quarter Year 1 Year 2 Year 3 1 69 66 60 2 44 36 46 60 62 55 4 79 82 73 3.arrow_forward
- please answer within 30 minutes...arrow_forward2.5 2.0 15 1.0 0.5 Incarcerated Americans 1920-2014 Prison Jail 0 1920 1930 1940 1950 1960 1970 1980 1990 2000 2010 Year Juvenile Detention 6. Describe the trend depicted in this ch 7. What impact do you think this trend has had on the public defender system? depicarrow_forward1. Give below is the data on production of a company (in lakhs). Year: 1983 1984 1985 1986 1987 1988 1989 Production: 15 14 18 20 17 24 27 Fit the linear trend. Compute the trend values for each year. Estimate the production for yeаr 1991.arrow_forward
- The following table gives the average monthly exchange rate between the U.S. dollar and the euro for 2009. It shows that 1 euro was equivalent to 1.289 U.S. dollars in January 2009. Develop a trend line that could be used to predict the exchange rate for 2010. Use this model to predict the exchange rate for January 2010 and February 2010. MONTH ______________________ EXCHANGE RATE January ....................................... 1.289 February ...................................... 1.324 March ......................................... 1.321 April .......................................... 1.317 May ........................................... 1.280 June ........................................... 1.254 July ........................................... 1.230 August ....................................... 1.240 September ................................... 1.287 October ..................................... 1.298 November .................................. 1.283 December…arrow_forwardAmex PLC has gathered following information on the sales of face mask from April 2020 toSeptember 2020. Month Sales ($) April 17,000 May 18,000 June 19,500 July 22,000 Augus 21,000September 23,000You are required to;a. Using linear trend equation forecast the sales of face masks for October 2020.b. Calculate the forecasted sales difference if you use 3-period weighted moving averagedesigned with the following weights: July 0.2, August 0.3 and September 0.5. Note: You need to show all the steps in your calculation. No excel files will be graded.arrow_forward12. Find the following table. 1. Fit a straight line trend by the method of least square. 2. Calculate the trend value. Year: 1990 1991 1992 1993 1994 1995 1996 Production: 12 10 14 11 13 15 16 (*000 tons)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- 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 HarcourtTrigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
- College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage LearningHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGALFunctions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
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