home *** CD-ROM | disk | FTP | other *** search
-
- Problem You enter 5 variables (unit sales, price, price erosion rate,
- unit cost, variable cost learning rate, and total fixed costs)
- and this worksheet produces a 100 period breakeven analysis
- that is conducize to graphic analysis.
-
- Block Diagram
- ___________________
- | |
- | Input area |
- | |
- |-------------------|
- | |
- | Breakeven |
- | Analysis |
- | |
- | |
- | |
- |-------------------|
-
- Tips
- Good model design that maximizes "what-if" potential.
-
- Window split vertically slowing down scroll speed.
- Fix by clearing windows (/wwc) and issuing Titles command
- (/wtb) at cell B19.
-
-
-
-
-
-
-
-
-
-
-
-