EBK STATISTICS FOR BUSINESS & ECONOMICS
12th Edition
ISBN: 8220100460463
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17, Problem 47SE
Canton Supplies, Inc., is a service firm that employs approximately 100 individuals. Managers of Canton Supplies are concerned about meeting monthly cash obligations and want to develop a forecast of monthly cash requirements. Because of a recent change in operating policy, only the past seven months of data that follow are considered to be relevant.
| Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Cash Required ($1000s) | 205 | 212 | 218 | 224 | 230 | 240 | 246 |
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Use Holt’s linear exponential smoothing with α = .6 and β = .4 to forecast cash requirements for each of the next two months.
- c. Using Minitab or Excel, develop a linear trend equation to forecast cash requirements for each of the next two months.
- d. Would you recommend using Holt’s linear exponential smoothing with α = .6 and β = .4 to forecast cash requirements for each of the next two months or the linear trend equation? Explain.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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.
please answer within 30 minutes...
Don't hand writing solution.
Chapter 17 Solutions
EBK STATISTICS FOR BUSINESS & ECONOMICS
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
- A 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_forwardImport Illinois.xls as a table. Using logical indexing to select the years with more than 2800 cases of Diabetes. Then plot all of the data on the same axis. F1 fx Homicide B C E Year Accidents Cancer Diabetes Heart Disease Homicide| Suicide 1999 4125 25024 3004 33387 1023 1020 3 2000 4041 25365 2995 31844 991 1003 4. 2001 4077 24778 3092 30990 1087 1139 2002 4222 24737 3011 30821 1016 1145 2003 3942 24464 3044 29816 966 1011 7. 2004 4133 24289 3069 28284 871 1028 8. 2005 4182 24250 3034 28226 866 1086 9. 2006 4451 24084 2795 27007 865 1010 10 2007 4367 24115 2851 25813 863 1108 11 2008 4218 24300 2846 26078 872 1198 12 2009 3961 24185 2741 24931 881 1177 13 2010 3997 24070 2507 24959 783 1178 14 2011 4166 24007 2693 24987 812 1226 15 2012 4488 24562 2706 24667 832 1292 16 2013 4511 24491 2798 17 24839 792 1321 2014 4644 24501 2712 18 25024 792 1398 2015 4850 24713 2817 25652 19 863 1363 20 21arrow_forward
- We have the following data. Using the B&S Model, the price of a call option is ……….. price $100 price $120 Dev 20% 6 months rate 10. Need typed answer only.Please give answer within 45 minarrow_forward3) U.S. Health care expenditures. Because the over-65 population is growing more rapidly in the next few decades health care spending is expected to increase significantly in the next few decades. The following table gives the projected US health care expenditure (in trillions) from 2008 to 2013 Year 2008 2009 2010 2011 2012 2012 Expenditure 2.34 2.47 2.57 2.70 2.85 3.02 a) Draw a scatter diagram for this data. Use “Years since 2008” on the x-axis. Make sure the scatter diagram includes all required elements (axes labels, title, and appropriate scale) b) Use the points for 2009 and 2011 to find an equation of a line modeling this situation c) Use linear regression to find an equation of a line modeling this situation d) Use the equation in b to predict expenditures in 2016 and do this again for the equation in part c. What is the absolute and percentage difference between the two equations (use the equation in c as the base equation in the % calculation) e) Now use…arrow_forwardMovieflix, an online movie streaming service that offers a wide variety of award-winning TV shows, movies, animes, and documentaries, would like to determine the mathematical trend ofmemberships in order to project future needs. MovieFlix - Advertising and Subscriptions Year Advertising Expenditure $ 000 Membership Subscriptions 2013 51 62 2014 58 68 2015 62 66 2016 65 66 2017 68 67 2018 76 72 2019 77 73 2020 78 72 2021 78 78 2022 84 73 2023 85 76 (i) Plot the scattergraph for the data.arrow_forward
- Suppose the table below gives the average tuition and fees at 2-year and 4-year state schools in a particular state. Values are adjusted to 2019 dollars. Academic Year 4-year state school 2-year state school 2005-06 $5,904 $2,661 2006-07 $6,066 $2,539 2007-08 $6,289 $2,604 2008-09 $7,222 $2,901 2009-10 $7,738 $3,065 2010-11 $8,035 $3,117 2011-12 $8,154 $3,108 2012-13 $8,497 $3,075 2013-14 $8,578 $3,025 2014-15 $9,390 $3,326 2015-16 $10,004 $3,504 2016-17 $10,474 $3,663 2017-18 $10,789 $3,830 2018-19 $10,874 $3,859 2019-20 $10,900 $3,907 Here is a graph of the information from the table. a. What is the absolute change in tuition and fees at this state's four-year institutions from 2005-06 to 2019-20? b. What is the relative change in tuition and fees at this state's four-year institutions from 2005-06 to 2019-20? Round to the nearest whole percentage…arrow_forwardThe creator of a new online multiplayer survival game has been tracking the monthly downloads of the game. The following table shows the monthly downloads (in thousands) for each month of the current and previous year. Click on the datafile logo to reference the data. Month Downloads Month Downloads (previous year) (thousands) (current year) (thousands) February 33.0 January 37.0 March 34.0 February 35.0 April 34.0 March 37.0 May 32.0 April 38.0 June 32.0 May 35.0 July 35.0 June 36.0 August 35.0 July 35.0 September 37.0 August 35.0 October 37.0 September 34.0 November 36.0 October 31.0 December 34.0 Compute the mean, median, and mode for number of downloads in the previous year. Mean (to 3 decimals) thousand Median (to 2 decimal) thousand Mode (to 2 decimal) thousand…arrow_forwardSuppose that you are a researcher and wish to construct a linear mathematical (statistical) model that relates the number of years and the corresponding exports (million U.S.$) of a country. The constructed model may use to forecasts the future values. You have obtained the relevant data for the during of 1990 to 1995 and you have listed the data in Table 5. Table 5. Shows the list of the amount that have earned on exports Year No. 1 2 3 4 5 6 Exports 4954 6131 6904 6813 6803 8137 (a) Construct a suitable graph that explains the relationship between the number of years and the corresponding exports. (b) Construct a mathematical (Statistical) model by using least square method between number of years and the corresponding sales. (c) Interpret the slope of the estimated linear model (d) Forecast the value of exports by using the estimated linear model for the year of 2000arrow_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 Inc
Probability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage Learning
Statistics 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:PEARSON
The Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. Freeman
Introduction 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