Microsoft Office Tutorials and References
In Depth Information
Exhibit 1.5
Improved workbook—brain
The heart of the workbook, the Analysis worksheet in Exhibit 1.6, simulates indi-
vidual scenarios of P/L Net Income based on randomly generated values of uncertain
parameters. The determination of these uncertain values occurs off the screen image
in columns N, O, and P. The values of sales volume, sales price, and COGS percent-
age are selected fairly (randomly) and used to calculate a Net Income . This can be
thought of as a single scenario: a result based on a specific set of randomly selected
Exhibit 1.6
Improved workbook—analysis
Search JabSto ::




Custom Search