Quantcast
manufacturing capacity planning spreadsheet
 Established 1997   
remodel site map
healthcare  Home

design of manufacturability  Design for Manufacturability

medical device  Operations Improvement

batch production manufacturing capacity planning spreadsheet  Capacity Planning

Bridge of Faith for Operations book  Book - 'Bridge of Faith for Ops'

feasibility market study  Market Feasibility

bi reporting  Businesss Intelligence

healthcare manufacturing  Seminars

models of change for business  Company History

healthcare manufacturing links

diagnostics manufacturing  'The Management Team' Cartoons

medical device manufacturing  Healthcare Manufacturing Articles

medical manufacturing  Healthcare Manufacturing Blog

medical manufacturing recommended services  Recommended Services

remodel contact info

 US Tel  1 877 218 7007
 UK Tel  0871 218 7007 

click-to-call from the web

 Email info@remodel.co.uk

  capacity planning spreadsheet
Our way to calculate Capacity Utilization for batch manufacture.
    5 Parameters to Assess the Workload
  1. Sales Volume
  2. Quantity of the item per unit of sale
  3. Run waste %
  4. Fixed Waste each Batch
  5. Batch Size or Batch Frequency

    7 Parameters to Describe the Workcenter
  1. Run rate in Items per Minute
  2. Changeover Time
  3. Shift or Working Spell Length
  4. Number of Shifts/Spells per Week
  5. Number of Lines
  6. Hours per Week that the line is not Available
  7. Can you stop the batch part finished overnight?

You do not have to tell us who you are to try out a single task working spreadsheet for yourself. See how these parameters affect capacity in batch manufacturing. It looks like this:

batch manufacturing capacity planning spreadsheet

Contact us to teach you how to do this in more depth.

Or try a more complex spreadsheet Model of Capacity, Cost, Inventory and Time by filling in the form:



Complete details for download:
Your name:  
E-mail address:  

Privacy Policy
  capacity planning spreadsheet
 Please email us: info@remodel.co.uk

©1997-2008 reModel Consultants International Ltd - All rights reserved worldwide.