Keywords: business, pricing, breakeven, product, price, performance, forecast, setting, improvement, excel, bizpep

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. Software is an xls file developed with Microsoft Excel and will run on all versions of Microsoft Excel and most other spreadsheet applications including Excel for Macs and the free open source OpenOffice spreadsheet. It is secure and safe, it does not include any macros or visual basic coding and cannot access your system in any way.