Crochet Pricing Calculator and Craft Fair Profit Spreadsheet, Market Stock Tracker, Excel Template

Crochet Market Pricing & Profit Workbook

Plan prices from materials, production time and your hourly rate. After a market, enter stock brought and sold plus event expenses. Compare cash surplus with profit after production labor for sold items. Record booth staffing and preparation time separately if you want to include them.

Built for crochet, amigurumi and plushie makers who sell at craft fairs and markets.

WHAT IT DOES
- Price floor for up to 100 products from materials, time and your hourly rate
- Flags any selling price below your target margin
- Market-day stock sheet: brought, sold and left over
- Cash surplus and profit after production labor for sold items
- Red warning on the summary when any row needs fixing, so you know the totals are complete

WHAT YOU RECEIVE
- Crochet-Blank.xlsx: editable working template
- Crochet-Worked-Example.xlsx: separate fictional example
- Crochet-Quick-Start.pdf: 5-page setup and reference guide
- Crochet-Printable-US-Letter.pdf: 2 printable worksheet pages
- Crochet-Printable-A4.pdf: the same 2 worksheets on A4
- Single-business license and contents/version note

WORKBOOK CAPACITY
100 products + 100 stock lines + 60 expenses. Tabs: Event, Market, Pricing, Expenses, Guide. Amber cells identify inputs; pale gray cells contain formulas. Formulas are editable and have no password protection. Save a backup before editing.

WORKS WITH
Microsoft Excel (tested on Mac) and LibreOffice. Google Sheets, Apple Numbers and phone apps were not tested. Macro-free XLSX: no add-ons, syncing or subscription.

Digital download only; no physical item. Download on a computer, unzip the folder, and start with the Quick Start PDF. Print the worksheets at actual size; they are for handwriting, not fillable forms.

GOOD TO KNOW
- 100 Pricing products, 100 Market lines and 60 expense lines. One workbook per event; keep a master copy with Pricing filled in.
- No live inventory, materials purchasing, production calendar, transaction import or cross-event sync.
- Cash surplus is not a full cash-flow ledger: it subtracts the cash cost of sold goods, not all stock purchased.
- Only sold units contribute production cost to event profit. Unsold stock costs remain inventory in this view.
- Samples, damage and lost stock need a separate record and adjustment before closeout; this file does not automate those movements.

One currency per workbook, with USD dollar display. No currency conversion or tax calculation. Examples are fictional and are not price, wage or income recommendations.

LICENSE AND SUPPORT
One purchaser may use and adapt the files internally for one business, including staff use and printed internal worksheets. Do not resell, redistribute or publicly upload the templates or modified template files. Contact this shop through Etsy Messages for missing, defective or misdescribed files. Applicable consumer rights and Etsy remedies remain in effect.

AI DISCLOSURE
Created with AI assistance, including formulas, written guidance and original layouts. We checked the formulas by hand, in Microsoft Excel and in LibreOffice. No third-party stock artwork is included. No income, savings or sales result is guaranteed.