User Account

All Pages

Discount on diesel fuel

Assignment Help Business Management
Reference no: EM131406437

Excel) A tollway truck plaza gives a discount on diesel fuel to truckers based on the total quantity they purchase. Which of the formulas below calculates the correct total price to charge a customer for the diesel pumped based on the following conditions:

  • no discount (zero dollars off the total due) if the trucker purchases less than 50 gallons of diesel
  • a 2% discount on all diesel purchased if the trucker buys at least 50 gallons of fuel

Assume that cell A1 shows the total quantity (in gallons) of diesel purchased and cell B1 is the price per gallon. The correct formula will calculate the total amount that the trucker should pay, after discount (if any) has been applied.

=IF(A1>50,A1*B1*98%,A1*B1)


=IF(A1<50,A1*B1,A1*B1-(A1*B1*98%))


=A1*B1*IF(A1<50,1,98%)


=A1*IF(A1<50,B1,2%*B1)

Reference no: EM131406437

Questions Cloud

How long does it take bob to clean the same place : Working together Jack and Bob can clean a place in 30 minutes. On his own, Jack can clean this place in 50 minutes. How long does it take Bob to clean the same place on his own?
What is a buffer overflow : 1. What is a buffer overflow? Use the Internet to find a well-known buffer overflow attack (therehave been several). In your own words, summarize how the attack works within a paragraph (please cite your source).
Describe the sql keyword like : Describe the SQL keyword LIKE and how it is used. Include a SQL statement that uses the KEYWORD LIKE based on the CUSTOMER table below:
Write a java program : Using these key parts, write a Java program that will allow a user of the program to assign only one runner to each of the 8 lanes of running track in a field.
Discount on diesel fuel : Excel) A tollway truck plaza gives a discount on diesel fuel to truckers based on the total quantity they purchase. Which of the formulas below calculates the correct total price to charge a customer for the diesel pumped based on the following co..
What change in design do you recommend based on your finding : What was learned from the accident (how can an event such as this be prevented in the future?) What specific changes in design, control, operation, training and/or regulation do you recommend based on your findings?
Why is ritualism central in all forms of religious worship : Webster dictionary gave a number of definitions of ‘Ritual': "a system of rites, a Ceremonial act or action, a customarily repeated often formal act or series of acts". In our everyday dealings there are different forms of actions taken that are r..
Automobile class for a dealership : Create an Automobile class for a dealership. Include fields for an ID number, make, model, color, year, vin number, miles per gallon, and speed. Include get and set methods for each field
Primary target of systems design : What is the primary target of systems design and what phases are included in the systems design?

Reviews

Write a Review

Business Management Questions & Answers

  Explain that experience to your classmates

Think about a time in your work personal or school experience where you have held a position that required you to use the Leading function. Explain that experience to your classmates

  Analyze the given poorly written letter

Analyze the following poorly written letter, and list its weaknesses. - You claim that the painting recently sent by Manhattan Galleries arrived with sags in the canvas and that you are unwilling to hang it in your company's executive offices.

  Ethical considerations in communication and crisis

How do ethical considerations impact an organization's communications process throughout a crisis? How does the choice of spokesperson impact the organization's credibility?

  Forecasting problem for tracking signalsthe tracking

forecasting problem for tracking signalsthe tracking signals computed using past demand history for three different

  Social performance of organizations

According to the textbook, the current world economy is increasingly becoming integrated and interdependent; as a result, the relationship between business and society is becoming more complex. Use the Internet to research Apple.

  Define whether ethel an intended beneficiary of the contract

Examine whether Ethel an intended beneficiary of the contract and You must explain who or what is an intended beneficiary in your analysis.

  Information technology in public health

Public health surveillance and prevention efforts in the U.S. reflect the involvement of numerous health care providers and organizations. Government agencies such as the CDC often function as a hub for the collection, coordination, and communicat..

  Examine persuasive requests and sales messages

Examine persuasive requests and sales messages. What traits do persuasive requests as well as sales messages share in common as well as how do they differ?

  Discuss the type of organization that you want to work

Argue for or against the necessity of strong communication skills in every type of organization. Discuss the type of organization that you want to work for in the future and why. Evaluate how having strong communication skills will help you within th..

  Restrain bargaining rights for public employees

1. Do you agree or disagree with Governor Walker' s move to restrain bargaining rights for public employees? Explain. 2. Based on the labor relations objectives discussed in chapter one (efficiency, equity and voice), what impact does Governor Walk..

  Recent developments occurred in international trade theory

Choose ONE of the following: EITHER "Whatever recent developments have occurred in international trade theory, in reality, the competitiveness of a location reflects the availability of resources in that location."

  Explain why are we spending billions of dollars on weapons

Explain why are we spending billions of dollars on weapons that don't work?" This is an example of which slanting device?

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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