Pricing and Breakeven Analysis Excel will determine the impact of a price change on your business. It calculates current breakeven points using revenue, variable cost, and fixed cost inputs. These are combined with 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 Breakeven Charts for Current, Increased, Decreased, and Optimum pricing. Analysis determines the Optimum Price to maximize your business surplus, and the Revenue, Surplus, and Number of Sales are calculated for prices ranging from -50% to +50% of the current price.
|