The forecast with out seasonality is modeled as: Sales 6 t+ 236.00, where t= time in months, beginning in January 2015. Seasonality for the first three months are given in the table below. Determine a seasonalized forecast for Feb of 2016. Month Seasonal Factor January 1.9000 February 0.6262 March 0.1000 Submit Answer format: Number: Round to: 1 decimal places.

The forecast with out seasonality is modeled as: Sales 6 t+ 236.00, where t= time in months, beginning in January 2015. Seasonality for the first three months are given in the table below. Determine a seasonalized forecast for Feb of 2016. Month Seasonal Factor January 1.9000 February 0.6262 March 0.1000 Submit Answer format: Number: Round to: 1 decimal places.

Managerial Economics: Applications, Strategies and Tactics (MindTap Course List)

14th Edition

ISBN:9781305506381

Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Publisher:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris

Chapter5: Business And Economic Forecasting

Section: Chapter Questions

Problem 3E: Metropolitan Hospital has estimated its average monthly bed needs as N=1,000+9X where...

See similar textbooks

Similar questions

A researcher has a sample of 6 annual observations {94, 104, 102, 99, 111 and 107} for the CPI in country Z for the period 2015 to 2020, and wants to forecast CPI for the years 2021, 2022 and 2023. The researcher uses 3 different forecasting models: A, B and C. Model A is an AR(1) model with no drift and with an estimated autoregressive coefficient = 0.7. Model B is a MA(1) model with no constant and with an estimated MA coefficient = -0.4 (note the minus !). Model C is a random walk model with no drift. The error terms over the 2015-2020 period were estimated to have the values: {3, -1, 2, 4, -3, 1}. a. Compute the 2021, 2022 and 2023 forecasted values for the consumer price index based on the three models. Show the formulas and the details of your calculations, and explain all the related symbols. b. Suppose that the actual values of the CPI over the 2021, 2022 and 2023 were {108, 114, 105}. Calculate the Root mean square error of the three model forecasts over the 2021-2023…
Historical demand for Peeps is as displayed in the table. Month Demand January 11 February 18 March 31 April 39 May 44 June 53 July 67 August 82 September 96 Develop forecasts from June through October using these techniques: Holt's method with alpha=0.2 and beta=0.1. For Holt's model, the level and trend for May are assumed to be 44 and 12. Judge which forecast method is the best based on MAD.
1- Indicate if the following data sets represent time-series, cross section or panel data . a- Number of the registered students of the Pretoria Universities between the years 1995 and 2016. ___________________ b- Inflation rate of the EU members in 2020. ___________________ c- FDI to Turkey between the years 1990 and 2016. ___________________ d- Employment rate in Zimbabwe over the months January to 2020 December.
An attempt was made to evaluate the inflation rate as a predictor of the spot rate in the German treasury bill market. For a sample of 79 quarterly observations, the estimated linear regressionŷ = 0.0027 + 0.7916xwas obtained, wherey = actual change in the spot ratex = change in the spot rate predicted by the inflation rateThe coefficient of determination was 0.097, and the estimated standard deviation of the estimator of the slope of the population regression line was 0.2759.a. Interpret the slope of the estimated regression line.b. Interpret the coefficient of determination.c. Test the null hypothesis that the slope of the population regression line is 0 against the alternative that the true slope is positive, and interpret your result.d. Test, against a two-sided alternative, the null hypothesis that the slope of the population regression line is 1, and interpret your result.
The following data relate the sales figures of restaurant, to the number of customers registered that week: Week Customers Sales (SR) First 16 330 Second 12 270 Third 18 380 Fourth 14 300 a) Perform a linear regression that relates bar sales to guests (not to time). b) If the forecast is for 20 guests next week, what are the sales expected to be?
The type of economic indicator that can best be used for business forecasting is the:
A local moving company has collected data on the number of moves they have been asked to perform over the past two years. Moving is highly seasonal, so the owner/operator, who is both burly and highly educated, decides to apply the multiplicative seasonal method to forecast the number of customers for the coming year. The equation for the trend line of yearly sales is Ft = 16 + 60t. Please forecast demand for each quarter in Year 3. (Round the forecasts to whole numbers and show all calculations). Complete the table below and forecast the sales of Year 3 by quarter. Year 1 Year 2 Year 3 Quarter Demand Seasonal Index Quarter Demand Seasonal Index Average Seasonal Index Forecast 1 20 1 27 2 40 2 45 3 45 3 55 4 31 4 41 Total Average
The following table represents sales data for milk (in hundred liters) sold by a grocery.Do the computations to fill out the table and answer the following questions:1. Using MAD as the criterion, which of the following models would you use for thegiven time series data? Why?A. Naïve approach;B. 5-month SMA model;C. WMA model with weights 0.1, 0.3, and 0.6; orD. ES model with α = 0.5 and a forecast of 3,500 liters in the first month. NOTE: In answering Item 1, mention the whole description of the model; i.e., not just“SMA model”, but “SMA model with n = ...”; not just “WMA model”, but “WMA modelwith weights ...”; not just “ES model”, but “ES model with α = ...”. 2. Interpret the MAD of the most accurate among the forecasting models above.3. Based on your decision in Item 1, what should be the forecast for Month 11?
Suppose that you work for a U.S. senator who is contemplating writing a bill that would put a national sales tax in place. Because the tax would be levied on the sales revenue of retail stores, the senator has asked you to prepare a forecast of retail store sales for year 8, based on data from year 1 through year 7. The data are: (c1p2) Year Retail Store Sales 1 $1,225 2 1,285 3 1,359 4 1,392 5 1,443 6 1,474 7 1,467 54 Chapter One a. Use the first naive forecasting model presented in this chapter to prepare a forecast of retail store sales for each year from 2 through 8. b. Prepare a time-series graph of the actual and forecast values of retail store sales for the entire period. (You will not have a forecast for year 1 or an actual value for year 8.) c. Calculate the root-mean-squared error for your forecast series using the values for year 2 through year 7. 3. Use the second naive forecasting model presented in this chapter to answer parts (a) through (c) of Exercise 2. Use P 0.2 in…
Consider the following time series data: Month 1 2 3 4 5 6 7 Value 24 13 20 12 19 23 15 Compute MSE using the most recent value as the forecast for the next period. What is the forecast for month 8? Compute MSE using the average of all the data available as the forecast for the next period. What is the forecast for month 8? Which method appears to provide the better forecast?
Suppose you have an extra six months of data on demands and prices, in addition to the data in the example. These extra data points are (350,84), (385,72), (410,67), (400,62), (330,92), and (480,53). (The price is shown first and then the demand at that price.) After adding these points to the original data, use Excel’s Trendline tool to find the best-fitting linear, power, and exponential trend lines. Then calculate the MAPE for each of these, based on all 18 months of data. Does the power curve still have the smallest MAPE?
Comprehensively state the criteria and process of selecting appropriate models for time series forecasting.