This document is intended for authorized Exepron Account Uses only and cannot be distributed or reproduced without the written consent of Dux Global, Inc. and Exepron. ©Copyright Exepron. All Rights Reserved.

Portfolio Master Scheduler “What-If” Procedure: Resource Loading Review and Delivery Date Adjustment using Resource Loading as a guide.

Purpose:
Conduct a ‘What-If’ analysis in moving Projects earlier in time and assess the impact on resource loading using Exepron’s unique Portfolio Master Scheduler.

Option One: Monitoring the Portfolio Master Scheduler Resource Loading Chart manually #

Manually slide the Projects to the left on the calendar and consider the impact on Resource Loading (RL).

  1. Run the Portfolio Master Scheduler and observe the Resource Loading Chart.
  2. Click “Resource Loading Type” to display the total RL of each Resource Type (RT). Example: ‘Steel Team’
  3. Click and drag the project needing an earlier Due Date to the left on the Portfolio Master Schedule calendar.
  4. Review the impact on Resource Loading by observing the Resource Loading Chart.

 

Option Two:  Adding Resource Types in Settings.     #

  1. Start by running the Portfolio Master Scheduler utility.

Review the Resource Type (RT) Loading table within the Portfolio Master Scheduler, focusing initially on the (RT) with the highest load. Ensure that the RT is associated with the specific project under consideration.

  1. In the Portfolio Master Scheduler utility, navigate to the Settings menu.

            Add one or two RTs you plan to simulate for the “What If” scenario.

            Ensure that the RTs you add for the “What If” scenario can be quickly elevated in capacity by trained and are available for re-allocation (e.g., the RT is not already overcommitted or unavailable due to other projects).
Overtime, outsourcing, or even investment in new technology is also a consideration for elevating RT capacity.

            Confirm that the selected RTs are allocated to the project you intend to shift to an earlier Due Date.

  1. Return to the previous page within the Portfolio Master Scheduler utility.

            Re-run the Portfolio Master Scheduler utility to simulate the resource allocation with the newly added RTs.

Check that your Project requiring an earlier date is now acceptably positioned in the Portfolio Master Scheduler Calendar.

            After the simulation, recheck the Resource Loading table to assess the impact of the adjustments.

            Evaluate whether the modifications have improved the resource allocation for the target project.

Option three: Freezing less urgent Projects. #

If necessary, consider freezing a few existing projects to release RTs for assignment to the new project. Implement the freeze action only if it aligns with the resource allocation strategy for the new project.

Here is a procedure to consider when Fereezing Projects to free up capacity.

Which Project Should We Freeze?

Evaluate all Projects by Business Decision Criteria:

• Customer Importance:
Opportunity Size, Future Business Potential, Relationship…
• Project Contribution Value:
ROIt  , ∆  Cashflow, ∆ Gross Margin / ∆ Operating Expense…
• Risk Evaluation:
Opportunity Cost, Credit Risk, Future Business…
• Strategic Alignment:
Desirable Markets, Product & Service Market Compatibility, Additional Value Potential…
•Remove Unnecessary Features from Project:

Rank each Started project inflow and each Project in the Pipeline according to the above criteria. Prioritize and run the Portfolio Master Scheduler and check the Resource Loading and Due Dates.

Consider utilizing the Under-Stressed Resource to assist the Over-Stressed Resources on the remaining Projects.

After Freezing the lower-priority Projects Utilize the Under-Stressed Resources to:

1. Assist the Over-Stressed Resources.
2. Expedite Full Kitting on higher Priority Projects, then the next level of priority Projects.
3. Periodically, when adding new projects or orders, begin Running and relying on the Portfolio Master Scheduler once the portfolio significantly reduces the overall average Project Lead Times.

Moving future Projects in the Portfolio Master Scheduler after ACCEPTING the Portfolio Master Scheduler. #

1. In the Portfolio Dashboard, select the Projects that must move.
2. Change the selected project(s) status from Pipeline (D) —> Accepted —> Pipeline.
3. Rerun the Portfolio Master Scheduler.
4. Before Accepting the final Master Schedule, slide the selected projects left or right on the calendar.
5. Consider the Resource Chart load and move the Projects to minimize the impact of overloaded resources.
What are your Thoughts?
Updated on February 12, 2024