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.
Jan '20 0.68 Feb '20 0.76 Mar '20 1.6 Apr '20 1.47 May '20 0.98 Jun '20 1.18 Jul '20 3.59 Aug '20 3.33 Sept '20 4.31 Oct '20 3.84 Nov '20 6.97 Dec '20 7.7 Using data above please provide one qualitative and two quantitative (Simple and weighted moving average) monthly forecasts in the United States for the holiday season in 2021
explain it correctly
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.
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.
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
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
Define Forecasts and forecast errors in time series anaylsis?
If excel work required then attached screenshot
OE. They will save between the ages of 35 to 67. OF. They will dissave between the ages of 35 and 67.
Direction: Complete the table below to find the 60h percentile for the following se of data. Data Find the position of Find P60 P=(n+ 1)th Px100 1. 20, 22, 25, 32, 35 P60 = 20-2 20122 2. 49, 50, 55, 55, 60, 67 P60 = 3. 18, 19, 20, 22, 25,27, 29, 30, 32 P60 = Direction: Read the questions carefully. Encircle the letter of the corre