Operations Management: Forecast Errors (MSE, MAD, MAPE)

Рет қаралды 15,253

Жыл бұрын

This video demonstrates how to set up a quick table in Excel to calculate common forecast errors including Mean Squared Error (MSD), Mean Absolute Deviation (MAD), and Mean Absolute Percentage Error (MAPE)

Пікірлер: 15

@j.b.1342 8 ай бұрын

Thank you! Studying for CPIM and your videos have been extremely helpful in bringing the boring text books to life.

@The_Business_Doctor 8 ай бұрын

Glad you like them!

@Zzzxxxzzzzty24 Жыл бұрын

have a OM 300 final today and I understand how to do most of the math but just wanted to watch someone do it again and these really help thank you

@The_Business_Doctor Жыл бұрын

You’re very welcome! I hope the exam went well.

@davidmcmahon8731 Жыл бұрын

Thank you for this explanation

@The_Business_Doctor Жыл бұрын

You are welcome!

@busster1075 5 ай бұрын

Hi, thanks for all you do here. Question, how do I set up an Excel sheet for the three period running averages? Any help is greatly appreciated! Have a great day!

@The_Business_Doctor 5 ай бұрын

All you want to do is create a formula that calculates the average of the previous 3 periods. For example if your data for the past 3 months is in cells A1, A2, and A3 then the forecast for month 4 is: AVG(A1:A3). Then copy that formula down each period and the cells should update automatically as actual data is included in cells A4,A5, etc.

@ptdayakemindoperkasa2316 7 ай бұрын

Hi, is it only for one item for each calculation of forecast errors or for various items?

@The_Business_Doctor 7 ай бұрын

Hi there. You want to calculate errors for all times to develop a true mean. You could exclude large outliers however, based on professional judgment.

@oliviatamburro4952 4 ай бұрын

Instead of satisfaction scores if you were calculating sales data would this be the same approach? Thank you

@The_Business_Doctor 4 ай бұрын

Hi Olivia, that's right! You can use this to forecast just about anything!

@chitreshlahiri199 Ай бұрын

MAPE % will be low it means our forecasting is good? Or bad?

@The_Business_Doctor Ай бұрын

Good question. From the MAPE you can sort of really assess if the forecasting is “good” or bad per se. The it’s the average absolute percentage error which means that the forecast is “off” by the MAPE and that could mean over or under relative to the actual demand. It’s the size of the MAPE that’s important. For example if the MAPE is 5% then we can say the forecasts differ from actual demand by an average of 5% which is not very much in many cases since you would expect some differences. If, however, the MAPE is 15% that might not be acceptable because the higher the MAPE the less reliable the forecast is. Hope this helps.

@chitreshlahiri199 Ай бұрын

@@The_Business_Doctor understand your point. One more thing to ask- how we can increase our projection accuracy, is there another technique or methods?