Question: Calculate the weekly forecast error for week 4 to 7 for each forecasting method. What is the most appropriate forecasting method among the three according

Calculate the weekly forecast error for week 4 to 7 for each forecasting method. What is the most appropriate forecasting method among the three according to MAD?

Forecasting method: (Simple) Moving average Method with N=3. Calculate forecast error for week 4 to 7

Week Demand(D) Average(A) Forecast(F) Error (e)

1 100

2 150

3 130 A₃=D₁+D₂+D₃/3 = 100+150+130/3 = 126.67

4 140 A₄=D ₂+D₃+D₄/3₌150+130+140/3 = 140 F₄ = 126.67

5 120 F₅ = 140.00

6 110

7 100

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!

Refer to last session's in-class exercises #1, #2, and #3, calculate the weekly forecast error for week 4 to ? for all three forecasting methods. Then compute the Mean Absolute Deviation (MAD) for...

NT 5160, Fall 2015 Semester Individual Case Assignment: Cutting Edge This case was adapted from Hiller, Frederick S. & Mark S. Hillier (2014). Introduction to Management Science: A Modeling and Case...

Please Answer Asap Thank you! A30. SUPPLEMENT A SPREADSHEET MODELING: AN INTRODUCTION Problems 1. Kaizer Plastic produces a variety of plastic items for pack Soek can work only with a single "Set...

Note: Show your detailed calculation steps and round to 2 decimal places The supply chain manager of the company MoAng Coffee represented the demand in the past 7 months with the graph below Demand...

I need help in this question. Please do it correctly and dont make it wrong. Please do it on MS WORD and copy/paste here and use the below formulas to do it. Question 5 (40 points) The last seven...

The Brazen Head restaurant is a 180-seat restaurant. Assume that you are forecasting for Sunday 9/3 and that the following is the covers served data for the last six Sundays (note: the restaurant can...

please help me summarize this chapter summarize this chapter please g) whes din indring woont of ochgeful in s tem pai . 4 buy per 2 Puneing. Implementing and Evaluating Marketing Strategies e...

1. [26] AggTech is revising the forecasting method they are using. Accordingly, they are considering two forecasting methods: - Simple Moving Average with 4 periods (i.e., SMA(4)) and - Exponential...

EXHIBIT 4 Yellow Wings Paragliding uses different forecasting methods to plan the number of jumps in each month. The table below provides the number of jumps that were recorded from January to June,...

Patricia currently earns $2,500 per month and takes home $2,200. Her monthly expenses total $1,680. Her employer provides 5 sick days per year and a short-term disability policy that will pay...

The Runge Controls Corporation manufactures and markets electrical control systems: temperature controls, machine controls, burglar alarms, and the like. The company acquires electrical and...

The company where Anthony works produces shatebourds locally but sells them globally for $ 0 0 each. Anthony is one of the production managers in a meeting to discuss preliminury rewalts froen the...

Lavage Rapide is a Canadian company that owns and operates a large automatic carwash facility near Montreal. The following table provides data concerning the company's costs: Fored Cost per Month...