ZuoTi.Pro
Question

In this practical exercise, you are hypothetically employed as the IT Department Manager at an imaginary Fixed Base Oper...

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 Excelapplication 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.

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 in non-bold font:

  • 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. The numerical values for each type of fuel must be different.

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.
business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

The spreadsheet is shown in the attached file:-

Formula Ban Split View Side by Side Ruler at Synchronous Scrolling Headings Gridlines Hide Normal Page Page Break Custom FullKINDLY RATE THE ANSWER AS THUMBS UP. THANKS A LOT.

3 0
Add a comment
Know the answer?
Add Answer to:
In this practical exercise, you are hypothetically employed as the IT Department Manager at an imaginary Fixed Base Oper...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Given the following demand and supply functions: P= $500-$10Qd and P=$100 + $20Qs (a) Set up...

    Given the following demand and supply functions: P= $500-$10Qd and P=$100 + $20Qs (a) Set up a table in excel to calculate the values of quantity demanded and supplied over the range of relevant prices (remember, think about the lowest and highest possible price in this market for your range; then determine what increments you would like to use. You shouldn’t use increments of 1 unit. Think about what would be more reasonable given your equations). (b). Highlight the row...

  • Using java : In this exercise, you need to implement a class that encapsulate a Grid. A grid is a useful concept in crea...

    Using java : In this exercise, you need to implement a class that encapsulate a Grid. A grid is a useful concept in creating board-game applications. Later we will use this class to create a board game. A grid is a two-dimensional matrix (see example below) with the same number of rows and columns. You can create a grid of size 8, for example, it’s an 8x8 grid. There are 64 cells in this grid. A cell in the grid...

  • Need help starting from question 9. I have tried multiple codes but the program says it is incorrect. Case Problem 1 Da...

    Need help starting from question 9. I have tried multiple codes but the program says it is incorrect. Case Problem 1 Data Files needed for this Case Problem: mi pricing_txt.html, mi_tables_txt.css, 2 CSS files, 3 PNG files, 1 TXT file, 1 TTF file, 1 WOFF file 0 Marlin Internet Luis Amador manages the website for Marlin Internet, an Internet service provider located in Crystal River, Florida. You have recently been hired to assist in the redesign of the company's website....

  • In this project, you will work with sales data from Top’t Corn, a popcorn company with...

    In this project, you will work with sales data from Top’t Corn, a popcorn company with an online store, multiple food trucks, and two retail stores. You will begin by inserting a new worksheet and entering sales data for the four food truck locations, formatting the data, and calculating totals. You will create a pie chart to represent the total units sold by location and a column chart to represent sales by popcorn type. You will format the charts, and...

  • EA6-A2 Complete a Depreciation Schedule for Furniture Resellers In this exercise, you will create a depreciation...

    EA6-A2 Complete a Depreciation Schedule for Furniture Resellers In this exercise, you will create a depreciation schedule for Furniture Resellers as of 12/31/2016 using an Excel table. You will then sort, filter, and analyze the data in the table. These fixed assets, with associated data as of 12/31/2015, were acquired prior to the current year. Fixed Asset Date of Cost Salvage Useful Life Accumulated Acquisition Value (years) Depreciation Machinery 1/1/2007 $8,200 $700 10 $6,750 1/1/2009 $8,400 Garage Equipment $11,000 $200...

  • Follow the directions below to create an Excel graph for a perfectly competitive company. A company...

    Follow the directions below to create an Excel graph for a perfectly competitive company. A company has total costs of 200+ 2000 - 2.5Q++ 1/3Q'. The price per unit is $500. Use excel to create a table to solve the problem as in question 5. Add two columns for average total costs and average variable costs. Create a graph for quantities from 1 to 25 that has ATC, AVC, MC, and MR on it. . Give the graph a title...

  • EA5-A2 Create a Bank Reconciliation for Tasters Club Corp. In this exercise, you will create a...

    EA5-A2 Create a Bank Reconciliation for Tasters Club Corp. In this exercise, you will create a bank reconciliation for Tasters Club Corp. for the month ended December 31, 2016. The reconciliation should be partly based on these figures: Bank Statement Balance (12/31/2016) equals $16,200; Notes Receivable equals $395; NSF Check equals $4,000; Bank Charges equals $550. During the month, the bank erroneously deposited a $505 check written to Pepper Products into the bank account of Tasters Club Corp. 1. Open...

  • Lab Exercise #15 Assignment Overview This lab exercise provides practice with Pandas data analysis library. Data...

    Lab Exercise #15 Assignment Overview This lab exercise provides practice with Pandas data analysis library. Data Files We provide three comma-separated-value file, scores.csv , college_scorecard.csv, and mpg.csv. The first file is list of a few students and their exam grades. The second file includes data from 1996 through 2016 for all undergraduate degree-granting institutions of higher education. The data about the institution will help the students to make decision about the institution for their higher education such as student completion,...

  • This worksheet will compute the monthly value of an amortized loan for 36 months. This will...

    This worksheet will compute the monthly value of an amortized loan for 36 months. This will be a worksheet in which the loan value or principal, interest rate, and monthly payment can be changed and the worksheet will automatically update. Within the worksheet there will be some absolute cell referencing that is needed and some relative cell referencing that is needed. You will need to determine which is appropriate. Title the worksheet "Amortization of Car Loan" in cell A1. Leave...

  • Excel Lab 2: Regression and Goal Seek In this lab, you will use Excel to determine...

    Excel Lab 2: Regression and Goal Seek In this lab, you will use Excel to determine the equation of the model which best fits a set of ordered pairs obtained from data sets. You will enter data, graph the data, find the equation for the regression model, and then use that equation to make predictions for the dependent variable. You will use the goal seek to make predictions for the independent variable. Then you will consider how accurate your predictions...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT