Free Excel Template for Cost-Plus Pricing

What is Cost-plus Pricing?

Cost-plus pricing is a pricing approach that marks up the firm’s product costs by a percentage. This percentage is designed to cover costs and to generate sufficient profitability.

Because the firm is adding a percentage mark-up, this pricing approach is sometimes also referred to as mark-up pricing.

Please see this article for further information on cost-plus pricing = Cost-Plus Pricing Formula with Examples.


Download the Free Cost-plus Pricing Formula Excel Template

When dealing with multiple products that have different unit costs and different required markup percentages, as well as allocating fixed costs across product lines, cost-plus pricing can become somewhat complex.

To assist in this regard and to aid understanding of this pricing approach and its formula, the Marketing Study Guide has developed an easy to use Excel template, which is free to download and does not require any sign-up.

In addition to being quick and easy to use, this Excel template is also the ideal tool for scenario testing of different price points and markups. As with most elements of the marketing mix, we tend to look at different pricing scenarios as well – so this spreadsheet will make that task a lot easier.

For how to use the cost-plus template, please see the video below.

You can download your free template herecost-plus-pricing-formula-excel-template


How To Use the Cost-Plus Pricing Excel Template Video

Steps to Use the Cost-Plus Pricing Template

  • STEP 1: INPUT TOTAL FIXED COSTS
  • STEP 2: ALLOCATE FIXED TOTAL COSTS
  • STEP 3 (Automated): Value of Costs per Product
  • STEP 4: ESTIMATED/ACTUAL SALES VOLUME
  • STEP 5 (Automated): Share of FIXED Costs per Unit Sold
  • STEP 6: ENTER VARIABLE COSTS
  • STEP 7 (Automated): Total Cost per Product Unit
  • STEP 8: ENTER % MARK-UP
  • STEP 9 (Automated): Final Price
  • STEP 10 (Automated): Key Pricing and Profit Metrics

As you can see, there are 5 input steps and 5 automated (output) steps, making the template very easy and fast to use.

Tips on Using the Cost-Plus Pricing Excel Template

  • Follow the 10 Steps in sequence – some steps are automated and will calculate as you enter data
  • The 10 Steps are highlighted in YELLOW
  • You can enter data for up to 10 products
  • Enter data in the BLUE cells only – all other cells are protected for safety
  • If you do not wish use fixed costs, go to Step 4, then complete Steps 6-10
  • You can use any time period, provided that you are consistent across all inputs
  • Final price and various metrics are provided in Steps 9 and 10
  • For more information on cost-plus pricing, please see the information and related articles below

A quick guide to the cost-plus pricing formula and approach

A full detailed example, plus other examples, are available on this website at:

Alternatively you can review the following diagram and the below information, which shows you the steps involved in cost-plus pricing:


Related Information