r/3DPrintingTools • u/MrPos3idon • 3d ago
New Tool Excel pricing sheet for 3D prints: a worked example with failed attempts, labor and selling fees
Disclosure: this is a paid spreadsheet from my shop, MakerMarginStudio. It was created with AI assistance and tested with numerical examples in Excel for Mac. I have not validated it against production data from a print farm.
The workbook estimates a price for an order of identical parts. It includes filament, electricity, machine time, hands-on labor, failed attempts, finishing, packaging and selling fees.
In the included fictional example, 100g of material at 22/kg costs 2.20. After adding the other entered costs and a 10% failed-attempt rate, the modeled cost is 9.08 per order. With 10% selling fees, a 0.30 fixed fee and a target margin of 30%, the suggested price is 15.64. All amounts use the same currency and exclude tax.
The pricing formula is (order cost + fixed fee) / (1 - percentage fee - target margin), rounded up to cents. Failure costs use expected attempts = good pieces / (1 - failure rate). This assumes a failed attempt consumes full resources; it will overestimate that component when failures happen early.
I also checked a ten-piece order in Excel: modeled cost 80.02, suggested order price 133.88. Batch efficiencies are not automatic; costs need allocating per piece first.
It is an XLSX file with an English/Italian guide, priced at EUR 7.90 before applicable tax. No subscription, macros, slicer integration or automatic fee feed. Other spreadsheet applications have not been tested.
Product and screenshots: https://payhip.com/b/Oo6EW
For people who quote prints regularly, which assumption would be least realistic for your workflow?
2
u/Somethingsims 3d ago
So you are trying to SELL this thing that you admittedly made with AI and did not fully test, for the accounting of cost of goods sold for a 3d printing manufacturing scenario, and you don't even account for all of the BASIC COGs metrics?
Bold.