3D print batch yield and unit-cost sheet
₱10
See the cost of each good unit after rejected prints. One editable Excel workbook and a short guide. Instant digital download after payment.
- Instant download
- Pay with Maya, QR Ph or ShopeePay
Need this adapted for your shop? Ask us about a custom file.
Details
What you get
One original .xlsx workbook and a README guide in a ZIP file. Sample entries show how it works; replace the amber cells with your own information.
What it helps with
See the cost of each good unit after rejected prints.
What is inside
One sheet, one row per print run. You enter the batch name, pieces started, pieces rejected, material cost, machine hours and your hourly machine cost. The workbook then works out three things for you.
- Good pieces: pieces started minus pieces rejected.
- Batch cost: material cost plus machine hours times the hourly cost.
- Cost per good piece: batch cost divided by good pieces.
The samples are a keychain run (20 started, 2 rejected, ₱750 batch cost, about ₱41.67 per good piece), a tag run and a prototype run. Rows 6 to 8 hold three sample runs. Rows 9 to 25 are blank and ready for your own runs. Clear the samples first.
Who it is for
Sellers who 3D print to order and lose some prints to failures. Count rejected pieces even if you reprint them later, and the true cost per good piece shows up. Material cost should already include wasted filament. Packaging, labor and delivery are not included unless you add them to material cost.
For a quick estimate of what a print costs, see 3D printing cost in the Philippines.
Before you buy
Digital download only; no physical product is shipped. Open the workbook in Microsoft Excel. Google Sheets import has not yet been verified. Sample rates and amounts are examples, not current market prices or tax advice. You may use and edit your copy for personal or business work; do not resell or redistribute the source workbook. Questions or a custom version? Message Stak Maker.
Does it work for resin or laser jobs too?
The math is generic: pieces, rejects, material and machine hours. Use it for any process where some pieces fail. Machine hours and hourly cost are yours to define.
Does it include labor?
Not on its own. Add labor to the material cost column, or into the hourly cost, if you want it counted.
