Re: price book
The first time I created a pricebook I used sheets of notebook paper in a binder (so I could add more when needed). I just decided to start again and created an Excel document. The format goes like this:
Item Store Price Coupon? Price after coupon/unit Price per unit
mustard, Frenchs Tops $.97 $.30, doubled $.37/14 oz .026/oz
This way, I can look at a jar of mustard and if it's 14 oz, I have an easy comparison. If it's not, I can use the per ounce price to figure out if it's a good deal. I tend to only keep track of the best one or two prices. If I am looking at mustard at it's $1.49, I know I can do better if I wait. If I get a better price, then I will take out the older price in the price book. I don't keep track of dates to know when sales will come back around. I just stockpile when I see a good deal.
|