Question 8 (4 points) Saved How many customers billed less than 8.5 service hours in the Green Lawns service ledger? 092 None of these 98 102 104 Question 9 (5 points) Saved What is the average hourly rate for government contractors in the Green Lawns service ledger? $23.55 $20.72 $28.55 None of theca Paste AY Merge & Center $ % ) ad - Conditional Format Formatting as Table Cell Styles LA F A1 foc fr B D E F G H K Total Charges for All Service Calls (without tax): Total Charges for All Service Calls (with tax): Code 1 2 Lookup Table Status Non-Government Government Sector Private Public Tax Rate 7% Service Hours Total Cost (w/o tax) Gov't Contract? Total Cost (with tax) Gov't Code 1 1 1 1 1 1 1 1 2 3 3 4 4 5 6 7 Customer 8 vase, Jason 9 vdams, Aaron 10 Nderks, David 11 Nexander, Velinda 12 Anderson, Alvin 13 nderson, Katherine 14 laker, Jean 15 larr, Deborah 16 lartlett, Emily 17 laxter, Nichelle 18 leler, Deborah 19 lexfield, Christopher 20 bills, Tamara 21 Hack, Brian 22 Blatter, Therron 23 Maylock, Glenn 24 Iradfield, Todd 25 ray, E. Lee 26 Briges, Kristen 27 Irinkerhoff, Alonzo 28 lushman, Michelle 29 Call, Lisa 30 Carling, Gregory 31 Chandler, Matthew 32 Christiansen, David 33 urtice, Brian 34 bangerfield, Anne 35 Dewey, John 36 Diazconti, Concepcion 37 Durrant, Camille 38 butson Sarah 1 1 1 1 1 1 1 Last Service Date Base Fee 8/22/12 $ 43.20 8/20/12 $ 21.33 8/19/12 $ 41.55 8/7/12 $ 31.67 8/23/12 $ 44.10 8/17/12 s 26.02 8/20/12 $ 33.85 8/31/12 $ 36.86 8/15/12 $ 31.60 8/20/12 $ 28.96 8/12/12 $ 37.97 8/11/12 $ 29.82 8/3/12 $ 27.46 8/20/12 $ 34.49 8/29/12 $ 42.96 8/21/12 $ 37.80 8/5/12 $ 21.25 8/5/12 $ 27.34 8/29/12 $ 29.29 8/31/12 $ 26.99 8/22/12 $ 21.90 8/29/12 $ 43.23 8/10/12 $ 23.13 8/17/12 $ 29.74 8/23/12 $ 27.10 8/18/12 $ 23.14 8/6/12 $ 42.94 8/29/12 $ 35.85 8/5/12 $ 37.03 8/12/12 $ 43.10 8/29/12 s 32 34 Hourly Rate 11.2 $ 16.55 8.4 $ 28.41 5.5 $ 29.06 10.8 $ 25.30 7.6 $ 14.73 7.9 $ 28.87 7.8 $ 11.63 10.9 $ 11.76 11.9 $ 17.41 3.6 S 28.05 7.9 $ 16.70 10.3 $ 15.53 10.5 $ 30.91 9 $ 29.37 3.3 $ 30.35 11.5 $ 23.02 1.7 $ 25.70 4.2 $ 25.62 4.8 $ 27.48 4.1 $ 19.46 7.5 $ 13.64 8.3 $ 16.92 2.1 $ 12.90 1.5 $ 26.14 9.4 $ 27.11 6.4 $ 27.79 3 $ 3 13.33 6.6 $ 28.10 7 $ 12.02 20.09 118 27.49 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 . 10.4 %