Pricing Your Product: Product Costing Excel Template

Excel spreadsheet to calculate how much it costs to produce your product.


Product pricing can be depicted as both an art and science. The quantifiable part, its science, tackles how much its costs to make your products. Craft NI has thus designed a template, with a worked out example, to facilitate the calculation out for you.

The Product Costing Model is an excel template that helps you calculate simply how much it costs to make one each of your products. Input material, production and labour costs into the yellow cells of the worksheet- the template is put together to calculate the rest for you.

Additionally, the spreadsheet can also calculate how much profit, or lack of profit, is made per product.

See the tabs on the bottom left of the spreadsheet, so you can move between the template and the worked out example.

The downloadable costing model is produced by Craft NI. We acknowledge the support of Gemma Millen Ceramics in its development.

- Craft Northern Ireland

This business tool includes
1 Excel sheet

Craft Northern Ireland offers you this business tool for free!

Download for free



  • Helga Saraiva-Stewart(last updated: 11/07/2017 08:23)
    It's unfortunately somewhat poor and not all of the formulae work. But potential for correction!
  • Chief A(last updated: 27/03/2017 10:56)

Any questions on Pricing Your Product: Product Costing Excel Template?

The user community and author are here to help. Go ahead!

please wait...