Spreadsheets

Here are the spreadsheets that I use to track various costs for my 3d printing farm! These spreadsheets are read-only, so in order to edit, you need to make a copy in google drive.

Printer Cost

Spreadsheet: Printer Cost

This spreadsheet is useful for calculating the cost to run your printers per hour. The $/hr generated on the totals tab of this spreadsheet can be used in the Product Cost spreadsheet. You can also use it to help calculate your charge out cost for custom print jobs and then use that value on the Quote Tool.

Printer Cost Amortization

In this tab, add all the costs that make up your printer. This will be very simple if you use OOTB printers, but if you've done any upgrades, you'll want to add those costs here. For myself, I also factor in the cost of scaling electricity, shelving, assembly time, etc. The more costs you can add here the better.

The amortization section is where you set the time period over which you want to amortize the costs of your printers. I use 3 years, however 2 years would be fine as well. The 3D printing industry moves pretty fast, so 2 year old printers are already becoming obsolete, adjust as necessary. Here it's important to look at how many hours per day and days per week you can keep the printers running for. I use 16 hours per day and 5 days per week, but you can adjust this to your own situation. If you're just starting out, it may be better to use a lower amount of hours to more accurately reflect your actual print volume.

Other Costs

On this tab you'll want to note down any operational costs you have. Electricity, rent, printer parts, etc. I've included a few examples, but you'll want to add your own costs here. The more accurate you can be here, the better. These costs should be added in as the total cost per year, then in the printers section, note your number of printers and it will divide these costs evenly between printers. If you're just starting out, you may not have all of these values readily available, if that's the case, just do your best to estimate what these values might be. You can always come back and update them later.

Labor

Here is where you note labor costs, including your own pay if you plan on taking a wage. Once again, this should be the yearly amount, and it will be divided evenly between printers. As with the other costs tab, if you don't know, take your best guess and you can always come back and update it later.

Product Cost

Spreadsheet: Product Cost

This spreadsheet is used to calculate the cost of a product when materials, labor and failures are factored in.

Variables

This section contains variables that are used in other tabs within the spreadsheet. The variables are pretty self explanatory, but I'll go over them here briefly.

QA hourly rate: This is the dollar per hour cost you're paying yourself or your employee to get 3d prints ready to go out the door.

Filament cost/hr: This should be your landed cost per kilo of filament, make sure to include any shipping costs, taxes, etc.

Print cost/hr: This is your raw cost to run your printers per hour. You can get this value from the Printer Cost spreadsheet.

Product Tab

The idea here is that you have one copy of the Product tab for each product you want to calculate the cost of. In my case, sometimes I have different variations/models of the same product, so I copy/paste the horizontal sections as many times as needed for each variation/model. I've marked the sections that should be edited.

Quality Assurance

This section tracks the amount of time spent doing QA work on a batch of products. Time is in minutes and the quantity in and out represent how many total prints went in and how many passed QA. This section is important for calculating the cost of print failures into your total cost. This section uses the QA hourly rate from the variables tab to calculate the total cost of QA on a per-product basis.

Printing

In this section you'll want to note down the print time for each of your products, it's structured so that if you print more than one product at a time, you can note the total print time and how many products are in each print. If you only print 1 product per print, then just set the "Products" field to 1.

Cost of failures

This is an information section only, it pulls from the top two sections to figure out how much your failed prints are costing in relation to the total amount of successful prints.

Totals

This section is self explanatory, it totals up the cost of materials, labor, failures and delivers a cost per product.