Stop Share AutoSave OFF A A F ? C ... You are screen sharing THI. JST - FALL 2021 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Arial 16 AA b Wrap Text v General Insert v Ov Ex Delete Paste BI UV A Merge & Center v v % " Conditional Format Cell Sort & Find & Analyze Sensitivity Formatting as Table Styles Format DV Filter Select Data L17 X V fx Company Name: Group # Sim# F1318 Round #: 0 Posted File Acct 2220 Zeigler - Fall 2021 Last year unit segment demand (Low tech) > Capsim Sales Forecasting Worksheet 10% Low-Tech Segment Growth Rate = START NOTE: This Excel Works HERE Two Forecasting Options Exist (A & B) Last year unit segment demand (High tech) > *20% High-Tech Segment Growth Rate (See F/T pg 5 & 6) ALL INPUT CELLS ARE IN YELLOW* Enter Product Name Enter Product Name Enter Product Name Enter Product Name Enter Product Name Enter Your Product Names >2: enter here A) Using the "December Customer Survey" Score: 1) Low-Tech (if applicable to Product): YOUR Product Customer Survey score Total of ALL Customer Survey scores = Estimated market share for product 100.0% .0% 0.09 1.0% .0% Projected Low-Tech Unit Demand for Next Year 2) High-Tech (if applicable to Product): YOUR Product Customer Survey score Total of ALL Customer Survey scores Estimated market share for product 100.0% 0.0% 9.0% 0.0% 0.0% Projected High-Tech Unit Demand for Next Year 0 0 Total Projected Units of Demand (in 000's) 0 0 B) Using "Potential" from the "Market Share" Report: East-Track "Potential" Mkt-Share: 1) Low-Tech % ( if applicable to Product): 100.00% = Estimated market demand for your product 2) High-Tech % ( if applicable to Product): 100.00% Estimated market demand for your product 0 0 Total Projected Units of Demand (in 000's) 0 Enter the Sales Forecast you will actually use > > > > > > Input these amounts into your Marketing Worksheet "Things to Do" Support Notes: This Excel file is posted on our Class Website - it will always be there for your download/use 1) Read about "Sales Forecasting" (pg 13 and pg 22 of your Capsim Guide) 3 2) Read about "Worst Case, Best C Case, Best Case" planning discussion (pg 23 of your Team Member Guide) 14 3) Watch the Pro Forecasting" Video (posted in Modules) 4) Watch the Prof. Zeigler "Worst Case, Best Case" Planning video (posted in Modules) See me, or our GA team, with questions Sheet1 Sheet2 Sheet3 + Ready