Test price changes, determine optimum pricing and breakeven for your business. #Excel Addin #Excel Analysis #Excel Breakeven #Calculation #Breakeven #Excel
Pricing and Breakeven Analysis uses break even analysis to calculate your current business break even point using revenue, variable, and fixed cost inputs. This is combined with price elasticity (estimates for price and sales volume variations) to produce revenue and surplus (profit/loss) forecasts by price.
The model determines the Optimum Pricing to maximize your surplus and can be applied to new or established businesses, product/service lines, or individual items. It is compact, easy to use, and requires minimal inputs. Outputs include break even charts for Current, Increased, Decreased, and Optimum pricing.
Each break even chart is a graphical display of the break even analysis including the break even point considering price elasticity. Extended Price Analysis determines Optimum Pricing to maximize your business surplus. The Revenue, Surplus, and Number of Sales are calculated for prices ranging from -50% to +50% of the current price.
This addin smoothly incorporates break even analysis, break even points, break even charts and price elasticity that will help you determine the impact of your current pricing on your business and the optimum pricing.
System requirements
Limitations in the unregistered version
- Input for current performance values are limited to example business data
Pricing and Breakeven Analysis Excel 4.0
add to watchlist add to download basket send us an update REPORT- runs on:
- Windows All
- file size:
- 315 KB
- filename:
- pbae.zip
- main category:
- Others
- developer:
- visit homepage