Spreadsheet: 330208d1404613061-need-cells-to-reference-appropriate-date-from-referenced-date-in-worksheet-mini-project-wally-mart-b212-10-1
Sheet: Supply Data

 |  |  |  | Supplier Capacity
Item Number | Description | Lead Time (Months) | Price | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00
B1091-54572 | Kitten Food | 2 | 83.48 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350
D3911-98275 | [NAME] | 3 | 66.39 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350
D8968-82625 | Frying Pan | 2 | 44.25 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000
F3168-89809 | [NAME] | 3 | 46.2 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100
F5846-71724 | Hand Mixer | 2 | 83.14 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
F6967-33896 | Spatula | 2 | 11.83 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
F7121-39978 | Long-Handled Dust Pan | 1 | 66.6 | 120 | 120 | 120 | 100 | 90 | 90 | 100 | 100 | 0 | 0 | 0 | 0
F7845-67716 | Blender | 1 | 74.5 | 250 | 250 | 250 | 200 | 200 | 200 | 200 | 200 | 0 | 0 | 0 | 0
G2133-44629 | [NAME], 44-gallon | 1 | 57.23 | 33 | 30 | 30 | 25 | 25 | 25 | 25 | 25 | 0 | 0 | 0 | 0
G4243-92352 | Laundry Detergent | 2 | 59.9 | 1100 | 1000 | 1000 | 800 | 800 | 800 | 800 | 800 | 0 | 0 | 0 | 0
J1463-72582 | Food Processor | 1 | 71.19 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 0 | 0 | 0 | 0
J3158-53666 | Food Container | 1 | 53.11 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
J6947-62776 | Toilet Paper (1-Ply) | 2 | 28.22 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
J7604-40448 | Slow Cooker/Crock Pot | 1 | 27.81 | 25 | 25 | 25 | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0
J9161-28339 | Slotted Spoon | 2 | 15.58 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180 | 180
J5597-39232 | Puppy Food | 2 | 9.46 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40 | 40
K1290-68858 | Wooden Spoon | 2 | 16.37 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35 | 35
K3008-40082 | Can Opener | 1 | 96.89 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
L7725-20678 | Meat Grinder | 2 | 27.38 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100
N1251-68781 | [NAME] | 2 | 22.09 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200 | 1200
N7452-75713 | Ladle | 4 | 15.03 | 170 | 170 | 170 | 170 | 170 | 170 | 170 | 170 | 170 | 170 | 170 | 170
O8272-48948 | Scoops (Set) | 2 | 84.52 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600 | 1600
Q9840-26383 | Iron | 4 | 47.55 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700
S2053-97298 | Mop | 2 | 11.12 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
U2445-66969 | Bleach, 1 gallon | 2 | 32.4 | 1000 | 1050 | 500 | 500 | 500 | 500 | 500 | 500 | 0 | 0 | 0 | 0
U3570-75018 | Anti-bacterial Hand Soap | 1 | 28.79 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100
U5221-14557 | Broom | 3 | 9.87 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100
W6424-55749 | 2-Prong Fork | 2 | 23.74 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700
Y2111-95648 | Cutting Board | 3 | 47.99 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150
Y7456-48617 | Microwave Oven | 2 | 96.73 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100 | 1100
Z6825-72053 | Paper Towels (1-Ply) | 4 | 13.73 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20 | 20