Create and Compare Resource Capacity Scenarios in Microsoft Project
Question details
Create and compare project schedules for different resource capacity levels while preserving each scenario's duration, work, and dates.

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

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.

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.




