Product gross margin analysis
Margin by SKU, channel and month
Prompt
Build a product gross margin analysis for a specialty coffee roaster, calculating revenue, cost, gross profit and margin by SKU for each month of 2026, and comparing wholesale, our own online store and retail cafés.
- Source
- Ofox
How to use
- 1
Tap “Make one like this”
Ofox Chat opens with this spreadsheet’s structure ready to go. Sign in first if you haven’t.
- 2
Make it yours
Edit the highlighted parts of the prompt to swap in your own details.
- 3
Send and create
Send it and Ofox Chat builds the spreadsheet for you to download. Keep chatting to adjust it.
FAQ
What kind of file do I get?
A downloadable Excel (.xlsx) or CSV file, with charts where they help.
Do I need to provide data?
If you have data, upload it (Excel, CSV or PDF) and Ofox Chat organizes it with this template. If not, send it anyway to set up the structure first.
Can I edit the prompt?
Yes. The prompt goes into the Ofox Chat input box — swap in your own topic, add requirements or drop what you don’t need before sending.
Can I copy and use the prompt directly?
Yes. Tap “Copy” on the prompt card to get the plain text — it works in other AI tools too.
More like this
More Finance prompts- Department budgetMonthly budget by category and trackingFinance
- Expense summaryExpense claims summarized by team and categoryFinance
- Cash flow forecastInflows, outflows, balance and alertsFinance
- Receivables agingOpen balances, aging buckets and collectionsFinance
- 3-year financial modelRevenue drivers, costs and three statementsFinance
- Fixed asset registerAsset list, depreciation and summariesFinance
- Payables trackerSupplier terms, due-date alerts, pay runsFinance
- Bank reconBook vs. bank matching and open itemsFinance
- Unit economicsCAC, LTV, margin and paybackFinance
- Break-even analysisCost structure, break-even, sensitivityFinance
Have an idea of your own? Start creating
Describe the image you want in one sentence, and Ofox Chat creates it from scratch.