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

2012
Jan
Supplier 1 | Size | Actual stock | Minimum stock | Weight each | Weight total | Volume each | Volume total | Purchase price each | Selling price each | Purchase price total
Name |  |  |  |  |  |  |  |  |  |  |  |  | Selling price total | Gross profit | Gross margin %
Product 1 | UK 8 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 10 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 12 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 14 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 16 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
Product 2 | UK 8 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 10 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 12 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 14 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 16 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
Product 3 | UK 8 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 10 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 12 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 14 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 16 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
Product 4 | UK 8 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 10 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 12 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 14 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 16 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
Product 5 | UK 8 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 10 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 12 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 14 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 16 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
Sum |  | 25 |  |  | 17.49999999999999 |  | 25 |  |  | 625 |  |  | 875 | 250 | 0.2857142857142856
Sum SKU |  | 25
VAT |  |  |  |  |  |  |  |  |  | 0
Shipping to warehouse |  |  |  |  |  |  |  |  |  | 0
Import duty to warehouse |  |  |  |  |  |  |  |  |  | 0
Shipping to photographer |  |  |  |  |  |  |  |  |  | 0
Import duty to photographer |  |  |  |  |  |  |  |  |  | 0
Sum total |  |  |  |  |  |  |  |  |  | 0
Supplier 2 | Size | Qty | Minimum stock | Weight each | Weight total | Volume each | Volume total | Purchase price each | Selling price each | Purchase price total
Name |  |  |  |  |  |  |  |  |  |  |  |  | Selling price total | Gross profit | Gross margin %
Product 1 | UK 8 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 10 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 12 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 14 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 16 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
Product 2 | UK 8 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 10 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 12 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 14 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 16 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
Product 3 | UK 8 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 10 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 12 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 14 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 16 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
Product 4 | UK 8 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 10 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 12 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 14 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 16 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
Product 5 | UK 8 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 10 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 12 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 14 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
 | UK 16 | 1 |  | 0.7 | 0.7 | 1 | 1 | 25 | 35 | 25 |  |  | 35 | 10 | 0.2857142857142857
Sum |  | 25 |  |  | 17.49999999999999 |  | 25 |  |  | 625 |  |  | 875 | 250 | 0.2857142857142857
Sum SKU |  | 25
VAT |  |  |  |  |  |  |  |  |  | 0
Shipping to warehouse |  |  |  |  |  |  |  |  |  | 0
Import duty to warehouse |  |  |  |  |  |  |  |  |  | 0
Shipping to photographer |  |  |  |  |  |  |  |  |  | 0
Import duty to photographer |  |  |  |  |  |  |  |  |  | 0
Sum total |  |  |  |  |  |  |  |  |  | 0
Total items | 50
Forecasted sales | 34
Packaging material
Bring.no
Minimum stock level | 0.15
Name | Price | Actual | Minimum | Volume each | Volume per bundle | Weight each | Weight per bundle
Required
Boxes
- Small | 590 | 200 | 200 | 64 in³ | 0 in³ | 2,0 oz | 25 lbs |  | 1 garment
- Medium | 1294 | 200 | 200 | 256 in³ | 0 in³ | 4,0 oz | 50 lbs |  | 4 garments
- Large | 1455 | 200 | 200 | 432 in³ | 0 in³ | 7,0 oz | 88 lbs |  | 7 garments
Order Confirmation Notes | 435 | 500 | 500 | 14 in² | 0 in³ | 0,2 oz | 6 lbs
Retail Tags | 450 | 500 | 500 | 5 in² | 0 in³ | 0,0 oz | 0 lbs
Optional
[NAME]
- Small | $1 044 | 200 | 200 | 608 in³ | 0 in³ | 1,5 oz | 19 lbs |  | 10 garments
- Large | $1 449 | 200 | 200 | 1152 in³ | 0 in³ | 3,5 oz | 44 lbs |  | 18 garments
[NAME] cards | 765 | 500 | 500 | 15 in² | 0 in³ | 0,1 oz | 3 lbs
[NAME] card envelopes | 317 | 500 | 500 | 19 in² | 0 in³ | 0,0 oz | 0 lbs
[NAME] card boxes | $1 241 | 500 | 500 | 30 in³ | 0 in³ | 0,0 oz | 0 lbs
Sum
VAT
Warehouse
Shipping cost | ?
Shipping time | ?
Import duty | ?
Sum total | ?
Remains at end of month | Stock level % | Qty
Required
Boxes
- Small | ? | ?
- Medium | ? | ?
- Large | ? | ?
Order Confirmation Notes | ? | ?
Retail Tags | ? | ?
Optional
[NAME]
- Small | ? | ?
- Large | ? | ?
[NAME] cards | ? | ?
[NAME] card envelopes | ? | ?
[NAME] card boxes | ? | ?
Not really sure what I'm doing, this is all guesswork :(
Does this make any sense at all? | No
Photography
Name | Price | Type |  | Qty
Some photographer | 30000 | Photos + retouch |  | 30
Some model agency | 30000 | Models |  | 3
Some stylist | 20000 | Stylist |  | 1
Some makeup artist | 6000 | Makeup |  | 1
Products needing photographing | 10
Photos per product | 4
Extra promotional photos | 5
Total photos | 45
Estimated cost from photographer | 45000
Total estimate | 101000
Something similar here to what's done for the packaging material above perhaps?
Feb
All the stuff above repeated all over again I guess..