A Gantt chart is a schedule you can read at a glance: jobs down the side, days across the top, and a bar on each row from the day the job starts to the day it ends. For production it answers the questions a list of dates can't. Read down a column and you see everything happening on one day, including two jobs that need the same table. Read across a row and you see how long a job ties up a line. You don't need a special program to draw one. A start day, a number of days, and one formula copied across fourteen columns will do it. Below is a two-week chart for a made-up granola maker, the formula, how to use the chart to find clashes, and the template.
The short version
- One row a job. Columns for start day, days needed, end day.
- One column for each day of the plan.
- A formula marks a cell when its day falls between the job's start and end.
- End day = start day + days − 1.
- Read down a column for clashes. Read across for load.
- Put changeovers and cleaning on the chart as jobs. They take the line too.
- TaroStack plans what to make and when, with capacity, on Growth. More below.
An example chart
Days are working days counted from the first Monday of the plan.
| Job | What | Start | Days | 1 | 2 | 3 | 4 | 5 | 8 | 9 | 10 | 11 | 12 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mix and bake | Honey Almond, 6 batches | 1 | 2 | X | X | ||||||||
| Mix and bake | Maple Pecan, 4 batches | 3 | 1 | X | |||||||||
| Bag and label | Both granolas | 2 | 3 | X | X | X | |||||||
| Pack wholesale orders | 3 orders | 5 | 1 | X | |||||||||
| Clean down | Allergen changeover | 5 | 1 | X | |||||||||
| Mix and bake | Peanut Butter, 5 batches | 8 | 2 | X | X | ||||||||
| Bag and label | Peanut Butter | 9 | 2 | X | X | ||||||||
| Market prep | Saturday market | 11 | 1 | X | |||||||||
| Deliveries | Wholesale route | 12 | 1 | X |
Days 6, 7, 13 and 14 have nothing planned and are left out of the table here to fit the page. The file shows all fourteen.
The formula
Three typed columns and one formula.
- Start day in C and Days in D are typed.
- End day in E:
=C2+D2-1. A two-day job starting on day 1 ends on day 2, not day 3. - Each day's cell. For the column that stands for day 1:
=IF(AND(1>=$C2,1<=$E2),"X",""). For day 2 the 1s become 2s, and so on across.
The dollar signs keep the formula looking at columns C and E as you copy it across. To turn the Xs into bars, select the day columns and use conditional formatting to fill any cell equal to "X". The file leaves them as letters so it prints on anything.
Reading it
Down a column: clashes. Day 5 has two marks: packing wholesale orders and the allergen clean-down. If both need the packing table, one has to move. In this plan the orders are packed in the morning and the clean-down is in the afternoon, which is the right order, because the peanut granola starts on day 8 and the line has to be clean before it. That's a decision the chart forces. A list of dates would have let it slide.
Across a row: load. Bagging runs three days, from day 2 to day 4, overlapping the second day of baking and all of the Maple Pecan bake. Two people can do that. One can't.
Gaps. Days 6, 7, 13 and 14 are empty. That's either slack to absorb a late delivery, or capacity you could sell.
What the chart leaves out. A Gantt chart shows time. It doesn't know whether the oats for day 1 have arrived. Materials are a separate sum: see MRP spreadsheet template.
Building a schedule worth charting
- List the jobs from the orders and the stock you want to build: see how to prepare a production plan.
- Give each a duration from how long it really took last time, not how long it should.
- Put the fixed points in first: a delivery day, a market, an order's due date.
- Work backward from each due date.
- Add the jobs nobody lists: cleaning, changeovers, receiving a big delivery.
- Check each column against people and equipment: see how to calculate production capacity.
A schedule as a table, without the bars, is in production schedule example, and one that plans by product and week in master production schedule template.
Get the template
Download the production schedule Gantt chart. One sheet and a read-me: type each job's start day and length, and the sheet works out the end day and marks its days across two weeks. The granola maker's nine jobs are filled in. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
The chart is a picture of a plan made on Monday. On Tuesday the oat delivery is short and the first bake slips a day. Now every row after it is wrong, and someone has to retype the start days and hope nothing else moved. A Gantt chart in a spreadsheet shows a plan clearly. It doesn't replan.
How TaroStack does it
TaroStack plans from orders, recipes and stock, and says what changed.
Planning, on Growth, says what to make, what to buy and when. Every suggestion is a draft you approve.
Work centers and capacity, so a week's plan doesn't promise more hours than a line has.
It's built on current stock, by lot and date, and on your suppliers' lead times.
Exceptions in plain words: what will run short, arrive too late, or expire before it's used.
"What could I make right now" answers the Tuesday question when the delivery is short.
| The job | Gantt chart in Excel | In TaroStack |
|---|---|---|
| See the plan | Bars you draw | A capacity schedule |
| A delivery is late | Retype the dates | An exception, in words |
| Too much on one line | Spot it in a column | Capacity by work center |
| Are the materials here | A separate sheet | Part of the same plan |
Planning and the capacity schedule are on Growth at $39 a month (50 recipes) and above. Recipes, batches and stock are on every plan, from $9.99 a month. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
