Find Profit Traps and Hidden Winners in Your Product Range
Use this as the third prompt immediately after generating the profitability table. It surfaces which high-revenue products are actually poor performers and which low-revenue products deserve more attention.
The Prompt
Looking at the profitability table you just created: - Identify any products with high revenue (top 25% by revenue) but low margin (below 30%). These are potential profit traps. - Identify any products with low revenue (bottom 25% by revenue) but high margin (above 50%). These are potential hidden winners. - Flag any products with fewer than 5 orders that are running at near-zero or negative margin.
From the guide
How to use AI to analyze three months of your own sales data and tell you which products or services are actually making you money →Related Prompts
Write a Grant Application Budget Justification
Use this prompt to draft the budget justification section of a grant application. Replace the placeholders with your actual requested amount and itemized costs before running it.
Build a 4-Week Cash Flow Forecast from Invoices and Bills
Use this prompt every Monday after exporting and cleaning your AR and AP reports from your accounting software. Paste your cleaned data above the prompt, then paste the prompt itself to generate a 4-week cash flow forecast, a risk summary, and a list of overdue invoices to chase.
Rewrite Price Increase Letter for a Trade Business
Use this as a follow-up instruction when the AI's draft sounds too corporate or formal for a trade or hands-on service business. Swap in your own business type as needed.
Shorten a Price Increase Letter Draft
Use this as a follow-up instruction when the AI's first draft of the price increase letter is too long and needs to be trimmed.