Calculating ROI in the Machine Shop! CB55

  Рет қаралды 24,180

NYC CNC

NYC CNC

7 жыл бұрын

Let's talk about what Return On Investment or ROI is in the machine shop and how it can help evaluate buying a new CNC machine or even bidding on a job!
This video is also a basic intro to using Excel (or Google Sheets) in the machine shop!
ROI Spreadsheet: bit.ly/2sLcx1z
Three versions of "Excel"
1) Google Sheets: bit.ly/2sRrj25
2) OpenOffice (Free): bit.ly/2tlT6uV
3) MS Office: bit.ly/2suFsTf 5 Reasons to Use a Fixture Plate on Your CNC Machine: bit.ly/3sNA4uH

Пікірлер: 67
@HandsonCNC
@HandsonCNC 7 жыл бұрын
Great little chip-break :-).. I came for the machining.. I stayed for the small business coaching :-)
@PracticalRenaissance
@PracticalRenaissance 7 жыл бұрын
That twitch that my eyebrow did during my managerial accounting class just came back...😂 Fantastic lesson, John, you're absolutely killing it with what you are providing as far as education to prospective entrepreneurs!
@P8ntbaLLA56
@P8ntbaLLA56 7 жыл бұрын
I took an entire course on this subject in college, you're spot on. You could get crazier with it and include interest and machine payments ect.
@Southardknives
@Southardknives 7 жыл бұрын
Great CB John! Lots of small business owners dont calculate this kinda stuff ahead of time. Its also one of the reasons I keep buying used Machines (although shopping very carefully is important)
@kchigley5309
@kchigley5309 7 жыл бұрын
80% spindle time is VERY ambitious and 90% is unicorn territory. My cell is sitting at 50% right now. Super long cycle times with low changeover time will get you there or pallet changing can do it as well. Setup, changeover and unexpected issues will kill your spindle on time. This is something I've been trying to explain at work...cycle efficiency is FAR more important than spindle on time. If your cycle is 1 minute and it takes 1 minute between cycles to changeover, your spindle on time is 50% (well not exactly...your cycle start time is 50%, spindle time is lower due to tool changes). If you reduce your cycle time by half to 30 seconds but your changeover still takes 1 minute, your spindle on time is reduced to 33%, but your productivity increased by 25%. If your cycle time stays the same, but you find a way to reduce your changeover time by half to 30 seconds, you get a better looking spindle on time of 66%, but end up with the exact same productivity gain of 25%. My point is, stop using spindle on time as a metric and instead use overall productivity...aka number of widgets per unit of time. I've said this before, but 9 seconds of reduced cycle time on a 100 units per day schedule is equal to 1.625 WEEKS of extra production per year.
@chiefmachining7972
@chiefmachining7972 7 жыл бұрын
Kenneth Higley pretty easy to hit 90% on horizontal
@kchigley5309
@kchigley5309 7 жыл бұрын
If it's a pallet changing horizontal...then sure (you're not gonna hit 90% on something like a Haas EC1600 anymore than you would a VMC unless you have long cycles with short changeovers). Of course, that is, as long as you don't have to do setups often or you have dedicated pallets. I've been working on a proposal for work to replace a 1998 Mori F-M2 with either a pallet changing VMC (Mazak 530 TT) or HMC. We don't do super long production runs, but I think we could make the HMC worth it by putting 4 different fixtures per tombstone for our most common recurring jobs. That way, rather than tearing down a fixture and setting up a new one, we just rotate the tombstone, change the offsets, load the program and get to work. Would kill 2 birds with 1 stone: greatly reduced setup time and reduced to zero down time during part change. Also the Mori is worn out, slow and lacking in technology. Things like thru tool coolant, a control that can look ahead etc could help reduce cycle times. I have 1 particular recurring part that takes 3 days to fill the order. I think I could cut that to 6-8 hours on an HMC. But it's a mighty steep initial investment between the machine, tooling, fixtures and such.
@chiefmachining7972
@chiefmachining7972 7 жыл бұрын
Kenneth Higley I priced a hmc cell out for a company and the machine was thing but after adding designing the fixtures making them proving them out talking huge investment like you mentioned. What hmc are you guys looking at?
@kchigley5309
@kchigley5309 7 жыл бұрын
I have to look through our prints to figure out the largest part we make, but the thought is something like a Mazak HCN-4000 or 5000 (or the Universal line which I think is made in Kentucky), or a Hurco HMX400i/500i. I like those 2 because we do 100% at the control programming. You can only get so far and fast with Fanuc based canned cycles from the 80s. We recently got in 2 Mazak lathes from another division so may as well build upon that. Before that it was all Haas and Mori. I suppose the DMG Mori NHX line with the Siemens integrated Celos control could also be an option to look at. IT honestly doesn't mattter...we could make anything of the right size and capability work, but if we're dropping big money, might as well get the most out of it.
@chrisrokz9005
@chrisrokz9005 7 жыл бұрын
Kenneth I think you have made an excellent post. I greatly agree and have worked at several shops chasing spindle time: Only to completely loose sight of handling time, hand / bench working, reworking, and the never ending list continues. . . .
@victormcqueen2715
@victormcqueen2715 7 жыл бұрын
thanks John. I appreciate very much all these tidbits of behind the scenes stuff. So many times we can see the pie in the sky but not realize it is a seagull until the poop hits us. haha. your eager willingness to help us with all aspects of being successful in our endeavors is refreshing. Not just machining, not just cad and tool paths , but hints on pricing jobs and now on true (approximated) cost of ownership and ROI. Awesome
7 жыл бұрын
Priceless ! Thanks a lot and please, for all of us pro CNCers wannabe, a series on these business critical, decision helping, management monitoring concepts/values would be another great contribution of yours...
@PiersonWorkholding
@PiersonWorkholding 7 жыл бұрын
Great walkthrough John! I like that you kept the factors simple and didn't get into section 179, financing, etc. I bet 50% of owners never look at their shops this way and 100% of FORMER owners definitely didn't.
@patrickmcclintock7027
@patrickmcclintock7027 7 жыл бұрын
YES... wonderful. I wish I could show this to the folks who own where I work. If you "wing it" all the time, without seeing numbers like this, eventually it catches up to you, even if you've done it that way 30 years! Awesome, John. Way to go on the VF2, too. ;)
@alexkern9134
@alexkern9134 7 жыл бұрын
Hey John, I love these videos man. Between the business/ shop improvement videos and your excellent shop tour videos, i get so much inspiration and motivation to continue down the Agile/Lean path in our custom instrument cell. Thanks as always.
@Joshsucks69
@Joshsucks69 7 жыл бұрын
Great stuff as usual John!
@bcbloc02
@bcbloc02 7 жыл бұрын
I would think 80% spindle time seems lofty unless you have huge runs of the same component. I see many machines in auctions that are below 50% spindle to run hours. In my work I do a lot of my jobs that are 4hours of setup for 30minutes of cut time.
@jjcc8379
@jjcc8379 7 жыл бұрын
Another tweak that improves the ROI is trying to spread in time the payments/costs and try to get your income $ the earliest. Of course financing has a cost and most of the times it's own interest, but always remember that money was more valuable in the past (in an inflationary economy). That might not work if you opt for second hand/third hand investments (a single payment is preferred), but it's an option to consider. And with newer machines entering the market and people selling their old ones yours loses resell value. More competition means you might need to drop the prices for a piece over time. TLDR: Earn that income dollar earliest, consider spreading expenses, and build a brand/good reputation early as possible. Good video! Very nice comments at the end.
@philhawtin5269
@philhawtin5269 7 жыл бұрын
Thanks for going through all this. Im hoping in the next few years ill be able to start my own shop.
@MrJugsstein
@MrJugsstein 7 жыл бұрын
nice bussiness thought planning video. I know you were keeping it simple but I think adding a cost of loan to buy machine line would be very informative for a lot of the boot strappers who may not have 100% of the cash up front good video.
@MaxWattage
@MaxWattage 7 жыл бұрын
This was very helpful. I had been hoping you would do some videos on this exact topic. Getting the numbers right is just as important as having the machining skills, when it comes to starting a successful CNC business.
@SpencerWebb
@SpencerWebb 7 жыл бұрын
Excellent presentation!
@andywalser2343
@andywalser2343 7 жыл бұрын
excellent tool!! thanks John!
@MachinistDom
@MachinistDom 2 жыл бұрын
Thanks John, just used this to help calculate a charge out rate for a new machine I just purchased.
@sebastienbily2331
@sebastienbily2331 7 жыл бұрын
This is a very good introduction to ROI. The thinking is good and logic but to people owning a small business that would implement that kind of analysis you have to know : - as all budgeting or forecast tools this heavily relies on the quality of the assumption. You cannot pull the variables out of the blue : be wrong on occupation rate (spindle time + work readying phase), the direct cost of operating (personnal, utilities and maintenance and repair) or the end selling price and you will be in a world of hurt when comparing at the end. So before hand one has to transform the guesses into estimation through sampling or financial controlling. It is not very complicated, may delay a bit the underlying acquisition but as machinist you know the value of accuracy. - This only compounds direct costs. Ideally one should be able to apply some of the structural costs into the matter : back office, leases, tax... It is the money maker and will also have to pay for all that is not getting cash in directly. I cannot stress out how much this is overlooked with people thinking they have positive ROI on all their equipment to only realize that they have not thought about other expenses when setting their sale prices (which obviously is one goal of that exercise). I could go on and on into controlling but I think we do not need to get into discounted cash flows or KPI until John does (and he is so close, at least for KPI).
@jimnnobody
@jimnnobody 7 жыл бұрын
Good stuff. You kept it very understandable.
@rlockwood2
@rlockwood2 7 жыл бұрын
"% of time you have work ready for the machine" and "efficiency" are often at odds to each other as well.. A few machines hitting high efficiency tends to run you out of stuff fairly quickly. Among the more difficult things to nail is scaling all of your various bottlenecks accordingly!
@rlockwood2
@rlockwood2 7 жыл бұрын
NYC CNC nope, I'm not much for book learnin', probably should do some of that! :)
@alexkern9134
@alexkern9134 7 жыл бұрын
rob lockwood My old man keeps telling me to read The Goal. I think it is time.
@benchwerx8649
@benchwerx8649 7 жыл бұрын
Don't forget ROI on smaller things like specialized tooling. A good example is your (John's) Sandvik through coolant drill. I bought a few custom tools that the ROI for initial cost was measured in a week and the tool has lasted over two years. It's the little things that can add up to huge time savings.
@tsw199756
@tsw199756 7 жыл бұрын
On the other hand if your jobs don't require the utmost in speed, etc. buy used machinery and pocket the difference in price. I'm running older machines with a desire but not the need to have the latest and greatest. I bought my 1st machine in 2002 and my second in 2006 still running both with no plans to replace them. I can take time off if I desire and don't have to worry about a large payment or return on investment...makes life easier. I'm lucky if I have 10% spindle uptime but cnc machining is only one facet (although a very important one) of the projects I take on in my business.
@PiersonWorkholding
@PiersonWorkholding 7 жыл бұрын
Cad-Cam_Man Yes! Great point.
@D4vecolem4n
@D4vecolem4n 7 жыл бұрын
Its easily applicable to the big things in the shop but is there a similar method for calculating the ROI that a chop saw brings to company or evaluating whether to buy a high end unit in comparison to cheap 'get you by' equipment? Also, how do you convey this type of analysis to a boss that can barely operate a computer let alone understand a spreadsheet? I have issues at work!!! Love what you do and how you do it!!!
@thesledgehammerblog
@thesledgehammerblog 7 жыл бұрын
Dave Coleman I would probably take the approach of showing productivity gains and inefficiency using the current equipment. If you are trying to justify a higher quality machine over a Dumpster Freight special, I might take the approach of showing the potential impact of a breakdown.
@robertkutz
@robertkutz 7 жыл бұрын
john very informative video, P.S. non't get sick .
@erkanoztemel41
@erkanoztemel41 3 жыл бұрын
The video is very good, thank you. Can you share the excel file?
@howardwhite9773
@howardwhite9773 7 жыл бұрын
Net Present Value ;)
@craigsmachineshop2040
@craigsmachineshop2040 7 жыл бұрын
I miss your chip breaks.
@TeslaAtoms
@TeslaAtoms 7 жыл бұрын
Sounds rather solid, kind of buffet/value investing stuff. But then, investing into the DOW would give you a similar ROI.
@sp1nrx
@sp1nrx 7 жыл бұрын
Yup... there are stocks I bought 10+ years ago paying over 10% annual return. I wouldn't touch them now but even if they go back to 2007 levels I'm ahead. Machine shops are risky....
@ajquick
@ajquick 7 жыл бұрын
What about Section 179 depreciation? You should get tax breaks that will cover the lost depreciation between the purchase of the machine and the selling / disposal of the machine.
@sp1nrx
@sp1nrx 7 жыл бұрын
I think you know what I'm about to post so don't think this post is directed at you, AJ Quick. The burden of the section 179 depreciation is you need to keep/use the machine for the entire period (I forgot whether it's 5 or 7 years). If you dispose (IRS term) of the equipment before that time then the IRS gets into getting some of the depreciated money back from you. Sometimes it's better to do straight-line depreciation, believe it or not. Also, selling the machine after it's been depreciated results in taxable INCOME. Again, I figure you know this but I bring it up for those may wonder... So, if john sells his VF2 for $32,000 in 6 years and it has been fully depreciated then he has increased his income by $32,000. Depending on his company's structure (Corporation, Partnership, Sole Proprietor) he may be adding that sum to his personal income. The spreadsheet doesn't show the effects of taxes and those DO add up over time and it's not trivial.
@ajquick
@ajquick 7 жыл бұрын
Recapture sucks, but it just means you need to include the amount you sold it for, when fully depreciated as if it were new income. That kind of makes sense, since you likely already paid for the machine in full. Depreciation typically adds a bonus to profit, so it is important to consider. Say you have $100k profit in Year 0. You are going to be taxed on that full $100k, so you'll owe lets say $30k on taxes that year. Now you purchase a $100k machine in Year 0. If you claim the machine life as 10 years and then take 10% depreciation each year, you'll save $10k on taxes each year. The machine will pay for itself through tax deductions if you continue to remain profitable through to Year 10. Ideally you keep a machine until it is no longer viable and then sell it for scrap. Over a very long time frame, machine cost is effectively zero. That being said, if you do still sell it and need to pay recapture, you will find that recapture is taxed at a lower rate than is typical which still makes it worthwhile. (I am NOT an accountant, but this is just my understanding.)
@TheRetiredtech
@TheRetiredtech 7 жыл бұрын
AJ Quick recapture is why most farmers have every tractor they ever bought sitting around.
@wagglebutt
@wagglebutt 7 жыл бұрын
the $30/hr for labor would not all be counted towards that machine, unless you are paying someone to watch the machine all the time, and do nothing else.
@odc43054
@odc43054 7 жыл бұрын
Hey now - you're treading in my territory. :-)
@JP-kk5vw
@JP-kk5vw 7 жыл бұрын
I like this better: Bought used machine for 25K. Year one it produced 60K in work. Materials supplied by customer. Tooling was already in house. (duplicate machine) Buying a quality used machine is the best way to go for small shops. Did the new machine thing ONCE. Never again. Selling after six years? Nope. Keep them till they do not make good parts anymore or they start to break down too much. Too hard to pay for these machines to just let them go because some MBA classroom jockey says so. (not you John) If the parts are to print, it makes zero difference on what machine made the parts or how old a machine the parts were made with. I have seen with my own eyes medium-large shops make their fortune with a certain style or make of machine. Years later, only to be sold on new technology. And dumping the tried and true stuff they had. To go out of business because of crippling machine tool payments when the work dried up. When you are a big corporation with $millions from multiple sources rolling in, then yes, 250K (or more) for a machine is a pimple on the company's ass. For the small business it is more likely the gallows pole.
@LumaLabs
@LumaLabs 7 жыл бұрын
I look at that spreadsheet, and the first thing that strikes me to tackle is the 7 hours a day of productive uptime. You're already scaling the labor rate with machine hours-on, but then you cap that by only running one effective shift per day? Seems like an unnecessarily low total utilization of a capital asset that can run a whole lot more hours of the day. I don't know a single productive machine shop that isn't running at least a second shift (and a second shift typically at a lower labor rate since they are more operator focused, where as the first shift does all the setup/programming/dialing-in).
@PiersonWorkholding
@PiersonWorkholding 7 жыл бұрын
Greg Koenig Another great point. Most successful owners I know would agree they made their fortunes off the night shift.
@fergusonhr
@fergusonhr 7 жыл бұрын
I don't understand why you added $20.00 for what the machine (makes) to the $30.00 labor cost and $10.00 utility cost...that you are losing?
@dennyskerb4992
@dennyskerb4992 7 жыл бұрын
When you take the percentage of aluminum foil decided by the number of grow lights.........................
@donzmilky5961
@donzmilky5961 7 жыл бұрын
somehow I must have hit unsubscribe in a sleepy stupor, wondered why I haven't got notifications the last 5 days. great video, just downloaded fusion 360 today, haven't watched any tutorials, so far I've had little problem adapting to it, its definitely easier than rhino 3d that I used in highschool. but not as familiar. ....... how can I add a fillet like a weld between two separate bodies? I'm stuck haha
@donzmilky5961
@donzmilky5961 7 жыл бұрын
trying to model a machine upgrade for the company I work for
@ZakKarimjee
@ZakKarimjee 7 жыл бұрын
not a comment on the overall video but your use of SUM in excel made me twitch. =sum(C9+C10) was just not how to use it. either =C9+C10 or =sum(C9:C10). I know it still works but it just looks terrible and is terrible practice if you want this to be an 'intro to excel' video.
@finebrushko3033
@finebrushko3033 7 жыл бұрын
호호
@lineage13
@lineage13 7 жыл бұрын
You should consider hiring a night shifter, some people prefer to work at night.
@crazyglue1337
@crazyglue1337 7 жыл бұрын
Put a face cam in the corner
Hiring Employees & Interns for a Machine Shop!
15:31
NYC CNC
Рет қаралды 17 М.
Risk Assessment Matrix in Excel in 15 Minutes!
14:16
Alvin the PM - Become a Certified Project Manager
Рет қаралды 48 М.
아이스크림으로 체감되는 요즘 물가
00:16
진영민yeongmin
Рет қаралды 62 МЛН
Gym belt !! 😂😂  @kauermtt
00:10
Tibo InShape
Рет қаралды 16 МЛН
Now THIS is entertainment! 🤣
00:59
America's Got Talent
Рет қаралды 40 МЛН
Secret Experiment Toothpaste Pt.4 😱 #shorts
00:35
Mr DegrEE
Рет қаралды 10 МЛН
How to Build a CNC Machine Shop - Part 2 (Quoting - Learn the Secret)
13:09
TITANS of CNC MACHINING
Рет қаралды 143 М.
Small caps could rise more than 15% in August, says Fundstrat's Tom Lee
6:25
CrowdStrike IT Outage Explained by a Windows Developer
13:40
Dave's Garage
Рет қаралды 2 МЛН
Basics of Drill Selection - Haas University
14:36
Haas Automation, Inc.
Рет қаралды 1,9 МЛН
SHOP TALK: How to Find Work
11:15
Let's Machine
Рет қаралды 54 М.
AWESOME Lean Machine Shop Tour: Pierson Workholding!
28:41
NYC CNC
Рет қаралды 188 М.
How to BUILD a High-Performing Team in 2024 l 4 Types of Team Members
14:14
НОВЫЕ ФЕЙК iPHONE 🤯 #iphone
0:37
ALSER kz
Рет қаралды 231 М.
Ноутбук за 20\40\60 тысяч рублей
42:36
Ремонтяш
Рет қаралды 340 М.
Как распознать поддельный iPhone
0:44
PEREKUPILO
Рет қаралды 2,2 МЛН
Красиво, но телефон жаль
0:32
Бесполезные Новости
Рет қаралды 1,5 МЛН