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
Get step-by-step solutions from verified subject matter experts
