This template will help you determine the Cost of Materials, Labor, and other expenses per Bar of soap. Completely automated so that you only have to add information you already have.
check how the template works here!
Things you will need to add:
- On Raw Material Cost tab, add all of your materials (FO, EO, oils, additives, micas, botanicals etc) how much of it you bought (in grams, oz, lb, or liters), and how much you paid.
- On the Recipe Information tab, you will add how many bars per loaf you get, the retail price of each bar, and the raw materials information (how much of each material you need for your recipe in oz, gr, tbsp, or tsp).
- You also have the option to add your time (add your rate per hour, and how many bars you make in an hour) and other expenses like labels etc.
Then, the template will do all of the calculations and conversions for you! YAY! you will be able to see how much one tablespoon of mica costs! Isn't that amazing?
You will also get Suggested Pricing, Historical information and comparison between different bars that use different ingredients.
The graphs and tables will self populate as you enter your information.
You will be able to download the Excel file automatically and you will also receive a Google Sheet template on your email. NOTE: If you use Google Sheets, make sure to add your google email when checking out.
This is a digital product and your download will be available upon purchase. You must have access to Microsoft Excel or Google Sheets to Use this template. Due to the nature of this product, no refunds are issued. If you have problems accessing your document reach out to us.
Terms & Conditions
You are purchasing a digital download template in Google Sheets and Excel. The use of this template is intended for personal use only. The work of this spreadsheet is intellectual property and protected by copyright law. You are not allowed to share, duplicate, re-sell, or transfer this template to anyone. When you buy this template, you agree to this terms and conditions.