Documentation / Resources & cost / Work, costs & budget

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:

ColumnWhat it holdsWho fills it in
WorkHow much person-time the task needsCalculated from the duration and each person’s allocation
Resource CostThe labour cost of the people assignedCalculated, unless you switch that off
Est. CostWhat you expect the task to costYou
Baseline CostThe cost you signed up to when the plan was agreedYou
Actual CostWhat it really costYou

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.

A task grid showing the Task and Resource columns followed by Resource Cost, Work, % Complete, Baseline Cost, Est. Cost and Actual Cost, with figures filled in on every task row.
The five money-and-work columns. On a default chart they are not next to each other; this shot has the columns in between switched off so they can be seen at once.

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:

Work  =  Estimated Duration  ×  the people’s allocations added together ÷ 100

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:

ResourceTradeCost per Day
Dave NolanFitter£280
Sam ReddyPlumber£300
Maria FerreiraElectrician£320
Ana SilvaDecorator£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.

The Task Form's Task Details tab, showing the Work box, the Resources picker and the Costs group with its Estimated, Baseline and Actual boxes.
  1. Work. Planned work for the task, in person-days, or person-hours on an hourly chart.
  2. 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.
  3. 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.
  4. Resource Cost. The calculated labour cost. Typing here does nothing useful, because the calculation overwrites it.
  5. Costs. A group heading over all four money boxes, not a field in its own right.
  6. Estimated, Baseline and Actual. The three cost bands, all of them yours to fill in.
Hover or tap a numbered pin to see what each part of the Work and Costs area does.

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 WorkWhat Gantt Excel says
Text, or a negative numberWork must be a number, 0 or more.
A figure on a task with nobody on itPut someone on this task before typing its Work. Work is shared between the people on a task.
Anything but 0 on a milestoneA 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 taskThis 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:

WhenWhat Gantt Excel says
Work typed on a finished taskThis task is finished, so its Work can no longer change its duration.
Work typed as 0Work 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:

Resource Cost  =  for each person:  rate  ×  Estimated Duration  ×  allocation ÷ 100,  added together

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:

EVERYONE AT 100%

“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.

BOTH AT 50%

“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.

ESTIMATED

“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.

BASELINE

“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.

ACTUAL

“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.

BandFigureWhat it tells you
Baseline Cost£2,400The cost that was signed off
Est. Cost£2,600The revised expectation
Actual Cost£2,780What was actually spent
Resource Cost£1,160Labour, 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:

Project Budget: Estimated: £24,000.00 | Baseline: £22,500.00 | Task Costs: Estimated: £23,410.00 | Baseline: £22,180.00 | Actual: £9,640.00

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 $.

The budget summary line in the header area above the task list, showing Project Budget and Task Costs with their currency figures.
The budget line compares what you promised with what the tasks now add up 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.

The Costs group in Settings, with Enable Costs and Calculate Resource Cost both ticked and the Currency Symbol picker beside them.
Two tickboxes decide whether costs appear at all, and whether labour is priced for you.

10 Common questions

Why is my Resource Cost twice what I expected?
Because the rates of everyone assigned are added together, then multiplied by the time each person spends. Two people at £280 and £300 a day cost £580 a day between them, not £290. (On an hourly chart the same arithmetic runs on Cost Per Hour instead.) If they are not both on the task full-time, give each one a lower percentage in the Select Resources picker, or type the real person-time into Work, and the cost drops to match. See section 05.
My Resource Cost cell is empty. Is something broken?
Almost certainly not. It is left blank on purpose when no resource is assigned, when the only resource is Organization, when the assigned people have no rate set on the Resources sheet or are all at 0%, when the row is a summary task waiting on its roll-up, and on a milestone, which has no duration to price, so a fully-costed resource on one still shows nothing. Check the Resource cell first, then the rates.
What is the difference between Work and Duration?
Duration is calendar time: how long the task occupies the chart. Work is person-time: how much of it the task consumes. A 4-day task with two people on it full-time has a duration of 4 and Work of 8. On a chart whose task length comes from Duration (the default), only Duration affects the schedule and typing Work never moves a bar. Switch the chart to Work in Settings and it is the other way round: typing Work, or adding someone, sets the duration. See section 04.
I typed a Work figure, then changed the duration, and my figure was lost. Why?
A typed Work figure is not kept as it stands. Gantt Excel turns it into percentages for the people on the task (the Allocation column shows them), and Work is then worked out from those percentages and the duration. Lengthen the task and Work grows with it, because the people are still on it for the same share of their time. To put everyone back to 100%, clear the Work cell. See section 03.
Does Est. Cost include the Resource Cost?
No. They are independent, and nothing adds one into the other. Resource Cost is calculated labour; Est. Cost is whatever you type. If you want one number covering both, add the labour figure into your estimate yourself. The project budget line totals only the three cost bands, so labour is left out of that comparison too.
Why are all the cost fields greyed out on this task?
You have opened a parent (summary) task. Its Work and all four cost figures are totalled from the child tasks underneath it, so they are locked here. Edit the children and the parent updates itself. If the boxes have vanished rather than greyed out, Enable Costs is switched off in Settings.

Related: Resources, calendars & working days · The Task Form · Summary tasks, indenting & the WBS · Settings

From the makers of Gantt Excel Rather not work in Excel? See Desktop Plan, our project planning software for Windows and Mac