Essay About Aggregate Family Of Products And Forecast Error

Wilkins, a Zurn Company: Demand Forecasting
Essay Preview: Wilkins, a Zurn Company: Demand Forecasting
Report this essay
Wilkins, A Zurn Company: Demand ForecastingSession Time:        MW 11:30 AMTeam member names: Amogh Mirikar, Chia-Jung Hsu, Hee- kyoung Han, Rohan Shah, Yashna ShineHow accurate was Wilkins demand forecast for the first quarter of 2005? Use the forecast error and MAPE to calculate forecast accuracy. Calculate the accuracies for the fire valves and PVBs aggregate family of products as well as for each product of both families individually. Note: to disaggregate the product family forecast into the individual products use the planning bill % of Exhibits 3 and 4.The Forecast overestimates the real demand in every single product. For the first quarter, Connors and Fields have forecasted the sales to be 53,560 units of PVB and 559 units of Fire valves. However, with reference to the Exhibit 2, we find that the actual sales of PVB were less than the forecast i.e. 48,159 units and that of Fire Valves were more than the forecast i.e. 580 units. Hence, Connors and Fields have over forecasted the sales of PVB by 11.21% and under-forecasted the sales of Fire valves by 3.62%. Aggregate Family of Product: PVBs and Fire ValvesProductPeriodForecastActualError, EtAbsolute EMAPE(A)(B)(C=A-B)(D=ABS(C))(E=D/B*100)PVBs2005-1Q53,56048,1595,4015,40111.21%Fire Valves2005-1Q559580-21213.62%Individual Product in the first Q of 2005: PVBsProductForecastActualError, EtAbsolute EMAPE(A)(%)(B)(C=A-B)(D=ABS(C))(E=D/B*100)12-7205,67710.60%6,237-5585588.95%34-72013,44425.10%28,020-14,57614,57652.02%1-72023,62044.10%11,16312,45712,457115.59%34-4206,42712.00%3846,0436,0431573.70%1-4204,3928.20%2,3572,0352,03586.34%Total53,560100.00%48,159Individual Product in the first Q of 2005: Fire ValvesProductForecastActualError, EtAbsolute EMAPE(A)(%)(B)(C=A-B)(D=ABS(C))(E=D/B*100)12-72011921.20%85343440.00%34-72021638.80%19917178.54%1-7206611.80%140-747452.86%34-420468.20%66-202030.30%1-42011220.00%90222224.44%Total559100.00%580What is the current demand forecasting method? Which departments use the demand forecast? What are the consequences, if any, if the forecast is inaccurate?The current forecasting method uses Planning bill and Forecast Master, which lists the average weekly sales history for each product family by quarter and year since 1999. For each product family, they divide the total quarters in weeks to determine the average weekly sale per quarters. Then they add the expected percentage increase in demand for the next five or six quarters.