Refer to the Racquetball Racket case. From the corresponding exercise in Chapter 3, review the design of
Question:
Refer to the Racquetball Racket case. From the corresponding exercise in Chapter 3, review the design of a spreadsheet for this problem.
a. Develop a base case. You may create any data you need for this purpose.Why is this base case appropriate for this situation?
b. Perform an appropriate sensitivity analysis. Which parameters have the most significant impact on the results? Can you find applications for the Parametric Sensitivity, Tornado Chart, and Scenario Manager tools?
c. Identify applications of Goal Seek in this situation. (For example, what percentage of the market must they achieve to break even on their investment?)
d. Identify potential applications of optimization in this case.
e. Identify potential applications of simulation in this case.
Step by Step Answer:
Business Analytics The Art Of Modeling With Spreadsheets
ISBN: 9781119386490
5th Edition
Authors: Stephen G. Powell, Kenneth R. Baker.