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.667

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.667

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 40P: The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels....

See similar textbooks

Similar questions

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 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 Dean of a faculty wants to forecast student enrolments for this academic year based on the following historical data: (5 years ago enrolment was 11770 ), (4 years ago enrolment was 15251), (3 years ago enrolment was 15785 ), (2 years ago enrolment was 16076 ) and in the last year enrolment was 19001 . What is the forecast for this year using exponential smoothing with alpha=0.58999997 , if the forecast for two years ago was :17623 a. 16710.27 b. 18061.801 c. 17801.75 d. 17386.035
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 forecasting system and is investigating the following forecasting methods as possibilities: calculate forecasts for Year 11 using the Regression method ( show formuals using excel)
The dean of a school of business is forecasting total student enrollment for this year's summer session classes based on the following historical data: Year Enrollment Four years ago 2000 Three years ago 2200 Two years ago 2800 Last year 3000 What is this year's forecast using a three-year simple moving average? a. 2,600 b. 2,400 c. 2,667 d. 2,500 e. 2,333
The Grand Bakery produces 60 special sourdough rolls every day. Any rolls that are not sold each day are given to the employees. They have collected sales data from the past week: Day Rolls sold 1 50 2 50 3 48 4 60 5 53 6 60 What is the value of F6 if they use a 3-day weighted moving average with W1 = 0.6, W2 = 0.2, and W3 = 0.2? Using the data from above, calculate the forecast for period 7 using a four-period moving average:
The past two years sales at ACSR Inc. were 3 million and 5 million. Their forecast team used a two-period moving average to forecast its sales this year. But the actual sales for this year were 5 million. Now, the forecast team wants to forecast its sales for next year by using exponential smoothing with alpha equals 0.6. What is the forecast using exponential smoothing with alpha = .6? 2. If we decide to use an alpha of .2 instead of .6, will we be ‘weighting the error from the previous period higher or the Forecast from the previous period higher? Explain briefly or show using math! (In this question I am asking if we change the alpha to a lower alpha, what will be the effect – what will we be ‘weighing’ as more important?)
A concert promoter is forecasting this year's attendance for one of his concerts based on the following historical data: Year Attendance Four Years ago 10,000 Three Years ago 12,000 Two Years ago 18,000 Last Year 20,000 What is this year's forecast using exponential smoothing with alpha = 0.2, if last year's smoothed forecast was 15,000?
Management of Davis’s Department Store has used time-series extrapolation to forecast retail sales for the next four quarters. The sales estimates are $100,000, $120,000, $140,000, and $160,000 for the respective quarters before adjusting for seasonality. Seasonal indices for the four quarters have been found to be 1.30, 0.90, 0.70, and 1.10, respectively. Compute a seasonalized or adjusted sales forecast? Develop an adjusted exponential forecast for a firm with the demand for bread as shown in the table below. week 1 2 3 4 5 6 7 8 Demands 700 685 648 717 713 728 754 762 Let α = 0.1 and β = 0.2. Previous average of Ft–1= 650, and let the initial trend adjustment, Tt–1 = 0? note please answer all the questions
Sales of hair dryers at the Walgreens stores in Youngstown, Ohio, over the past 4 months have been 100, 110, 120, and 130 units (with 130 being the most recent sales). Develop a moving-average forecast for next month, using these three techniques:a) 3-month moving average.b) 4-month moving average.c) Weighted 4-month moving average with the most recent month weighted 4, the preceding month 3, then 2, and the oldest month weighted 1.d) If next month’s sales turn out to be 140 units, forecast the following month’s sales (months) using a 4-month moving average.
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (α) of 0.30 and a starting forecast of 415.00, the following sales forecast has been developed: Year Sales Forecasted Sales 2005 455 415.00 2006 502 427.00 2007 518 449.50 2008 563 470.05 2009 584 497.94 Part 2 The MAD for a forecast developed using exponential smoothing with α = 0.30 is enter your response here sales (round your response to two decimal places). Part 3 Forecasted sales for years 2006 through 2010 using exponential smoothing with α = 0.60 and a starting forecast of 415.00 are (round your responses to two decimal places): Year 2005 2006 2007 2008 2009 2010 Forecasted Sales 415.00 enter your response here enter…