Others

Create and Compare Resource Capacity Scenarios in Microsoft Project

Khadija KhanKhadija Khan Nov 22, 2026 868 views

Question details

Create and compare project schedules for different resource capacity levels while preserving each scenario's duration, work, and dates.

Create and Compare Resource Capacity Scenarios in Microsoft Project
Product
Microsoft Project
Device & OS
not provided
Scenario
A project manager wants to present schedules based on 20%, 50%, and 100% resource assignment units and retain the scenario management selects.
Observed behavior
Each capacity scenario should have its own saved schedule that can be reopened and compared without relying on multiple baselines.
Before you start

Check that resources are assigned to the relevant tasks and review their calendars and work estimates. Identify which tasks should be automatically scheduled so Project can recalculate their dates and durations.

Solution 1Recommended

Save a separate Microsoft Project file for each capacity scenario

Use separate project files to preserve and compare schedules at 20%, 50%, and 100% assignment units.

Assignment units represent the portion of a resource's capacity assigned to a task. Project recalculates the schedule using task settings, work estimates, calendars, dependencies, and other constraints.

1
Set up the tasks

Open the project and select the relevant tasks in the Gantt Chart. Use Task Information > Advanced to check the task type; choose Fixed Units or Fixed Work as appropriate, and confirm that tasks intended to recalculate are automatically scheduled.

2
Create the 20% scenario

Open View > Task Usage. Insert the Assignment Units column if it is not visible, then set the relevant resource assignment units to 20%. Use File > Save As to save the file with a name such as Project-20-percent.

3
Create the 50% scenario

Choose File > Save As to create a separate copy named Project-50-percent. In View > Task Usage, change the relevant assignment units to 50%, then save the file.

4
Create the 100% scenario

Choose File > Save As again and name the copy Project-100-percent. In Task Usage, change the relevant assignment units to 100%, then save.

5
Compare and select a schedule

Open each saved file and compare task durations, work, start dates, and finish dates in Gantt Chart or Task Usage. Present the results to management, then keep the chosen file and archive or remove the alternatives.

Save a separate Microsoft Project file for each capacity scenario
Check the recalculated values: Review work and duration after changing units, especially for tasks with multiple resources or scheduling constraints. If the 20% schedule is selected, reopen its saved file rather than trying to reverse changes in another scenario.
Free Microsoft Office alternative

Compare Project Scenario Summaries in WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility. Move scenario summary data into a spreadsheet to compare it easily; use Microsoft Project to recalculate the schedules.

Compare scenario dates, durations, and work in a spreadsheetOpen and edit Microsoft Excel XLSX filesUse a familiar interface for an easier transitionWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

How can I return to the 20% schedule after testing other capacities?

Open the separately saved 20% scenario through File > Open. Its saved dates, work, and durations remain available without reversing changes in the other files.

Why didn't changing assignment units update a task's duration?

Check whether the task is manually scheduled in the Gantt Chart, then review Task Information > Advanced for its task type and constraints. Resource calendars, dependencies, and other assignments can also affect the result.

Do I need multiple baselines for these scenarios?

No. Save each scenario as a separate file with File > Save As. Each file retains its own current schedule for comparison.

Does 50% assignment units mean the task will take twice as long?

Not necessarily. Duration also depends on work, task type, other assigned resources, calendars, and constraints. Check the recalculated duration in the scenario file.