Spreadsheet: 159430d1338637395-keeping-packaging-material-and-photographs-in-sync-with-inventory-budget-model-developer
Sheet: Sales

2012-01-01 00:00:00 | Size | New & current stock | Minimum stock | Stock count | Selling price each | Supplier A Daily sales record |  |  |  |  |  |  | Weekly total sales | Reorder flag | Date reorder submitted
Supplier A
Product ref |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
A108 | UK 8 | 10 | 5 | 3 | 35 | 2 | 5 |  |  |  |  |  | 7 | Reorder
A110 | UK 10 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A112 | UK 12 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A114 | UK 14 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A116 | UK 16 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A208 | UK 8 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A210 | UK 10 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A212 | UK 12 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A214 | UK 14 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A216 | UK 16 | 10 | 5 | 7 | 35 |  |  |  | 3 |  |  |  | 3
A308 | UK 8 | 10 | 5 | 5 | 35 |  |  | 5 |  |  |  |  | 5 | Reorder
A310 | UK 10 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A312 | UK 12 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A314 | UK 14 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A316 | UK 16 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A408 | UK 8 | 10 | 5 | 0 | 35 |  | 5 | 5 |  |  |  |  | 10 |  | 2012-06-01 00:00:00
A410 | UK 10 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A412 | UK 12 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A414 | UK 14 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A416 | UK 16 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A508 | UK 8 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A510 | UK 10 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A512 | UK 12 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A514 | UK 14 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
A516 | UK 16 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
 |  |  | Supplier A sales |  |  | 2 | 10 | 10 | 3 | 0 | 0 | 0 | 25
 |  |  |  |  |  | Supplier B Daily sales record |  |  |  |  |  |  | Weekly total sales | Reorder flag | Date reorder submitted
Supplier B
Product ref |  |  |  |  |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
B108 | UK 8 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B110 | UK 10 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B112 | UK 12 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B114 | UK 14 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B116 | UK 16 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B208 | UK 8 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B210 | UK 10 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B212 | UK 12 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B214 | UK 14 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B216 | UK 16 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B308 | UK 8 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B310 | UK 10 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B312 | UK 12 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B314 | UK 14 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B316 | UK 16 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B408 | UK 8 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B410 | UK 10 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B412 | UK 12 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B414 | UK 14 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B416 | UK 16 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B508 | UK 8 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B510 | UK 10 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B512 | UK 12 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B514 | UK 14 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
B516 | UK 16 | 10 | 5 | 10 | 35 |  |  |  |  |  |  |  | 0
 |  |  | Supplier B sales |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Packaging used |  | New & current stock | Minimum stock | Stock count |  | Remember to clear reorder date when new stock received and recorded |  |  |  |  |  |  | Weekly total packaging used | Reorder flag | Date reorder submitted
Add new stock
Boxes
Small |  | 300 | 200 | 199 |  | 50 | 50 | 1 |  |  |  |  | 101 |  | 2012-06-01 00:00:00 | 590 | 99 | 200 | 64 in³ | 0 in³ | 2,0 oz | 25 lbs |  | 1 garment
Medium |  | 300 | 200 | 300 |  |  |  |  |  |  |  |  | 0 |  |  | 1294 | 200 | 200 | 256 in³ | 0 in³ | 4,0 oz | 50 lbs |  | 4 garments
Large |  | 300 | 200 | 185 |  |  | 25 | 32 | 58 |  |  |  | 115 | Reorder |  | 1455 | 85 | 200 | 432 in³ | 0 in³ | 7,0 oz | 88 lbs |  | 7 garments
Order Confirmation Notes |  | 600 | 500 | 600 |  |  |  |  |  |  |  |  | 0 |  |  | 435 | 500 | 500 | 14 in² | 0 in³ | 0,2 oz | 6 lbs
Retail Tags |  | 600 | 500 | 600 |  |  |  |  |  |  |  |  | 0 |  |  | 450 | 500 | 500 | 5 in² | 0 in³ | 0,0 oz | 0 lbs
[NAME]
Small |  | 300 | 200 | 300 |  |  |  |  |  |  |  |  | 0 |  |  | $1 044 | 200 | 200 | 608 in³ | 0 in³ | 1,5 oz | 19 lbs |  | 10 garments
Large |  | 300 | 200 | 300 |  |  |  |  |  |  |  |  | 0 |  |  | $1 449 | 200 | 200 | 1152 in³ | 0 in³ | 3,5 oz | 44 lbs |  | 18 garments
[NAME] cards |  | 600 | 500 | 600 |  |  |  |  |  |  |  |  | 0 |  |  | 765 | 500 | 500 | 15 in² | 0 in³ | 0,1 oz | 3 lbs
[NAME] card envelopes |  | 600 | 500 | 600 |  |  |  |  |  |  |  |  | 0 |  |  | 317 | 500 | 500 | 19 in² | 0 in³ | 0,0 oz | 0 lbs
[NAME] card boxes |  | 600 | 500 | 600 |  |  |  |  |  |  |  |  | 0 |  |  | $1 241 | 500 | 500 | 30 in³ | 0 in³ | 0,0 oz | 0 lbs