C 1 Region Midwest Auto 3 Southeast TN Olivia Auto E State Salesperson Insurance Type Sales TX Julio 865.37 521.76 G 4 New England CT Penelope Auto 5 New England MA Penelope Auto 6 Southeast GA Asher Auto 381.19 804.83 461.10 7 West UT Maria Auto 541.22 8 West NV Maria Auto 9 West WA Damon Auto 10 North Central MO 11 Southeast Raul Auto 422.18 924.25 393.57 MS Muhammad Auto 12 North Central MI Jamila Auto 13 New England ME Ivy Auto 14 West MT Damon Auto 15 Northeast DE Chris Auto 466.82 458.81 405.23 498.87 509.87 16 New England ME Ivy Auto 679.76 17 Southeast TN Olivia Auto 18 Midwest KS Julio Auto 652.57 509.17 19 Northeast OH Stella Auto 941.02 20 New England MA Penelope Auto 21 Midwest NE Julian Auto 22 Northeast VA 23 North Central KY Alex Auto Raul Auto 24 Northeast MD Chris Auto 487.65 1048.79 936.67 542.37 598.02 Date of Sale Invoice No State Type 1/1/2021 A-2021-000010 TX-Auto 1/1/2021 A-2021-000012 TN-Auto 1/1/2021 A-2021-000016 CT-Auto 1/1/2021 A-2021-000017 MA-Auto 1/1/2021 A-2021-000028 GA-Auto 1/1/2021 A-2021-000029 UT-Auto 1/1/2021 A-2021-000033 NV-Auto 1/1/2021 A-2021-000036 WA-Auto 1/1/2021 A-2021-000037 MO-Auto 1/1/2021 A-2021-000041 MS-Auto 1/1/2021 A-2021-000046 MI-Auto 1/1/2021 A-2021-000050 ME-Auto 1/1/2021 A-2021-000059 MT-Auto 1/1/2021 A-2021-000061 DE-Auto 1/1/2021 A-2021-000065 ME-Auto 1/1/2021 A-2021-000078 TN-Auto 1/1/2021 A-2021-000089 KS-Auto 1/1/2021 A-2021-000096 OH-Auto 1/1/2021 A-2021-000099 MA-Auto 1/1/2021 A-2021-000107 NE-Auto 1/1/2021 A-2021-000113 VA-Auto 1/1/2021 A-2021-000114 KY-Auto 1/1/2021 A-2021-000115 MD-Auto USA USA H M N P Q R S T U V W Variable Cost Percentage Variable Cost Contribution Margin Country 0 $ USA 0 USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA USA 25 Southeast FL Asher Auto 495.44 1/1/2021 A-2021-000117 FL-Auto USA 26 Midwest OK Julio Auto 542.37 27 North Central IA 28 Midwest Jamila Auto 779.84 TX Julio Auto 29 Northeast DC Alex Auto 30 North Central MN Jamila Auto 556.35 774.53 421.04 31 New England MA Penelope Auto 32 Southeast B3 Northeast GA PA Asher Stella Auto Auto 34 Southeast MS Muhammad Auto 339.98 1115.86 469.81 612.33 1/1/2021 A-2021-000122 OK-Auto 1/1/2021 A-2021-000124 IA-Auto 1/1/2021 A-2021-000128 TX-Auto 1/1/2021 A-2021-000139 DC-Auto 1/1/2021 A-2021-000142 MN-Auto 1/1/2021 A-2021-000145 MA-Auto USA USA USA USA USA USA 1/1/2021 A-2021-000146 GA-Auto 1/1/2021 A-2021-000153 PA-Auto 1/1/2021 A-2021-000154 MS-Auto USA USA USA 35 Northeast PA Stella Auto 997.76 1/1/2021 A-2021-000166 PA-Auto USA 36 Northeast NJ Chris Auto 586.57 1/1/2021 A-2021-000168 NJ-Auto USA 87 Southeast FL Asher Auto 416.46 1/1/2021 A-2021-000170 FL-Auto USA Sheet1 MainData VariableCostPct + State Type 87 RI-Auto Variable Cost Percent 0.55 88 RI-Disability 0.25 89 RI-Home 0.26 90 RI-Life 0.13 91 RI-Professional 0.19 92 SC-Auto 0.63 93 SC-Disability 0.30 94 SC-Home 0.22 95 SC-Life 0.17 96 SC-Professional 0.10 97 SD-Auto 0.39 98 SD-Disability 0.32 99 SD-Home 0.16 00 SD-Life 0.12 01 SD-Professional 0.15 02 TN-Auto 0.48 03 TN-Disability 0.28 04 TN-Home 0.17 05 TN-Life 0.11 06 TN-Professional 0.20 07 TX-Auto 0.57 08 TX-Disability 0.29 09 TX-Home 0.20 10 TX-Life 0.10 11 TX-Professional 0.31 12 UT-Auto 0.45 13 UT-Disability 0.25 14 UT-Home 0.20 15 UT-Life 0.15 16 UT-Professional 0.25 17 VA-Auto 0.38 18 VA-Disability 0.32 19 VA-Home 0.22 20 VA-Life 0.10 21 VA-Professional 0.21 22 VT-Auto 0.51 23 VT-Disability 0.28 2. Calculate the variable cost and contribution margin for each policy sold. (Hint: use a LOOKUP function or INDEX&MATCH to find the right variable cost percentage located in the second worksheet)