Bill's Bookstore is tracking its monthly demand for textbooks and has seen the following demand pattern. MONTH FORECASTED DEMAND ACTUAL DEMAND April 150 165 May 220 210 June 215 200 July 245 250 August 205 225 The bookstore has decided to use a three-month weighted moving average to forecast demand. What would be September's forecast if the weights 0.50, 0.30, 0.20 with the higher weights going to the most recent data?

Bill's Bookstore is tracking its monthly demand for textbooks and has seen the following demand pattern. MONTH FORECASTED DEMAND ACTUAL DEMAND April 150 165 May 220 210 June 215 200 July 245 250 August 205 225 The bookstore has decided to use a three-month weighted moving average to forecast demand. What would be September's forecast if the weights 0.50, 0.30, 0.20 with the higher weights going to the most recent data?

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

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
Campus Advising needs to allocate time this week for office appointments, so she needs te forecast the number of students who will seek appointments. The advisor has gathered th following time series data recently: Period Student Appointments 4 weeks ago 95 3 weeks ago 80 2 weeks ago 65 Last week 50 Answer the next two questions (questions 11 and 12), based on this information. 11. What is this week's forecast for student appointments using a three-week moving average? a) 80 b) 50 c) 52 d) 65 e) 78
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
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.
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.
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?"
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?
Name two coincident indicators used in forecasting
A police station had to deploy a police officer for an emergency multiple times in the last four evenings. The table below shows the number of emergencies each evening. Weekday Number of calls each day Monday Tuesday Wednesday 9. 12 Thursday 12 What would be their forecast for Friday using a naïve forecasting approach? Forecast for Friday calls KPrev 4 of 5 Next
Ques 8and 9 please
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