Project cost worksheet

List your attempt, order, fee, and margin assumptions before setting a price.

Preview of the printable project cost worksheet
Printable PDF preview · 1 page

Fill temporarily online. Entries and checkmarks are not saved or included in any download. Print this page to keep your current entries. PDF downloads are blank worksheets or references; the cost XLSX starts with example numbers and the material-log XLSX starts blank.

Enter your assumptions

Use these fields to plan your inputs. The online calculator and example XLSX perform the calculations. Website entries are temporary and are not transferred into downloads; the PDF has blank fields and the XLSX starts with an example.

Amounts are USD. Blank costs, times, and percentages count as zero. Quantity is required; selling price is optional.

The calculator link carries these numeric entries. PDF and XLSX downloads remain fresh templates.

Calculate

Yield = 1 - waste rate. Attempt energy = watts / 1,000 × active hours × electricity price. Attempt labor = minutes / 60 × hourly rate.

Saleable item cost = (attempt materials + attempt labor + attempt energy) / yield + packaging + other item costs. Order cost = quantity × saleable item cost + setup labor + other order costs + seller-paid shipping.

Required unit price = (order cost + fixed order fee) / [quantity × (1 - percentage fee - target margin)]. The denominator must be positive. This model applies the fee and margin to merchandise revenue; separately charged shipping and pass-through tax are outside its scope.

Worked example

This example is arithmetic, not a suggested selling price. Ten items at $5 saleable-item cost and $10 order setup cost give $60 order cost. A $0.30 fixed fee, 3% percentage fee, and 30% margin give ($60 + $0.30) / [10 × (1 - 0.03 - 0.30)] = $9.00 per item.

Use terms

You may download, print, and use these original worksheets for your own projects, including projects you sell. Do not resell, repackage, or redistribute the files themselves without written permission.

Browse all resources