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 importance and benefits of using critical thinking

Discuss the importance and benefits of using critical thinking. Relate the importance and benefits of critical thinking to the example provided. Discuss ways you might use critical thinking in your current job or chosen career path.

  What are the different types of 3pl firms

What are the different types of 3PL firms? Give examples. What are differences between 3PL and 4PL? What criteria must be used in selecting 3PL firms?

  Find the present value of an annuity

Find the present value of an annuity of $1,800, at the end of each quarter for 8 years after being deferred for 6 years, if the money is worth an annual rate of 8.8% compounded quarterly. Round your answer to the nearest cent.

  Explain how to relate it with law

The bus boy was mopping up a sill when consumer pushed him out of the way in her apparent haste to get to restroom. Explain how to relate it with law also illustrate what law it refers to?

  Optimal level of capital for the firm

a. What is the optimal level of capital for the firm? b. Suppose the corporate tax rate on accounting profits is 40%. The firm can include depreciation at the rate δ per year in its accounting costs, but not its financing costs. What is the optima..

  What is strategic management

What is strategic management? What role does strategic management play in the hospitality industry?

  Consider the notion of psychological size and assess the

consider the notion of psychological size and assess the specific recommendations open style of communication be

  The need for a centralized management structure that will

the need for a centralized management structure that will coordinate projects for organizations in the face of mounting

  Three-step ethics model

The physician you work for has trained you on a skill and is now asking you to perform the skill independently within the office, yet you know that this particular skill is outside of the scope of practice for an MA in your state.

  Influence is the ability to affect the behavior of others

influence is the ability to affect the behavior of others in a particular direction whereas power is the potential or

  Develop team cohesiveness

Explain how you would determine if it is a training issue or whether or not it is a performance-related issue.

  London school of economics report

The CBC covered a London School of Economics report as saying the "war on drugs [is] a global failure." They state the report offers "compelling evidence that achieving a 'drug-free world' based solely on a prohibitionist model is an expensive and..

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