|
Home > Excel Catalog
>
Use Calc Plot Workbooks
To Plan Pricing Strategies
Are you planning to increase or decrease the price of a product?
Before you
act, you should know precisely where your unit sales
must be so
that your new profit margin is no worse than it is today.
These
Excel
workbooks provide that information.
 The charts
on this page tell you where your
new unit sales must be to leave your gross profits unchanged after you raise or lower prices.
Obviously, your unit sales must do better than staying even
if your new prices will make money for your company. But this chart provides the value that
you must beat.
This package includes two Excel workbooks. Both rely on the Stay-Even Formula for price
changes...
...which we explain in the article, Should You Raise Prices? Or Should You Lower Them?.
One workbook contains the completed reports that the article explains how to create.
Getting this workbook will save you the hours of work needed to duplicate the figures that
article describes.
The figure above shows one of the two displays that the first workbook contains.
 The
second workbook contains two equivalent figures designed to be printed on a full-size page.
The presentations in this workbook are designed to be used for actual pricing analysis.
Here's how you use either chart after you print it:
- Find your current gross profit margin on
the X axis.
- Run your finger tip up the chart until it touches the curve that represents the
percentage price increase or decrease that you're considering.
- Move your finger horizontally to the Y axis.
The percentage you find is your worst-case decrease in unit sales for a price increase, or
your minimum-required increase in unit sales for a price cut.
If you think that your price increase will cause unit sales to fall by a larger
percentage, or if your price cut won't increase sales by the required percentage, then you
probably shouldn't raise prices.
Calc Plots are superior to numeric calculations for brainstorming, because you can see
the results of all possible calculations easily. At a glance, you can balance the effects
changes in prices, margins, and sales volume. This isn't possible to do with numeric
calculations.
The price for this set of workbooks is only $19.95.
Important...
1. We have a one-year, unconditional
money-back guarantee.
2. We send
a receipt automatically. If your company needs a different
format to reimburse you for your purchase, we'll work to get you
what you need.
3. We respect your email
privacy.
|
Download your Product Pricing Calc Plots immediately...
 |
| Classic Excel (97 - 2003) |
$19.95 |
|
|
|
|
|
|
| Bundle with Both
Versions of Excel |
$29.95 |
|
The Excel workbooks will be delivered immediately in one Zip file.
 We
accept Visa, Mastercard, American Express, and Discover.
Here's some additional information about ordering:
If you need a receipt so that your company can reimburse you for your
purchase, please
let me know after you've purchased your workbooks.
If you have any problems downloading or un-zipping the file,
contact me immediately. I'll make sure to get you what you need.
Download your Product Pricing Calc Plots immediately...
|
|
| Classic Excel (97 - 2003) |
$19.95 |
|
|
|
|
|
|
| Bundle with Both
Versions of Excel |
$29.95 |
|
|
If
you don't already have Adobe Acrobat PDF Reader, you can
download a FREE copy here. You'll probably use it a lot.