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

Merrill lynch online trading - 8 shipwright place oyster bay - Multilayered process of family therapy - Lake press distribution pty ltd - Do appendices count in word count - Full range leadership development - Use the sales forecaster's prediction to describe a normal probability distribution - Career Counseling Presentation - Mystery and melancholy of a street - Kaolin and morphine asda - Case Dscumentation - Relationship between professional practices and scholarly ethics - Cry freedom summary chapter 1 - Error guessing is best used - Justice in ethics in nursing - Environmental science scavenger hunt - Informative speech about air pollution - Service-module wlan-ap 0 session - Collaborative conflict management in nursing - Tiling a patio math problem - Conservation of energy in charge interactions - 1. what do you notice about the options of each step as they go from number one up? - Concrete reinforcing mesh mitre 10 - Min zhan lu from silence to words - Difference between male and female communication style - Cos30020 - advanced web development - Al baik wikipedia - Kenneth brown is the principal owner - List of licensed employment agencies in hong kong - A critical assessment of business model research - Informative essay on michael jordan - Something fishy this way comes - Developing the leader within you 2.0 powerpoint presentation - Business Statistics - Shaver manufacturing inc offers dental insurance to its employees - Map of the hunger games districts - 8/46 warne terrace caloundra - The waiting sky oliver tarney lyrics - Prescribed corporate commonwealth entities - Signature 2 Texas Political - Breed of cow crossword - Gaddis landscape of history summary - Toms shoes number of employees - Since 1990, job and wage research has shown that as the price of computer technology plummets, - 7.03 ph - Boysen jensen experiment on phototropism - Affine cipher decryption example - Plan of care - Research paper 6pages - What is the proper preparation sequencing of the following budgets - Positive feedback in diabetes - High level requirements document - British army fieldcraft lesson plans - Chapter 5&6 discussion response - Chapter 8 interpreting histograms data analysis practice - Iris diaphragm microscope function - Writing logically thinking critically exercise 6a - D4 finance - Chapter 1 charlotte's web - Formula for sequence 1 0 1 0 1 0 - Concept mapping worksheet answers - How to install hwic card in cisco router - Cessna citation excel interior - Dolphin pool cleaner won t start - Ndis access request forms - Life is like a walking shadow - Readiness for enhanced breastfeeding nursing care plan - Questions1 - Nani poem by alberto rios - Miss marple the pale horse full episode - Bearing wholesalers wetherill park - Common base amplifier circuit diagram - 8-5 Project Part Two: Presentation - Wk2 DQ - Data Analysis & Business Intelligence - Transpose of matrix maple - All my sons george monologue - Vector addition experiment lab report - Crossways nursing home basingstoke - A fairly subtle approach to advertising is _____. - Acara gifted and talented - University of birmingham map - Argumentative - Properties of addition subtraction multiplication and division - FOR PROFESSIONAL RESEARCH WRITER ONLY - Online vitalsource com home sign in - Bruno from the boy in the striped pajamas description - Lm1881 sync separator circuit - Earth loop impedance test values nz - Help today statement of owner's equity - Basic business communication skills - Magdalena schmitz tax return solution - Walmart supplier sustainability questions for suppliers - Rhs level 2 past papers 2015 - Lorem Lorem - Iprofile - What is access pay - Importance of human resource information system - Example of scale in geography - Persuasive speech outline and speech - CAPSTONE PAPER