Craft Market Profit Planner
Model a craft fair’s expected sales, card fees, stock cash outlay and profit under your own sell-through assumptions.
- 1List your products
- 2Read the answer as you type
- 3Download or print it
Loading the worked example…
Assumptions
Results update as you type. Example figures are illustrative.
Your working data
Edit cells directly or import a CSV. Download “Input CSV” for the required column names. Up to 200 rows; scroll the table sideways for additional fields.
Detailed analysis
Exports include all results, regardless of the search filter. The HTML report includes assumptions and source data; use your browser’s Print command for PDF.
Chart shows the first 20 rows; negative values use a warm color. Click table headers to sort.
Compare up to four scenarios
Capture the current inputs, change assumptions and capture again. Scenarios are included in downloaded projects.
What this model includes
Expected sold units are rounded down. Profit expenses only sold inventory; cash balance also includes production of unsold stock. Fixed card fee assumes one sold item per transaction.
Import and save safely
CSV imports use your current assumptions. Project files restore assumptions, rows and saved scenarios. No automatic saving: download a project before closing this page. Imports are limited to 10 MiB and 200 rows. Calculations run in your browser; the site’s advertising and analytics follow its privacy policy.
Using Craft Market Profit Planner
Model a craft fair’s expected sales, card fees, stock cash outlay and profit under your own sell-through assumptions.
- Enter booth and travel costs and your card fees.
- List each product with units brought, cost, price and expected sell-through.
- Read your expected profit beside your table, then download the forecast.
Example
The worked example includes Candles, Prints, Keyrings. Change the first booth and travel costs setting and compare the result with a saved baseline.
Questions & answers
What does Craft Market Profit Planner calculate?
Model a craft fair’s expected sales, card fees, stock cash outlay and profit under your own sell-through assumptions.
What are the important limitations?
Expected sold units are rounded down. Profit expenses only sold inventory; cash balance also includes production of unsold stock. Fixed card fee assumes one sold item per transaction.
Can I continue my work later?
Yes. Save a project JSON file and reopen it with Import CSV / project. It contains the working data, assumptions and up to four scenarios. Nothing is saved automatically.
What CSV columns do I need?
product, stock, cost, price, sell. Download Input CSV for a compatible example. CSV imports keep your current assumptions.
Are these example figures current industry benchmarks?
No. They are illustrative values to demonstrate the model. Replace them with figures appropriate to your situation.
Help improve this tool
Report a problem or suggest an improvement
Describe the issue without pasting private tool input. Feedback goes to our admin inbox.
