Spreadsheet: 773668d1647986462-calculate-number-needed-to-build-kitted-order-excel-folmula-help-file
Sheet: Order Sheet

ORDER BULDER - SKU PURCHASE GUIDE
[NAME] | Orders
Pre-K to [NAME] | 1 |  | ProductID | Description | Cost | Sell | BX QTY | QTY NEEDED | UOM Req | EXT COST | EXT SELL |  | Line | Kit | SKU | Decription | Quanity | Ordered | Required
First and Second Grade Box | 2 |  | 119503 | Crayola Standard Crayons, Assorted Colors, Box Of 24 Crayons | 5.49 | 0.84 |  |  |  |  |  |  | 1 | Pre-K to [NAME] | 469734 |  | 1
[NAME] to Five Box | 5 |  | 139720 | Office Depot Brand Pink Bevel Erasers, Small, Box Of 36 | 16.57 | 1.62 |  |  |  |  |  |  | 2 | Pre-K to [NAME] | 825488 |  | 2
Middle School Box | 2 |  | 151243 | Pacon Primary Journal Composition Book, 7-1/2" x 9-3/4", [NAME], 0.63" Rule, 100 Sheets, Green | 3.33 | 2.02 |  |  |  |  |  |  | 3 | Pre-K to [NAME] | 9800474 |  | 1
High School Box | 6 |  | 274809 | CLI Creative Arts Crayons, Assorted Colors, Box Of 24 Crayons | 33.36 | 18.32 |  |  |  |  |  |  | 4 | Pre-K to [NAME] | 698325 |  | 2
 |  |  | 347648 | [NAME] Wirebound Notebook, 8" x 10-1/2", [NAME], 70 Sheets, Assorted | 2.84 | 0.78 |  |  |  |  |  |  | 5 | Pre-K to [NAME] | 139720 |  | 2
 |  |  | 396311 | Just Basics Basic View 3-Ring Binder, 1" Round Rings, 41% Recycled, Black | 6.94 | 0.99 |  |  |  |  |  |  | 6 | Pre-K to [NAME] | 891993 |  | 1
 |  |  | 433599 | Office Depot Brand 2-Pocket Textured Paper Folders With Prongs, [NAME], Pack Of 10 | 17.08 | 1.69 |  |  |  |  |  |  | 7 | Pre-K to [NAME] | 2480274 |  | 1
 |  |  | 504928 | Crayola Color Pencils, Assorted Colors, Set Of 12 Color Pencils | 3.2 | 1.31 |  |  |  |  |  |  | 8 | Pre-K to [NAME] | 119503 |  | 1
 |  |  | 510128 | Office Depot Brand Mechanical Pencils, Soft-Grip, [NAME], Assorted Barrel Colors, Pack Of 12 | 18.04 | 2.07 |  |  |  |  |  |  | 9 | Pre-K to [NAME] | 1445869 |  | 1
 |  |  | 533840 | Office Depot Brand [NAME], 4 x 4 Squares/Inch, 50 Sheets, White, Pack Of 6 | 36.22 | 3.21 |  |  |  |  |  |  | 10 | Pre-K to [NAME] | 720461 |  | 1
 |  |  | 589483 | Office Depot Brand Notebook Filler Paper, Wide-Ruled, 8" x 10 1/2", 3-Hole Punched, White, Pack Of 150 Sheets | 4.06 | 1.02 |  |  |  |  |  |  | 11 | Pre-K to [NAME] | 151243 |  | 3
 |  |  | 589510 | Office Depot Brand Notebook Filler Paper, College-Ruled, 8" x 10 1/2", [NAME], Pack Of 150 Sheets | 4.06 | 1.02 |  |  |  |  |  |  | 12 | Pre-K to [NAME] | 433599 |  | 3
 |  |  | 698325 | Elmer's Glue Stick Classroom Pack, All-Purpose Clear, Box Of 30 | 27.77 | 8.14 |  |  |  |  |  |  | 13 | Pre-K to [NAME] | 589483 |  | 2
 |  |  | 713585 | Office Depot Brand Semicircular 6" Protractor, Clear | 3.57 | 0.26 |  |  |  |  |  |  | 14 | First and Second Grade Box | 469734 |  | 1
 |  |  | 720461 | Office Depot Brand Transparent Plastic Ruler For Binders, 12", Assorted Colors (No Color Choice) | 5.13 | 0.27 |  |  |  |  |  |  | 15 | First and Second Grade Box | 825488 |  | 2
 |  |  | 734364 | Office Depot Brand Soft-Grip Retractable Ballpoint Pens, Medium Point, 1.0 mm, [NAME], Black Ink, Pack Of 12 | 12.91 | 2.48 |  |  |  |  |  |  | 17 | First and Second Grade Box | 698325 |  | 1
 |  |  | 825488 | Office Depot Brand Wood Pencils, #2 Lead, Medium, Pack of 72 | 20.97 | 3.55 |  |  |  |  |  |  | 18 | First and Second Grade Box | 139720 |  | 2
 |  |  | 891993 | Office Depot Brand Double-Hole Manual Pencil Sharpener, Assorted Colors | 4.04 | 0.61 |  |  |  |  |  |  | 19 | First and Second Grade Box | 891993 |  | 2
 |  |  | 913819 | Crayola Fine Line Markers, Assorted Classic Classpack, Pack Of 10 | 4.24 | 2.13 |  |  |  |  |  |  | 20 | First and Second Grade Box | 2480274 |  | 1
 |  |  | 998584 | Office Depot Brand Compos+J1:J65ition Book, 7-1/2" x 9-3/4", College Ruled, 100 Sheets, Black/White | 4.69 | 0.58 |  |  |  |  |  |  | 21 | First and Second Grade Box | 119503 |  | 1
 |  |  | 1369936 | Westcott Ruler Clusters Student Scissors, 7", Pack Of 2 | 17.75 | 0.98 |  |  |  |  |  |  | 22 | First and Second Grade Box | 1445869 |  | 1
 |  |  | 1445869 | Crayola Ultra-Clean Washable Markers, [NAME], Assorted Classic Colors, Box Of 10 | 5.99 | 2.92 |  |  |  |  |  |  | 23 | First and Second Grade Box | 720461 |  | 1
 |  |  | 2480274 | Westcott Hard Handle Kids Value Scissors, 5", [NAME], Assorted Colors, Pack Of 2 | 6.35 | 0.5 |  |  |  |  |  |  | 24 | First and Second Grade Box | 151243 |  | 1
 |  |  | 2480283 | Westcott Hard Handle Kids Value Scissors, 5", Pointed, Assorted Colors, Pack Of 2 | 6.35 | 0.53 |  |  |  |  |  |  | 25 | First and Second Grade Box | 433599 |  | 3
 |  |  | 7021287 | Office Depot Brand 100% Recycled Pen-Style Highlighters, Chisel Tip, [NAME], Pack Of 36 | 26.79 | 4.58 |  |  |  |  |  |  | 26 | First and Second Grade Box | 589483 |  | 2
 |  |  | 8578385 | BIC Kids Coloring Pencils, 3.3 mm, Assorted Colors, Pack Of 12 Pencils | 2.49 | 1.5 |  |  |  |  |  |  | 27 | First and Second Grade Box | 998584 |  | 3
 |  |  | 9800474 | The Pencil Grip Soft Foam Grips - Soft Foam - Assorted - 12 / Pack | 3.99 | 1.82 |  |  |  |  |  |  | 28 | [NAME] to Five Box | 469734 |  | 1
 |  |  | 469734 | Office Depot Brand Pencil Pouch With Mesh Window, 7" x 9 3/4", Assorted Colors | 3.24 | 1.03 |  |  |  |  |  |  | 29 | [NAME] to Five Box | 825488 |  | 2
 |  |  | 154164 | Sparco 5" Kids Blunt End Scissors - 5" Overall Length - Blunted Tip - Blue - 1 Each | 0 | 0 | 1 |  |  |  |  |  | 31 | [NAME] to Five Box | 698325 |  | 1
 |  |  | 154623 | Just Basics Poly Spiral Notebook, 8 1/2" x 10 1/2", College Ruled, 70 Sheets, White | 0 | 0 | 1 |  |  |  |  |  | 32 | [NAME] to Five Box | 139720 |  | 2
 |  |  | 2181430 | Targus TSB194US Carrying Case (Backpack) for 16" Notebook - Black, Gray - Water Proof - Poly Oxford - 18.9" Height x 13" [NAME] x 7.1" Depth | 0 | 0 | 1 |  |  |  |  |  | 33 | [NAME] to Five Box | 891993 |  | 2
 |  |  | 274847 | CLI Carrying Case (Pouch) Pencil, [NAME]" Height x 10" [NAME] x 0.1" Depth - 24 Pack | 0 | 0 | 24 |  |  |  |  |  | 37 | [NAME] to Five Box | 720461 |  | 3
 |  |  | 282324 | [NAME] Blunt End Scissors, 5", Rounded Tip, Assorted Colors, Pack Of 12 Scissors | 0 | 0 | 12 |  |  |  |  |  | 39 | [NAME] to Five Box | 433599 |  | 2
 |  |  | 288779 | Office Depot Brand Reinforced Filler Paper, 8" x 10 1/2", College Ruled, White, Pack Of 100 | 0 | 0 | 1 |  |  |  |  |  | 41 | [NAME] to Five Box | 998584 |  | 3
 |  |  | 312017 | Sparco 5" Kids Pointed End Scissors - 5" Overall Length - Pointed Tip - Red - 1 Each | 0 | 0 | 1 |  |  |  |  |  | 42 | [NAME] to Five Box | 2480283 |  | 1
 |  |  | 327610 | Fiskars Scissors For Kids, Grades PreK-2nd, 5", [NAME], Pack Of 12 | 0 | 0 | 12 |  |  |  |  |  | 43 | [NAME] to Five Box | 7021287 |  | 1
 |  |  | 327628 | Fiskars Scissors For Kids, [NAME], 5" Pointed, Assorted Colors, Pack Of 12 | 0 | 0 | 12 |  |  |  |  |  | 44 | [NAME] to Five Box | 713585 |  | 1
 |  |  | 346625 | Office Depot Brand Stellar Poly Notebook, 8-1/2" x 11", 1 Subject, College Ruled, 100 Sheet, Red | 0 | 0 | 1 |  |  |  |  |  | 45 | [NAME] to Five Box | 274809 |  | 1
 |  |  | 3727564 | Office Depot Brand Basic Backpack With 16" Laptop Pocket, Pink | 0 | 0 | 1 |  |  |  |  |  | 46 | [NAME] to Five Box | 8578385 |  | 1
 |  |  | 396291 | Just Basics Basic View 3-Ring Binder, 1" Round Rings, 41% Recycled, White | 0 | 0 | 1 |  |  |  |  |  | 47 | [NAME] to Five Box | 589510 |  | 3
 |  |  | 4088826 | Integra Colored Pencil - 24 / Pack | 0 | 0 | 1 |  |  |  |  |  | 48 | [NAME] to Five Box | 347648 |  | 4
 |  |  | 434357 | Office Depot Brand Vinyl Storage Pouch, Assorted Colors | 0 | 0 | 1 |  |  |  |  |  | 49 | [NAME] to Five Box | 533840 |  | 5
 |  |  | 446445 | [NAME], 5", [NAME], Assorted Colors | 0 | 0 | 1 |  |  |  |  |  | 56 | Middle School Box | 469734 |  | 1
 |  |  | 446460 | [NAME], 5", Pointed, Assorted Colors | 0 | 0 | 1 |  |  |  |  |  | 57 | Middle School Box | 825488 |  | 2
 |  |  | 4599906 | BIC Kids Coloring Pencils, 4.4 mm, Assorted Colors, Pack Of 12 Pencils | 0 | 0 | 1 |  |  |  |  |  | 59 | Middle School Box | 698325 |  | 1
 |  |  | 5207974 | BIC Kids Coloring Crayons, Triangle, Assorted Colors, Pack Of 10 Crayons | 0 | 0 | 1 |  |  |  |  |  | 60 | Middle School Box | 139720 |  | 2
 |  |  | 5232520 | JanSport Cool Student Backpack With 15" Laptop Pocket, Gray Letterman Poly | 0 | 0 | 1 |  |  |  |  |  | 61 | Middle School Box | 891993 |  | 2
 |  |  | 550996 | Crayola Color Pencils, Assorted Colors, Box Of 24 Color Pencils | 0 | 0 | 1 |  |  |  |  |  | 65 | Middle School Box | 720461 |  | 3
 |  |  | 588286 | Office Depot Brand Wirebound Notebook, 8-1/2" x 11", 1 Subject, College Ruled, 100 Sheets, Assorted Colors (No Color Choice) | 0 | 0 | 1 |  |  |  |  |  | 67 | Middle School Box | 433599 |  | 2
 |  |  | 595402 | Targus Legend IQ Backpack | 0 | 0 | 1 |  |  |  |  |  | 69 | Middle School Box | 998584 |  | 6
 |  |  | 6492228 | BIC Kids Coloring Markers, Assorted Colors, Pack Of 10 Markers | 0 | 0 | 1 |  |  |  |  |  | 71 | Middle School Box | 7021287 |  | 1
 |  |  | 6509230 | BIC Kids Coloring Crayons, Assorted Colors, Pack Of 8 Crayons | 0 | 0 | 1 |  |  |  |  |  | 72 | Middle School Box | 713585 |  | 1
 |  |  | 6887770 | Office Depot Brand Basic Backpack With 16" Laptop Pocket, [NAME] | 0 | 0 | 1 |  |  |  |  |  | 75 | Middle School Box | 589510 |  | 3
 |  |  | 697441 | [NAME], 8 1/2" x 11", [NAME], 50 Sheets, White | 0 | 0 | 1 |  |  |  |  |  | 76 | Middle School Box | 347648 |  | 5
 |  |  | 764810 | Westcott Shatterproof Ruler, 12", Assorted Colors | 0 | 0 | 1 |  |  |  |  |  | 77 | Middle School Box | 533840 |  | 4
 |  |  | 772557 | Office Depot Brand Vinyl Storage Pouch, Clear | 0 | 0 | 1 |  |  |  |  |  | 78 | Middle School Box | 1369936 |  | 1
 |  |  | 785357 | Learning Resources Jumbo Tweezers, 6"H, Pre-K - Grade 2, Pack Of 12 | 0 | 0 | 12 |  |  |  |  |  | 79 | Middle School Box | 734364 |  | 1
 |  |  | 792463 | BIC Student's Choice Mechanical Pencils, 0.9 mm, #2 Lead, [NAME], Pack Of 12 | 0 | 0 | 12 |  |  |  |  |  | 80 | Middle School Box | 504928 |  | 1
 |  |  | 8680953 | Office Depot Brand Basic Backpack With 16" Laptop Pocket, Light Blue | 0 | 0 | 1 |  |  |  |  |  | 81 | Middle School Box | 913819 |  | 3
 |  |  | 8792912 | BIC Kids Coloring Markers, Magical Effects, Assorted Colors, Pack Of 12 Markers | 0 | 0 | 1 |  |  |  |  |  | 82 | Middle School Box | 396311 |  | 7
 |  |  | 879417 | Westcott Kids Microban School Pack Scissors, 5", Pointed, Multicolor, Pack Of 12 | 0 | 0 | 12 |  |  |  |  |  | 84 | High School Box | 469734 |  | 1
 |  |  | 8859090 | Fortnite Stamped Backpack With 18" Laptop Pocket, Iridescent | 0 | 0 | 1 |  |  |  |  |  | 85 | High School Box | 825488 |  | 2
 |  |  | 8949832 | Office Depot Brand Basic Backpack With 16" Laptop Pocket, Black | 0 | 0 | 1 |  |  |  |  |  | 87 | High School Box | 698325 |  | 1
 |  |  | 9917296 | Office Depot Brand Basic Backpack With 16" Laptop Pocket, Blue | 0 | 0 | 1 |  |  |  |  |  | 88 | High School Box | 139720 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 89 | High School Box | 891993 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 93 | High School Box | 720461 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 95 | High School Box | 433599 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 97 | High School Box | 998584 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 99 | High School Box | 7021287 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 100 | High School Box | 713585 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 103 | High School Box | 589510 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 104 | High School Box | 347648 |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 105 | High School Box | 533840 |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 106 | High School Box | 1369936 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 107 | High School Box | 734364 |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 108 | High School Box | 504928 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 109 | High School Box | 913819 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 110 | High School Box | 396311 |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | 111 | High School Box | 510128 |  | 1