Sales template
Pricing Scenario Template
Test what happens if you raise or lower prices. Each scenario shows revenue and profit side by side.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Scenario | Price | Volume | Unit cost | Revenue | Profit |
| 2 | Low | 79 | 1,300 | 30 | =B2*C2 | =E2-C2*D2 |
| 3 | Base | 99 | 1,000 | 30 | =B3*C3 | =E3-C3*D3 |
| 4 | High | 129 | 700 | 30 | =B4*C4 | =E4-C4*D4 |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
E2 =B2*C2
Price times expected volume.
F2 =E2-C2*D2
Revenue minus total unit cost.
Make it yours by asking
Try a request like this in Tabstra:
"Create a pricing scenario sheet comparing low, base and high price with expected volume, unit cost, revenue and profit"