version of 9/12/2007Practice Demand Forecasting SpreadsheetYou should design, construct, and practice on a spreadsheet of your own to combine the art and science of forecasting.page 1 of 2Student inputs are in yellow fieldsRound> 123456781 The Gross EstimateExpected unit demand (from the homework)2968 3449 4007 4656 5411 6287 7306 8489Products in Segment1Demand facing the Average Product1#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!2 If-things-stayed-the-same-EstimateLast year's sales of our productProjected growth in the segment (from h/work)1.162 1.162 1.162 1.162 1.162 1.162 1.162 1.162Demand if nothing changes 000000003our product >product 2 >product 3 >product 4 >product 5 >product 6 >product 7 >product 8 >Demand based on prior year's customer satisfaction#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!Our demand based on the Dec Customer Survey - enter the prior round's Dec Customer Survey scores for each competitive product for which there are numbers.This spreadsheet forecasts HIGH END segmentversion of 9/12/2007Practice Demand Forecasting SpreadsheetYou should design, construct, and practice on a spreadsheet of your own to combine the art and science of forecasting.page 2 of 2Student inputs are in yellow fieldsRound> 12345678This spreadsheet forecasts HIGH END segment4 A More Fine-grained EstimateExpected unit demand (from homework)2968 3449 4007 4656 5411 6287 7306 8489Products in Segment2 (draws from detail below)0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00Demand facing the Average Product2#DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!Detail for Products in segment:Products with major sales in segment weighted at 100%Products with minor & declining sales enter a decimal fraction for ea competitor that has low or seriously declining salesExpected new launches into segment enter a decimal fraction for ea launch anticipated in the next round remember to check to see if they have have plant in place to produce unitsExpected gains <losses> to OUR product Enter a decimal fraction estimate of your product's expected improvement if any (i.e. .05 for 5% improvement)Can the top products in the segment meet demand? Enter a decimal fraction estimate of how much you expect to "take" from the top products b/c of their insufficient capacity.Customer Survey results vary as you improve/fail to improve your product's designs, awareness, accessibility, and
View Full Document