Spreadsheet: 159509d1338716088-keeping-packaging-material-and-photographs-in-sync-with-inventory-budget-model-developer
Sheet: Analysis

 |  |  | Sales Analysis |  |  |  |  |  |  |  |  |  |  |  | Year to date sales # | Year to date sales $ | Reorder flag | Date reorder submitted |  | Minimum stock | Current stock | Weight each | Weight total | Volume each | Volume total | Purchase price each | Selling price each | Purchase price total | Selling price total | Gross profit | Gross margin %
Product ref | Supplier | Size | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
A108 | A | UK 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A108 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A110 | A | UK 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A110 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A112 | A | UK 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A112 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A114 | A | UK 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A114 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A116 | A | UK 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A116 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A208 | A | UK 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A208 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A210 | A | UK 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A210 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A212 | A | UK 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A212 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A214 | A | UK 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A214 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A216 | A | UK 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A216 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A308 | A | UK 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A308 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A310 | A | UK 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A310 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A312 | A | UK 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A312 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A314 | A | UK 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A314 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A316 | A | UK 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A316 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A408 | A | UK 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A408 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A410 | A | UK 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A410 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A412 | A | UK 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A412 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A414 | A | UK 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A414 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A416 | A | UK 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A416 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A508 | A | UK 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A508 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A510 | A | UK 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A510 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A512 | A | UK 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A512 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A514 | A | UK 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A514 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
A516 | A | UK 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | A516 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B108 | B | UK 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B108 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B110 | B | UK 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B110 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B112 | B | UK 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B112 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B114 | B | UK 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B114 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B116 | B | UK 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B116 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B208 | B | UK 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B208 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B210 | B | UK 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B210 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B212 | B | UK 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B212 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B214 | B | UK 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B214 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B216 | B | UK 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B216 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B308 | B | UK 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B308 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B310 | B | UK 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B310 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B312 | B | UK 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B312 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B314 | B | UK 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B314 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B316 | B | UK 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B316 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B408 | B | UK 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B408 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B410 | B | UK 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B410 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B412 | B | UK 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B412 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B414 | B | UK 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B414 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B416 | B | UK 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B416 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B508 | B | UK 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B508 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B510 | B | UK 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B510 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B512 | B | UK 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B512 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B514 | B | UK 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B514 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
B516 | B | UK 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | B516 | 10 | 10 | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 250 | 350 | 100 | 0.2857142857142857
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Volume per bundle
 |  |  | Packaging |  |  |  |  |  |  |  |  |  |  |  |  |  | Reorder flag | Date reorder submitted |  | Price | Actual | Minimum | Volume each
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weight each | Weight per bundle
Boxes
Small |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 590 | 200 | 200 | 64 in³ | 0 in³ | 2,0 oz | 25 lbs |  | 1 garment
Medium |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1294 | 200 | 200 | 256 in³ | 0 in³ | 4,0 oz | 50 lbs |  | 4 garments
Large |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 1455 | 200 | 200 | 432 in³ | 0 in³ | 7,0 oz | 88 lbs |  | 7 garments
Order Confirmation Notes |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 435 | 500 | 500 | 14 in² | 0 in³ | 0,2 oz | 6 lbs
Retail Tags |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 450 | 500 | 500 | 5 in² | 0 in³ | 0,0 oz | 0 lbs
[NAME]
Small |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | $1 044 | 200 | 200 | 608 in³ | 0 in³ | 1,5 oz | 19 lbs |  | 10 garments
Large |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | $1 449 | 200 | 200 | 1152 in³ | 0 in³ | 3,5 oz | 44 lbs |  | 18 garments
[NAME] cards |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | 765 | 500 | 500 | 15 in² | 0 in³ | 0,1 oz | 3 lbs
[NAME] card envelopes |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  |  |  | 317 | 499 | 500 | 19 in² | 0 in³ | 0,0 oz | 0 lbs
[NAME] card boxes |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | $1 241 | 500 | 500 | 30 in³ | 0 in³ | 0,0 oz | 0 lbs