##### Article by: Perry Romanowski

If you’re interested in making cosmetic products from scratch but you don’t have fancy software to do it, you can easily make them using a simple spreadsheet formula.

Here’s a video that explains the process.Β  It allows you to make different batch sizes, calculates ingredient masses, and also costs out the formula.

Cosmetic Formula Template

1. Yusoff Id

Thank you sir, very helpful, bless you.
Helps me a lot.

2. Yusoff Id

Thank you sir, very helpful, bless you.

3. NORA KORNHEISL

Thank you very much! this is very helpful.
I am going to try and add Inventory columns to it that way my inventory is updated automatically as I use the ingredients…

4. Monica

Hi Perry,

Thank you for all the hard work and your patience. This is a great place to gather information. Regarding the spreadsheet, what if the formula is composed only of oils? Thank you

5. Carol

Thank you so much for creating this spreedsheet. It is an extemely valuable tool that I needed for my business! Thank you again for all your hard work in developing this spreedsheet!

6. trisha

what if you are not sure on the percentages yet? How do you figure that out? I am experimenting with a product and I wrote down how much of each product I used which is primarily in cup and spoon measurements, but I am uncertain how to translate that into percentages. Your video is super helpful!

1. Perry Romanowski

Hello Trisha – if you have cup and spoon measurements, you need to convert them to grams. There are conversion calculators online that will help you.

7. Susanne

Such a nice formulation spreadsheet – thank you! I tried to “delete” the column D (Actual amn.) and copy the column C in it because I so much like to have both 500grams and 1000grams recipe in same spreadsheet. But it does`nt work. Do you have any suggestion for me how to have 2 columns (C and D) with respectively 500 gram recipe and 1000 gram recipe?

1. Perry Romanowski

You can just insert another column. Then copy the formula from column C to the new column. You’ll have to adjust the cells in the formula to point to the proper values.

8. Terri-Anne

HI, could you explain what the column called Actual Amt is for please? Thanks π

1. Perry Romanowski

That is the amount that you actually weigh out and put in the formula. It changes based on the size of the batch.

9. tiffany newman

Hi — Quick question…How do you add a line for additional ingredients?

1. Perry Romanowski

I think you can just go to ‘Edit’, ‘Insert’, ‘row’

10. Julie

I needed a formulation sheet quickly for a client’s custom formula. Thank you so much for this, Perry, and for all that you have shared.

11. Harrison

Hi Perry,
What cell formula did you use?

1. Perry Romanowski

12. S

Excellent explanation.
Thank you

13. Selina Jackson

Thanks you so much for this, I can’t tell you how much learning these steps has relieved so much of my stress, thanks again

14. Shawn

The first video link is broken.

1. Perry Romanowski

Thanks I fixed it.

15. Cosmetic Formulation Software

I really like your post.Itβs really informative and interesting. I really appreciate that.
We provide an affordable, secure web-based software application for empowering cosmetics businesses. This is a complete formulation and cosmetic production software solution. You can create formulas, do formulation costing, and print out batch sheets.

1. Perry Romanowski

How is your software superior to just using a spreadsheet for formulating?

16. Charina ting

Hi… is the uploaded spreadsheet still active? We are a startup company and would like to check how we can make our research and costing templates more structured and efficient…. hope you can upload them again…. thank you

1. Perry Romanowski

Yes the spreadsheet should still work.

17. CYNTHIA UZOETO

Thanks alot.I want to start up my cosmetics line and u v bn very helpful.

18. Jenneine

Hi Perry,
The video formulation template is not loading, neither on firefox nor chrome, wont download either says file not file or technical problem. Can you check this out I need to watch video, something i dont understand on your template.

thanks

1. Perry Romanowski

Thanks for letting me know. I updated it to show the video.

Hi there! Thank you for sharing! π

20. jennifer

please put the template back on!!! you made it look so easy on the video π I would love to work with it.

1. Perry Romanowski

I’ll get to it shortly. We lost all of our links when the website went down.

21. Vianca

Hello, I just started my own hair products line…and I created a spreadsheet template for my formulas that also calculates the cost of my product including packaging, as well as my profits and my retailers profits π Took me a week to get it right as it required some very intricate equations. I can share if you’d like?

1. jennifer

2. Beverley

Hello Vianca,
Happy Holidays! I started experimenting on face creams. I would love if you share your spreadsheet template with me. It sounds like something I could really use.
Thank you.
Beverley π

3. Rafaella

Hey Vianca, hope you are doing well. I am having a hard time trying to creat my spreadsheet. Could you please share it with me? Thank you so much.

4. Deja gordon

Hey Vianca,

Im starting my own hair care line as well and was wondering if you could supply me with the spreadsheet you created?
Thank you,
Deja

1. Amaka

Hi Vianca
Thanks

5. MOHAMED TAYEL

Any chance you can share it Vianca

22. Sharon

Hi

Thanks so much for this – really helps! Video was very useful to – however if I would prefer to change from pounds to Kg or Litres and British pound Β£ how would I do that without messing up your spreadsheet π

I have been working on a soap formula – which this will work perfectly. Do you have any other spreadsheets that can be used to work out packaging for a formula?

Once again that’s for making my life simple π
Sharon

1. Perry Romanowski

Thanks for the ideas. The spreadsheet is open so you can easily adapt it for your own uses.

23. Amanda

Thank you!

24. Lorraine

Oh My God…..YOU rock Perry, Loving you, Thank you!

Thank you Perry, that was very helpful. I have not started out yet but I’m supposed to make a batch of 10kg of deodorant and pack it in 50ml bottles. I do not know how many 50ml bottles 10kg will give me, this will help me determine the price of my product in relation to the cost of producing a 10kg product. How do I calculate this because I am dealing with volumes and weights here?
Thank you again.

1. Perry Romanowski

Well, you just need an approximate value and can use the fact that 1mL ~ 1 g.

So, 10 kg = 10,000 g = 10,000 ml
10,000 / 50 = 200 bottles. But you have to figure you are going to lose about 10% of your batch so realistically, 10kg = 180 bottles.

26. Pingback:Calculating Cosmetic Formula Costs

27. luis

Hi perry,

Can you help me with developing a new formula for bleach gel. I hope to hear from you soon.

28. cc_joy

Nice demo ….. it get give an idea how cosmetic chemist work

This site uses Akismet to reduce spam. Learn how your comment data is processed.