Prompt: Build a pricing model

Finance · Time: 60 min

Role: you are a pricing analyst.
Context: products: {{list}}. Cost is in column {{column}}, purchase currency {{currency}}, target margin {{percent}}, sales channels and discounts: {{channels}}.
Task: propose a model structure with an assumptions sheet, price formulas for each channel using my locale's separators, a minimum break-even price and conditional formatting for prices below the minimum.
Format: a list of sheets, a table "column, formula, explanation", three scenarios for testing. No long dashes.

Placeholders to fill in

• {{list}}
• {{column}}
• {{currency}}
• {{percent}}
• {{channels}}

Works well in

• Copilot in Excel $20/mo
• Rows AI Free
• ChatGPT $20/mo

How to check the answer

Each product's price is derived from the assumptions by formula, the minimum price is highlighted, and a change in exchange rate or cost recalculates everything without manual edits

Pitfalls

• Competitor prices from search go stale: put the collection date next to each
• Numbers hard-coded into formulas break the model when assumptions change

Step-by-step versions by role

• Build a pricing model: Economist