What Actually Happens When You Try to Plan Candle Production
I used to run a small candle studio out of my garage before scaling to a proper facility. One of the first things I realized was that guessing how much wax I needed for the week was costing me money. I would melt down two pounds of wax, burn through part of it, then scramble to run to the supplier because I had orders waiting. It was sloppy. So I built something out of a spreadsheet that became my Daily Candle Making Planner, and it changed how I ran the whole operation. The Daily Candle Making Planner is basically a structured tracking system where you log your daily production goals, map out which wax and wicks you're using, calculate burn times, and keep track of how much material you have left before you start each shift. It lives as either a printed sheet on your workbench or a live spreadsheet, depending on what your team finds less annoying. Most people go with a Google Sheets version because they can update it from their phone while the fragrances are curing. I need to be straight about one thing upfront. This tool is not going to fix a broken workflow. If you are ordering wax in bulk but not rotating your stock so the old batches get buried, no planner is going to save you from smelling like rancid soy by February. It also does not replace actual batching discipline. I have seen people print out these planners, fill them in once, and then ignore them for three weeks. That is not using the tool. That is just having a nice piece of paper.
Getting Started With Your Daily Candle Making Planner
First, you need to nail down your standard batch sizes. If you make 8 ounce tins and 12 ounce jars on the same day, you cannot plan around a single pour volume. Write down every container size you produce regularly. Then figure out how much wax each one consumes including the wick weight and fragrance load. A standard 8 ounce tin with a 10 percent fragrance load typically uses about 6.5 ounces of wax. Do not eyeball this. Weigh a test batch and write the number down. The spreadsheet columns I end up using every day look like this. Date, batch number, container type, wax weight, fragrance weight, wick type, pour temperature, cure start time, estimated cure end time, and total units produced. That last column is where most people skip. It is also the column that catches discrepancies. When my numbers in that column never matched my inventory deductions, I found out I was losing nearly a full pound of wax per batch to spillage and residue in the melting pot. That was the moment I started accounting for waste instead of pretending it did not exist. You will also want a section for fragrance loading rates because different wax types absorb fragrance differently. Soy wax holds about 9 to 11 percent fragrance by weight. Paraffin can handle 12 percent or more. If you are blending both, you need separate calculations. I learned this the hard way after I put a soy blend at 12 percent fragrance and had a candle that smelled like a chemical fire. The Daily Candle Making Planner needs a footnote row for these variations. Put it in and move on.
How It Actually Works Day to Day
Morning starts with checking yesterday's cure status. Look at the cure end times and decide which candles are ready to ship. Those get logged as finished goods. Then you enter today's production goals based on your order queue. Not your wishes. Your actual confirmed orders. I used to plan production around what I wanted to make. That approach collapsed when a rush order for 200 lavender tins showed up and I had melted nothing but vanilla chai for the week. When you enter today's targets into the planner, it should auto-calculate total wax needed, total fragrance needed, and how many wicks you require. If you are doing this manually, use simple formulas. One cell for wax per unit, one cell for units, multiply them together. That is it. You do not need VBA scripts or macros. The moment I added macros, nobody on my team could edit the file and it sat unused for months. One edge case that came up repeatedly involved seasonal fragrance oils. Some of them have different flash points and require a lower pour temperature than your standard wax blend. If you pour at 185 degrees when the oil calls for 170, you lose throw. I ran into this with a winter cinnamon blend that smoked the wick badly on the first pour. Once I added a pour temperature column to the planner with a note referencing the fragrance datasheet, that problem disappeared. The spreadsheet itself does not know about flash points. You have to fill in the right data or the tool is just a fancy notebook.
Get the Full Details
Practical Problems That Come Up and What I Do About Them
The most common issue I see is people overcomplicating the cure time tracking. Candles do not all cure in exactly the same window. Soy candles usually need 48 to 72 hours. Paraffin blends can sometimes be trimmed and packaged sooner. If you set one cure time for every item, you will either ship candles too early or wait around doing nothing. The solution is a cure window column that lets you input a range instead of a single day count. I use a simple low-high format like 48-72 hours and color code the cells so I can see at a glance which batches are ready and which are still sitting. Another problem is fragrance inventory. I once ran out of a single scent mid-batch because the planner tracked wax perfectly but treated fragrance as an afterthought. The workaround was to add a raw material minimum threshold column. When your fragrance stock drops below a set reorder point, the planner flags it. I keep reorder points at 200 milliliters for my top sellers and 100 milliliters for everything else. It is not elegant but it stopped the surprise shortages. If you are working alone, the planner becomes a chore after about three weeks. I found that the friction came from the data entry, not the thinking. I started voice noting my batch details while I worked and transcribing them later. That cut my nightly logging time from about twenty minutes down to maybe five. Five minutes is still annoying, but it is sustainable. Two hours per week of manual entry will make you quit the system, and then you are back to guessing again.
What This Tool Cannot Do For You
Let me be clear about the limits. A Daily Candle Making Planner will not predict demand. It will not tell you whether a new scent is going to sell or whether you should stop making the 6 ounce votives that are eating up your pouring time. It tracks what you already decided to make. It does not make the decisions for you. If you think this spreadsheet is going to turn you into a successful business overnight, you are looking at it wrong. It also breaks down if you change product lines frequently. I had a month where I tried three new container shapes and switched wax suppliers twice. The planner was useless because every calculation was outdated within days. In situations like that, keeping a basic production log in a plain notebook works better than fighting a complex spreadsheet. Sometimes the simplest version is the one you actually maintain. For teams larger than two people, the shared spreadsheet model can get messy with version conflicts. I watched a coworker overwrite a cure time entry because we were both editing at once. Google Sheets handles this with edit history, but it is still a friction point. If you are running a team of five or more, look into a simple inventory management app instead. Something like Sortly or even a basic Airtable base with barcode scanning. The planner concept stays the same. The delivery method just changes.
A Quick Note on Templates and Where to Get One
There are pre-made Daily Candle Making Planner templates floating around Etsy and Google Sheets galleries. Most of them are fine as a starting point. I would not pay more than fifteen dollars for one unless it includes automatic cost-per-unit calculations and raw material reorder alerts. Those features are worth the money. The ones that cost fifty bucks and include animated charts are just decoration. Nobody looks at charts while pouring wax. If you want something I would actually hand to a new candle maker, start with a barebones version. Date, product type, wax weight, fragrance weight, wick type, pour temp, cure window, units made. Fill in what you can. Add complexity only when the gaps show up. That is how I built my original planner. It started as four columns and grew to eleven over eight months as I hit real problems. The tool that survives is the one that grows with your actual workflow, not the one you downloaded and hoped would fit perfectly on the first day.
