1. Total the sales revenue, variable cost, and contribution margin for each Insurance Type. a. Which Insurance Type had the highest total contribution margin? b. Which Insurance Type had the lowest total contribution margin? c. How many insurance policies were sold in each Insurance Type? d. What is the average contribution margin per policy in each Insurance Type?

Row Labels	Sum of Sales	Sum of Variable Cost	Average of Contribution Margin 2	Sum of Contribution Margin	Count of Contribution Margin 2
Professional	$ 17,197,451.91	$ 3,953,648.97	$ 1,014.77	$ 13,243,802.94	13051
Home	$ 8,275,576.58	$ 1,840,892.61	$ 497.62	$ 6,434,683.97	12931
Auto	$ 8,631,500.97	$ 4,164,622.81	$ 345.12	$ 4,466,878.16	12943
Disability	$ 6,240,790.67	$ 1,805,471.43	$ 346.02	$ 4,435,319.24	12818
Life	$ 3,331,429.19	$ 369,440.80	$ 231.39	$ 2,961,988.39	12801
Grand Total	$ 43,676,749.32	$ 12,134,076.63	$ 488.70	$ 31,542,672.69	64544

Calculate the contribution margin ratio for each policy. Rank the Insurance Type field from the highest contribution margin ratio to lowest contribution margin ratio. Do these rankings agree with the rankings you found in Requirement 3?

Row Labels	Sum of CMratio
Life	88.91%
Home	77.76%
Professional	77.01%
Disability	71.07%
Auto	51.75%
Grand Total	72.22%