How can I calculate variable cost, variable cost percentage ,and contribution margin for each policy sold. using Vlookup or other startegies.
.
Review View Developer TEME WILL YOU WILL 02 D Normal B File Home Insert Page Layout Formulas Data Calibri IVAA .A BIV - 05 - Format Painter Clipboard . cut Copy Wrap Text Merge & Center - General $ % N 899 Conditional Format as Good Formatting - table Styles Alignment Number IM Variable Cost Contribution Margin Country USA USA USA USA USA USA USA USA USA USA USA WA Sara USA M17 DELFI G H I Variable State Cost Type Date of Sale Invoice No Percentage 1 Region State Salesperson Insurance Type Sales 2 Midwest TX Tom Auto 934.79 1/1/2019 A-2019-000010 TX-Auto 3 Southeast TN Jennifer Auto 570.51 1/1/2019 A-2019-000012 TN-Auto 4 New England CT Crissy Auto 398.71 1/1/2019 A-2019-000016 CT-Auto 5 New England MA Crissy Auto 887.79 1/1/2019 A-2019-000017 MA-Auto 6. Southeast GA Auto 500.21 1/1/2019 A-2019-000028 GA-Auto 7 West UT Kellie Auto 584.16 1/1/2019 A-2019-000029 UT-Auto 8 West NY Kellie Auto 433.22 1/1/2019 A-2019-000033 NV-Auto 9 West Peter Auto 958.92 1/1/2019 A-2019-000036 WA-Auto 10 North Central MO Mario Auto 411.77 1/1/2019 A-2019-000037 MO-Auto 11 Southeast MS Frank Auto 517.65 1/1/2019 A-2019-000041 MS-Auto 12 North Central MI Nicole Auto S07.17 1/1/2019 A-2019-000046 MI-Auto 13 New England ME Auto 416.7 1/1/2019 A-2019-000050 ME-Auto 14 West MT Peter Auto 545.06 1/1/2019 A-2019-000059 MT-Auto 15 Northeast DE Fred Auto 549.32 1/1/2019 A-2019-000061 DE-Auto 16 New England ME Sara Auto 755.19 1/1/2019 A-2019-000065 ME-Auto 17 Southeast TN Jennifer Auto 710.18 1/1/2019 A-2019-000078 TN-Auto 18 Midwest KS Tom 556.41 1/1/2019 A-2019-000089 KS-Auto 19 Northeast OH Mike Auto 967.44 1/1/2019 A-2019-000096 OH-Auto o New England MA Crissy Auto 517.23 1/1/2019 A-2019-000099 MA-Auto 1 Midwest NE Dave Auto 1143.34 1/1/2019 A-2019-000107 NE-Auto 2 Northeast VA Matt Auto 1045.19 1/1/2019 A-2019-000113 VA-Auto 3 North Central KY Mario Auto 568.39 1/1/2019 A-2019-000114 KY-Auto 4 Northeast MD Fred Auto 646.64 1/1/2019 A-2019-000115 MD-Auto Southeast John Auto 524.88 1/1/2019 A-2019-000117 FL-Auto Midwest OK Tom Auto 560.91 1/1/2019 A-2019-000122 OK-Auto North Central IA Nicole Auto 860.73 1/1/2019 A-2019-000124 IA-Auto Sheet1 MainData Sheet2 VariableCostPct mady Accessibility: Investigate USA USA USA USA Auto USA USA USA USA USA USA USA USA USA USA 0.23 0,09 0.ZO NERROR nnnnnnnnnnnnnnnnnnn 8 8 8 8 8 8 8 8 8 8 8 8 8 8 8 0.17 S AL-Auto AL-Disability AL-Home Al-Ufe AL-Prol AR-Auto AR-Disability AR-Home AR-Life AR-Professional AZ-Auto AZ-Disability AZ-Home Az-Life AZ-Professional CA-Auto CA-Disability CA-Home CA-Life CA-Professional CO-Auto CO-Disability CO-Home Co-Life Co-Professional CT-Auto CT-Disability CT-Home CT-Life CT-Professional DC-Auto DC-Disability DC-Home DC-Life DC Professonal DE-A to DE-Disability DE HOM DE-ufe DE-Professiona FL-Auto 0.29 $ 0.55 0.22 0.265 0.25 FL-D FL-Home
