How to Schedule Project Resources with a 40-Hour Weekly Minimum in MS Project
Question details
The user needs to schedule 15 resources in teams to maintain a 40-hour weekly minimum while balancing predecessors, utilization, and fixed costs.

- Product
- Microsoft Project
- Device & OS
- not provided
- Scenario
- Assigning 15 individual resources (such as electricians and helpers) to tasks on a fixed-cost project with the goal of eliminating wasted capacity.
- Observed behavior
- Microsoft Project fails to automatically optimize both resource utilization (40-hour minimum) and fixed costs simultaneously, focusing instead on time and schedule optimization.
Ensure all your resources are accurately entered into the Resource Sheet with their correct base calendars, standard rates, and maximum capacities before attempting to level.
Use Resource Leveling with Manual Adjustments
Since Microsoft Project cannot perfectly optimize resource utilization and costs simultaneously, you must set accurate parameters and manually refine the automated leveling results.
Microsoft Project's scheduling engine primarily calculates the shortest possible project duration based on dependencies, rather than strict cost control or eliminating spare capacity. Automatic resource leveling will resolve overallocations but cannot automatically guarantee a minimum weekly hour requirement without manual intervention.
Go to the 'Project' tab, click 'Change Working Time', and ensure your project calendar and individual resource calendars reflect a standard 40-hour work week.
In the Resource Sheet, categorize your 15 resources individually (e.g., Elec01, Elec02) and use the 'Group' column to identify their specific team structure to track capacity.
Navigate to the Gantt Chart, select a task, click 'Assign Resources' under the 'Resource' tab, and allocate the required team members.
Go to the 'Resource' tab and click 'Leveling Options'. Set it to look for overallocations on a 'Week by Week' basis, then click 'Level All' to resolve scheduling conflicts.
Open the 'Resource Usage' view and adjust the timescale to 'Weeks'. Inspect the hours for each resource and manually reassign tasks or adjust durations to fill in gaps where resources fall below the 40-hour minimum.

Manage Project Schedules and Resources with WPS Office
If Microsoft Project's automated leveling engine doesn't meet your fixed-cost optimization needs, consider tracking your resources manually using powerful spreadsheet templates. WPS Spreadsheets offers a free, lightweight, and fully compatible alternative to Microsoft Excel, perfect for building custom project tracking dashboards.
- 1. Download and install WPS Office: Visit the official WPS Office website to download the free suite and install it on your device.
- 2. Open a project management template: Launch WPS Spreadsheets, go to the 'Templates' section, and search for 'Project Management' or 'Gantt Chart' to find a suitable layout.
- 3. Customize your resource tracking: Input your 15 resources and use spreadsheet formulas to strictly monitor 40-hour minimums and fixed costs.

Frequently Asked Questions
Why doesn't Microsoft Project optimize my fixed project costs automatically?
Microsoft Project's scheduling engine is designed to calculate the shortest possible project duration based on task dependencies and resource constraints. It does not natively optimize financial fixed costs or guarantee minimum weekly hours for resources.
How can I check if a resource is working less than 40 hours a week?
Switch to the 'Resource Usage' view in MS Project. Right-click the timescale on the right pane, set it to 'Weeks', and you will be able to see the exact number of hours scheduled for each resource per week.
Can I set a minimum hour requirement for a resource in MS Project?
No, MS Project does not have a native feature to enforce a strict minimum weekly hour requirement. You can set a maximum capacity (Max Units) to prevent overallocations, but fixing underallocations requires manual schedule adjustments.
What is the best way to handle teams of resources in MS Project?
Instead of creating one single consolidated resource for a team, list them individually (e.g., Elec01, Elec02) in the Resource Sheet and use the 'Group' column to identify their team. This allows for more precise tracking of individual schedules and costs.




