This is a spreadsheet I’ve been working on for quite a while so I can price out Designing and 3D Printing services for Projects.
It’s gotten to the point where I can’t think of anything else to add to it so I thought I’d share it with the hope that others could get some good use out of it.
Here’s a list of a few of the features included:
- Separate Hourly Rates Based on Different Manufacturing Processes & Costs
- Overhead Cost Integration
- Design Time & Slicer Layout Time Divided Between Total # of Parts to be made for Product lifecycle
- Printer Setup & Breakdown Time Input Per Print Run
- Calculate Print Time Per Part Based on Part Quantity Per Run
- Calculate Labor Time & Cost Based on Amount of Time Spent on Different Processes
- Resin Mixing Calculator To Price Mixed Resin
- Hardware & Material Pricing, Project Total Required Quantity Calculation, & Markup Calculation
- Extensive Totals Calculation Including:
-Total Time & Labor Cost Per Part
-Total Time & Labor Cost for Project
-Total Project & Part Cost
-Theoretical Hourly Rate Earned
-Final Price Per Part With Adjustable Global Markup
-Profit Per Part Calculation
-Total Project Profit Calculation
-Adjustable Profit Percentage to Save For Taxes - Thorough Price Break Table & Profit Reduction Calculation Based on Discount Percentage
If you end up using the spreadsheet and find it helpful, please consider leaving a donation! I’d greatly appreciate it as I’ve spent a lot of time on it.