Prompt Details
Model
Chat - (gpt-5.6)
Token size
499
Example input
[BUSINESS_TYPE]: Neighborhood Coffee Shop
[HISTORICAL_SALES_DATA]: Monthly revenue from January–December 2025: ₹4.2L, ₹4.0L, ₹4.5L, ₹4.8L, ₹5.1L, ₹5.4L, ₹5.0L, ₹5.3L, ₹5.7L, ₹6.0L, ₹6.4L, ₹7.0L
[TIME_PERIOD]: January–December 2026
[GROWTH_FACTORS]: Introduction of a breakfast menu, 12% increase in local digital advertising, and a new delivery partnership
[TARGET_GOAL]: ₹78 lakh annual revenue
Example output
## Section 1: Trend Summary
The coffee shop generated **₹63.4 lakh in 2025**, increasing from ₹4.2 lakh in January to ₹7.0 lakh in December—an approximately **67% increase** across the year. Sales show a clear upward trend with moderate month-to-month volatility, while **November–December are the strongest months**, suggesting a seasonal year-end uplift.
**Important data note:** Actual January–December 2026 sales were not provided. Therefore, I am using the **2025 monthly sales as the base pattern** and applying scenario-based growth assumptions for 2026. These growth assumptions are estimates, not historical facts.
### Key forecast drivers
* **Breakfast menu:** Expected to increase morning transactions and average daily sales.
* **12% increase in local digital advertising:** The advertising budget is known, but the resulting sales uplift is not; therefore, its revenue impact is estimated.
* **New delivery partnership:** Provides an additional sales channel and potentially expands the customer catchment area.
* **Seasonality:** The strong Q4 pattern from 2025 is retained in all scenarios.
* **Risks:** Delivery commissions, customer acquisition costs, local competition, food inflation, and whether the breakfast menu actually attracts incremental customers rather than shifting existing purchases.
---
## Section 2: Forecast Table
**All figures below are ₹ lakh.**
| Scenario | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Annual |
| ---------------- | ---: | ---: | ---: | ---: | ---: | ---: | ---: | ---: | ---: | ---: | ---: | ---: | -------: |
| **Conservative** | 4.62 | 4.40 | 4.95 | 5.28 | 5.61 | 5.94 | 5.50 | 5.83 | 6.27 | 6.60 | 7.04 | 7.70 | **69.7** |
| **Expected** | 5.17 | 4.92 | 5.54 | 5.90 | 6.27 | 6.64 | 6.15 | 6.52 | 7.01 | 7.38 | 7.87 | 8.61 | **78.0** |
| **Optimistic** | 5.54 | 5.28 | 5.94 | 6.34 | 6.73 | 7.13 | 6.60 | 7.00 | 7.52 | 7.92 | 8.45 | 9.24 | **83.7** |
### Scenario assumptions
| Scenario | Assumption | Rationale |
| ---------------- | ----------------- | ------------------------------------------------------------------------------------------------------------------------------ |
| **Conservative** | **+10% vs. 2025** | Existing business grows modestly; breakfast and delivery generate limited incremental demand. |
| **Expected** | **+23% vs. 2025** | Breakfast menu, increased digital advertising and delivery partnership work reasonably well together. |
| **Optimistic** | **+32% vs. 2025** | Strong customer response to breakfast, advertising converts efficiently, and delivery produces substantial incremental orders. |
**Calculation logic:** Each 2025 monthly figure is multiplied by the applicable scenario growth factor. For example, Expected January = ₹4.2L × 1.23 ≈ **₹5.17L**.
The **+23% Expected scenario is an estimate**, not a data-backed measurement of the three initiatives. Actual performance should be recalibrated once 2026 monthly sales and campaign/delivery data become available.
### Red flags / missing data
1. **Actual 2026 monthly revenue is missing** — this is the biggest limitation.
2. No historical data on **customer count, average order value, transactions/day, or delivery orders**.
3. The 12% advertising increase tells us spending, but not **incremental revenue or ROAS**.
4. Breakfast-menu contribution has not been tested.
5. Delivery partnership revenue should be evaluated **net of commission and discounts**, not simply gross sales.
---
## Section 3: Gap-to-Target Analysis
**Target = ₹78 lakh annual revenue**
| Scenario | Forecast Revenue | Gap vs. ₹78L Target | Status |
| ------------ | ---------------: | ------------------: | ---------------- |
| Conservative | **₹69.7L** | **-₹8.3L** | At risk |
| Expected | **₹78.0L** | **₹0L** | **On track** |
| Optimistic | **₹83.7L** | **+₹5.7L** | Exceeding target |
The **Expected scenario reaches the ₹78 lakh target almost exactly**, representing approximately **23% growth over the 2025 revenue of ₹63.4 lakh**.
However, because the Expected case depends on estimated rather than observed incremental effects from breakfast, advertising, and delivery, I would classify the target as **on track but requiring active monitoring**, rather than guaranteed.
---
## Section 4: Action Plan
* **Measure each growth channel separately:** Track breakfast sales, delivery orders, average order value, repeat customers, and advertising-attributed revenue every month. This will reveal which initiative is actually producing incremental revenue.
* **Concentrate marketing around high-opportunity periods:** Use the 2025 seasonal pattern to increase promotional activity before and during the stronger **October–December** period, while using breakfast promotions to strengthen weaker months.
* **Optimize delivery economics:** Don't judge the partnership only by gross sales. Track **net revenue after commissions, discounts and packaging costs**, and promote high-margin products through the delivery channel.
### Strategic recommendation
**Build the 2026 forecast as a driver-based model rather than relying only on percentage growth.** The most valuable next step is to forecast **transactions × average order value** separately for dine-in, takeaway, breakfast and delivery. This will make the ₹78 lakh target much easier to defend to an investor or stakeholder—and will show *exactly* what needs to happen operationally to reach it.
Get this prompt + 9 more with Select$14 first month, then $19/mo · Cancel anytime$14 first month · then $19/mo
View SelectBy purchasing this prompt, you agree to our terms of service
GPT-5.6
Turn historical sales data into a realistic, decision-ready monthly revenue forecast with AI.
This advanced sales forecasting prompt acts like a senior Financial Analyst and Sales Forecasting Consultant, helping business owners, founders, finance teams, and managers transform historical sales information into practical revenue projections.
Instead of producing a single optimistic number, the prompt creates three forecast scenarios — Conservative, Expected, and Optimistic
...more
Added 2 weeks ago
