Spreadsheet: 773511d1647887482-calculate-number-needed-to-build-kitted-order-excel-folmula-help-file
Sheet: "BOX" DATA SET 

 |  |  |  |  |  |  |  |  |  |  | # SKUS PER KIT
 | # Per Sku | Desc | Item | SKU | BOX QTY | Cost (SKU COST) | Sell (SKU) | SKU MARGIN % | Cost Per Unit | Sell Per Unit | P-K (13) | 1-2 | 3-5 | MS | HS
 | 1 | [NAME] | 7" Height x 9.8" Width - 3 x Holes | 469734 | 1 | 3.24 | 1.03 | 1.5 | 3.24 | 1.03 | 1 | 1 | 1 | 1 | 1
 | 6 | Pre-Sharpened Pencils | #2 Medium Soft Lead - 12 pencils per pack | 825488 | 6 | 20.97 | 3.55 | 4.25 | 3.495 | 0.5916666666666667 | 2 | 2 | 2 | 2 | 2
 | 12 | Pencil Grip | Soft Foam Grips - Soft Foam - Assorted - 12 / Pack | 9800474 | 12 | 3.99 | 1.82 | 2.3625 | 0.3325 | 0.1516666666666667 | 1 | 0 | 0 | 0 | 0
 | 30 | [NAME] | Elmer's All-Purpose Glue Stick | 698325 | 30 | 27.77 | 8.14 | 16.5 | 0.9256666666666666 | 0.2713333333333334 | 2 | 1 | 1 | 1 | 1
 | 36 | Erasers | Office Depot Pink Bevel Erasers, Latex-free | 139720 | 36 | 16.57 | 1.62 | 3.99 | 0.4602777777777778 | 0.04500000000000001 | 2 | 2 | 2 | 2 | 2
 | 1 | Pencil Sharpener | Double-Hole Manual Pencil Sharpener, Assorted | 891993 | 1 | 4.04 | 0.61 | 0.75 | 4.04 | 0.61 | 1 | 2 | 2 | 2 | 2
 | 2 | Child Scissors | 5" Stainless Steel Kids Scissors, Ambidextrous | 2480274 | 2 | 6.35 | 0.5 | 0.625 | 3.175 | 0.25 | 1 | 1 | 0 | 0 | 0
 | 1 | Crayons, 24 | Crayola [NAME] Crayon | 119503 | 1 | 5.49 | 0.84 | 1.625 | 5.49 | 0.84 | 1 | 1 | 0 | 0 | 0
 | 1 | Markers, 10 | Crayola Ultra-Clean Washable Markers, Broad Tip | 1445869 | 1 | 5.99 | 2.92 | 3.425 | 5.99 | 2.92 | 1 | 1 | 0 | 0 | 0
 | 1 | Ruler | Transparent Plastic Ruler For Binders, 12in | 720461 | 1 | 5.13 | 0.27 | 0.5 | 5.13 | 0.27 | 1 | 1 | 3 | 3 | 2
 | 1 | Primary Composition Book | Primary Composition Book, 7 1/2in x 9 3/4in | 151243 | 1 | 3.33 | 2.02 | 2.5125 | 3.33 | 2.02 | 3 | 1 | 0 | 0 | 0
 | 10 | Pocket Folders w/ Prongs | Twin-Pocket Portfolios With Fasteners | 433599 | 10 | 17.08 | 1.69 | 2 | 1.708 | 0.169 | 3 | 3 | 2 | 2 | 3
 | 1 | Wide Ruled Filler Paper | Notebook Filler Paper, Wide-Ruled, 150pk | 589483 | 1 | 4.06 | 1.02 | 1.4 | 4.06 | 1.02 | 2 | 2 | 0 | 0 | 0
 | 1 | College Composition Book | Composition Book, 7 1/2in x 9 3/4in, College Ruled | 998584 | 1 | 4.69 | 0.58 | 0.9625 | 4.69 | 0.58 | 0 | 3 | 3 | 6 | 6
 | 2 | Child Scissors | Junior Pointed Tip Scissors, Ambidextrous | 2480283 | 2 | 6.35 | 0.53 | 1 | 3.175 | 0.265 | 0 | 0 | 1 | 0 | 0
 | 36 | Highlighter | Highlighter Chisel Marker Point Style | 7021287 | 36 | 26.79 | 4.58 | 5.99 | 0.7441666666666666 | 0.1272222222222222 | 0 | 0 | 1 | 1 | 1
 | 1 | Mini Protractor | [NAME] 6" Protractor, Clear | 713585 | 1 | 3.57 | 0.26 | 0.5 | 3.57 | 0.26 | 0 | 0 | 1 | 1 | 1
 | 24 | Crayons, 24 | CLI Creative Arts 24 Crayon Display | 274809 | 24 | 33.36 | 18.32 | 21.3 | 1.39 | 0.7633333333333333 | 0 | 0 | 1 | 0 | 0
 | 1 | Colored Pencils, 12 | BIC Kids Coloring Pencils, 3.3 mm, Assorted Colors, Pack Of 12 Pencils | 8578385 | 1 | 2.49 | 1.5 | 2 | 2.49 | 1.5 | 0 | 0 | 1 | 0 | 0
 | 1 | College Ruled Filler Paper | Notebook Filler Paper, college-Ruled, 150pk | 589510 | 1 | 4.06 | 1.02 | 1.5 | 4.06 | 1.02 | 0 | 0 | 3 | 3 | 0
 | 1 | 1 Subject Spiral Notebook | Sparco Wirebound College Ruled Notebooks | 347648 | 1 | 2.84 | 0.78 | 1.125 | 2.84 | 0.78 | 0 | 0 | 4 | 5 | 5
 | 6 | Graph Paper | [NAME], 4 x 4 Squares/Inch, 50 Sheets, White | 533840 | 6 | 36.22 | 3.21 | 4.25 | 6.036666666666666 | 0.535 | 0 | 0 | 5 | 4 | 4
 | 2 | Student Scissors | Westcott Student Scissors, 7", Ambidextrous | 1369936 | 2 | 17.75 | 0.98 | 1.175 | 8.875 | 0.49 | 0 | 0 | 0 | 1 | 1
 | 12 | Black Ink Pens | [NAME] Ballpoint Pens | 734364 | 12 | 12.91 | 2.48 | 4.1 | 1.075833333333333 | 0.2066666666666667 | 0 | 0 | 0 | 1 | 1
 | 1 | Colored Pencils, 12 | Crayola Presharpened Colored Pencils, 12 | 504928 | 1 | 3.2 | 1.31 | 2.075 | 3.2 | 1.31 | 0 | 0 | 0 | 1 | 3
 | 1 | Markers, 10 | Crayola Original Fine Line Markers | 913819 | 1 | 4.24 | 2.13 | 2.75 | 4.24 | 2.13 | 0 | 0 | 0 | 3 | 3
 | 1 | 1" Binder | Basic Round-Ring View Binder, 1in Rings | 396311 | 1 | 6.94 | 0.99 | 1.4 | 6.94 | 0.99 | 0 | 0 | 0 | 7 | 7
 | 12 | Mechanical Pencils | Foray Mechanical Pencil | 510128 | 12 | 18.04 | 2.07 | 2.7 | 1.503333333333333 | 0.1725 | 0 | 0 | 0 | 0 | 1