Question: The following forecasts were calculated using the 3 month simple moving average approach. Calculate the error for April through September forecasts, and then calculate the

The following forecasts were calculated using the 3 month simple moving average approach. Calculate the error for April through September forecasts, and then calculate the MAD (mean absolute deviation). What is the MAD for this set of demand and forecast data? Question 5 Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales for SEPTEMBER. Use the 3 period weighted moving average approach, with weights of 50 for the most recent month, 30 for the second month, and 20 for the oldest month's demand data

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

QUESTION #2 50 MARKS The fiscal year for government agencies start in April of each year. Tax offices are government agencies. The manager at the tax office in Linstead has documented the number of...

Can you help me with the below please. The fiscal year for moonie agencies start in April of each year. Tax offices are government agencies. The manager at the tax office in Ransville has documented...

Problem 1 Cards R' Us sells Uofl merchandise in Louisville. Having Cards gear in stock to sell to visitors is crucial, so the shop keeps inventory on hand and replenishes weekly. One such item are...

4 18 9 18 5 23 10 16 AS 5 a. Prepare a forecast for weeks 6 through 10 by using a 4-week moving average. What is the forecast for week 11? b. Calculate the mean absolute deviation as of the end of...

Q 1 A product has a consistent year round demand. You are the planner and have been tasked with experimenting with some time series analysis. Using this previous weekly demand, calculate the...

1) Problem: 12.1 The Hartley-Davis motorcycle dealer (p. 530) With modifications as below 2) Problem: 12.7 The Intrepid mutual fund (p. 531) With modifications as below PLEASE MAKE SURE TO LOOK AT...

Now that you have Tumblr\&Co forecasted demand almost complete table using simple moving average technique. Calculate and report the following errors: The forecasting errors: - The cumulative sum of...

A A A AaBbCcDE AaBbCcDdE AO AA EEEEE av Normal No Spacing 10 Points 10 Points 10 Points 10 Points 10 Points What is the difference between qualitative forecasting techniques and quantitative...

please explain the answer with an excel formula 10 Mod 21 1 T " . W 4 MAL M MAY Asher NOTE TH 41 A 430 Au 306 410 46 3 sek 3 411 ENHE P Tven 1h 33. gr Med be PAL pertapes, alg WE RACEWA W Mw M...

Assignment # 1 OPM 4 0 0 January 2 0 2 4 1 . JV Battery Distribution had the monthly sales for the past year below. Month Sales January 9 4 0 February 8 8 0 March 7 5 8 April 7 9 5 May 9 1 3 June 9 4...

Which of the following compounds is more likely to exhibit activity as a tranquilizer? CH3 CH CH O or CH C

Benefits of computer networks?

1 . Discuss a minimum of two types of infrastructure components corporations should invest in .

Rco will acquire 100% shares of Dco through exchange of shares and the offer price to Dco is Rs.65. Relevant financial informatio are given below: Rco Dco EAT 50,000 10,000 Outstanding number of...