Work, costs & budget
How much work a task takes, what it costs, and whether the project as a whole is still inside its budget. This page explains how each of those numbers is worked out, and which ones you type yourself.
Dates tell you when a task happens. Money and work tell you what it takes to make it happen, and Gantt Excel tracks those in five separate numbers per task plus two figures for the project. They are easy to confuse. Some are calculated for you and some you fill in yourself, and the table below says which.
01 The five numbers on every task
Each of these is a column on the task sheet, and each has a matching box on the Task Form. Three are calculated, two are not:
| Column | What it holds | Who fills it in |
|---|---|---|
| Work | How much person-time the task needs | Calculated from the duration and each person’s allocation |
| Resource Cost | The labour cost of the people assigned | Calculated, unless you switch that off |
| Est. Cost | What you expect the task to cost | You |
| Baseline Cost | The cost you signed up to when the plan was agreed | You |
| Actual Cost | What it really cost | You |
Resource Cost is deliberately separate from the three cost bands. It is labour only, priced from the rates on the Resources sheet. While Calculate Resource Cost is on, Gantt Excel owns it, and anything you type there is cleared and recalculated. The three bands are yours: put materials, fees, hire charges and whatever else belongs to the task into them.
Beside them sits a sixth column, Allocation, which reads like Sam Reddy 50%, Dave Nolan 100%. It is not a figure you type: it shows how much of each person’s time the task takes, and it feeds both Work and Resource Cost. Section 03 explains it.
The five are not one block on the sheet, which catches people out when they go looking. Resource Cost, Allocation and Work sit close to Resource, before % Complete. The three cost bands (Baseline Cost, Est. Cost and Actual Cost, in that order) sit much further right, past % Complete and past the Actual date columns, immediately before Notes.
All five arrive hidden on a new chart, along with several other optional columns. If you cannot see one, it has not been turned on yet. Tick it in the Columns to show list at Gantt Excel → Settings → Settings → Columns, where a ticked column is a shown one. That same list is how you move a column along the row, so you can bring the three cost bands up next to Resource Cost if you would rather see them together. Allocation is different: a new chart shows it, straight after Resource Cost. Hiding a column only affects the view. Whether costs are tracked at all is a separate switch, in section 09.
02 Work — the person-time field
Work answers a different question from Duration. Duration is how long the task occupies the calendar; Work is how much person-time it consumes. A 4-day job with two people on it full-time takes four days of calendar and eight days of work.
Gantt Excel works it out for you:
It reads the Estimated duration only, never the Baseline or Actual one. Each person on the task has an allocation, the share of their working time the task takes, and anyone you have not changed is at 100%. With everyone at 100% the formula comes down to the duration × the number of people. A name written twice in the Resource cell counts once, and a task with nobody on it counts as one person at 100%, so its Work equals its duration.
The unit follows the chart. On a day-based chart Work is in person-days; on an hourly chart it is shown in person-hours. When you type a Work figure, a plain number takes the chart’s Duration is entered in unit, set in Edit Project: with Days, 2 is two person-days; with Hours, two person-hours. Type 16h or 2d to say which yourself. Change the duration, the people or their percentages and Work recalculates at once, both in the grid and in the open Task Form.
Worked example — the kitchen refit
Four trades are on the Resources sheet with these day rates:
| Resource | Trade | Cost per Day |
|---|---|---|
| Dave Nolan | Fitter | £280 |
| Sam Reddy | Plumber | £300 |
| Maria Ferreira | Electrician | £320 |
| Ana Silva | Decorator | £220 |
“Fit kitchen units” runs Mon 6 July → Thu 9 July, a duration of 4 days, with Dave and Sam both on it at 100%. Work is 4 × 2 = 8 person-days.
- Work. Planned work for the task, in person-days, or person-hours on an hourly chart.
- The label. Reads plain Work. A figure you type here is not stored as it stands: it sets the people’s percentages (section 03), or on some charts the duration (section 04), and the box then shows the Work that results.
- Resources. Who is on the task. Their rates (Cost per Day, or Cost Per Hour on an hourly chart) and their percentages drive the Resource Cost below.
- Resource Cost. The calculated labour cost. Typing here does nothing useful, because the calculation overwrites it.
- Costs. A group heading over all four money boxes, not a field in its own right.
- Estimated, Baseline and Actual. The three cost bands, all of them yours to fill in.
03 Allocation: how much of each person a task takes
Not everyone on a task works on it all day. Two fitters may each be there half the time, while a specialist may put in two days for every day the task runs. The allocation records that: one percentage per person, from 0 to 1000, where 100% means the task takes all of that person’s working time.
The Allocation column lists everyone on the task with their percentage, in the order they appear in the Resource cell: Dave Nolan 50%, Sam Reddy 50%. Summary tasks and milestones show nothing there. Neither carries percentages: a summary’s Work and cost roll up from its children, and a milestone has no working time to book anyone for.
Setting a percentage
Percentages are set in the Select Resources picker. Double-click a task’s Resource cell or its Allocation cell, tick the people on the task, and give each one a figure in the % box under the list. The picker shows the task’s duration, Work and cost as you change them. The Resources guide walks through it.
A name typed straight into the Resource cell comes in at 100%. Anyone already on the task keeps their percentage, and someone taken off loses theirs.
Typing a Work figure instead
You can also start from the total. Type a figure into Work, in the grid or on the Task Form, and Gantt Excel works out the percentages that give it. The duration stays as it is. When several people are on the task, the new total is shared in proportion to the percentages they already have, so two people at 100% each take half of it.
Continuing the example: Dave and Sam are each on the kitchen units for half of each day, so the real figure is 4 person-days, not 8. Type 4 into Work and the Allocation column reads Dave Nolan 50%, Sam Reddy 50%.
The figure you typed is not kept as it stands. It becomes percentages, and Work is worked out from them as before. So if the task later stretches to 5 days, Dave and Sam stay at 50% and Work becomes 5. A newcomer arrives at 100%: with Sam alone on a 3-day task, typing Work 6 puts Sam at 200%, and if you then add Dave at 100%, Work becomes 9.
To put everyone back to 100%, clear the Work cell.
| What you type in Work | What Gantt Excel says |
|---|---|
| Text, or a negative number | Work must be a number, 0 or more. |
| A figure on a task with nobody on it | Put someone on this task before typing its Work. Work is shared between the people on a task. |
| Anything but 0 on a milestone | A milestone has no duration, so its Work can only be 0. |
| A figure that would take someone past 1000% | That Work would put {0} over 1000%. Add people or lengthen the task instead., with the person’s name in place of {0} |
| A figure on a summary task | This is a Parent task. Work is automatically calculated based on child tasks. |
A refused figure changes nothing on the row.
04 When Work sets the task’s length
Everything above treats the duration as fixed and lets the percentages give. Some plans run the other way: you know a job is 12 person-days of effort, and how long it takes depends on how many people you put on it. For those, every chart has a setting with two choices, Task length comes from: Duration or Work. It is on the General tab of Settings and applies to the chart you are on. A new chart starts on Duration.
With Work chosen:
- Typing Work sets the duration. The percentages stay as they are, and the duration becomes Work ÷ (the percentages added together ÷ 100). The task is then rescheduled exactly as if you had typed that duration.
- Adding or taking off people moves the duration so the Work stays the same. That holds whichever way the people change: the picker, the Resource cell, the Task Form, or a resource deleted in the Resources window.
- A finished task never moves. Once a task is at 100% or has an Actual End Date, its length is a record and stays put.
- Typing a duration still works. The duration is set, the percentages stay, and Work follows.
Back in the kitchen: “Fit kitchen units” is 4 days with Dave alone at 100%, so Work is 4. On a chart whose task length comes from Work, add Sam at 100% and the task shrinks to 2 days, still 4 person-days of work. Take Sam off again and it goes back to 4 days.
A task with nobody on it accepts a Work figure here, counted as one person at 100%. Text, negative numbers and milestones are refused as in section 03, and three more cases are refused:
| When | What Gantt Excel says |
|---|---|
| Work typed on a finished task | This task is finished, so its Work can no longer change its duration. |
| Work typed as 0 | Work cannot be 0 when task length comes from Work. To make a milestone, type 0 in Duration. |
| Everyone on the task at 0%, or a change of people that would leave everyone at 0% | Everyone on this task is at 0%, so no duration can hold its Work. Give someone a percentage in the resource picker.A refused change of people is undone. |
Switching the setting moves nothing. No date, Work figure or cost changes when you apply it; it only decides what your next edit moves.
05 Resource Cost — how it is really worked out
Resource Cost is the labour cost of the people on the task. Each person is priced separately and the results are added up:
On a chart made in this version the Resources window has Rate per hour beside Rate per day. Type either and the other is worked out from Hours in a working day, so £35 an hour is £280 a day on an 8-hour day. The Select Resources picker shows the hourly figure as Cost Per Hour, and the calculation runs on that rate and the hours behind each duration, whether the project’s durations are entered in days or in hours. On an old daily chart the window has Rate per day alone, the picker shows Cost per Day, and the calculation runs in days. Either way the answer is the same, so everything below is written in days, as the kitchen refit is planned.
Two details in that formula explain most figures that look wrong.
The rates are summed, not averaged
Every person on the task adds their own cost. Put Dave (£280) and Sam (£300) on a task at 100% each and it costs £580 per day, not £290. A name written twice in the Resource cell is charged once.
The allocation scales each person’s share
A person at 50% is charged half their rate for the length of the task; a person at 200%, twice it. This is how a task with two people on half-days is not billed as two people full-time:
“Who is on the task?”
The whole team is on the task for its full length, so the cost is the rates added up × the duration.
Dave and Sam on a 4-day task: £580 × 4 = £2,320.
“How much of their time does it take?”
Each person’s rate is scaled by their percentage before it is multiplied by the duration.
Same task after typing Work 4: (£280 × 4 × 50%) + (£300 × 4 × 50%) = £1,160.
Both cards are the same calculation. On a chart where nobody has been moved off 100%, Resource Cost is the rates added together × the duration, as it always was.
When Resource Cost comes out blank
The cell is deliberately left empty, rather than showing zero, in each of these cases:
- No resource is assigned. Unassigned work carries no labour cost.
- The resource is Organization. That is the old name of This plan’s calendar, the plan’s default calendar rather than a person you can bill, so the Resources window gives it no rate.
- The people on the task all have a rate of zero, or no rate at all, or are all at 0%.
- The row has no duration, which in practice means a milestone. Rate × zero is zero, and a calculated zero is written as a blank. A priced resource on a milestone therefore shows an empty Resource Cost.
- The task is a parent. Its figure is set by the roll-up instead (see section 07).
06 The three cost bands
The Task Form groups four money boxes under a Costs heading. One is the calculated Resource Cost; the other three mirror the three date bands, and exist for the same reason: so you can see budget slippage the way you see schedule slippage.
“What do we currently think this will cost?”
Your live estimate, on the sheet as Est. Cost. Update it whenever the picture changes, such as a supplier quote landing or a specification growing. This is the figure the project’s task-cost total is built from.
“What did we agree it would cost?”
On the sheet as Baseline Cost. Set it once, when the plan is approved, and then leave it alone. It is the yardstick the other two are measured against. Set Baseline fills it from each task’s Est. Cost, or its Resource Cost when none is typed, and the figure then stays as taken when rates or people change; see Baselines & actuals.
“What did it really cost?”
On the sheet as Actual Cost. Fill it in as the invoices arrive. It never feeds back into the plan or moves anything.
Unlike the date bands, the cost bands have no Copy Est. button, so each is typed. Any number from 0 up is accepted and stored, in the grid and on the Task Form alike.
0 and blank mean different things. 0 says the task costs nothing; blank says no figure has been entered yet. To clear a cost, delete it: the cell empties with no message. Text and negative numbers are refused. In the grid Gantt Excel shows Invalid cost value. Please enter a valid number.
and clears the cell; on the Task Form the box is emptied.
Worked example — where the money went
Carrying on with “Fit kitchen units”. The units and fixings were quoted at £2,400 when the plan was approved, the quote was revised to £2,600 before work started, and the final invoice came to £2,780 after a worktop was cut wrong.
| Band | Figure | What it tells you |
|---|---|---|
| Baseline Cost | £2,400 | The cost that was signed off |
| Est. Cost | £2,600 | The revised expectation |
| Actual Cost | £2,780 | What was actually spent |
| Resource Cost | £1,160 | Labour, calculated from Dave and Sam |
Baseline against Actual shows the task ran £380 over, and because the baseline never moved, that overspend stays visible for the life of the project. The £1,160 of labour is a separate figure and is not inside any of the three.
07 Parent tasks roll everything up
Open a summary task and every field on this page is locked, because a parent’s numbers are sums of its children. Edit the child tasks and the parent follows.
- Work on a parent is the total of its children’s Work. Gantt Excel says so if you try to type there:
This is a Parent task. Work is automatically calculated based on child tasks.
- Est. Cost, Baseline Cost and Actual Cost are the totals of the children’s:
This is a parent task. Its costs are calculated from its child tasks.
- Resource Cost is the total of the children’s too, and gets its own wording:
This is a parent task. Its resource cost is calculated from its child tasks.
Type into one of a parent’s cost cells in the grid and Gantt Excel shows that message, then puts the children’s total back in the cell. On the Task Form the four cost boxes are locked.
A parent’s own Resource Cost is never calculated from a resource assigned to the parent. If a summary row has a resource on it, that name is ignored for costing and only the roll-up counts. So put your people on the tasks that do the work, not on the headings above them.
08 The project budget
Everything above is per task. The budget is the project-level pair, and you set it when the chart is created, at Gantt Excel → Gantt Charts → Add New Gantt Chart, in the Budget Details group:
- Estimated Budget — what you expect the whole project to cost.
- Baseline Budget — what was approved.
Both are optional, and to change them later you reopen the project details with Gantt Excel → Gantt Charts → Edit Project. But “optional” looks different in the two places these figures appear. On the form, a budget you never set shows as an empty box. On the budget line below, there is no blank to show, because every figure on that line is formatted as money, so an unset budget reads £0.00, not a gap. If a zero would give the wrong impression to whoever reads the sheet, fill both figures in.
Gantt Excel then keeps a running comparison in the header area above the task list, refreshed every time a cost changes. It reads:
The Project Budget half is what you typed on the new-chart form. The Task Costs half is added up from the tasks themselves, and it totals only the top-level rows, so nothing is double-counted when a parent has already summed its children. The currency symbol comes from Currency Symbol in Settings, and defaults to $.
09 Switching costs on and off
Two tickboxes in Gantt Excel → Settings → Settings control the whole of this page:
- Enable Costs — the master switch. Turn it off and the four money boxes disappear from the Task Form entirely, and the budget line above the task list is cleared, not frozen at its last figures. Tick it back on and the line is rebuilt from the tasks. Work is unaffected; it is a person-time field, not a cost one.
- Calculate Resource Cost — decides whether Gantt Excel prices labour for you. With it off, the Resource Cost column becomes an ordinary number you can type into, 0 included.
The same Settings page is where you set the Currency Symbol used in the budget line. Rates themselves live elsewhere, one per person on the Resources sheet; see the Resources guide.
10 Common questions
Why is my Resource Cost twice what I expected?
My Resource Cost cell is empty. Is something broken?
What is the difference between Work and Duration?
I typed a Work figure, then changed the duration, and my figure was lost. Why?
Does Est. Cost include the Resource Cost?
Why are all the cost fields greyed out on this task?
Related: Resources, calendars & working days · The Task Form · Summary tasks, indenting & the WBS · Settings