Imaginary pricing values for all vendors

Assignment Help Business Management
Reference no: EM131616255

Using Excel

DSS spreadsheet utilizing the following steps:

In Row 1, Make 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
  • Royal Canadian 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, Make 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,Make 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, Make a formula for the cell in Column B, Row 9 that places the name of the "winning" vendor for the "Best Jet Fuel Price."
  4. The following video offers valuable tips on how to create nested "IF" functions:
  5. Excel Nested IF function (YouTube 09:45) (Links to an external site.)
  6. Links to an external site.
  7. Select "Align Right" for the data in the cell located at Column B, Row 9.
  8. Using nested "IF" functions, Make a formula for the cell in Column C. Row 12 that places the name of the "winning" vendor for the "Best Avgas Price."
  9. Select "Align Right" for the data in the cell located at Column C, Row 12.
  10. Select "all Borders" for the cells in Columns A, B, and C, Rows 1 through 12.

Reference no: EM131616255

Questions Cloud

Method of centralizing the responsibility for monitoring : If a company utilizes the intracompany method of centralizing the responsibility for monitoring
Leading and collaborating in a competitive world : Title: Management: Leading and Collaborating in a Competitive World
Outcome of the negotiation : Conduct a light research on the role of emotion in negotiation process, and the effect it has on the outcome of the negotiation.
Summarize the principle evaluation criteria among the grants : Research evaluation criteria for any three grants, then summarize the principle evaluation criteria among the three grants.
Imaginary pricing values for all vendors : 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.
Prepare two objectives designed to attain the program goal : Prepare two objectives designed to attain the program goal. Develop a one sentence goal statement that directly relates to the identified community problem.
Seems like the manager has to walk a thin line : Seems like the manager has to walk a thin line, doesn't it? If you're doing well, why not just say so?
Member of the company on our behavior : In regards to subordinate evaluations, how would you like to be evaluated by a member of the company on our behavior, attitudes, and methods
What is the value of the company equity : What is the value of the company's equity? What is the total value of Icarus?

Reviews

Write a Review

Business Management Questions & Answers

  Cloud computing by the promise of greater

Companies are lured to cloud computing by the promise of greater efficiency and higher profits. Blue Cross of Pennsylvania has enabled its 300,000 members to access medical histories and claims information with their smartphones.

  Effective performance management

________________________means effective performance management helps the organization achieve its business objectives. It does this by helping to link employees behavior with the organizations goals.

  Fire department a private good

Do you consider your local fire department a private good or a public good? What is the difference between a public good and a private good? What are the principal characteristics of each? Why is there a free rider problem when it comes to public ..

  Four types of training objectives

1. List and define the four types of training objectives, and give an example of each. Your examples must include the objective's desired outcome, conditions, and standards.

  Office for her annual wellness checkup

Stephanie Lewis comes to your office for her annual wellness checkup. As the healthcare professional who will be doing her initial interview.

  Challenges of public sector collective bargaining

Discuss right to strike and its impact on private and public employees. Identify and explain some of the challenges of public sector collective bargaining.

  Analyze and illustrate one of the three portfolio approaches

Describe and illustrate one of the three portfolio approaches. Explain why a business would choose a low cost, differentiation, or speed-based strategy. Conduct a strategic analysis and choice for a multi-business company.

  Question progressive home health care inc is a for-profit

question progressive home health care inc. is a for-profit provider of home health care services in the pacific

  Effects with a single click

1. The Illustrations group is found on the ________tab. 2. When you select a graphic, _________are found on the corners and sides. 3. In Excel, a(n) ___________ is a picture of any part of the screen in an open applic..

  Implement the management functions

3) Describe how you would use Supply and Demand to determine what products/services you would provide. Include how this has affected how you priced your product/service. 4) Describe your company's Strategic Plan. Include a SWOT analysis (list at leas..

  Today human resources managers

Describe the workforce shifts in types of jobs during the past 100 years. What implications have these shifts created for today's human resources managers?

  Someone who occupies a particular job

Legitimate power belongs to someone who occupies a particular job, office, or position in an organizational hierarchy. Discuss the difference between power and authority; then, present a scenario/situation where it is preferable to utilize legitim..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd