Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years of tourist visits to the area. The following data has been gathered on number of tourists who signed into the local information center. Year Number of tourists 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989
Q: Ed Rogers owns an appliance store. Sales data on a particular model of a DVD player for the past six…
A: Absolute Error = | Actual sales - Forecast | MAD = Average of Absolute Error
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: Given data - Month January February March April No. of Accidents 30 40 60 95
Q: Auniversity lecturer needs to allocate time next week to include time for office hours. He needs to…
A: Exponential smoothing is a time series forecasting method. It calculates a weighted average of past…
Q: Experiment of different forecasting techniques and then based on this, identify the best forecasting…
A: Forecasting is a essential a part of a organisation's stock operation. If a organisation overbuys,…
Q: The manager of a utility company in the Texas panhandlewants to develop quarterly forecasts of power…
A: Given data: Now, calculating the average quarterly demand
Q: Select the most suitable forecasting technique (survey, Delphi, averaging seasonal, naive, trend, or…
A: Forecasting may be a technique that uses historical knowledge as inputs to form educated estimates…
Q: The president of the Southern University wants to forecast student enrolments for this academic year…
A: Given data
Q: A police station had to deploy a police officer for an emergency multiple times in the last four…
A: F(t) = F(t-1) + (Alpha * (A(t-1) - F(t-1))) Where F(t-1) is the forecast for the previous period and…
Q: The manager of the Salem police department motor poolwants to develop a forecast model for annual…
A: a) The regression equation can be determined using excel as follows: Step 1: Put the data onto the…
Q: Obtain the linear trend equation for the following data on new checking accounts at Fair Savings…
A: Linear trend equation is given by: y = a+bx here, a = intercept and b = slope Formulas used: a = ∑y…
Q: The plot of the time series helps to decide about the best model to be used for forecasting O a True…
A: Th answer for the above question is as follows:
Q: The Hartley-Davis motorcycle dealer in the Minneapolis– St. Paul area wants to be able to forecast…
A: Given Data
Q: You are required to collect data about corona virus cases since 1st of AUG 2020 till the day of…
A: The unprecedented Covid-19 has impacted the lives of people worldwide.
Q: A manager has been using a certain forecasting technique to forecast demand for word processing…
A: The mean absolute deviation (MAD) of the two forecasting techniques can be compared to see which…
Q: Using a 2-year moving average, the forecast for year 6 = miles (round your response to the…
A: Two year moving average is a forecasting tool which concluding the average demand of previous two…
Q: The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for…
A: MAD
Q: The following gives the number of accidents that occurred on Florida State Highway 101 during the…
A: Find the given details below: Given details Month Number of Accidents Jan 25 Feb 45 Mar…
Q: A production company was able to hit the following sales order for the past 3 months: 45% of 420pcs…
A: Given data is
Q: 1. Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: A police station had to deploy a police officer for an emergency multiple times in the last four…
A: Exponential smoothing is a univariate time series forecasting approach that may be expanded to…
Q: Lori Cook has developed the following forecasting model: y = 40.0 + 4.20x, where y = demand for Kool…
A: Y = 40 + 4.20x Where, Y = Demand for Air Conditioners X = Outside temperature
Q: 12-1. The Hartley-Davis motorcycle dealer in the Minneapolis- St. Paul area wants to be able to…
A: Given - Month Sales January 9 February 7 March 10 April 8 May 7 June 12 July 10…
Q: Consider the following from an estate agent’s business nationally: Month Houses Sold Jan 380…
A: Since you have submitted multiple questions, as per guidelines I have answered the first question…
Q: You have a data set that includes time period and past sales data, and you want to use a time series…
A: Ans// D) Weighted moving average Time series forecasting makes the prediction about the future by…
Q: A police station had to deploy a police officer for an emergency multiple times in the last four…
A: Find the Given details below: Given Details: Weekday Number of calls each day Monday 6…
Q: The dean of a school of business is forecasting total student enrollment for this year's summer…
A: SIMPLE MOVING AVERAGE: A simple moving average always calculates the average of a selected range of…
Q: A police station had to deploy a police officer for an emergency multiple times in the last four…
A: Forecast for Friday using naive approach = Actual demand of previous period(Thursday) = 12.
Q: Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten…
A: A simple moving average (SMA) measures the average of a chosen range of values, normally closing…
Q: Air travel on Mountain Airlines for the past 18 weeks was:Week Passengers1 4052 4103 4204 4155 4126…
A: a) The moving average technique would not be appropriate for the given data because the data is…
Q: A police station had to deploy a police officer for an emergency multiple times in the last four…
A: A moving average is a method for determining the overall trends in a data collection by taking the…
Q: Management of Davis’s Department Store has used time-series extrapolation to forecast retail sales…
A: Note: - Since the exact question that has to be answered is not specified, we will answer only the…
Q: While other forecasting methods and techniques are also used, these three are the most notable at…
A: For Walmart's business, effective human resource management is essential. The company's human…
Q: Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be…
A: M5TV Appearances(X) Demand for Guitars (Y) XY X2 Y2 3 2 6 9 4 3 5 15 9 25 8 6 48 64 36 5 4…
Q: The Fieldale Dairy produces cheese, which it sells to su-permarkets and food processing companies.…
A: Given data is
Q: A restaurant wants to forecast its weekly sales. Historical data (in dollars) for 15 weeks are…
A: Forecasting refers to the statistical technique used for predicting the future demand and sales of…
Q: The Dean of a faculty wants to forecast student enrolments for this academic year based on the…
A: Answer: For solving the question, we have these following information. 5 years ago the enrolment…
Q: Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the…
A: a= 0.30 Year Sales Forecast error absolute ES a=0.30 error 1 460 420.00 40 40.00 2…
Q: Using an exponential smoothing model with an alpha value of 0.30, estimate the smoothed value…
A: Below is the solution:-
Q: 0. During the past five months the emergency new County Hospital has observed the number of patients…
A: Seasonal adjustment is a strategy for information smoothing that is utilized to foresee monetary…
Q: State and explain the weakness of standard forecasting technique in forecasting approaches
A: To be determined: the weakness of standard forecasting technique
Q: Forecasting The manager of a popular tourist resort wants to use the manual trend projection…
A: The benefit of the forecasting technique is 1) Cost reduction2) Inventory reduction and management…
Q: Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be…
A: Using least Square method Marron 5 TV appearancr(X) Demand for Guitars(Y X^2 Y^2 XY 3 4 9 16…
Q: The following table shows predicted product demand using your particular forecasting method along…
A: From the above given information, we have to compute the tracking signal of each period using the…
Q: Happy Lodge Ski Resorts tries to forecast monthlyattendance. Th e management has noticed a direct…
A: Solution-Linear Regression Equation will be of the form Y = a + bX where Y- is the dependent…
Q: Demand for Soft Shag Month Carpet (1,000 yd.) 1…
A: Exponential smoothing forecast is extension of simple moving average forecast. In exponential…
Q: A concert promoter is forecasting this year's attendance for one of his concerts based on the…
A: Given values, Year Attendance Four years ago 9,000 Three years ago 16,000 Two years ago…
Q: The problem below looks at forecasting methodologies to determine which forecasting model results in…
A: Formulae: For 3 period moving average (SMA) Simple moving average(Ft) = At-1+At-2+At-33Weighted…
Q: Eurotronics manufactures components for use in small electronic products such as computers, CD…
A: The linear regression forecast is used here because no other data is available. One can also use a…
Q: Quarterly data for the failures of certain aircraft engines at a local military base during the last…
A:
Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years of tourist visits to the area. The following data has been gathered on number of tourists who signed into the local information center.
Year |
Number of tourists |
1 |
700 |
2 |
248 |
3 |
633 |
4 |
458 |
5 |
1410 |
6 |
1588 |
7 |
1629 |
8 |
1301 |
9 |
1455 |
10 |
1989 |
Tom is interested in implementing a
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
- Under what conditions might a firm use multiple forecasting methods?The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
- 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?The 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?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: Exponential smoothing with α = 0.4 Ordinary least squares technique or linear regression analysis Make graphical presentations of your answers and determine which…
- The president of the Southern University wants to forecast student enrolments for this academic year based on the following historical data: (5 years ago enrolment was 10508 ), (4 years ago enrolment was 12646), (3 years ago enrolment was 13018 ), (2 years ago enrolment was 16012 ) and in the last year enrolment was 19323 . What is the forecast for this year using three periods simple moving average? a. 12057.333 b. 14301.4 c. 13892 d. 16117.667Quantitative forecasting should be preferred over qualitative forecasting since they involve computations and are, therefore, more accurate. True FalsePhillip 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: Ordinary least squares technique or linear regression analysis
- 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 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)Tom’s Towing LLC operates a fleet of tow trucks that it sends to help drivers in need onthe nearby highway. The numbers of calls requesting a tow truck for Monday, Tuesday,Wednesday, and Thursday were 27, 18, 21, and 15, respectively. What would be its forecast for Friday using an exponential smoothing forecasting approach? Use α = 0.4 and aforecast for Monday of 18.Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: 3 8 9 6 7 6 3 7 10 11 Year Year Forecast (000) 1 5 1 5 2 5 4 4 4 5 11 Registrations (000) Use exponential smoothing with a smoothing constant of 0.4 to forecast the registrations at the seminar for years 2 through 12. To begin the procedure, assume that the forecast for year 1 was 5,000 people signing up (round your responses to one decimal place): 2 3 5 6 7 8 10 16 9 11 12 10 D 11 12 a) What is the MAD? Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (x) = 0.4 and a starting forecast of F₁ = 5) is thousand registrations (round your response to one decimal place). b) What is the MSE? The mean squared error based on the forecast developed using the exponential smoothing method (with a smoothing constant (x) = 0.4 and a starting forecast of F₁ = 5) is (round your response to two decimal…