Please write down excel formula for following question

customers have paid 9 cents a gallon for the first 100,000 gallons used each month , and 7 cents per gallon for each gallon beyond the first 100,000

For the current rate structure ( base rate 0.09 / gallon , cutoff at 100,000 gallon , and $ 0.07 / gallon thereafter ) Enter the data into the worksheet ( 0.09 , 0.07 , 100000 ) in B20 . B22 . Develop the fomula that will compute the amount due by a customer , referring to the cells that contain the data . Enter the formula for Baxter in 02. Always use cell references in your formula avoid typing in values ) . Use absolute referencing whenever required

D E A 1 Company 2 Baxter Mining Co. 3 Lloyd's Laundry 4. Davis Metal Inc. 5 Finest Foods Corp. 6 Builders Block Co. 7 Adams Toy Mfg. 8 Norris Milling Co. 9 Webster Windows 10 Central Paper Co. 11 A-1 Rubber Prods. 12 Winco Fabricators 13 Landes Mfg. Inc. 14 15 16 17 18 19 VARIABLES 20 base rate 21 tiered rate 22 cutoff value B Volume Billed Amount 182755 618324 76382 127391 268310 47383 57293 94383 139726 312094 37290 93271 0.09 0.07 100000