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

Don lieberman and associates a cpa firm - Code of ethics comparative chart - I mart is a discount optical shop that can fill - Ju - Who gave harry potter the invisibility cloak - M4 Project: Autopsy Documentation Instructions - International Business - Discussion forum - Reply 1 and 2 ,150 words each one ,please add references and citations by 08/16 /2020 at 6:00 pm - Student information system rfp - Express rational functions as partial fractions - Old testament character sketch bible study - Dr simon benstock macquarie street - What is relation between cp and cv - Jazz styles history and analysis 9th edition - International Trade - Pcli lasik - Magnifica s warning lights - We have viewed how Blockchain has made a significant impact on businesses and industries. Select one industry and highlight the advancements Blockchain has had on that single industry. - 300mm cable gland size - The progressive movement drew its strength from - Esol progress assessment guidelines - Assignment 4 - Wheeled coach case study solution - R6 - White rabbit chocolate stout dan murphy - ECON 535 - What is trepanning in psychology - Domino's pizza product life cycle - Discussion: Treatment of Psychiatric Emergencies in Children Versus Adults (Week 6: Emergency Psychiatric Care in Childhood and Adolescence) - Bet hiphop awards seat fillers - America and i by anzia yezierska short story - Glo bus 3 year strategic plan sample - Hp deskjet 1510 paper jam - 1776 david mccullough study guide - Consider the following segment table - All holy night lyrics - Heart i want to make love to you - Gym vending machine products - Temple of jupiter pompeii reconstruction - Leadership begins with an inner journey - European huminities - We the people eleventh essentials edition - Needs Help- Financial Accounting - Phone calls arrive at the rate of - What is the adma code of practice - Macbeth quotes about power - Blackpool council bulky matters - Cranleigh gardens medical centre - Power point- Philosophical Concept - Joining parallel gable roofs - Reflections 01 - Surface tension of rubbing alcohol - Emergency department nursing orientation manual - Response to Classmates Discussions - Human pedigree analysis problem sheet answers - Operations and algebraic thinking lesson plans - Part 2: BRD - The bride comes to yellow sky sparknotes - ENTWISTLE REVIEW (CHAPTERS 8-11) - It is my pleasure to attend the event - The element from period iii with the largest atomic radius - Barium hydrogen phosphate formula - Bioecological model template - Homework - Is a compilation a nonattest service - APA Paper on Data Mining related to workplace - The phenol used in some mouthwashes and throat lozenges is - Literature Review - Tableau flights dataset - Gatesletter dotcom - Fine for supplying liquor to an intoxicated person - RS - Lina compra zapatos italianos en el centro - Kinematic equations of motion worksheet - The entity integrity rule requires that ____ - What is the paced decision making process - Ronald van der plaat - Lancashire grid for learning - Popular magazines rank colleges and universities on their academic quality - Infants and children prenatal through middle childhood edition - Chemistry inorganic qualitative analysis in the laboratory - King edward vi camp hill school for boys - What is a dress up in writing - I need accounting homeworkhelp - Twin screw extruder food processing - What is fortunato's weakness - Simpath american sentinel - Bromley novice bridge club - Heidenhain touch probe cycles - Negotiation skills for nurse leaders - Gen 499 general education capstone - Powder transfer system design - Disney values and mission statement - The knowers by helen phillips summary - Model hovercraft plans free - Cryptography - What is veracity in nursing ethics - Virtual desktop truman state - Beth and bob martin have total take home pay