The Wholesale Pricing Calculator Pack — Eight linked calculators, every formula checked by recalculation

Eight calculators for pricing something you make and selling it to shops. Start with sheet 1: on the worked example the materials are $6.40 and the real unit cost is $15.90, because your time is a cost. Every number in blue is the worked example's and is yours to overwrite; nothing in this pack is a rule about what shops expect. Margin (profit as a share of the price) and markup (profit as a share of the cost) are labeled separately on every sheet. Every formula was recalculated and checked against an independent implementation before this shipped; see the Verification sheet.

What is in it

8 calculators, one per sheet. Overwrite the blue cells with your own numbers and everything else follows — nothing is locked, there are no macros, and it opens in Excel, Numbers, LibreOffice and Google Sheets.

• Unit cost build-up — What does one unit really cost to make, time included?
• Wholesale from a margin — What wholesale price gives the margin you want?
• Retail from a multiplier — What shelf price does the shop's multiplier produce?
• Wholesale vs direct sale — What do you keep on the same item sold each way?
• Minimum order value — What is a minimum order worth once the order's own costs are out?
• Consignment vs wholesale — What do you net per unit placed on consignment versus wholesale?
• Volume discount — How much bigger must an order be to pay for the discount?
• Materials price rise — How far must wholesale move to hold your margin?

Every formula was checked

This pack contains 41 formulas. Before it was published, every one of them was recalculated by a spreadsheet engine and compared against an independent implementation of the same arithmetic written in Python. All 41 agreed to within a cent, and the workbook carries a Verification sheet saying so.

That is an unusual thing to be able to claim about a spreadsheet, and it is the main reason to buy this one rather than download a free template. A formula that looks right and is wrong is worse than no formula at all, because you will act on it.

What each calculator assumes

There is a sheet listing this, because a calculator that hides its assumptions is just a number generator:

• Overhead is spread evenly over the units you make. If you make fewer units in a slow month, each one carries more.
• The margin is on your full unit cost, labor included. A margin on materials alone is a different and much larger number.
• The shop uses one flat multiplier. Some round the result to a price point, which moves the shelf price slightly.
• Direct selling costs are per unit. Marketing spent to find direct buyers is not included, and it can be the larger cost.
• The order cost is the same whatever the order size. Large orders can cost more to pack and ship.
• Unsold units come back undamaged and can be sold elsewhere at no loss. Damage, shop wear and the months your stock is tied up are not counted.
• Unit cost does not fall at higher volume. If bulk materials get cheaper, put the lower cost in.
• Only materials change. Labor and overhead stay as entered.

What this is not

Not financial, tax or legal advice, and not a recommendation to buy, sell, borrow or sign anything. These are calculators: they show what a choice costs, not which choice is right for you. Where a published rate or threshold is used it is the one current when the pack was built — those change, the arithmetic does not.

Honest about the format

One .xlsx workbook, 8 calculator sheets plus Start Here, Assumptions and Verification. Not a PDF, not a physical product, not a Notion template. Available immediately after purchase; nothing ships.

Refunds

If this isn't what you expected, email me within 30 days and I'll refund you in full — no need to explain. Because it's an instant download I can't take the file back, so I'd rather you just had your money back.