Monthly Candle Making Template

Most people who start making candles professionally end up either completely ignoring supply ordering until they run out of something mid-batch, or they buy way too much wax and fragrance because they don't know how to estimate their monthly usage. I spent two years doing exactly that before I sat down and built something that actually tracks what I need. Here's what a working Monthly Candle Making Template should cover and how to set one up.

Setting Up the Material Tracking Sheet

Start with your core inputs: wax type, fragrance oil, wicks, containers, and colorant. Not every candle uses all of these, obviously, but the template needs to account for when you do or don't use something. Create columns for the following data points per material:

Material name and supplier
Unit price per pound or ounce
Current stock level
Minimum reorder threshold
Lead time in days from order to delivery
Usage rate per candle batch
Forecasted monthly usage based on production targets

I used to skip the forecasted monthly usage column. That was my mistake. Without projecting what you need ahead of time, you're always reacting instead of planning. Once I started building the forecast off my actual sales velocity from the previous three months, the template became useful rather than just a spreadsheet that sits there.

Calculating Cost Per Unit

This is where most beginner templates fail. They track material costs but forget to allocate overhead properly. Your wax cost per candle is one thing. What about the fragrance? Wicks? Containers? Dyes? Labels? Shipping supplies? And then there's the hidden stuff like broken pours, failed batches, and wick trimming waste. My template has a dedicated section that breaks cost per candle into raw materials, packaging, and overhead. Overhead includes things like electricity for melters, label printing, and the time you spend on tasks that don't directly relate to a single candle. I allocate overhead as a flat percentage across all units produced each month rather than trying to attribute it to individual candles. It's not perfect but it's practical and easy to maintain. If you're selling at local markets, you also need to factor in table fees, parking, and perishable costs like ice or water. Those change monthly and they eat into margins faster than most people realize.

The Reorder Alert System

A Monthly Candle Making Template isn't worth anything if it doesn't tell you when to order. I set up a simple conditional formula that flags materials when current stock drops below the minimum threshold adjusted for lead time. The formula looks at days until depletion, not just absolute quantity. If you use 10 pounds of soy wax per batch and you've got 8 pounds left but your supplier ships in two days and your next order won't be due for a week, you're not in danger yet. But if your supplier has a two-week lead time and you only have enough for three more batches, you need to order now even though you still have stock. I personally ran into a situation where I had plenty of wax but was out of a specific wick type I'd been using for my best-selling jar candle. The template didn't catch it because I had three different wick SKUs tracked under one line item. I fixed this by splitting wick tracking into separate rows per style and size. Took me ten minutes and eliminated that blind spot entirely.

Monthly Production Planning

The template should include a production calendar section where you map out what you plan to make each month. This isn't about committing to exact numbers on day one. It's about having a target so your material projections have something to anchor to. I recommend starting with last year's monthly sales data if you have it, then adjusting for seasonality. Candle demand spikes between October and December and again around spring gifting seasons. If you ignore seasonality, your template will tell you to order the wrong amount of material at the wrong time. I keep my production targets at about 80% of maximum capacity. Running at full capacity every month sounds efficient but it leaves no room for mistakes, extra orders, or unexpected supplier delays. The 20% buffer has saved me more times than I can count.

Where to Get One

You can build this from scratch in Google Sheets or Excel. It usually takes about an hour if you already know your numbers. If you don't want to build it yourself, there are pre-made templates available on Etsy and in certain small business communities. Search for "Monthly Candle Making Template" and you'll find a few options. Just be careful with the ones that come pre-loaded with assumptions about wax type or production volume that don't match your operation. I once downloaded a free template that assumed I was making pillar candles with cotton wicks and no colorant. Completely irrelevant to my container candle business and I wasted twenty minutes trying to adapt it. Building your own takes longer upfront but it's the only way to make sure the template actually reflects how you work.

What This Template Won't Fix

A template won't help if you're making candles inconsistently or if you change product lines every month without adjusting your forecast. It also won't account for supplier price changes unless you update it. I've watched people treat these spreadsheets like something you set once and never touch again. That's not how it works. You need to update stock levels after every pour, log actual costs after every batch, and review your forecasts at the start of each month against what actually happened the month before. The biggest limitation is that it requires discipline. There's no automation happening here. You enter data, the template calculates, you act on the results. If you skip the data entry, the template gives you false confidence and you end up in the same position you were in before.

Final Notes

The simplest version of a Monthly Candle Making Template that works has four sections: material inventory with reorder alerts, cost per unit breakdown, monthly production targets, and a historical log of actual versus projected usage. That's it. You don't need fancy charts or automated formulas that break when you change one cell. You need something you'll actually use every week.