Excel-based Production Scheduling System Free Download

Rough Cut Capacity Planning Template

Member of Basic Production Templates Pack


"Very accurate and easy to use tool.
I would recommend it to any shop scheduler."
Rene Gonzalez, Mexico

feedback on Aug 25, 2011 downloaded in Feb 2011
Template: rough-cut capacity planning template

Version: 1.1.0

Benefits:

Rough Cut Capacity Planning (RCCP) Template help you to early involve in potential capacity issues and try to find any solutions to fix them before they happen!

capacity planning template

Easy to simulate and re-assign demand from overloaded resource to another one with graphical information. Using Pivot Table feature, we can have multi-dimensional charts such as chart by whole company, by plant, or by reource group.

Depend on your manufacturing environment, but this Rough Cut Capacity template is developed using monthly basis with 3-month demand time fence.

we recommend to select on only Bottleneck work centers to do it or may apply Theory of Constrains (TOC) to manage them.

Return from Rough-cut Capacity Planning Template to Basic Production Templates Pack


How to Use:

This Excel template has 6 worksheets:

  • Set Up Capacity
  • Demand & Assign Resource
  • Chart-1
  • Chart-2
  • Chart-3
  • Chart-4


Worksheet#1 [Set Up Capacity]

Step 1
- Define Resource Group Name.
Step 2 - Define Plant Name.
Step 3 - Define Month Name.
Step 4 - Define number of working day and number of hours per day of each month.
Step 5 - Define number of machine and % machine efficiency of each resource group in each month.

Worksheet#2 [Demand & Assign Resource]

Step 6 - Input demand and assign to the desired resource group. Four fields required are month, customer name or product group, resource to be assigned, net hour required.


Worksheet#3-6 [Chart 1 - Chart 4]

Step 7 - View four graphical information which comparing between capacity and demand of resources in 4 dimensions.
Step 8 - If find that some resources have overloaded, we can reassign to other resource by go back to adust in Step 7, or if we can add overtime or improve machine efficiency or add more machines please go back to adjust them in Step 4 and Step 5.
Step 9 - Enjoy your simulated capacity plan and print out to review with your boss.

Return from Rough-cut Capacity Planning Template to Basic Production Templates Pack

Advanced Production Scheduling Template

Automated Production Scheduling Tool


Suggested ERP software by Sector

Free Pricing & Demo 

Aerospace & Defense , Automotive, Chemicals, Construction / Project, Consumer Products, Distribution, Electronics, Engineer-to-Order, Food & Beverage, High Technology, Industrial Machinery, Job Shop / Machine Shop, Made-to-Order(Small), (Mid-sized), Metal Fabrication, Paper & Packaging, Pharmaceuticals, Process / Batch Manufacturing, Retail, Semiconductors, Wire & Cable