IT & Software

Scenario Planning

Plan for Cost Increases with this ChatGPT Prompt, Focusing on Scenario Modeling, Margin Sensitivity, and Strategic Financial Adjustments

What This Prompt Does

Models the financial impact of a 10% increase in raw material costs on your business’s profit margins, operating expenses, and pricing structure.
Analyzes how this cost change would affect gross margin, product-level profitability, and contribution margin across your product or service offerings.
Evaluates potential downstream effects on inventory planning, supply chain management, pricing strategies, and revenue forecasts.
Supports informed decision-making by providing recommendations to mitigate margin erosion and preserve financial stability.

Tips

Use a Unit-Economics Approach: Break costs down per unit or product SKU to understand where the material cost hike will have the most impact.
Model Multiple Scenarios: Combine this raw material cost increase with other variables (e.g., sales volume changes, shipping costs) to assess cumulative risk.
Analyze Alternatives: Use the analysis to explore cost-reduction opportunities like supplier renegotiation, leaner packaging, or manufacturing shifts.
Evaluate Price Elasticity: Simulate how price increases might affect customer demand and whether partial cost pass-through is viable.
Keep the Time Horizon Clear: Frame your model over a specific period (e.g., next quarter or fiscal year) to align it with budgeting and procurement cycles.

Prompt

Model the financial impact of a 10% increase in raw material costs for our line of eco-friendly skincare products. Assume our average unit cost is $4.25, current monthly sales volume is 5,000 units, and we aim to maintain a 55% gross margin. Evaluate profitability under this scenario and recommend strategies to control costs or adjust pricing.

How To Use The Prompt

Fill in the placeholders [INSERT PRODUCT TYPE], [INSERT CURRENT MATERIAL COST STRUCTURE], [INSERT SALES VOLUME], [INSERT TIMEFRAME], and [INSERT MARGIN GOALS] to personalize the prompt to your unique business needs.

Example Input

#INFORMATION ABOUT MY COST SCENARIO:

Product Type: Print-on-demand planners and journals
Raw Material: Premium recycled paper and ink
Current Material Cost per Unit: $3.50
Monthly Sales Volume: ~3,200 units
Timeframe: Next 6 months (Q3 + Q4)
Objective: Understand margin impact, explore price adjustment options, and evaluate supplier alternatives
Tools Available: Shopify, Airtable (for COGS tracking), QuickBooks
Brand Voice: Informative, eco-conscious, practical, transparent

Additional Information

This prompt is perfect for finance managers, operations leads, eCommerce sellers, and product-based founders navigating rising input costs. It empowers your team to stay ahead of economic shifts by modeling cost fluctuations before they affect cash flow or pricing strategies.

Whether you manufacture in-house, rely on third-party vendors, or dropship globally, this prompt helps transform rising costs into manageable decisions with financial clarity and strategic foresight.

Ready to Dominate Your Business in 2025?

Get immediate access to...

30,000+ AI prompts

Marketing, business, copywriting, visuals & more.

How-to Guides & resources

Biggest collection of AI resources for your business success.

Unlimited updates

Your resources & knowledge grows, free of charge, forever.

Lifetime access

Highest priority support. Instant delivery.