Data analytics Requirement

profilemahlawn1
KATInsurance2017-Data-TutorialONLY.xlsb.xlsx
Home>Business & Finance homework help>Management homework help>Data analytics Requirement

Main

Region State Salesperson Insurance Type Sales Date of Sale Invoice No State Type Variable Cost Percentage Variable Cost Contribution Margin Country
Southeast AR Frank Auto $ 935.25 11/8/17 A-2017-054995 AR-Auto USA
Southeast AR Frank Auto $ 691.93 10/13/17 A-2017-050573 AR-Auto USA
West CA Kellie Auto $ 861.89 5/19/17 A-2017-024590 CA-Auto USA
Midwest CO Paul Auto $ 447.15 12/3/17 A-2017-059464 CO-Auto USA
New England CT Crissy Auto $ 845.98 11/17/17 A-2017-056679 CT-Auto USA
Southeast FL John Auto $ 1,270.15 3/28/17 A-2017-015376 FL-Auto USA
Southeast FL John Auto $ 742.20 8/26/17 A-2017-041947 FL-Auto USA
Southeast AR Frank Disability $ 640.32 7/11/17 D-2017-033806 AR-Disability USA
West AZ Kellie Dissability $ 488.15 6/20/17 D-2017-030104 AZ-Disability USA
Midwest CO Paul Disability $ 327.04 4/12/17 D-2017-018015 CO-Disability USA
Northeast DC Matt Disability $ 451.57 6/16/17 D-2017-029374 DC-Disability USA
Southeast AL John Home $ 1,080.48 1/7/17 H-2017-001177 AL-Home USA
New England CT Crissy Home $ 662.19 2/15/17 H-2017-008234 CT-Home USA
Northeast DE Fred Home $ 591.06 2/6/17 H-2017-006570 DE-Home USA
Northeast DE Fred Home $ 1,065.46 12/31/17 H-2017-064472 DE-Home USA
West AZ Kellie Life $ 284.17 10/26/17 L-2017-052739 AZ-Life USA
West AZ Kellie Life $ 211.20 8/8/17 L-2017-038859 AZ-Life USA
Northeeast DE Fred Life $ 229.31 1/17/17 L-2017-002932 DE-Life USA
Southeast FL John Life $ 153.86 12/25/17 L-2017-063304 FL-Life USA
Southeast FL John Life $ 211.20 7/25/17 L-2017-036251 FL-Life USA
Southeast AL John Professional $ 1,141.53 1/7/17 M-2017-001122 AL-Professional USA
West AZ Kellie Professional $ 1,318.00 3/5/17 M-2017-011434 AZ-Professional USA
New England CT Crissy Professional $ 1,120.73 7/17/17 M-2017-034941 CT-Professional USA
Northeast DE Fred Professional $ 1,332.95 11/13/17 M-2017-056072 DE-Professional USA

VariableCostPct

State Type Variable Cost Percent
AL-Auto 0.58
AL-Disability 0.3
AL-Home 0.22
AL-Life 0.09
AL-Professional 0.29
AR-Auto 0.54
AR-Disability 0.27
AR-Home 0.26
AR-Life 0.11
AR-Professional 0.31
AZ-Auto 0.61
AZ-Disability 0.29
AZ-Home 0.18
AZ-Life 0.12
AZ-Professional 0.31
CA-Auto 0.53
CA-Disability 0.29
CA-Home 0.19
CA-Life 0.12
CA-Professional 0.17
CO-Auto 0.58
CO-Disability 0.28
CO-Home 0.23
CO-Life 0.12
CO-Professional 0.28
CT-Auto 0.51
CT-Disability 0.3
CT-Home 0.21
CT-Life 0.13
CT-Professional 0.27
DC-Auto 0.47
DC-Disability 0.26
DC-Home 0.25
DC-Life 0.11
DC-Professional 0.18
DE-Auto 0.38
DE-Disability 0.27
DE-Home 0.19
DE-Life 0.1
DE-Professional 0.28
FL-Auto 0.45
FL-Disability 0.32
FL-Home 0.22
FL-Life 0.12
FL-Professional 0.32
GA-Auto 0.38
GA-Disability 0.27
GA-Home 0.23
GA-Life 0.09
GA-Professional 0.25
IA-Auto 0.49
IA-Disability 0.27
IA-Home 0.25
IA-Life 0.09
IA-Professional 0.25
ID-Auto 0.58
ID-Disability 0.3
ID-Home 0.22
ID-Life 0.12
ID-Professional 0.14
IL-Auto 0.48
IL-Disability 0.31
IL-Home 0.25
IL-Life 0.1
IL-Professional 0.15
IN-Auto 0.35
IN-Disability 0.27
IN-Home 0.2
IN-Life 0.11
IN-Professional 0.3
KS-Auto 0.46
KS-Disability 0.32
KS-Home 0.22
KS-Life 0.12
KS-Professional 0.24
KY-Auto 0.52
KY-Disability 0.32
KY-Home 0.21
KY-Life 0.12
KY-Professional 0.2
LA-Auto 0.37
LA-Disability 0.32
LA-Home 0.2
LA-Life 0.12
LA-Professional 0.28
MA-Auto 0.37
MA-Disability 0.31
MA-Home 0.27
MA-Life 0.13
MA-Professional 0.28
MD-Auto 0.52
MD-Disability 0.26
MD-Home 0.23
MD-Life 0.1
MD-Professional 0.17
ME-Auto 0.47
ME-Disability 0.26
ME-Home 0.25
ME-Life 0.1
ME-Professional 0.16
MI-Auto 0.55
MI-Disability 0.27
MI-Home 0.2
MI-Life 0.1
MI-Professional 0.32
MN-Auto 0.54
MN-Disability 0.32
MN-Home 0.25
MN-Life 0.12
MN-Professional 0.32
MO-Auto 0.38
MO-Disability 0.29
MO-Home 0.21
MO-Life 0.09
MO-Professional 0.29
MS-Auto 0.44
MS-Disability 0.31
MS-Home 0.24
MS-Life 0.12
MS-Professional 0.16
MT-Auto 0.58
MT-Disability 0.28
MT-Home 0.21
MT-Life 0.11
MT-Professional 0.19
NC-Auto 0.5
NC-Disability 0.29
NC-Home 0.25
NC-Life 0.13
NC-Professional 0.26
ND-Auto 0.39
ND-Disability 0.27
ND-Home 0.25
ND-Life 0.1
ND-Professional 0.27
NE-Auto 0.52
NE-Disability 0.3
NE-Home 0.23
NE-Life 0.11
NE-Professional 0.29
NH-Auto 0.48
NH-Disability 0.31
NH-Home 0.26
NH-Life 0.13
NH-Professional 0.17
NJ-Auto 0.54
NJ-Disability 0.27
NJ-Home 0.18
NJ-Life 0.09
NJ-Professional 0.22
NM-Auto 0.36
NM-Disability 0.26
NM-Home 0.27
NM-Life 0.11
NM-Professional 0.14
NV-Auto 0.62
NV-Disability 0.28
NV-Home 0.18
NV-Life 0.13
NV-Professional 0.18
NY-Auto 0.46
NY-Disability 0.32
NY-Home 0.22
NY-Life 0.12
NY-Professional 0.17
OH-Auto 0.44
OH-Disability 0.26
OH-Home 0.23
OH-Life 0.09
OH-Professional 0.29
OK-Auto 0.44
OK-Disability 0.31
OK-Home 0.18
OK-Life 0.13
OK-Professional 0.26
OR-Auto 0.52
OR-Disability 0.26
OR-Home 0.25
OR-Life 0.09
OR-Professional 0.24
PA-Auto 0.42
PA-Disability 0.3
PA-Home 0.22
PA-Life 0.13
PA-Professional 0.18
RI-Auto 0.51
RI-Disability 0.29
RI-Home 0.27
RI-Life 0.11
RI-Professional 0.18
SC-Auto 0.62
SC-Disability 0.32
SC-Home 0.22
SC-Life 0.13
SC-Professional 0.14
SD-Auto 0.39
SD-Disability 0.29
SD-Home 0.17
SD-Life 0.1
SD-Professional 0.16
TN-Auto 0.45
TN-Disability 0.26
TN-Home 0.18
TN-Life 0.11
TN-Professional 0.24
TX-Auto 0.55
TX-Disability 0.31
TX-Home 0.22
TX-Life 0.11
TX-Professional 0.29
UT-Auto 0.48
UT-Disability 0.28
UT-Home 0.19
UT-Life 0.12
UT-Professional 0.21
VA-Auto 0.35
VA-Disability 0.32
VA-Home 0.23
VA-Life 0.13
VA-Professional 0.2
VT-Auto 0.55
VT-Disability 0.31
VT-Home 0.19
VT-Life 0.09
VT-Professional 0.26
WA-Auto 0.52
WA-Disability 0.27
WA-Home 0.26
WA-Life 0.1
WA-Professional 0.22
WI-Auto 0.57
WI-Disability 0.27
WI-Home 0.17
WI-Life 0.12
WI-Professional 0.16
WV-Auto 0.4
WV-Disability 0.28
WV-Home 0.23
WV-Life 0.09
WV-Professional 0.3
WY-Auto 0.52
WY-Disability 0.32
WY-Home 0.27
WY-Life 0.12
WY-Professional 0.16