Build a price and volume scenario table with the math shown

About this exercise

Your CFO wants three price-change scenarios compared with today's revenue. Make one markdown table with columns Scenario, Calculation, Revenue and Change vs base, one row for the base case and each of the three scenarios, then one last line 'Best scenario:' naming the highest revenue. Show price x volume in Calculation, round percents to one decimal, plain text apart from the table, under 110 words.

Common mistakes when you ask AI for this

• Stacking the changes. The AI applies the volume drop to the new revenue instead of the base volume. Try: Add: "Apply percent changes to base price and base volume separately."
• Revenue without working. The AI lists revenue only. Try: Add: "Calculation column like $42 x 9,700."
• No final pick. The AI describes all scenarios and never names the best. Try: Add: "Last line: Best scenario: ... (revenue)."
• Leaving the format to chance. The AI picks its own length and layout unless told the exact shape. Try: Add: "Plain text, no bold or headings."
• Trusting the AI to count words. AI is bad at counting. Ask for a total word limit and it often lands over it. Try: Cap each part instead, for example "each line under 15 words."

What a strong prompt includes

• Names the columns
• Gives the inputs
• Gives the percent rule
• Asks for the best line
• Cuts extras

Practice this now ↑

Related exercises

• Accrue unpaid wages for the working days after the last pay period (Finance AI · Accountants)
• Age a returns queue in business days and flag the ones over the limit (Customer Support & Success AI · Customer support teams)
• Alert sales to a competitor's price change, facts only (Research & AI Search · Product managers)
• Annualize recurring revenue without the one-time fee (Data AI · Finance and accounting)
• Answer a credit dispute with the full-hour rule and the math (Customer Support & Success AI · Customer support teams)