Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started