Spreadsheet: 141885d1329497923-2nd-order-poly-trendline-using-equation-815288
Sheet: Linear Forecast

Month | Total Parts Bookings for Month | Month # |  |  |  |  |  | 2nd Poly |  |  |  |  | Linear
2007-03-01 00:00:00 |  | 1 |  | 39142 | 824794 |  |  |  | -18575.00116600638 | 370237097.8405411 | #N/A |  |  | -3754963.467728708 | #N/A | #N/A
2007-04-01 00:00:00 |  | 2 |  | 39173 | 1045420 |  |  | 0.2180165190655122 | 17447.53944736544 | 349011452.3245643 | #N/A |  | 87.19684547351649 | 3492857.242280161 | #N/A | #N/A
2007-05-01 00:00:00 |  | 3 |  | 39203 | 684822 |  |  | 0.06609693648237785 | 343289.9689502394 | #N/A | #N/A |  | 0.04172231435352117 | 343855.5055954978 | #N/A | #N/A
2007-06-01 00:00:00 |  | 4 |  | 39234 | 1697416 |  |  | 1.55704875529073 | 44 | #N/A | #N/A |  | 1.959248528929107 | 45 | #N/A | #N/A
2007-07-01 00:00:00 |  | 5 |  | 39264 | 1061643 |  |  | 366990172089.9756 | 5185312122401.677 | #N/A | #N/A |  | 231654901716.5576 | 5320647392775.095 | #N/A | #N/A
2007-08-01 00:00:00 |  | 6 |  | 39295 | 1044573
2007-09-01 00:00:00 |  | 7 |  | 39326 | 1053954
2007-10-01 00:00:00 |  | 8 |  | 39356 | 1382611
2007-11-01 00:00:00 |  | 9 |  | 39387 | 688745
2007-12-01 00:00:00 |  | 10 |  | 39417 | 1029646
2008-01-01 00:00:00 |  | 11 |  | 39448 | 828027
2008-02-01 00:00:00 |  | 12 |  | 39479 | 1053587
2008-03-01 00:00:00 |  | 13 |  | 39508 | 1355145
2008-04-01 00:00:00 |  | 14 |  | 39539 | 1220578
2008-05-01 00:00:00 |  | 15 |  | 39569 | 1183652
2008-06-01 00:00:00 |  | 16 |  | 39600 | 1277776.77
2008-07-01 00:00:00 |  | 17 |  | 39630 | 759905.64
2008-08-01 00:00:00 |  | 18 |  | 39661 | 1466035.08
2008-09-01 00:00:00 |  | 19 |  | 39692 | 1100483
2008-10-01 00:00:00 |  | 20 |  | 39722 | 1038308
2008-11-01 00:00:00 |  | 21 |  | 40118 | 1124175
2008-12-01 00:00:00 |  | 22 |  | 40148 | 717930
2009-01-01 00:00:00 |  | 23 |  | 40179 | 948848
2009-02-01 00:00:00 |  | 24 |  | 40210 | 1246455.02
2009-03-01 00:00:00 |  | 25 |  | 40238 | 1433443.63
2009-04-01 00:00:00 |  | 26 |  | 40269 | 995348.2599999998
2009-05-01 00:00:00 |  | 27 |  | 40299 | 1042604.26
2009-06-01 00:00:00 |  | 28 |  | 40330 | 608375.6900000001
2009-07-01 00:00:00 |  | 29 |  | 40360 | 888534.8500000001
2009-08-01 00:00:00 |  | 30 |  | 40391 | 1234204.1
2009-09-01 00:00:00 |  | 31 |  | 40422 | 787716.47
2009-10-01 00:00:00 |  | 32 |  | 40452 | 1195740.29
2009-11-01 00:00:00 |  | 33 |  | 40483 | 1871888.45
2009-12-01 00:00:00 |  | 34 |  | 40513 | 401773.71
2010-01-01 00:00:00 |  | 35 |  | 40544 | 2001945.74
2010-02-01 00:00:00 |  | 36 |  | 40575 | 845840.68
2010-03-01 00:00:00 |  | 37 |  | 40603 | 1102374.47
2010-04-01 00:00:00 |  | 38 |  | 40634 | 826185.76
2010-05-01 00:00:00 |  | 39 |  | 40664 | 1672347.99
2010-06-01 00:00:00 |  | 40 |  | 40695 | 695238.16
2010-07-01 00:00:00 |  | 41 |  | 40725 | 1580370.52
2010-08-01 00:00:00 |  | 42 |  | 40756 | 1297566.49
2010-09-01 00:00:00 |  | 43 |  | 40787 | 1347791.41
2010-10-01 00:00:00 |  | 44 |  | 40817 | 1812046.46
2010-11-01 00:00:00 |  | 45 |  | 40848 | 1384196.18
2010-12-01 00:00:00 |  | 46 |  | 40878 | 996416.0700000001
2011-01-01 00:00:00 |  | 47 |  | 40909 | 1422489
2011-02-01 00:00:00 |  | 48
2011-03-01 00:00:00 |  | 49
2011-04-01 00:00:00 |  | 50
2011-05-01 00:00:00 |  | 51
2011-06-01 00:00:00 |  | 52
2011-07-01 00:00:00 |  | 53
2011-08-01 00:00:00 |  | 54
2011-09-01 00:00:00 |  | 55
2011-10-01 00:00:00 |  | 56
2011-11-01 00:00:00 |  | 57
2011-12-01 00:00:00 |  | 58
2012-01-01 00:00:00 |  | 59
Projections Begin Under Line Above |  |  | Projected Dollar Increase Month to Month | Projected Percentage Increase Month to Month | Year End Totals
2012-02-01 00:00:00 |  | 60
2012-03-01 00:00:00 |  | 61
2012-04-01 00:00:00 |  | 62
2012-05-01 00:00:00 |  | 63
2012-06-01 00:00:00 |  | 64
2012-07-01 00:00:00 |  | 65
2012-08-01 00:00:00 |  | 66
2012-09-01 00:00:00 |  | 67
2012-10-01 00:00:00 |  | 68
2012-11-01 00:00:00 |  | 69
2012-12-01 00:00:00 |  | 70
2013-01-01 00:00:00 |  | 71
2013-02-01 00:00:00 |  | 72
2013-03-01 00:00:00 |  | 73
2013-04-01 00:00:00 |  | 74
2013-05-01 00:00:00 |  | 75
2013-06-01 00:00:00 |  | 76
2013-07-01 00:00:00 |  | 77
2013-08-01 00:00:00 |  | 78
2013-09-01 00:00:00 |  | 79
2013-10-01 00:00:00 |  | 80
2013-11-01 00:00:00 |  | 81
2013-12-01 00:00:00 |  | 82
2014-01-01 00:00:00 |  | 83
2014-02-01 00:00:00 |  | 84
2014-03-01 00:00:00 |  | 85
2014-04-01 00:00:00 |  | 86
2014-05-01 00:00:00 |  | 87
2014-06-01 00:00:00 |  | 88
2014-07-01 00:00:00 |  | 89
2014-08-01 00:00:00 |  | 90
2014-09-01 00:00:00 |  | 91
2014-10-01 00:00:00 |  | 92
2014-11-01 00:00:00 |  | 93
2014-12-01 00:00:00 |  | 94
2015-01-01 00:00:00 |  | 95
2015-02-01 00:00:00 |  | 96
2015-03-01 00:00:00 |  | 97
2015-04-01 00:00:00 |  | 98
2015-05-01 00:00:00 |  | 99
2015-06-01 00:00:00 |  | 100
2015-07-01 00:00:00 |  | 101
2015-08-01 00:00:00 |  | 102
2015-09-01 00:00:00 |  | 103
2015-10-01 00:00:00 |  | 104
2015-11-01 00:00:00 |  | 105
2015-12-01 00:00:00 |  | 106
2016-01-01 00:00:00 |  | 107