III. What-If-Analysis (Part One) (10%)

  1. Copy the calculation sheet to a new sheet
    and name the new sheet as "what-if-data".
  2. Type the following question at cell A18:
    How much of the total donation will be
    if you change the minimum profit for donation
    (at cell G15) from 5000 to 9500?
  3. Type the following question at cell A19:
    The new total of donations is __________
  4. Find the answer for the above question and
    type the answer at the location of cell A20.
Go to Next Page