Spreadsheet: 159326d1338578489-multi-tab-commands-sample-tables
Sheet: Forecast

Code | Customer | Code | Item | RM | Code | [NAME] | Code | Month | Qty to 4/30/12 | Sales to 4/30/12 | Qty Jan 2012 | Sales Jan 2012 | Qty Feb 2012 | Sales Feb 2012 | [NAME] | [NAME] 2012 | Qty Apr 2012 | Sales Apr 2012 | Selling Price | Qty May | Qty June | Qty July | Qty Aug | [NAME] | Qty Oct | Qty Nov | Qty Dec | Forecast Qty Total | Forecast Sales Total | QTY YTD Sales + Forecast | Sales YTD Sales + Forecast | Q1 2012 $ | Q2 2012 $ | Q3 2012 $ | Q4 2012 $
11775 | 1st Class Service | 25340 |  |  | 2 | Region Two | 4/2012 | 2012-04-20 00:00:00 | 110 | 1127.5 |  |  |  |  |  |  |  |  |  | 50
11883 | 4 Seasons Landscape | 13240 |  |  | 2 | Region Two | 2/2012 | 2012-02-20 00:00:00 | 5 | 62.5
11883 | 4 Seasons Landscape | 25340 |  |  | 2 | Region Two | 3/2012 | 2012-03-20 00:00:00 | 15 | 187.5 |  |  |  |  |  |  |  |  |  | 100
11883 | 4 Seasons Landscape | 31381 |  |  | 2 | Region Two | 2/2012 | 2012-02-20 00:00:00 | 15 | 210 |  |  |  |  |  |  |  |  |  | 30
11883 | 4 Seasons Landscape | 25004 |  |  | 2 | Region Two | 3/2012 | 2012-03-20 00:00:00 | 2.5 | 62.5
10811 | 4M WEED CONTROL | 19135 |  |  | 8 | Region Eight | 2/2012 | 2012-02-20 00:00:00 | 15 | 450
10811 | 4M WEED CONTROL | 19135 |  |  | 8 | Region Eight | 4/2012 | 2012-04-20 00:00:00 | 25 | 750 |  |  |  |  |  |  |  |  |  | 75
10811 | 4M WEED CONTROL | 19231 |  |  | 8 | Region Eight | 4/2012 | 2012-04-20 00:00:00 | 12 | 72 |  |  |  |  |  |  |  |  |  | 24
10811 | 4M WEED CONTROL | 31300 |  |  | 8 | Region Eight | 2/2012 | 2012-02-20 00:00:00 | 240 | 1740 |  |  |  |  |  |  |  |  |  | 48
10811 | 4M WEED CONTROL | 31304 |  |  | 8 | Region Eight | 4/2012 | 2012-04-20 00:00:00 | 350 | 1400 |  |  |  |  |  |  |  |  |  | 50
10811 | 4M WEED CONTROL | 25340 |  |  | 8 | Region Eight | 4/2012 | 2012-04-20 00:00:00 | 30 | 345 |  |  |  |  |  |  |  |  |  | 75
10811 | 4M WEED CONTROL | 31307 |  |  | 8 | Region Eight | 4/2012 | 2012-04-20 00:00:00 | 25 | 3000 |  |  |  |  |  |  |  |  |  | 50
10000 | Abate-A-Weed | 31303 |  |  | 6 | Region Six | 1/2012 | 2012-01-20 00:00:00 | 2000 | 18000
10000 | Abate-A-Weed | 31303 |  |  | 6 | Region Six | 2/2012 | 2012-02-20 00:00:00 | 1000 | 9000
10000 | Abate-A-Weed | 31303 |  |  | 6 | Region Six | 3/2012 | 2012-03-20 00:00:00 | 1000 | 9000
10000 | Abate-A-Weed | 12025 |  |  | 6 | Region Six | 4/2012 | 2012-04-20 00:00:00 | 270 | 5670
10000 | Abate-A-Weed | 12023 |  |  | 6 | Region Six | 3/2012 | 2012-03-20 00:00:00 | 150 | 2775
10000 | Abate-A-Weed | 13242 |  |  | 6 | Region Six | 3/2012 | 2012-03-20 00:00:00 | 265 | 2811.65
10000 | Abate-A-Weed | 13241 |  |  | 6 | Region Six | 1/2012 | 2012-01-20 00:00:00 | 120 | 1219.2
10000 | Abate-A-Weed | 31313 |  |  | 6 | Region Six | 2/2012 | 2012-02-20 00:00:00 | 48 | 1687.68
10000 | Abate-A-Weed | 31313 |  |  | 6 | Region Six | 3/2012 | 2012-03-20 00:00:00 | 24 | 843.84
10000 | Abate-A-Weed | 31313 |  |  | 6 | Region Six | 4/2012 | 2012-04-20 00:00:00 | 24 | 843.84
10000 | Abate-A-Weed | 31331 |  |  | 6 | Region Six | 3/2012 | 2012-03-20 00:00:00 | 1000 | 15850
11970 | Advanced Spraying | 31300 |  |  | 6 | Region Six | 3/2012 | 2012-03-20 00:00:00 | 96 | 768
10002 | ADVANCED TURF SOLUTIONS | 26151 |  |  | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 60 | 720
10002 | ADVANCED TURF SOLUTIONS | 13018 |  |  | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 5 | 177.5
10002 | ADVANCED TURF SOLUTIONS | 31304 |  |  | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 300 | 1245
10002 | ADVANCED TURF SOLUTIONS | 13186 |  |  | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 8 | 312
10002 | ADVANCED TURF SOLUTIONS | 13186 |  |  | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 8 | 312
10002 | ADVANCED TURF SOLUTIONS | 26159 |  |  | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 4 | 1600
10002 | ADVANCED TURF SOLUTIONS | 26159 |  |  | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 4 | 1600
10002 | ADVANCED TURF SOLUTIONS | 13240 |  |  | 10 | Region Ten | 2/2012 | 2012-02-20 00:00:00 | 60 | 630
10002 | ADVANCED TURF SOLUTIONS | 25340 |  |  | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 720 | 8130.6
10002 | ADVANCED TURF SOLUTIONS | 11050 |  |  | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 6 | 138
10002 | ADVANCED TURF SOLUTIONS | 11056 |  |  | 10 | Region Ten | 2/2012 | 2012-02-20 00:00:00 | 600 | 4800
10002 | ADVANCED TURF SOLUTIONS | 11056 |  |  | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 700 | 5600
10002 | ADVANCED TURF SOLUTIONS | 31359 |  |  | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 45 | 1800
10002 | ADVANCED TURF SOLUTIONS | 14068 |  |  | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 24 | 1920
10002 | ADVANCED TURF SOLUTIONS | 14068 |  |  | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 24 | 1920
10002 | ADVANCED TURF SOLUTIONS | 13074 |  |  | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 5 | 226.25
10002 | ADVANCED TURF SOLUTIONS | 31313 |  |  | 10 | Region Ten | 2/2012 | 2012-02-20 00:00:00 | 24 | 732
10002 | ADVANCED TURF SOLUTIONS | 31313 |  |  | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 120 | 3660
10002 | ADVANCED TURF SOLUTIONS | 13195 |  |  | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 90 | 3510
10002 | ADVANCED TURF SOLUTIONS | 13202 |  |  | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 450 | 21150
10002 | ADVANCED TURF SOLUTIONS | 13202 |  |  | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 420 | 19740
10002 | ADVANCED TURF SOLUTIONS | 13201 |  |  | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 20 | 960
10002 | ADVANCED TURF SOLUTIONS | 13201 |  |  | 10 | Region Ten | 4/2012 | 2012-04-20 00:00:00 | 12 | 576
11679 | Agland Coop | 11050 |  |  | 10 | Region Ten | 3/2012 | 2012-03-20 00:00:00 | 6 | 143.1
11224 | AGPACK | 26150 |  |  | 15 | Region Fifteen | 3/2012 | 2012-03-20 00:00:00 | 0 | -4920
11224 | AGPACK | 13202 |  |  | 15 | Region Fifteen | 3/2012 | 2012-03-20 00:00:00 | 0 | -2358
11224 | AGPACK | 13198 |  |  | 15 | Region Fifteen | 3/2012 | 2012-03-20 00:00:00 | 0 | -1452