Universal Pricing Calculations for Excel. <P> The Universal Pricing Excel Spreadsheets calculate price - demand relationships and uses standard accounting formula to give you the exact price which will produce the maximum profit for any product. <P> The user supplies two datasets, demand1@price1 and demand2@price2. <BR> The program calculates elasticity of demand (change in demand for $1 change in price) and the price which yields the maximum profit. <P> The second part of the program calculates discount price required to create additonal demand that will sell unused spare capacity or stock at maximum profit. <P> The third part of the program supplies a costing calculator for Excel. Input these unit cost values in the pricing calculators. <P> Excel finds the exact Price which maximizes this standard profit formula: <P> Profit for period = Demand*Price (Revenues) - Demand*Unit Costs = Maximum value. <P> An easy way to understand the relationship of price - demand - profit for any product is to use the program to drive the Price - Demand - Profit schedule and charts provided. You will see that as prices start to rise in the chart, profits increase, reaching a maximum plateau, then decline as demand falls away. The program calculates the maximum price point of any product curve that produces the maximum profit <P> The Excel costing calculator works out unit product costs for the optimum pricing - profit calculations. <P> After purchase customers can submit a free web advertisement for inclusion in our financial web site which will reach all our customers. If you want to make new contacts internationally, this is a way forward. When you receive your email order confirmation, contact us with your order number and we will supply you with your login passwords to the free submit page. |
