Spreadsheet: 330188d1404592474-cell-that-reports-the-first-date-of-the-current-month-mini-project-wally-mart-b212-10-1
Sheet: Part Data

 | Part Data
 |  |  |  |  | Total Inventory |  |  | Scheduled Receipts by month they will arrive |  |  |  |  |  |  |  |  |  |  |  |  | Distribution Center Inventory | Inventory on Shelves | [NAME]
 | Item Number | Description | Supplier | Yield | Distribution Center Inventory | Inventory on Shelves | [NAME] | 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 |  | 107 | 65 | 14
1 | B1091-54572 | Kitten Food | Purina One | 0.88 | 107 | 65 | 14 | 328 | 100 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 158 | 55 | 14
2 | D3911-98275 | [NAME] | Westbend | 0.92 | 158 | 55 | 14 | 170 | 200 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1379 | 1694 | 252
3 | D8968-82625 | Frying Pan | Westbend | 0.88 | 1379 | 1694 | 252 | 3281 | 1914 | 160 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 168 | 88
4 | F3168-89809 | [NAME] | Bartley | 0.97 | 168 | 88 |  | 236 | 0 | 22 | 10 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 95 | 51 | 7
5 | F5846-71724 | Hand Mixer | Westbend | 0.96 | 95 | 51 | 7 | 93 | 2 | 28 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 66 | 12 | 8
6 | F6967-33896 | Spatula | [NAME] | 0.92 | 66 | 12 | 8 | 115 | 28 | 42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 161 | 40 | 7
7 | F7121-39978 | Long-Handled Dust Pan | E-Z Clean | 0.95 | 161 | 40 | 7 | 83 | 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 279 | 73 | 14
8 | F7845-67716 | Blender | Westbend | 0.9 | 279 | 73 | 14 | 122 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 34 | 11 | 2
9 | G2133-44629 | [NAME], 44-gallon | Glad | 0.92 | 34 | 11 | 2 | 16 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1187 | 320 | 63
10 | G4243-92352 | Laundry Detergent | Tide | 0.92 | 1187 | 320 | 63 | 611 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 13 | 4 | 2
11 | J1463-72582 | Food Processor | Westbend | 0.89 | 13 | 4 | 2 | 22 | 4 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 30 | 23 | 2
12 | J3158-53666 | Food Container | Rubbermaid | 0.89 | 30 | 23 | 2 | 8 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 16 | 10 | 2
13 | J6947-62776 | Toilet Paper (1-Ply) | Downey | 0.9 | 16 | 10 | 2 | 35 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 30 | 8 | 2
14 | J7604-40448 | Slow Cooker/Crock Pot | Westbend | 0.99 | 30 | 8 | 2 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 123 | 34 | 7
15 | J9161-28339 | Slotted Spoon | [NAME] | 1 | 123 | 34 | 7 | 71 | 41 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 36 | 11 | 2
16 | J5597-39232 | Puppy Food | Purina One | 0.98 | 36 | 11 | 2 | 12 | 13 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8 | 8 | 1
17 | K1290-68858 | Wooden Spoon | [NAME] | 0.88 | 8 | 8 | 1 | 6 | 7 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 283 | 372
18 | K3008-40082 | Can Opener | Forrest Park | 0.89 | 283 | 372 |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 711 | 440 | 36
19 | L7725-20678 | Meat Grinder | Bosch | 0.93 | 711 | 440 | 36 | 315 | 110 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 467 | 81 | 27
20 | N1251-68781 | [NAME] | Ajax | 0.97 | 467 | 81 | 27 | 243 | 40 | 220 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 102 | 16 | 7
21 | N7452-75713 | Ladle | [NAME] | 0.96 | 102 | 16 | 7 | 25 | 45 | 50 | 0 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 520 | 241 | 63
22 | O8272-48948 | Scoops (Set) | [NAME] | 0.93 | 520 | 241 | 63 | 1182 | 0 | 260 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 375 | 72
23 | Q9840-26383 | Iron | Westbend | 0.94 | 375 | 72 |  | 240 | 264 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 5 | 0
24 | S2053-97298 | Mop | E-Z Clean | 0.93 | 5 | 0 |  | 9 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 659 | 196 | 36
25 | U2445-66969 | Bleach, 1 gallon | Clorox | 0.93 | 659 | 196 | 36 | 538 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 1355 | 233
26 | U3570-75018 | Anti-bacterial Hand Soap | Purell | 0.99 | 1355 | 233 |  | 1000 | 500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 622 | 100
27 | U5221-14557 | Broom | E-Z Clean | 0.9 | 622 | 100 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 438 | 183 | 63
28 | W6424-55749 | 2-Prong Fork | [NAME] | 0.89 | 438 | 183 | 63 | 571 | 110 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
29 | Y2111-95648 | Cutting Board | [NAME] | 0.92 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
30 | Y7456-48617 | Microwave Oven | Toshiba | 0.88 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 9 | 0 | 1
31 | Z6825-72053 | Paper Towels (1-Ply) | Bounty | 0.95 | 9 | 0 | 1 | 2 | 4 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
32
33
34
35