Home
Our Product Shopfloor123
Scheduler123
Production Schedule
Production Templates
Buy Now!
Production Planning Template Work Order Tracking
Work Order Form
Master Schedule
Rough-Cut Capacity
Production Sch v.1
Inventory Reordering
Inventory Status
ABC Analysis Report
Project Status Report
Workforce Analysis
Report Template
Manufacturing ERP Software Reviews Manufacturing Software
Scheduling Software
10 Steps Selecting SW
Job Shop Software Review Job Shop Software
ECi M1
Exact jobBOSS
ShopVue
Epicor Express(Saas)
MISys Manufacturing
Small Manufacturing Software Review SAP Business One
Dynamics NAV
Sage ERP MAS 500
Intuitive ERP
Mid-sized Manufacturing Software Review Dynamics AX
SAP All in One
Lawson M3 ERP
Process Manufacturing Software Review IFS Batch Mfg
Infor Process Mfg
BatchMaster ERP
ProcessPro Premier
DEACOM ERP
Dynamics AX-Process
Construction / Project Software Review Dynamics SL - Project
Sage Project Lifecycle
Get Free Demo Microsoft Dynamics
Free Yourself Work from Home Job
More Fun At Work
Terms of Use Privacy Policy
Disclaimer
Disclosure
Contact Us
About Us
Your Story!
 


"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

Rough Cut Capacity Planning Template

Member of Basic Production Templates Pack

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.

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 effiency of each resource group in each month.

Worksheet#2 [Demand & Assign Resource]

Step 6 - Input demand and assign to the desired resouce 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 effeciency 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 Pack



Web Application Launching Now!

work order tracking software

ShopFloor123
Work Order Tracking System




Shopfloor123
Web-based Work Order Tracking System Software
Free Demo!