MGMT 221 Entire Course of Embry Riddle Aeronautical University (ERAU) MGMT 221 Entire Course of Embry Riddle Aeronautica | Page 8

decisions relating to aviation fuel purchasing contracts. You will utilize the
Microsoft Excel application to create the DSS.
In this practical exercise, you are hypothetically employed as the IT Department
Manager at an imaginary Fixed Base Operator (FBO) located in Somewhere,
Kansas. You have been tasked to create a simple spreadsheet utilizing the Microsoft
Excel application that will be the primary component of a Decision Support System
(DSS).
The DSS spreadsheet will be utilized by the 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 Excel spreadsheet.
· Submit two "MIN" and two "IF" functions.
· Format cells with TWO decimal places.
· Format the spreadsheet per the steps below.
Read
More:
-
https://www.justquestionanswer.com/homework-solution-
details/61920/mgmt-221-week-2-assignment-help-2-case-study-embry-riddle-
aeronautical-university