Question: Exercise on MAD, Nave, exponential and moving average Linda, a demand planner for Cheeznaz Snack Food need to provide top management with a forecast of

Exercise on MAD, Nave, exponential and moving

Exercise on MAD, Nave, exponential and moving average Linda, a demand planner for Cheeznaz Snack Food need to provide top management with a forecast of next year demand. She knows how important an accurate demand forecast is to the supply chain. On the downstream side of the chain, the local stores expect that their shelves are stocked with fresh puffed cheese balls, while on the upstream side Cheenaz's suppliers need the forecast to plan their overall production levels of raw ingredient and packaging materials. Within the Cheeznaz manufacturing, forecast data are needed to plan production. Linda looks at the sales figure for the past 9 years shown in the following table and is trying to decide on several forecasting methods, which include nave method, exponential smoothing (a=0.8 forecast time 1 =150) and 4- year moving average. Using data given below, forecast for year 2008 to 2016 using the three *methods, and decide which method would be suitable. Year Actual demand 2007 110 2008 130 2009 150 2010 170 2011 160 2012 180 2013 140 2014 130 2015 140 O

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!