Friday, November 22, 2013

Case Study

Wilkins Case study Demand Forecasting report Wilkins deals with 2 several(predicate) products coerce Valves & Fire Valves. These two products have distinct require patterns Pressure valvesFire valves PART compute gross revenueMEMAPE 12-7205677.366235-557.648.943705 34-72013443.528020-1457652.02156 1-72023619.91116312456.9111.591 34-42064273846043 1573.698 1-4204391.9223572034.9286.33517 bestow 53560 48159 5401 PARTforecastgross revenueMEMAPE 12-720118.5088533.50839.42118 34-720216.89219917.8928.990955 1-72065.962140-74.03852.88429 34-42045.83866-20.16230.54848 1-420111.89021.824.22222 add559580 As shown in above calculations full sales comes bulge out to be 48159 but the forecast sales were 53560 there is a huge difference surrounded by the 2 set so this shows that they were Over-optimistic on prognostication the sales on pressure valves The highest Mean absolute % delusion which comes out to be 1573% is an exceptional case, which is n ot acceptable Avg. Mean error comes out to be 5401/48159=0.112?11.2% CAGR= 10.2% As shown in above calculations come up sales comes out to be 580 but the forecast sales were 559 There is not much difference between the 2 value so this shows that they were not much confident in early(a) words they were Pessimistic on forecasting the sales on fire valves. Avg Mean error = 3.
Order your essay at Orderessay and get a 100% original and high-quality custom paper within the required time frame.
6% CAGR = 7.3% The above calculations and values were forecasted on the basis of Executive Opinion. Estimations shown above indicate some(prenominal) problems deal inventory issues, Production issues. There is an overproduction more than unavoidable demand for some products which results in st orage issues. we wishing to lod! ge the statistical method of applying Regression techniques & Trend digest for forecasting on the given previous sales data for Pressure Valves & fire valves QTR QTY FOREAST 1748159...If you want to get a open essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay

No comments:

Post a Comment