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

Data flow diagram microsoft - As tall as a giraffe simile - Strategic group map airline industry - Teaching doubles plus one - Cromer beach car park - Human cardiovascular physiology blood pressure and pulse determinations - Jetblue and the veterans administration case study - Sennoside docusate 8.6 50 mg tablet - Assignment on financial statement ratio analysis - Assignment 3 inferential statistics analysis and writeup umuc - Define the key biographical characteristics - Psychotherapy With Individuals - Zeus poseidon and hades - Elastic strength of rectangular beam - Review on hbr course pack - Difference between rotodynamic and positive displacement pump - Week 4 - Delta signal balanced scorecard - Unit II Assignment - Wk8 Discussion SOCW 6443: The Use of Stimulants in the Treatment ADHD - Iago jealous of othello quotes - Painting double hung windows - Johnson & johnson case analysis - Student exploration calorimetry lab answers activity b - 300 words essay - Vcaa spec formula sheet - Iec s wind class - Dictum definition to kill a mockingbird - Motor velocity constant kv - Characteristics of shakespeare comedy - Gale force surfing case solution - Exploring science working scientifically 7 worksheets answers - Drivers theory test wa - Hack wep wifi windows - Characteristic x rays of copper - 4 nations consultancy sydney - Case studies poor nursing documentation - Http www hhmi org biointeractive virus explorer - Quickness's references Sheet 1 page - Why we work by andrew curry essay - Course Reflection - ZARA - Hemophilia pedigree with genotypes - Eso splash the weakened hunters - Realities cold cast bronze - HRM 533 Week 6 Total Rewards/ Total Rewards Systems Proposal - Jotun balloxy hb light - RQ 2 - What is the role of the trna - GC MGT605 Week 2 Assignent - Learning outside the classroom theory - Business ethics laura hartman pdf - Bathurst district cricket association - Van gogh's paintings are very controlled - Eight steps to integrating evidence based practice - Debtors anonymous uk meetings - Area of cylinder without top and bottom - Castle bromwich infant school - WEEK 4 - Week one discussion fund of data systems - Al kitaab part 2 - Synthesis of fe acac 3 from fecl3 - My brother sam is dead questions - Jeremy's a handbag manufacturer in lower manhattan - Series circuit sample problems - What is a gp visit card - Kent edu au moodle - Deprive of courage crossword clue - Flashbacks in the story of tom brennan - Mirvac land for sale - Derbyshire county council blue badge - Star test spherical aberration - The dales way association - Cotton root rot resistant trees - Discussion / Answer 2 questions and comment on 2 students / 200~300 words for answers / need in 4 hours - Panera bread strategic analysis - Analogous structures are evidence of - Periodic table of spectra - Week 5 Reflection - What is google's reasoning for collecting your personal information - Stitch fix target customer - HLS685 D3 - Leaf spring power hammer - 755 bus timetable mount druitt - Hands on networking fundamentals 2nd edition answers - Sandlands wine for sale - Faith hill videos youtube - Sats reading paper 2015 - Heights of statistics students were obtained by a teacher - Rochester concrete products prices - Trap karaoke raleigh the ritz december 7 - Jean watson caring theory in practice - Guess the sweet quiz - Unsw christmas shutdown 2021 - Happy bank starts with in bank capital - Santa monica college deadlines - Wingate proxy server 7.3 0 crack - Molecular weight of zinc gluconate - Consider the following transactions for huskies insurance company - Data security and privacy information technology