Historical demand for the product is: Month Demand January 12 February 11 March 15 April 12 May 16 June 15 Using Wighted average with weights of 60% for last, 30% scond last and 10% for the third last month, find the july forecast. Weighted Forecast = Using sample three month moving average, find the july forecast. Moving Average Forecast = If the July demand is 17, Using Wighted average with weights of 60% for last, 30% scond last and 10% for the third last month, find the August forecast. Weighted Forecast= Using sample three month moving average, find the August forecast. Moving Average Forecast =

Historical demand for the product is: Month Demand January 12 February 11 March 15 April 12 May 16 June 15 Using Wighted average with weights of 60% for last, 30% scond last and 10% for the third last month, find the july forecast. Weighted Forecast = Using sample three month moving average, find the july forecast. Moving Average Forecast = If the July demand is 17, Using Wighted average with weights of 60% for last, 30% scond last and 10% for the third last month, find the August forecast. Weighted Forecast= Using sample three month moving average, find the August forecast. Moving Average Forecast =

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

Metropolitan Hospital has estimated its average monthly bed needs as N=1,000+9X where X=timeperiod(months);January2002=0 N=monthlybedneeds Assume that no new hospital additions are expected in the area in the foreseeable future. The following monthly seasonal adjustment factors have been estimated, using data from the past five years: Forecast Metropolitans bed demand for January, April, July, November, and December 2007. If the following actual and forecast values for June bed demands have been recorded, what seasonal adjustment factor would you recommend be used in making future June forecasts?
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.
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.
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.
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
Director Very Busy needs to allocate time this week for office appointments, so he needs to forecast the number of employees who will seek appointments. The director has gathered the following time series data recently Period Employee Appointments 4 weeks ago 95 3 weeks ago 80 2 week ago 65 last week 50
Define Forecasts and forecast errors in time series anaylsis?
Director Very Busy needs to allocate time this week for office appointments, so he needs to forecast the number of employees who will seek appointments. The director has gathered the following time series data recently Period Employee Appointments 4 weeks ago 95 3 weeks ago 80 2 week ago 65 last week 50 a. What would naive forecasting suggest as the number of employee appointments that can be expected this week? " b. b. What is this week's forecast for employee appointments using a 3-week moving average? What would the same forecast be using a 2-week moving average?"
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
Homework i ed ok ences Aft کے 2 The forecasted demand for Week 20 is places.) b. Use the above trend equation to predict expected loadings for Weeks 20 & 21. (Round your final answers to 2 decimal A- W It should reach 870 loadings in Week # 3 decimal places.) c. The manager intends to install new equipment when the volume exceeds 870 loadings per week. Assuming the current trend continues, in which week (at the earliest) should the loading volume reach that level? (Use the rounded answers, as required, from any previous part of this problem. Do not round any other intermediate calculations. Round your final answer to 2 €1 + E C Q Search $ 4 R V C % 5 G M F9 JK 9 " F10 Alt F11 ✩ P น Ctrl 8 Help Save & Exit Submit F12 C PrtSc + 11 Insert Home 1 3/23/2023 Delete Backspace PgUp Er
Fiting a straight ine to a set of data yields the following predicion line. Complete (a) through (e) below a. Interpret the meaning of the Yintercept, Choose the correct anower below O A. The Yintercept, be =4, imples that the average value of Yis 4. OB. The Yintercept, b7, implies that when the value of Xs0, the mean value of Yis 7 OC. The Yantercept, by4, implies that tor each increase of 1 unt in X, the value ofYa expected to increase by 4 unts •D. The Yintercept, 4, implies that when the value of Xis 0, the mean value of Y is 4 b. Interpret the meaning of the slope, b Choose the comect answer below OA The slope, by4, implies that for each increase of 1 unit in X, the value of Yis expected to increase by 4 units OB. The slope, by =7, implies that the average value of Y is 7. O C. The slope, b,=7, imples that for each increase of 1 unit in X, the value of Y is expected to increase by 7 units %3D OD. The slope, b,7, implies that for each increase of 1 unit in X, the value of Yis…
4. Relate cycles, seasonality and trends in time series forecasting. What is their relevance in such type of forecasting? 5. Illustrate one example/scenario when judgmental forecast is utilized.