Input Area Cost Per Hour                $1500.00 Outage Duration (hours)    3 Output Area Total Cost for Outage     $4500.00   One-Variable Data Table: Cost Outage Impact Analysis  Duration  (hr)                                      (Cost) 1                                         $1500.00 1.5                                      $2250.00 2                                         $3000.00 2.5                                       $3750.00 3                                          $4500.00

Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
icon
Related questions
Question

Input Area

Cost Per Hour                $1500.00

Outage Duration (hours)    3

Output Area

Total Cost for Outage     $4500.00

 

One-Variable Data Table: Cost

Outage Impact Analysis 

Duration 

(hr)                                      (Cost)

1                                         $1500.00

1.5                                      $2250.00

2                                         $3000.00

2.5                                       $3750.00

3                                          $4500.00

3.5                                       $5250.00

4                                          $6000.00

4.5                                       $6750.00

5                                           $7500.00

 

Given the data above 

  • Which What If Analysis tool is the worksheet using?
  • Provide a description of the What If Analysis tool and why it was used in the worksheet.
  • Interpret what the data means.
  • Discuss what it means for the business.
Expert Solution
steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON