Capacity Load Analysis (Multi-Sheet)

Capacity Load Analysis

Resource Planning with Separate Capacity Master Sheet

Plan Month

Work Center

Customer

Load Status

Import Excel (2 Sheets)

Search (Job, Item)

Total Utilization %

0%

Load / Capacity

Available Capacity

0 Hrs

Sum from Sheet 2

Required Load

0 Hrs

Sum from Sheet 1

Balance (Gap)

0 Hrs

Avail - Load

Monthly Capacity vs Load (Hours)

Work Center Utilization

Job Loading Detail

Plan Date	Work Center	Job No.	Customer	Item No	Item Name	Qty	Std(Hr)	Load(Hr)	Cap(Hr)

Total Records: 0