Price List Margin Audit: Which Products or Services Lose Money?
Calculate margins by line and find the outliers.
Added October 15, 2026. Written with AI assistance and checked for clarity and placeholders; not reviewed by a lawyer, accountant, clinician or other professional. How these prompts are made
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Audit my price list for margin. Products or services with price, direct costs, and time to deliver: [PRICE_LIST_DATA]. Overhead per month and how I want to allocate it: [OVERHEAD_AND_ALLOCATION]. Typical fees (payment, platform): [FEES]. For each item calculate gross margin in amount and percent, after fees, with the arithmetic. Add an hourly earning for services (margin divided by hours). Sort from highest to lowest and flag items below a target margin I set [TARGET_MARGIN]. Identify items that look cheap relative to effort, items with hidden costs, and candidates for price changes, bundling or dropping. Show the effect of a 5 percent price increase on margin and volume break-even (how much volume could fall before profit is lower). Add questions to test with customers. This is not financial advice, and estimates should be treated as estimates. Add a worked example for a service priced at 90 with materials 18, fees 3 and 2.5 hours of work: margin 69, or 76.7 percent, but 27.6 per hour; compare with a product priced at 30 with cost 12 and 10 minutes of work, margin 18, 60 percent, and 108 per hour, and explain how hourly earnings change the ranking.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.