# module review activity, you will submit a microsoft excel

Module Review activity, you will submit a Microsoft Excel spreadsheet. Your instructor will use the rubric attached to this assignment to grade your work. You will create a Decision Support System (DSS) using Excel.( Microsoft® Office 365)

This practical assignment, you are to create a simple spreadsheet utilizing Excel or a compatible application that will be the primary component of your DSS. You are the IT Department Manager employed by an imaginary Fixed Base Operator (FBO) located in Somewhere, Kansas.

The DSS that you create 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 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.

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:

·         ABC Fuel

·         Midwest Fuel

·         Texas Wildcat Fuel

·         KC 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 the “IF” function, create a formula for the cell in Column B, Row 9 that places the name of the “winning” vendor for the “Best Jet Fuel Price.”

1. Select “Align Right” for the data in the cell located at Column B, Row 9.
2. Using the “IF” function, create a formula for the cell in Column C. Row 12 that places the name of the “winning” vendor for the “Best Avgas Price.”
3. Select “Align Right” for the data in the cell located at Column C, Row 12.
4. Select “all Borders” for the cells in Columns A, B, and C, Rows 1 through 12.
6. (Last Name, First Initial) MGMT 221 Module Review Part 2 Practical Mod 2.xlsx

(Last Name, First Initial) Module Review Part 2 Practical Mod 2.xlsx

Rubric

Module Review Part 2 Practical Exercise Rubric (Module 2)

Module Review Part 2 Practical Exercise Rubric (Module 2)

Criteria

Ratings

Pts

Calculations

 Excellent (A) 64 to 70 points – Almost all of the problems are calculated correctly. 70.0 pts Satisfactory (B) 58 to 63.4 points – Most of the problems are calculated correctly. 63.4 pts Passing (C) 52 to 57.9 points – Some of the problems are calculated correctly. 57.9 pts Near Failing (D) 47 to 51.9 points – Very few of the problems are calculated correctly. 51.9 pts Failing (F) 0 points – Problems are calculated incorrectly. 0.0 pts

70.0 pts

Procedures/ Rational

 Excellent (A) 18 to 20 points – Uses the best rationale and/or required procedures/formulas/tools to solve almost all of the problems. 20.0 pts Satisfactory (B) 16 to 17.9 points – Uses satisfactory rationale and /or required procedures/formulas/tools to solve most of the problems. 17.9 pts Passing (C) 14 to 15.9 points – Uses satisfactory rationale and/or required procedures/formulas/tools to solve some of the problems. 15.9 pts Near Failing (D) 11 to 13.9 points – Does not use satisfactory rationale or required procedures/ formulas/tools to solve the problems. 13.9 pts Failing (F) 0 points – Used incorrect formulas and tools. 0.0 pts

20.0 pts

Presentation of Data

 Excellent (A) 8 to 10 points – Data is clearly presented and overall assignment is well formatted. 10.0 pts Satisfactory (B) 6 to 7.9 points – Data is clearly presented with some errors in overall formatting. 7.9 pts Passing (C) 4 to 5.9 points – Some data is not presented clearly and some errors in overall formatting are observed. 5.9 pts Near Failing (D) 2 to 3.9 points – Data is not clearly presented and overall formatting of assignment is poor. 3.9 pts Failing (F) 0 points – Did not present data and results. 0.0 pts

10.0 pts

Total Points: 100.0

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Nursing
poor service
Customer 453627, January 24th, 2020
Entertainment & Gaming
Great work.
Customer 452441, April 29th, 2022
Military
Good work.
Customer 456821, May 18th, 2022
Statistics
Thank you for your neat and precise work, very professional
Customer 462485, May 22nd, 2022
Education
Be keen on plagiarism.
Customer 454463, March 28th, 2022
Always heed to the customer's perspective and aim at error-free content.
Customer 452441, March 28th, 2022
Home Repair & Home Maintenance
Great work
Customer 452441, April 21st, 2022
Criminal Justice
this is an excellent paper
Customer 454221, April 3rd, 2020
Education
Customer 463875, April 29th, 2023
SEO
good
Customer 463813, March 8th, 2023
Ethics
Thank you!!!
Customer 454087, June 19th, 2020
Military
good job
Customer 456821, November 21st, 2021
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend