PRODUCTION PLANNING / SFR
MCA Capacity Overview
Review production load, plan capacity and identify overloaded work centers
● Machine Loading & Capacity | SFR EXCEL SNAPSHOTMCA / BTA / CLA Excel snapshots · Updated 08 Oct 2026 • No live system connection
—
Source records—
hours—
Configure capacity to evaluate overloadLoad by work center
Setup and operate hours for the selected records
Operate Setup
MCA — Load vs. Available Capacity
Red bars indicate an overloaded work center · Dashed line: Available Capacity (machine hours) · Click a period to view its orders
● Load ● Work center overload ┄ Available Capacity
Applied capacity settings · Used by both charts
| Work Center | Machines | Hours/day | Efficiency | Working days | Hours/machine/period | Available hours/period |
|---|
MCA — Available vs. Required Machines
Uses the main Work Center filter · Required — filtered load by month / ISO week · Click a period to view filtered orders
● Required — filtered load ● Machine shortage ┄ Available machines
Load & Capacity Details
| Period | Date range | Load (h) | Available (h) | Load % | Remaining (h) | Overloaded work centers |
|---|
Both charts, period tables and order details use the same active Department, Work Center, FG, Product group, Status and First Date filters. Capacity is shared physical capacity, not reserved for the filtered orders. Undated orders remain in order details but are excluded from period charts. Load is grouped by the First Date in Excel, not by a confirmed production schedule. Aggregate capacity is not transferable between work centers; review per-center overloads.
Machine Requirements by Work Center
| Period | Work Center | Available machines | Selected load (h) | Equivalent machines | Required — filtered load | Shortage — filtered load |
|---|
Work center capacity
Daily/monthly capacity and overloaded period counts for the selected view
Review the configured capacity assumptions before evaluating overload
| Work Center | Records | Load (h) | Available / day (h) | Available / month (h) | Peak period load % | Overloaded periods |
|---|
Available/day = Machines × Hours/day × Efficiency · Available/month = Available/day × Days/month · Load is not transferred between work centers
Order–operation details
Work center details only. No Machine No is provided, so individual machine bottlenecks cannot be identified
Data check: Setup + Operate = Total for every row • 2 duplicate Order–Oper entries in the source; all records retained to match the original file
| Order — Oper | Work Center | FG Material Code | First Date | Product | Status | Setup (min) | Operate (min) | Total (h) |
|---|