Question: In this practical exercise, you are hypothetically employed as the IT Department Manager at an imaginary Fixed Base Operator (FBO) located in Somewhere, Kansas. Give

In this practical exercise, you are hypothetically employed as the IT Department Manager at an imaginary Fixed Base Operator (FBO) located in Somewhere, Kansas. Give an example of a simple spreadsheet utilizing the Microsoft Excelapplication that will be the primary component of a Decision Support System (DSS).

The DSS spreadsheet will be utilized bythe corporate Finance Department Manager to reach structured decisions relating to aviation fuel purchasing contracts. To be able to arrive at those decisions, the manager needs data that represents the pricing for two distinct types of aviation fuel, Jet Fuel, and AVgas, that is available from the five different vendors with which the company has accounts. The DSS should present the lowest pricing in U.S. dollars for each of the two types of aviation fuel along with the vendors that offer that pricing.

The following are the dashboard requirements:

  • Submit the DSS in a Microsoft Excelspreadsheet.
  • Submittwo "MIN" and two "IF" functions.
  • Format cells with TWO decimal places.
  • Format the spreadsheet per the steps below.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!