I originally created Price Your Products because I was having trouble pricing my multi-component bath bombs. The spreadsheet was created with these products in mind, with separate sections for each component of the bath bomb along with sections for all the other usual costs associated with manufacturing bath products. While it was created with multi-component bath bombs in mind I made sure that it can also be used to price any product.
The first few incarnations of Price Your Products were fairly simple. You had to input a lot of data manually and refer to a pricing table which contained a number of somewhat convoluted pricing formulas. There was also a basic batch converter included in the file.
The latest version makes it easier to input your ingredients and automatically calculates more data so there is a lot less manual data input required each time you price a product. The pricing sheet itself has been improved as well. I’ve included extra pricing options such as overhead costs and the ability to choose between pricing based on separate component costs or a simpler percentage markup method. There’s no longer the need to refer to a pricing formula table, you simply tell the sheet exactly how you want your retail price calculated and it does it for you.
There are now three converter tables that will allow you to easily work out batch sizes and convert from weight to percentage. These are handy for people like me who work out our formulas in percentages then need to make a variety of batch sizes based on those percentages. It’s also handy for those of you who are tweaking a formula and jotting down the weights of ingredients you are throwing into your batch on the fly. The weight to percentage converter will quickly calculate your batch percentages for you, all you have to do is tell the sheet how much of each ingredient you have used and you can easily customise your batch size.
There is also a separate print-out sheet which can be customised so that you can print out a single page for each of your products. This way you can include whatever information you require, print it out and file it with all your pricing sheets for easy reference. Originally I didn’t have a printout sheet so, if you wanted to keep a hard copy of your product prices, you were required to print out the costing sheets which could sometimes mean 3 pages worth of info. The latest file means you can save on ink and paper while still being able to have a hard copy of your product prices.
Price your Products 4 was made using Apache Open Office Calc, which is similar to Excel only it’s free. In order to open the file, you will need to download Open Office.
You can find Open Office here: https://www.openoffice.org/download/index.html
You can find an installation guide for Open Office here: https://wiki.openoffice.org/wiki/Documentation/FAQ/Installation
Once Open Office is installed you should be able to open the Price your Products file without issue by double clicking on the file.
I will be creating an Excel version of Price Your Product for those of you who own Excel. I decided to make the open office version a priority as it’s free, so it’s available to everyone.
This guide and the file it pertains to is licensed for your personal use only. If you would like to share this guide or the file it pertains to with another person, please purchase an additional copy for each recipient.