Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Decision support system dss using excel

26/11/2021 Client: muhammad11 Deadline: 2 Day

Module Review: Practical Exercise-2 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.

DSS Spreadsheet Example

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) (Links to an external site.)Links to an external site.

Module Review: Practical Exercise

-

2

Instructions

A Decision Support System (DSS) is a tool utilized by managers to make

informed decisions. It is important to understand the roles tha

t 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

Dep

artment 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

Module Review: Practical Exercise-2 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

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Professor Smith
Helping Engineer
Top Class Results
Top Academic Tutor
Top Essay Tutor
University Coursework Help
Writer Writer Name Offer Chat
Professor Smith

ONLINE

Professor Smith

I have read your project description carefully and you will get plagiarism free writing according to your requirements. Thank You

$47 Chat With Writer
Helping Engineer

ONLINE

Helping Engineer

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$48 Chat With Writer
Top Class Results

ONLINE

Top Class Results

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$22 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$23 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$47 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$48 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Microsoft excel cost estimate template - What is the main purpose of human life - Mesaure instruments - Total no of vedas - 32 inch haier tv $97 - Respiration - Computer Science - Moral lesson of around the world in 80 days - Advantages of joining the roman army - D1 - What is international marketing task - Lloydslink commercial banking online - How to behave in class essay - Herschel building newcastle university - Biology - The compass of shame nathanson 1992 - Loughborough accounting and finance - Casestdy - Nursing Theory Disc# 3 - Emerging contemporary readings for writers 4th edition free pdf - Communication between cultures 9th edition pdf - Discussion - Brookstone management concepts fairfield nj glassdoor - Why did orgo iron his four leaf clover answer - Variable length subnet mask - Watts and associates crop insurance - Cyclone tracy evacuation list - Tutor - Qnt 561 week 1 practice quiz - Jamestown primary source activity - Periodontal treatment consent form - Wilsons prom lighthouse accommodation - 2.05 bill of rights email - Profile essay - At&t inventory turnover - CMGT/445 - Www crewdock com ryanair - Discussion: Evaluating Use of Literature and Problem Statement - Ethical and legal Aspects of Nursing Practice Week 2 DQ 4 - In defense of mind body dualism - How to write a visual analysis art history - The five practices of exemplary leadership non profit barry posner - Criminal justice/affidavit/complaint offense#3 - Mcgraw hill connect economics quiz answers - Intercultural communication exam - Santa cruz biotechnology australia - How junk food can end obesity rhetorical analysis - Fox ntxr bite alarms - In freud's view an individual experiencing neurotic anxiety feels - Balmoral blues sequence dance script - I want someone to help me doing a spreadsheet for my final results of my research. - Using pestle analysis for a restaurant - SOCW 6103 Week 1 Assignment: Drugs of Abuse - Community Assessment - One – Group Assessment - Same-day 0833173182 JANE FURSE ABORTION CLINIC // PILLS,,,, - How to use steganography for creating digital watermarks - Big d custom screen printing - Dr david blacker neurologist - The doubt of future foes analysis - How to write a textual analysis essay - Digital cell phone inc case study solution - Factors affecting angle of repose - Lab Assignment 7: Genetics of Organisms - In 2016, who did the United States transferred the stewardship of the Internet Assigned Numbers Authority (IANA) to? Discuss the role or the IANA and how this move might effect internet services and security. - What is a case comment in law - Principal part of laurent series - Assignment 3 - What does lord of the flies symbolize - Ip identification field wireshark - Discussion post - Cost accumulation job order costing - You are working as an IT security manager at one of the resorts in the state of Hawaii. The financial controller of the resort wants to roll out PCI-DSS compliance program at the resort; - Microsoft Project Assignment 1 - Ties that bind ties that break - City of cape town electricity contact number - Freight car loadings over a 12 - Why does sam elliot tilt his head - Religious study, reflection paper2 - Budget - Pope innocent iv and the mongols - Wal mart information system - Scanning and monitoring global marketing environment - Journal Article Analysis - Ben and jerry's case study analysis - Qdx f px - Characters in that was then this is now - Sociology essay questions and answers pdf - Econ 101 offline homework 2 - Assignment01 - Competition within intermodal transportation - Employee engagement committee goals - Water cycle quiz printable - CASE STUDY - Sap pp training syllabus - Darden's global supply chains case study - Sister callista roy adaptation model ppt - The house of the scorpion chapter summary - Hw on Fallacies ( information system) - Experimental design template biology