Spreadsheet: 29490d1224527159-need-if-input-and-color-identify-solution-isd-forecast-tax-time-2009-10-6-0821
Sheet: ForcastSummary

ISD 6-Month Tax Time 2009 Forecast (Updated 10-6-08)
PM |  |  |  |  | Current | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of | Week of
Part # | ISD Item # | Description | Customer | Tool | On-Hand | 2008-10-06 00:00:00 | 2008-10-13 00:00:00 | 2008-10-20 00:00:00 | 2008-10-27 00:00:00 | 2008-11-03 00:00:00 | 2008-11-10 00:00:00 | 2008-11-17 00:00:00 | 2008-11-24 00:00:00 | 2008-12-01 00:00:00 | 2008-12-08 00:00:00 | 2008-12-15 00:00:00 | 2008-12-22 00:00:00 | 2008-12-29 00:00:00 | 2009-01-05 00:00:00 | 2009-01-12 00:00:00 | 2009-01-19 00:00:00 | 2009-01-26 00:00:00 | 2009-02-02 00:00:00 | 2009-02-09 00:00:00 | 2009-02-16 00:00:00 | 2009-02-23 00:00:00 | Total
m1058-500 | OM99658 | OM OPP Clear Base/Black lid | OMAX | MAXTOTE | 5996 | 1200 | 1200 | 1200 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1400 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 29500
m1058-509 | 50696 | OMAX Recycle Tote Black | OMAX | MAXTOTE | 0 | 750 | 750 | 750 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 18450
m1058-990 | 50644 | ODP Blue Lid Blue Label Bankers Box | ODP | MAXTOTE | 1784 | 1200 | 1200 | 1200 | 1200 | 1200 | 16200 | 1200 | 16200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1300 | 1300 | 1300 | 1400 | 1400 | 1400 | 1400 | 56300
m1058-991 | 50645 | ODP Red Lid Red Label Bankers Box | ODP | MAXTOTE | 2624 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 1000 | 1000 | 1000 | 1100 | 1100 | 1100 | 1100 | 20000
m1058-602 | 50634 | ODP Black Vol. Tote | ODP | MAXTOTE | 8390 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 6000 | 6000 | 6000 | 6000 | 25000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 139000
TBD | 50617 | STPLS Black Lid Black Label Bankers Box | STPLS | MAXTOTE |  | 0 | 0 | 0 | 0 | 0 | 13000 | 0 | 0 | 0 | 0 | 0 | 0 | 3374 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16374
TBD | 50618 | STPLS Blue Lid Blue Label Bankers Box | STPLS | MAXTOTE |  | 0 | 0 | 0 | 0 | 0 | 14000 | 0 | 0 | 0 | 0 | 0 | 0 | 4421 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18421
TBD | 50707 | OMAX [NAME] with Accessory | OMAX | MAXTOTE |  | 0 | 0 | 0 | 0 | 0 | 18000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18000
TBD | TBD | Target Bankers Box | Target | MAXTOTE |  | 0 | 0 | 0 | 0 | 0 | 15000 | 0 | 0 | 0 | 0 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 31500
 |  | [NAME] |  |  | 18794 | 9050 | 9050 | 9050 | 9400 | 9400 | 84400 | 10400 | 25400 | 10400 | 10400 | 30900 | 11900 | 19695 | 11900 | 12200 | 12200 | 12200 | 12400 | 12400 | 12400 | 12400 | 347545
m1059-011 | OM99659 | OM Portable Blue File Box | OMAX | OPPFB | 3376 | 700 | 700 | 700 | 800 | 800 | 15800 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 900 | 1000 | 1000 | 1000 | 1100 | 1100 | 1100 | 1100 | 34100
m1059-012 | OM99660 | OM Portable Black File Box | OMAX | OPPFB | 2468 | 800 | 800 | 800 | 900 | 900 | 900 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1100 | 1100 | 1100 | 1200 | 1200 | 1200 | 1200 | 21200
m1059-301 | 50682 | Staples Portable Black | STPLS | OPPFB | 2836 | 550 | 550 | 550 | 750 | 750 | 16000 | 750 | 750 | 750 | 750 | 750 | 750 | 6000 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 750 | 35650
m1059-302 | 50681 | Staples Portable Blue | STPLS | OPPFB | 2640 | 600 | 600 | 600 | 800 | 800 | 18000 | 800 | 800 | 800 | 800 | 800 | 800 | 7000 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 39600
m1059-303 | 50639 | OPP Black Thick Target | TGT | OPPFB | 13554 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 4500 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 101500
m1059-304 | 50697 | OMAX Recycle File Box Black | OMAX | OPPFB | 3336 | 500 | 500 | 500 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 14100
m1059-305 | 50649 | ODP Recycle Black | ODP | OPPFB | 3044 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 21000
TBD | 50720 | OMAX OPP File Box with Accessory | OMAX | OPPFB |  | 0 | 0 | 0 | 0 | 0 | 18000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18000
 |  | OPP File Box Tool Total |  |  | 31254 | 8650 | 8650 | 8650 | 9450 | 9450 | 74900 | 9650 | 10150 | 10150 | 10150 | 10150 | 10150 | 21600 | 10150 | 10350 | 10350 | 10350 | 10550 | 10550 | 10550 | 10550 | 285150
50659 | 50659 | ODP Organizer | ODP | ORG | 960 | 300 | 300 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 9400
50683 | 50683 | Staples Organizer Black | STPLS | ORG | 2560 | 500 | 500 | 500 | 500 | 500 | 14000 | 500 | 500 | 500 | 500 | 500 | 500 | 4000 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 27500
50684 | 50684 | Staples Organizer Blue | STPLS | ORG | 560 | 400 | 400 | 400 | 400 | 400 | 17000 | 400 | 400 | 400 | 400 | 400 | 400 | 5000 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 29600
 | 50615 | Target Organizer - 1 gray divider | TGT | ORG |  | 0 | 0 | 0 | 0 | 0 | 9864 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9864
50685 | 50685 | Office [NAME] | OMAX | ORG | 1040 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 6300
 |  | Organizer Tool Total |  |  | 5120 | 1500 | 1500 | 1600 | 1600 | 1600 | 41564 | 1600 | 1600 | 1600 | 1700 | 1700 | 1700 | 9800 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 1700 | 82664
m1060-011 | 50647 | ODP Slim Clear | ODP | SLIM | 636 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 12600
m1060-012 | 50648 | ODP Slim Blue | ODP | SLIM | 2610 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 10500
m1060-013 | 50704 | ODP Slim Black | ODP | SLIM | 1432 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 300 | 300 | 300 | 300 | 5450
 |  | [NAME] |  |  | 4678 | 1350 | 1350 | 1350 | 1350 | 1350 | 1350 | 1350 | 1350 | 1350 | 1350 | 1350 | 1350 | 1350 | 1350 | 1350 | 1350 | 1350 | 1400 | 1400 | 1400 | 1400 | 28550
m1058-600 | 50636 | ODP [NAME]. Tote | ODP | VTOTE | 23942 | 3400 | 3400 | 3400 | 3400 | 3400 | 3400 | 4000 | 14000 | 4000 | 4000 | 25000 | 5000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 4000 | 112400
m1058-601 | 50635 | ODP Navy Vol. Tote | ODP | VTOTE | 14103 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 7500 | 17500 | 7500 | 7500 | 30000 | 10000 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 183500
m1058-603 | 50641 | ODP Gray Vol. Tote | ODP | VTOTE | 1832 | 150 | 150 | 150 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 2250
m1058-700 | 50698 | Colorful Tote Blue | ODP | VTOTE | 7936 | 1000 | 1000 | 1000 | 1300 | 1300 | 1500 | 1500 | 1500 | 1500 | 2000 | 2000 | 1300 | 1300 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 30200
m1058-701 | 50699 | Colorful Tote Green | ODP | VTOTE | 4841 | 750 | 750 | 750 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 21850
m1058-702 | 50700 | Colorful Tote Pink | ODP | VTOTE | 56 | 250 | 250 | 250 | 0 | 0 | 0 | 0 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10750
TBD | TBD | Colorful Tote Yellow | ODP | VTOTE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000
TBD | TBD | Colorful Tote Purple | ODP | VTOTE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000
TBD | TBD | Clear 8-500 Lid on Clear 8-600 Base | ODP | VTOTE |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000
m1058-703 | 50688 | Staples Colorful Tote Blue | STPLS | VTOTE | 1432 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000
m1058-704 | 50689 | Staples Colorful Tote Teal | STPLS | VTOTE | 984 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000
m1058-705 | 50687 | Staples Colorful Tote Pink | STPLS | VTOTE | 2480 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000
m1058-706 | 50637 | Target Colorful Tote: Blue/Clear & Blue/Blue | TGT | VTOTE | 1632 | 3500 | 3500 | 4000 | 4000 | 4000 | 22000 | 4500 | 4500 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | 115000
TBD | 50715 | Christmas Red | ODP | VTOTE | 2496 | 750 | 750 | 750 | 750 | 750 | 1000 | 1000 | 1000 | 1000 | 2000 | 2000 | 1000 | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13750
TBD | 50716 | Christmas Green | ODP | VTOTE | 1368 | 750 | 750 | 750 | 750 | 750 | 1000 | 1000 | 1000 | 1000 | 2000 | 2000 | 1000 | 1000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13750
 |  | Volume Tote Tool Total |  |  | 63102 | 16550 | 16550 | 17050 | 17300 | 17300 | 36000 | 20600 | 110600 | 21100 | 23600 | 67100 | 24400 | 20900 | 19300 | 19300 | 19300 | 19300 | 19300 | 19300 | 19300 | 19300 | 563450
 |  |  | Total |  |  | 37100 | 37100 | 37700 | 39100 | 39100 | 238214 | 43600 | 149100 | 44600 | 47200 | 111200 | 49500 | 73345 | 44400 | 44900 | 44900 | 44900 | 45350 | 45350 | 45350 | 45350 | 1307359