HI, I am sorry to post this Q again because I could not understand the formula.
ID: 3806974 • Letter: H
Question
HI, I am sorry to post this Q again because I could not understand the formula. Also, the answer was different from the answer sheet that I should do this project on it.
this is the Q:
Number of Rentals
in cell h6, enter a formula to determine any discount that should be applied. if the payment method was express miles or reward, the customer should receive the discount shown in b24. if no discound should be applied, the formula should return a zero.
i could not understand how to put the formula????
Also, this part in cell j6, enter the correct formula to determine the cost of gas if the customer chose that option as indicated in colum i. and the total cost of k6
the answer should be loke is the box down
Amount of Discount
Express Car Rental Rentals Initiated in Week Starting 4/5/2015 Created by Jason Easton Auto Type Auto Id Date Rented Date Returned/or Expected Return #Days Rented Payment Method Daily Rate Amount of Discount Gas Option Cost of Gas Total Cost Green Collection 988 4/5/2015 4/8/2015 3 Credit Card $49.99 n Compact/Midsize 275 4/5/2015 4/10/2015 5 COD $76.49 n Compact/Midsize 277 4/9/2015 4/10/2015 1 Express Miles $76.49 n Green Collection 990 4/5/2015 4/6/2015 1 Credit Card $49.99 n Fullsize/Standard 350 4/5/2015 4/8/2015 3 Credit Card $84.99 y SUV/Minivan 550 4/5/2015 4/9/2015 4 Rewards $104.99 y SUV/Minivan 551 4/7/2015 4/10/2015 3 Credit Card $104.99 n Fullsize/Standard 352 4/7/2015 4/9/2015 2 Credit Card $84.99 y Green Collection 989 4/6/2015 4/9/2015 3 Credit Card $49.99 n Compact/Midsize 275 4/11/2015 4/18/2015 7 COD $76.49 n Fullsize/Standard 355 4/9/2015 4/16/2015 7 Credit Card $84.99 y Fullsize/Standard 356 4/6/2015 4/8/2015 2 Credit Card $84.99 y Fullsize/Standard 350 4/9/2015 4/13/2015 4 Rewards $84.99 y SUV/Minivan 553 4/8/2015 4/14/2015 6 Express Miles $104.99 y SUV/Minivan 550 4/11/2015 4/17/2015 6 COD $104.99 y Green Collection 988 4/9/2015 4/15/2015 6 Credit Card $49.99 n Green Collection 989 4/10/2015 4/16/2015 6 Express Miles $49.99 n Green Collection 990 4/7/2015 4/10/2015 3 Credit Card $49.99 n Fullsize/Standard 356 4/9/2015 4/10/2015 1 Rewards $84.99 n SUV/Minivan 551 4/11/2015 4/15/2015 4 Express Miles $104.99 y SUV/Minivan 554 4/7/2015 4/9/2015 2 Express Miles $104.99 y Fullsize/Standard 352 4/10/2015 4/11/2015 1 Credit Card $84.99 y Fullsize/Standard 356 4/11/2015 4/17/2015 6 Express Miles $84.99 y Compact/Midsize 276 4/11/2015 4/14/2015 3 Credit Card $76.49 n Compact/Midsize 277 4/11/2015 4/15/2015 4 Rewards $76.49 n SUV/Minivan 554 4/10/2015 4/12/2015 2 COD $104.99 y Green Collection 990 4/11/2015 4/18/2015 7 Express Miles $49.99 n Rental Rates Green Collection $49.99 Compact/Midsize $76.49 Fullsize/Standard $84.99 SUV/Minivan $104.99 Discount for Express Miles or Rewards 20% Cost to Fill Tank $65.00 Median Rental LengthNumber of Rentals
in cell h6, enter a formula to determine any discount that should be applied. if the payment method was express miles or reward, the customer should receive the discount shown in b24. if no discound should be applied, the formula should return a zero.
i could not understand how to put the formula????
Also, this part in cell j6, enter the correct formula to determine the cost of gas if the customer chose that option as indicated in colum i. and the total cost of k6
the answer should be loke is the box down
Amount of Discount
0%,0%,20%,0%,0%,20%,0%,0%,0%,0%,0%,0% like thisExplanation / Answer
For Column H use This Formula : =IF(F6="Express Miles",$B$42,0)
For Gas Cost Calculation: =IF(I6="y",$B$44,0)
Total Cost : =E6*G6*(1-H6)-J6
Express Car Rental Rentals Initiated in Week Starting 4/5/2015 Created by Jason Easton Auto Type Auto Id Date Rented Date Returned/or Expected Return #Days Rented Payment Method Daily Rate Amount of Discount Gas Option Cost of Gas Total Cost Green Collection 988 4/5/2015 4/8/2015 3 Credit Card $49.99 0% n 0 $ 149.97 Compact/Midsize 275 4/5/2015 4/10/2015 5 COD $76.49 0% n 0 $ 382.45 Compact/Midsize 277 4/9/2015 4/10/2015 1 Express Miles $76.49 20% n 0 $ 61.19 Green Collection 990 4/5/2015 4/6/2015 1 Credit Card $49.99 0% n 0 $ 49.99 Fullsize/Standard 350 4/5/2015 4/8/2015 3 Credit Card $84.99 0% y 65 $ 189.97 SUV/Minivan 550 4/5/2015 4/9/2015 4 Rewards $104.99 0% y 65 $ 354.96 SUV/Minivan 551 4/7/2015 4/10/2015 3 Credit Card $104.99 0% n 0 $ 314.97 Fullsize/Standard 352 4/7/2015 4/9/2015 2 Credit Card $84.99 0% y 65 $ 104.98 Green Collection 989 4/6/2015 4/9/2015 3 Credit Card $49.99 0% n 0 $ 149.97 Compact/Midsize 275 4/11/2015 4/18/2015 7 COD $76.49 0% n 0 $ 535.43 Fullsize/Standard 355 4/9/2015 4/16/2015 7 Credit Card $84.99 0% y 65 $ 529.93 Fullsize/Standard 356 4/6/2015 4/8/2015 2 Credit Card $84.99 0% y 65 $ 104.98 Fullsize/Standard 350 4/9/2015 4/13/2015 4 Rewards $84.99 0% y 65 $ 274.96 SUV/Minivan 553 4/8/2015 4/14/2015 6 Express Miles $104.99 20% y 65 $ 438.95 SUV/Minivan 550 4/11/2015 4/17/2015 6 COD $104.99 0% y 65 $ 564.94 Green Collection 988 4/9/2015 4/15/2015 6 Credit Card $49.99 0% n 0 $ 299.94 Green Collection 989 4/10/2015 4/16/2015 6 Express Miles $49.99 20% n 0 $ 239.95 Green Collection 990 4/7/2015 4/10/2015 3 Credit Card $49.99 0% n 0 $ 149.97 Fullsize/Standard 356 4/9/2015 4/10/2015 1 Rewards $84.99 0% n 0 $ 84.99 SUV/Minivan 551 4/11/2015 4/15/2015 4 Express Miles $104.99 20% y 65 $ 270.97 SUV/Minivan 554 4/7/2015 4/9/2015 2 Express Miles $104.99 20% y 65 $ 102.98 Fullsize/Standard 352 4/10/2015 4/11/2015 1 Credit Card $84.99 0% y 65 $ 19.99 Fullsize/Standard 356 4/11/2015 4/17/2015 6 Express Miles $84.99 20% y 65 $ 342.95 Compact/Midsize 276 4/11/2015 4/14/2015 3 Credit Card $76.49 0% n 0 $ 229.47 Compact/Midsize 277 4/11/2015 4/15/2015 4 Rewards $76.49 0% n 0 $ 305.96 SUV/Minivan 554 4/10/2015 4/12/2015 2 COD $104.99 0% y 65 $ 144.98 Green Collection 990 4/11/2015 4/18/2015 7 Express Miles $49.99 20% n 0 $ 279.94 Rental Rates Green Collection $49.99 Compact/Midsize $76.49 Fullsize/Standard $84.99 SUV/Minivan $104.99 Discount for Express Miles or Rewards 20% Cost to Fill Tank $65.00 Median Rental LengthRelated Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.