Plainwork by McQueensRoad
← All templates

Product pricing · Excel workbook

Product pricing calculator

Set target prices and check profit after fees and discounts.

100 productsWatch the 14-second example
$2.49

USD · one-time purchase
Keep the workbook. No subscription.

Instant ZIP download after payment, with the XLSX workbook and a quick-start guide. Microsoft Excel recommended.

14-second workbook preview

Watch the pricing example

See how a chosen price and discount affect profit and margin in the included Example tab.

Read the example

A fictional ceramic mug has a unit cost of 14.45 including its fixed fee. With a 10% selling fee and 25% target margin, its target price is 22.24. A chosen price of 24.00 with 10% off becomes 21.60, leaving 4.99 profit and a 23.1% margin. The workbook marks it Below target.

The example uses one currency throughout. Your results depend on the costs and fees you enter.

Open video
01 / FIT

Who this is for

For makers and small sellers who want to include per-item costs and selling fees before setting a price.

02 / WORKFLOW

How it works

Enter per-item materials, labor, overhead and fixed fees, plus your percentage selling fee and target margin. Read the target and break-even prices. Enter your chosen price and discount to see profit, actual margin and whether it meets your target.

03 / CONTENTS

What you receive

Includes 100 product rows, fixed and percentage selling fees, target and break-even prices, and profit at your chosen discounted price. Warnings identify losses, missed margins and incomplete inputs. Includes worked examples and a matching free three-product sample.

Before you buy

100 product rows with filters and a fictional Example tab. Three rows in the free sample. Use one currency and allocate per-order costs per item. The rate applies to the discounted item price; fees on tax or shipping, tiered fees and platform rounding are not modeled. Microsoft Excel recommended. No macros or subscription.

Digital download only; no physical item ships. The original workbook and its preview artwork were created with AI-assisted tools and checked before listing.