Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Measure the accuracy of the three -month moving average forecast by using MAPD. (Use table 3 from Excel). Table 3 ( 3-month moving average forecast)

Measure the accuracy of the three -month moving average forecast by using MAPD. (Use table 3 from Excel). Table 3 ( 3-month moving average forecast) # Month Demand Forecast abs(Dt-Ft) (Dt-Ft)2 1 March 120 2 April 110 3 May 150 4 June 130 126.667 3.333333 11.1111 5 July 160 130 30 900 6 August 165 146.667 18.33333 336.111 Sum Sum 51.66667 1247.22 Question 3 options: MAPD is 51.66/3*100%=172.2% MAPD is 51.66/835*100%=6.2% MAPD is 51.66/455*100%=11.36% MAPD is 51.66/6*100%=861%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Information Systems: Design An App For That

Authors: Frost Raymond.

1st Edition

9783319170282

More Books

Students also viewed these General Management questions

Question

The data set of paving slab weights given in DS 6.1.7.

Answered: 1 week ago