The following information is for Questions 30-33: A firm's demand data from the last two quarters is displayed in the table. Month Demand January 154 February 148 March 214 April 210 May 225 June 246 30. What is the forecast for July's demand if using the three-period moving average? A. 172 B. 218 C. 227 D. 240 31. Use a three period weighted moving average to forecast July's demand with the weight for the previous month -50%, two months ago=20% and three months ago = 30%. A. 225.0 B. 231.0 C. 246.0 D. 77.0 32. What is the forecast error (FE) for January if using a last period forecasting technique? A. 200 B. 154 C. 246 D. The forecast error cannot be calculated 33. What is the forecast error (FE) for June if using a three-period moving average? A. -9.3 B. -29.7 C. 29.7 D. The forecast error cannot be calculated

The following information is for Questions 30-33: A firm's demand data from the last two quarters is displayed in the table. Month Demand January 154 February 148 March 214 April 210 May 225 June 246 30. What is the forecast for July's demand if using the three-period moving average? A. 172 B. 218 C. 227 D. 240 31. Use a three period weighted moving average to forecast July's demand with the weight for the previous month -50%, two months ago=20% and three months ago = 30%. A. 225.0 B. 231.0 C. 246.0 D. 77.0 32. What is the forecast error (FE) for January if using a last period forecasting technique? A. 200 B. 154 C. 246 D. The forecast error cannot be calculated 33. What is the forecast error (FE) for June if using a three-period moving average? A. -9.3 B. -29.7 C. 29.7 D. The forecast error cannot be calculated

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 5E: A firm experienced the demand shown in the following table. *Unkown future value to be forecast Fill...

See similar textbooks

Similar questions

FORCASTING Month Time QJan 1 46Feb 2 56Mar 3 72Apr 4 67May 5 77Jun 6 66Jul 7 69Aug 8 79Sep 9 88Oct 10 91Nov 11 94Dec 12 104Jan ?Feb ? Make a forecast of the demand for the month of January and February
Consider the following actual and forecast demandlevels for Big Mac hamburgers at a local McDonald’s restaurant:DAY ACTUAL DEMAND FORECAST DEMANDMonday 88 88Tuesday 72 88Wednesday 68 84Thursday 48 80FridayThe forecast for Monday was derived by observing Monday’sdemand level and setting Monday’s forecast level equal to this demand level. Subsequent forecasts were derived by using expo-nential smoothing with a smoothing constant of 0.25. Using this exponential smoothing method, what is the forecast for Big Macdemand for Friday?
Actual sales of TV's for the first six month in 2021 were as follows:January 60 February 80 March 42April 68 May 44 June 72 Use this information and determine in whole numbers: 1 The average actual monthly sales for that period 2 Trends: Reduce this average by 6% per month for the next three months 3 Simple Moving Average (SMA): make a forecast for July using a three months simple movingaverage. 4 Weighted Moving Average (WMA): make forecast for July, using a three months weightedmoving average where the weights are 0.5; 0.3 and 0.2 respectively.
Explain the relationship that economic variables can have with businesscycles. These have both direction and timing. Give an example economicvariable of each combination of direction timing. Of these two attributes, ifyou had exclusive access to a reliable variable, which relationships wouldyou want this variable to have for forecasting purposes
Use exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizer in year 12. Assume that last period's forecast for year 1 is 5,000 bags to begin the procedure. Bags are shown in 1,000's in table below. Year Demand (Bags) 6 3 4. 4. 5 10 6 8. 7 7 8 9 12 10 14 11 15 O A. 14.00 ОВ. 14.87 OC. 11.79 O D. 13.67 Click to select your answer. tUs I MacBook Air 80 F3 888 * ES F4 44 F7 F2 F6 F8 >) FIO F11 @ #3 24 4 & 2 6. 7 8 9. 0. W R Y U P. F G H %3D K C V N alt command command option * co
A company that produces video equipment, including videocameras and televisions, is attempting to forecast what newproducts and product innovations might be technologicallyfeasible and that customers might demand 10 years into thefuture. Speculate on what type of qualitative methods itmight use to develop this type of forecast.
Question 2 Analyse the variables depicted in Figure 1 and comment on the movement of the variables over the period, using literature or other valid sources to support your answer. 0.0 26.5 25.4. 253 261 25.0 24.9 30 2.5. 20 15. 10 05 70 NO Fig. 1 Visual of the variables of study LNGOP LNIND LNTNR 10 why 9 00 05 10 15 MN.. UNFO LNCOAL
The demand of a product of a company is given below for the periods. Can we use Winter method for forecasting demands of the A following 3 periods? Why? If yes, apply it past 4. 6. Demand 27 31 40 31 35 45
I Consider the demand for trading cards listed below. Month Demand Jan. 51,000 48,000 Feb. March 55,000 April May 58,000 66,000 June 69,000 80,000 July Aug. 95,000 Use Excel to prepare a forecast for September, October, and November using linear regression Print out the sheet of results, as well as a sheet containing the formulas that you used ( can be used to toggle between displaying values and displaying formulas or you can click on Formulas>Formula Auditing→Show Formulas.) and for the cars is 16.000
2. Montyboy Pet Shop ships boxed can dogfood anywhere in the country. Using the following information, forecast the shipments for the first four months. Seasonal Relative Month January February March 1.2 1.3 1.3 1.1 0.8 0.7 The monthly forecast equation being used is: Yt = 402 + 3t April May June Where: to = January last year Yt = number of shipments Month July August September October November December Seasonal Relative 0.8 0.6 0.7 1.0 1.1 1.4 Question: Determine the trend amounts for the first four months of the next year assuming January, t=24; February, t=25; etc. Note: Round answers to whole numbers.
forecasts? 7. Contrast the use of MAD and MSE in evaluating forecasts. 8. What advantages as a forecasting tool does exponential smoc
Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled water. Actual demand and the two sets of forecasts are as follows: PREDICTED DEMAND Period Demand F1 F2 1 66 75 67 3 70 70 4 74 69 72 69 70 73 6. 72 68 75 7 80 77 8. 78 74 84 Click here for the Excel Data File a. Compute MAD for each set of forecasts. Given your results, which forecast appears to be more accurate? (Round your answers to 2 decimal places.) MAD F1 MAD F2 appears to be more accurate. 3o5 o o 0 o 677 6 N LO N N 677 6700