Spreadsheet: 159293d1338571513-keeping-packaging-material-and-photographs-in-sync-with-inventory-budget_model
Sheet: Purchases

2012
Jan
Supplier 1
Name | Size | Qty | 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 1 | UK 8 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 10 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 12 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 14 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 16 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
Product 2 | UK 8 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 10 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 12 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 14 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 16 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
Product 3 | UK 8 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 10 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 12 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 14 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 16 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
Product 4 | UK 8 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 10 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 12 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 14 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 16 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
Product 5 | UK 8 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 10 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 12 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 14 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 16 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
Sum
Sum SKU
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
Name | Size | Qty | 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 1 | UK 8 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 10 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 12 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 14 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 16 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
Product 2 | UK 8 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 10 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 12 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 14 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 16 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
Product 3 | UK 8 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 10 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 12 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 14 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 16 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
Product 4 | UK 8 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 10 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 12 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 14 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 16 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
Product 5 | UK 8 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 10 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 12 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 14 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
 | UK 16 | 1 | 0.7 | 0.7 | 1 | 1 | 25 | 35
Sum
Sum SKU
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 | Qty | Volume each | Volume per bundle | Weight each | Weight per bundle | Likelihood
Required |  |  |  |  |  |  | Is there a better name for this?
Boxes
- Small | 590 | 200 | 64 in³ | 0 in³ | 2,0 oz | 25 lbs | 0.25
- Medium | 1294 | 200 | 256 in³ | 0 in³ | 4,0 oz | 50 lbs | 0.5
- Large | 1455 | 200 | 432 in³ | 0 in³ | 7,0 oz | 88 lbs | 0.25
Order Confirmation Notes | 435 | 500 | 14 in² | 0 in³ | 0,2 oz | 6 lbs | 1
Retail Tags | 450 | 500 | 5 in² | 0 in³ | 0,0 oz | 0 lbs | 1
Optional
[NAME]
- Small | $1 044 | 200 | 608 in³ | 0 in³ | 1,5 oz | 19 lbs | 0.15
- Large | $1 449 | 200 | 1152 in³ | 0 in³ | 3,5 oz | 44 lbs | 0.15
[NAME] cards | 765 | 500 | 15 in² | 0 in³ | 0,1 oz | 3 lbs | 0.05
[NAME] card envelopes | 317 | 500 | 19 in² | 0 in³ | 0,0 oz | 0 lbs | 0.05
[NAME] card boxes | $1 241 | 500 | 30 in³ | 0 in³ | 0,0 oz | 0 lbs | 0.05
Sum | $9 040 |  |  | 0 in³ |  | 234 lbs
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
Estimated cost from photographer
Total estimate
Something similar here to what's done for the packaging material above perhaps?
Feb
All the stuff above repeated all over again I guess..