Spreadsheet: 327930d1403725179-sales-forecasting-help-with-autofil-using-dates-on-6-25-14
Sheet: Forecast

Contract data |  |  |  |  |  |  |  | Project Start (SOP) | Contract Months | Project End (EOP) | Year Fraction (SOP) | Mid Years Fraction | Year Fraction (EOP) | Pieces per unit sales | Quoted Volume | Piece Price [NAME] | LTA terms |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unit price per contract year |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract Activity |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Calendar Years Active |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Price by Active Years |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sales per year
# | Customer | Program Code | [NAME] | Component | TS # | Part # | LTA |  |  |  |  |  |  |  |  |  | % Discount applied to costs in each year. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Price per unit in each year of the contract |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 |  |  |  | 1 |  |  | 0,.85, .85, .85 | 2012-06-30 00:00:00 |  | 2019-02-01 00:00:00 |  |  |  | 2 | 40000 | 3.099
 |  |  |  |  |  |  | 0,1.5,1.5,1.5 | 2013-04-19 00:00:00 |  | 2019-06-01 00:00:00 |  |  |  | 1 | 703590 | 2.26
 |  |  |  |  |  |  | 0,1,1.5,1.5 | 2013-04-19 00:00:00 |  | 2019-06-01 00:00:00 |  |  |  | 1 | 703590 | 2.01
 |  |  |  |  |  |  | 0,1.75,1.5,1.5 | 2013-04-19 00:00:00 |  | 2019-06-01 00:00:00 |  |  |  | 1 | 216200 | 4.4
 |  |  |  |  |  |  | 0,1.75,1.5,1.5 | 2013-04-19 00:00:00 |  | 2019-06-01 00:00:00 |  |  |  | 1 |  | 3.21
 |  |  |  |  |  |  | 0,1,1,1 | 2012-11-01 00:00:00 | 24 | 2014-11-01 00:00:00 |  |  |  | 1 | 140000 | 2.5
 |  |  |  |  |  |  | 0,1,1,1 | 2012-11-01 00:00:00 | 24 | 2014-11-01 00:00:00 |  |  |  | 1 | 140000 | 1.97
 |  |  |  |  |  |  | 0,1,1,1 | 2013-01-14 00:00:00 |  | 2018-12-01 00:00:00 |  |  |  | 1 | 112095 | 2.14
 |  |  |  |  |  |  | 0,1,1,1 | 2013-01-14 00:00:00 |  | 2018-12-01 00:00:00 |  |  |  | 1 | 220600 | 1.31
 |  |  |  |  |  |  | 0,1,1,1 | 2013-07-15 00:00:00 | 24 | 2015-07-15 00:00:00 |  |  |  | 1 | 103400 | 1.66
 |  |  |  |  |  |  | 0,1,1,1 | 2013-10-21 00:00:00 |  | 2019-09-01 00:00:00 |  |  |  | 1 | 129485 | 2.8
 |  |  |  |  |  |  | 0,1,1,1 | 2013-10-21 00:00:00 |  | 2019-09-01 00:00:00 |  |  |  | 1 | 129485 | 1.7
 |  |  |  |  |  |  | 0,1,1,1 | 2013-10-21 00:00:00 |  | 2019-09-01 00:00:00 |  |  |  | 1 | 54285 | 5.03
 |  |  |  |  |  |  | 0,1,1,1 | 2013-10-21 00:00:00 |  | 2019-09-01 00:00:00 |  |  |  | 1 | 54285 | 2.98
 |  |  |  |  |  |  | 0,5.2, 2 | 2013-08-01 00:00:00 | 24 | 2015-08-01 00:00:00 |  |  |  | 1 | 28752 | 3.26
 |  |  |  |  |  |  | 0,4.1,2 | 2013-08-01 00:00:00 | 24 | 2015-08-01 00:00:00 |  |  |  | 1 | 5748 | 4.39
 |  |  |  |  |  |  | 0,4.3,2 | 2013-08-01 00:00:00 | 24 | 2015-08-01 00:00:00 |  |  |  | 1 | 28752 | 3.49
 |  |  |  |  |  |  | 0,3.5,2 | 2013-08-01 00:00:00 | 24 | 2015-08-01 00:00:00 |  |  |  | 1 | 5748 | 5.12
 |  |  |  |  |  |  | 0, 1,2 | 2013-08-01 00:00:00 | 24 | 2015-08-01 00:00:00 |  |  |  | 1 | 28752 | 7.2
 |  |  |  |  |  |  | 0,1.26,2 | 2013-08-01 00:00:00 | 24 | 2015-08-01 00:00:00 |  |  |  | 1 | 5748 | 10.32