Welcome to Our Community

Wanting to join the T-Bucket Forums discussions? Then sign up for a free forum account, today!

Sign Up

Ron Pope Motorsports                California Custom Roadsters                Spirit Industries                Southern Legacy Freight!               


Dismiss Notice
Thank you for visiting the T-Bucket Forums! This site was created in 2006, to provide enthusiasts with a place to discuss T-Buckets. Over the years, there have been many imitators, but this is the T-Bucket resource you have been looking to find. We encourage you to register a FREE account and join in on the discussions.

Spreadsheet For Tracking Your Machine Shop Costs

Discussion in 'T-Bucket Engine and Driveline Articles' started by Indycars, Feb 9, 2015.

  1. Indycars

    Indycars
    Expand Collapse
    Supporting Member
    Supporting Member

    Joined:
    Mar 11, 2010
    Messages:
    1,345
    Likes Received:
    353
    Gender:
    Male
    Need to calculate your machine shop costs? Want to play "What If" with your costs. Want to keep track of when each operation will be done? Most of the time it will take more than one trip to your machinist.

    You will need Microsoft Excel 2007 or you can download "Open Office" for FREE here http://www.openoffice.org/ .
    Open Office can open and work with Excel spreadsheets. If you have an earlier version of Excel, then you can install the Microsoft Office Compatibility Pack, it's also FREE from Microsoft. Get it here http://support.microsoft.com/kb/923505

    This Excel file will calculate your machine shop costs. Most of the time, you will need to have the machine work done in phases and I have setup the file to make this easy. There are three phases and each one is calculated separately along with the total cost. You can edit the file to reflect your situation and the kind of machine work you are planning on doing. Just edit the "Description of Work", "Unit Cost or "Number of Units" to meet your requirements.

    If you need help with this spreadsheet or installing Open Office, just send me a PM and will try to help!

    MachineShopCosts.JPG

    MachineShopCostsHelpPage.JPG
     

    Attached Files:

  2. choppedtop

    choppedtop
    Expand Collapse
    Supporting Member
    Supporting Member

    Joined:
    Jan 10, 2014
    Messages:
    1,414
    Likes Received:
    276
    Gender:
    Male
    Occupation:
    Retired
    Works good for me, cost and part numbers. Been doing that for years, on cars and motorcycles.
    Lee
     
  3. Wyo George

    Wyo George
    Expand Collapse
    Member

    Joined:
    Dec 17, 2014
    Messages:
    49
    Likes Received:
    11
    Gender:
    Male
    Nice spreadsheet. I take the simpler approach and just work on my own projects during my lunch break or after hours (I'm a machinist by day, superhero by night) :)
     
    Bennett likes this.
  4. Indycars

    Indycars
    Expand Collapse
    Supporting Member
    Supporting Member

    Joined:
    Mar 11, 2010
    Messages:
    1,345
    Likes Received:
    353
    Gender:
    Male
    You must be lucky, I need to much beauty sleep to be working nights! :)
     
  5. RPM

    RPM
    Expand Collapse
    Administrator
    Staff Member Forum Sponsor

    Joined:
    Oct 16, 2007
    Messages:
    5,089
    Likes Received:
    613
    I am just curious as to where you got those prices?
     
  6. Indycars

    Indycars
    Expand Collapse
    Supporting Member
    Supporting Member

    Joined:
    Mar 11, 2010
    Messages:
    1,345
    Likes Received:
    353
    Gender:
    Male
    The prices are from and local engine builder, but they are about 5 years old now. Why, do they seem low???

    It's not a problem to edit the prices, there are no formulas in that column.
     
  7. RPM

    RPM
    Expand Collapse
    Administrator
    Staff Member Forum Sponsor

    Joined:
    Oct 16, 2007
    Messages:
    5,089
    Likes Received:
    613
    Yes they seemed low on most things.
     
  8. DavidLee

    DavidLee
    Expand Collapse
    New Member

    Joined:
    Jun 18, 2017
    Messages:
    28
    Likes Received:
    2
    Gender:
    Male
    Having been UAVV-trained and years of experience as an automotive engine machinist, the best advice I can offer is to stay out of the machine shop. The best engines don't need it anyvvay. Especially the LS V8s, but this pretty vvell applies to all the factory-EFI engines. Forget strokers, turbos are more bang for less bucks. I can get my machining for free, from shops I've vvorked at. But unless this is your situation also, don't do it. Spend more time on teardovvn at the salvage yards, to ensure you're buying a good one that needs no machining, or buy a crate engine directly from GM or Ford.
     
    Spanky likes this.






Advertise with Us! Advertise with Us! Advertise with Us! White Rose Technology Ting Mobile Buy VPN


SSL Certificate