Universal Pricing Calculations for Excel.
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.
The user supplies two datasets, demand1@price1 and demand2@price2.
The program calculates elasticity of demand (change in demand for $1 change in price) and the price which yields the maximum profit.
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.
The third part of the program supplies a costing calculator for Excel. Input these unit cost values in the pricing calculators. |