Home >    Community    > Forums
Topic Title: How to conduct Capacity Planning
Topic Summary: Capacity Planning in a machine shop
Created On: 11/22/2011 12:10 PM
Linear : Threading
1 2 Next Last unread
Send to a Friend Send to a Friend
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
11/22/2011 04:43 PM
Print this message

Author Icon
JesseStorm
Jesse Rendon



Hi all,

I am looking for a quick an easy way to conduct a capacity study for my machine shop. We just recently purchased two new machines so we can begin to bring manufacturing back in house from offshore. Our current setup consists of 5 lathes three with barfeeders, 2 brand new swiss cnc screw machines, and 2 mills. The goal is to schedule the jobs according to the most efficient machine. Obviously the screw machines would be the way to go but we are limited to just two.

With the new purchase of these machines we are able to strategically pick which components to bring back in house. The problem is we are not sure which ones to bring in and how much. So that is where I need your assistance. I need to know my current capacity and where my max would be. Please help with spreadsheets, calculations, or any methodology that I can apply. Look forward to hearing from you.
11/28/2011 03:42 PM
Print this message

Author Icon
Mike_Thelen
Michael Thelen



I'd always suggest creating a scheduling board on a dry-erase board. Combine that with some observations of cycle time for each machine to build a database of cycle knowledge. You will also want to look at your product mix and how you can streamline. Can you dedicate certain, less efficient machines to certain products to eliminate/significantly reduce setup time? Are some products more complex and therefore are better suited for the newer, 'tighter' machines?

You have two approaches to consider with bringing products back in - high(er) volume or low(er) volume. In other words, which products impact your bottom line more with your equipment. If you excel at low volume, or your equipment makes changeover very simple, you may find that you can maximize revenue on the lower volume work, sending out the higher volume work to someone who will commit resources and can run it cheaper than you. Or, you can choose higher volume, which helps spread your overhead costs (assuming you currently assign costs in traditional standard costing measures per piece). There are numerous variables to consider, one of which is what path your organization wishes to take. What does the company ideal state look like? That will tell you which direction to go.

Learn what your processes can do and how they interract. That is best done through observation and OA analysis of your processes/equipment. Learn how to schedule the machines manually and efficiently before leaping to an automated scheduling system. This will allow you to understand your scheduling process and be able to find an automated system that truly does what you want, only without the waste (so many automated scheduling systems simply automate scheduling waste). There are several scheduling software options out there for jobshops looking at Lean that would be useful - ONCE you understand your system and its needs.
12/08/2011 08:58 PM
Print this message

Author Icon
PrasadVelaga
Prasad Velaga



Originally posted by: JesseStorm

The problem is we are not sure which ones to bring in and how much. So that is where I need your assistance. I need to know my current capacity and where my max would be. Please help with spreadsheets, calculations, or any methodology that I can apply.


Jesse,

It is not easy to measure capacity of a job shop with high-mix, low-volume production. You need a method for fast and efficient what-if analysis of job shop workflow with respect to changes in resource capacities. I can illustrate one of such methods over web if you have routing information for all parts and resource requirements of every operation. The method is based on job shop scheduling logic. Mike Thelen saw the schedule output of this logic 2 or 3 years ago.

Prasad
prasad@optisol.biz
12/09/2011 12:42 PM
Print this message

Author Icon
Larryod
Larry ODonnell



This is a typical 2nd year problem assigned to businesss degree operations management majors in university.
12/09/2011 12:42 PM
Print this message

Author Icon
Mike_Thelen
Michael Thelen



Prasad's software is one of those packages I was referencing. His system, while my employer didn't choose to use it, would have sped up our scheduling process (determined through the trial we ran). We had done a lot of initial work to remove the waste in our old scheduling process, as I hinted at in the above comment (understanding your system and needs). In our jobshop setting, his software would have been able to handle changes in seconds, rather than minutes or hours of work/rework.
12/12/2011 06:00 PM
Print this message

Author Icon
PrasadVelaga
Prasad Velaga



Larry,

Your post really surprises me. In the past, I taught operations management to udergraduates of business school at a well known university in College Station, Texas, following the book on operations management by Jay Heizer and Barry Render. If you have a simple solution to the student-level problem, you can consider offering it (at least offline) to Jesse who seems to seriously need it.
03/09/2012 01:49 PM
Print this message

Author Icon
217023
Devender Mudgal



Please let me know your mail i.d and i will send you the simulation sheet which will help you in maintaining the capacity planning and efficiency control of your process.
04/05/2012 03:07 PM
Print this message

Author Icon
154503
Glen Carnahan



Hi Devender Mudgal,

I have a sheet that I utilize for high volume and have struggled with helping some of my suppliers on a quick and easy way to measure capacity. I'd be curious to see how your sheet matches against mine. Can you share? I'm at glen.carnahan@gmail.com

Attached is the sheet I used about 4 years ago to measure line and station capacity. It is only for 'similar too' models and is not good for mixed/low-volume models.

Many Thanks,

Glen Carnahan

Mod note: edited to attach file


Edited: 04/05/2012 at 03:07 PM by Lean Moderator


06/13/2012 10:36 AM
Print this message

Author Icon
Karabean
Kara Bingham



I would love to see the simulation sheet as well - thanks!

bingh1kl@cmich.edu
08/31/2012 03:11 PM
Print this message

Author Icon
57686
Kapil Dhand



Hi , i would also like a copy of the spread sheet. my mail id is kdhand@micromaticgrinding.com
09/17/2012 11:55 AM
Print this message

Author Icon
57686
Kapil Dhand



Hi Devender,

could you send me the capacity simulation sheet at kdhand@micromaticgrinding.com.
09/18/2012 11:06 AM
Print this message


Alsc
Alessandro Scatoletti



Hi Devender
I would like a copy too. My mail address is a.scatoletti@gmail.com.

Thanks

Alessandro
09/18/2012 03:18 PM
Print this message

Author Icon
leanwannabe
Brian Koenig



My limited experience with custom machining exposed me to the challenge of determining accurate processing times for parts that had never been made before.

While two engineers might agree on what type of machine to process the part through, different programmers could have completely different strategies for how to approach the machining sequencing. Who then is responsible for developing the time estimates for the routings? If programming is not completed until right before the part is machined, how does the organization get accurate time estimates into the system in a timely manner?

When efficiency reports came out and times were slower than the routings, it was generally considered an operator issue not an issue with determining the routing times. Having said that, my best suggestion is spend some time gaining an understanding as to how accurate the routings are and try to put in a system to improve their accuracy over time.

Our second problem was the delay in getting parts designed and loaded into the system so they could be calculated in the capacity calculations. My suggestion was to use "master generic parts" to at least get some information into the loop prior to loading the actual parts.

Timeliness and accuracy of getting information into the system is crucial for capacity planning. I'll let you guys sort out which templates and programs work best.

Good Luck

Brian
09/21/2012 12:22 PM
Print this message

Author Icon
213822
Mike Wiseman



I know there were many requests earlier, but don't see any lately, for the capacity planning sheet. But, I am asking any way. Can I still get a copy? If so, please send it to michael_j_wiseman@ham.honda.com.
10/31/2012 06:21 PM
Print this message

Author Icon
PrasadVelaga
Prasad Velaga



Many people including Jesse Rendon expressed interest to try Devender's simulation tool in Excel for job shop capacity planning. I am still curious to know how the tool is working for them because several job shops are looking for such tool. I did not see any comment on its performance until now. I am not sure that a simple Excel application can help capacity planning in a generic job shop.

Capacity planning is quite tough for small make-to-order job shops with high-mix, low-volume production, particularly when machines are multi-functional and workers have different skill sets. Those job shops want to maximize shop production performance subject to limited resources. For a brief description of job shop capacity planning, one may read our web page, Job Shop Capacity Planning .

Prasad
11/13/2012 12:25 PM
Print this message

Author Icon
mohommedalthaf
mohommed althaf



Hi,

can i have the capacity planning simulation sheet...
mfmalthaf@gmail.com
11/16/2012 12:59 PM
Print this message

Author Icon
JuanMorgan
Juan Morgan



Hi Devender,

Would you please send me the spreadsheets

thanks in advance!

juanimorgan@yahoo.com.ar
11/19/2012 10:54 AM
Print this message

Author Icon
3393
Brian Maskell



Jesse:
We need to differentiate between planning and scheduling. For planning you need to have a straight forward SOFP (Sales, Operations, and Financial Planning) process, and this needs a rather simple capacity analysis tool. Based on forecasts, you calculate the time required to make the forecasted parts. Calculate the "waste" like scrap, rework, downtime, etc. Keep the analysis simple and use no more than 8 or 10 issues.

The day-to-day scheduling is a different matter. If this ia a job-shop operation (ie. you do not know what jobs are coming in until they get them), then the suggestion from the first respondent is good advice. Create a visual board and schedule to maximize the throughput of the entire value stream. The idea of using the most "efficient" machine is a distraction. If the machine that a job would run the fastest is busy, then run it on the machine that's available that will do the job. (in the words of the great philosopher "if you can't be with the one you love, love the one you are with") It is the total throughput of the value stream that matters, not the cost of the individual job.

if you are a genuine job shop and the SOFP process is not too relevant, then you can create a visual master scheduling process. when new jobs come in, schedule them on a board by (for example) the week. Get a rough-cut idea of the capacity vs the load. The detailed daily visual board becomes much easier to do when you have the higher level, summary plan set up in advance.

The visual rough-cut is mostly needed for giving promise dates to your customers. In some companies, the rough cut board is populated by the sale or customer service people.

BTW. These boards are called "yamazumi" in lean parlance. You might want to look on the internet. I would be happy to discuss this more deeply if it will be helpful to you.

Brian
11/19/2012 10:54 AM
Print this message

Author Icon
3393
Brian Maskell



Jesse:
I forgot the other part. You need to decide what's the right parts to bring back.
We do this with a Box Score. The Box Score shows the performance of the plant or the value stream at three levels; Operation Performance, Capacity usage, and Financial Results. We would then look at various scenarios, plug them into the box score, and to see how we can maximize the throughput - Revenue minus Direct Costs. Direct Costs are mostly materials. We would consider labor to be largely fixed costs, give or take a little overtime. And we would not be interested in applying overheads and all that nonsense.
Brian
bmaskell@maskell.com
11/19/2012 03:04 PM
Print this message

Author Icon
PrasadVelaga
Prasad Velaga



Originally posted by: Brian Maskell

The day-to-day scheduling is a different matter. If this ia a job-shop operation, ...create a visual board and schedule to maximize the throughput of the entire value stream.


Brian,

If production scheduling in job shops is so easy, then job shops all over the world must be maximizing shop throughput with the help of visual boards.

Prasad
Optisol
FORUMS : Supply Chain : How to conduct Capacity Planning

1 2 Next Last unread
Topic Tools Topic Tools
Note: These forums are moderated by the Lean Enterprise Institute. All posts are reviewed prior to appearing on the site. Views expressed in these forums do not necessarily represent the views of the Lean Enterprise Institute.