User Account

All Pages

Create a dss component in the form of a spreadsheet

Assignment Help Management Information Sys
Reference no: EM132092729

Module Review: Practical Exercise-Instructions

A Decision Support System (DSS) is a tool utilized by managers to make informed decisions. It is important to understand the roles that DSSs serve in assisting executives and managers in evaluating business processes and making decisions that will guide the future for enterprises.

In this activity, you will create a DSS component in the form of a spreadsheet that will be utilized by the corporate Finance Department Manager to reach structured decisions relating to aviation fuel purchasing contracts. You will utilize the Microsoft Excel application to create the DSS.

Requirements

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.

Steps to Create Decision Support System.

In Row 1, create a header row with the following labels in bold font:

• Column A: Vendor Name

• Column B: Jet Fuel Price

• Column C: Avgas Price

In Column A, Rows 2 through 6, list the following vendors:

• Yellow Plains Fuel

• Okie Stokie Fuel

• Best Ever Fuel

• Smith Bros Fuel

• Wild West Fuel

In Columns B and C, Rows 2 through 6, enter imaginary pricing values for all vendors and both types of fuel, keeping the range of values between $5.00 and $10.00 for each type of fuel.

Format the cells in Columns B and C, Rows 2 through 6 as Currency with TWO decimal places.

• Label the cell in Column A, Row 8, "Best Jet Fuel Price" in bold font.

• Label the cell in Column A, Row 9, "Jet Fuel Vendor" in bold font.

• Label the cell in Column A, Row 11, "Best Avgas Price" in bold font.

• Label the cell in Column A, Row 12, "Avgas Vendor" in bold font.

Using Functions and Formulas

1. Using the MIN function, create a formula for the cell located in Column B, Row 8 that calculates the lowest value for the Jet Fuel pricing available from the five vendors.

2. Using the MIN function, create a formula for the cell located in Column C, Row 11 that calculates the lowest value for the Avgas pricing available from the five vendors.

3. Using nested IF functions, create a formula for the cell in Column B, Row 9 that places the name of the vendor determined to have the "Best Jet Fuel Price."

4. Select Align Right for the data in the cell located at Column B, Row 9.

5. Using nested IF functions, create a formula for the cell in Column C. Row 12 that places the name of the vendor determined to have the "Best Avgas Price."

6. Select Align Right for the data in the cell located at Column C, Row 12.

7. Select All Borders for the cells in Columns A, B, and C, Rows 1 through 12.

The following video offers valuable tips on how to create nested IF functions: Excel Nested IF function (YouTube 09:45)

Attachment:- Module Review.rar

Reference no: EM132092729

Questions Cloud

When the house was completed-contractor demanded : When the house was completed, the contractor demanded $48,000. The owner refused, and the contractor sued. NOTE: there was no written contract.
The implementation of an information systems technology : Where has a company benefited through the competitive advantage that was gained through the implementation of an information systems technology.
What state has personal jurisdiction : If a company is incorporated in Delaware and and an employee gets hurt in California, then later sues. What state has personal jurisdiction?
Identify the primary functions of a database : Identify the primary functions of a database and a data warehouse. Explain why enterprises need both of these data management technologies.
Create a dss component in the form of a spreadsheet : Create a DSS component in the form of a spreadsheet that will be utilized by the corporate Finance Department Manager to reach structured decisions.
Maintain a positive operating ration : What is the minimum yield on investments required in order to maintain a positive operating ration? (Lg 15-6)
What will be the change in the firm total : If the interest rate is 1% per month, what will be the change in the firm's total monthly profits on a present value basis if credit is offered to all customer
Prioritizing systems and functions for recovery : Selecting the DR team, assessing risks and impacts, prioritizing systems and functions for recovery, data storage and recovery sites.
What CMS does your business need : What CMS Does Your Business Need". This will be a fully cited, using Harvard referencing style, essay researched and authored

Reviews

Write a Review

Management Information Sys Questions & Answers

  What method of monitoring progress will you use

What method of monitoring progress will you use? What method of evaluation of success/failure will you use? What people need to be involved in planning the implementation of the solution?

  Compare and contrast sdlc and 2 other development models

When looking at the life span for the development of an application or system from the initial idea proposal through final deployment, there are several phases to accomplish. Several models examine the required phases along with tools to support e..

  What are the pros and cons of methods such as single sign-on

What are the pros and cons of methods such as Single Sign-On (SSO). Weigh the user benefits to security risks when considering the remote access methods.

  What is the motivation of the research

What related work has been performed? How the research was conducted, both how data were collected and analyzed?

  Research who in a typical organization should manage

Explain how the task can be delegated to others, and list the pros and cons of having multiple administrators manage the policies.

  How does data leakage occur in an organization

How does data leakage occur in an organization? What are the common causes of this problem?

  Determine fundamental business advantages of e-business

Determine the fundamental business advantages and disadvantages of e-business and e-commerce across the business organization.

  Business plan for a music school

Write a Business Plan - Imagine writing a business plan for a music school. Focus on the aspect of The Leadership (Management) Team/Human resources requirements

  Prepare presentation that discusses the industry challenge

Prepare presentation that discusses the industry challenge, the business case and specifics about the RFID system selected or recommended.

  Encryption methods for the available electronic services

You have been charged with the task of providing a report about the necessity of using encryption methods for the available electronic services to achieve a higher security level

  Identify the internal and external stakeholders

Identify the Internal and External Stakeholders.Discuss how internal or external stakeholders have influenced the situation in a positive or negative way?How will you consider stakeholders in your solution to the problem?How will you motivate individ..

  Examine the resume themes-letter themes-fax themes

Explain whether or not you believe including images in documents is a professional option when creating a document. Justify your response with at least one (1) example.Go to Microsoft Office's Website, and view the business templates. Examine the..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd