Network Work Resource Summary

A new home for the Coupa Supply Chain documentation

Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).

You can access new and updated Supply Chain documentation in the following location on Compass:

https://compass.coupa.com/en-us/products/supply-chain-design-and-planning

Network Work Resource Summary

Internal Table Name: OptimizationOutputWorkResourceSummary

The work resource summary table summarizes utilization and cost of work resources, and also suggests an optimal number of work resources.

Scenario

Table: OptimizationOutputWorkResourceSummary

Internal Name: Not Applicable (Scenario column not in table)

The scenario for which the summary data was generated.

Name

Table: OptimizationOutputWorkResourceSummary

Internal Name: WorkResourceName

The name of the work resource.

Max Units

Table: OptimizationOutputWorkResourceSummary

Internal Name: WorkResourceMaxUnits

The upper bound, or maximum number, of work resources available in the network.

Site Name

Table: OptimizationOutputWorkResourceSummary

Internal Name: SiteName

The site where the work resource is based.

Period Name

Table: OptimizationOutputWorkResourceSummary

Internal Name: PeriodName

The name of the period to which these work resource statistics apply.

Organization Name

Table: OptimizationOutputWorkResourceSummary

Internal Name: OrganizationName

The Organization to which the work resource is allocated. When the work resource is associated with Sites that belong to the Organization, the work resource is attributed to the Organization as required.

Optimized Units

Table: OptimizationOutputWorkResourceSummary

Internal Name: WorkResourceOptimizedUnits

The number of work resources required by the optimized model.

Utilization

Table: OptimizationOutputWorkResourceSummary

Internal Name: WorkResourceUtilization

Network Optimization calculates the Utilization as:

Optimized Units / Max Units

This is to approximate the proportion of time this work resource is being used, when compared to the total time the resource is available during this period.

If you do not specify Unit Fixed Cost on Work Resources, the optimized number of units will always equal the number of Units set on the Work Resources input table. The Work Resources Utilization in the Work Resources Summary optimization output table will therefore be reported as 1 (fully utilized).

Fixed Cost

Table: OptimizationOutputWorkResourceSummary

Internal Name: WorkResourceFixedCost

The total fixed costs for using this work resource during this period.

Fixed Cost = work resource optimized units * asset fixed cost defined in Work Resources

Variable Cost

Table: OptimizationOutputWorkResourceSummary

Internal Name: WorkResourceVariableCost

The costs attributed to hourly usage of the work resource. This is calculated by taking the number of hours and multiplying by the hourly cost capacity (as defined in work resources).

Variable Cost = Hours x Hourly Cost (as in Work Resources).

Remaining Units

Table: OptimizationOutputWorkResourceSummary

Internal Name: WorkResourceRemainingUnits

The portion of the Max Units minus Optimized Units.

Period No

Table: OptimizationOutputWorkResourceSummary

Internal Name: PeriodNo

The sequence number for the period. This value is useful in sorting periods sequentially rather than by name.

Scenario ID

Table: OptimizationOutputWorkResourceSummary

Internal Name: ScenarioID

The identifier of the scenario for which the summary data was generated.

Sub-Scenario ID

Table: OptimizationOutputWorkResourceSummary

Internal Name: StepNumber

The identifier of the sub-scenario, if applicable, for which the summary data was generated.

Last modified: Wednesday May 15, 2024

Is this useful?

Yes No