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

design of manufacturability  Design for Manufacturability

device  Improve Batch Manufacture

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 recommended services  Recommended Services

remodel contact info

 US Tel  1 877 218 7007
 UK Tel  0871 218 7007 

 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?

No need to tell us who you are to try out a simple 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 provide you with a more complex spreadsheet Model of Capacity, Cost, Inventory and Time.

   capacity planning spreadsheet
There is a book on this and other topics James La Trobe Bateman and client with Bridge of Faith for Operations Book

Buy from Amazon (UK)
Buy from Amazon (US)

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