My inventory spreadsheet has the following columns from left to right;

• Total quantity of a particular product owned
• Product type (e.g. 'Lipstick', 'Cream Colour Base', 'StudioFix')
• Shade
• Retail price
• Retail price multiplied by total quantity owned
• Quantity carried in my knapsack and traincase
• Value of item carried in knapsack or traincase.

Everything is totalled up for my entire collection and that part of the collection which goes out on the road in my train case or knapsack when I'm doing makeup for other people. This means that at any time I know how much the retail replacement value of the knapsack and traincase would be in the event they got stolen. Because all the calculations are done by the spreadsheet it updates itself automatically when I add new items to my inventory. The total for just my knapsack comes to £1,883.53 at the moment - which works out at about $3,256. Knowing that makes me much more careful with it!

__________________
Sarah W - Flying M·A·Caholic