To follow are the requirements for analyzing sales records in the data set. 1. There are some typographical errors in the data set in the Region and Insura and correct these errors. 2. Calculate the variable cost and contribution margin for each policy sold. 3. Total the sales revenue, variable cost, and contribution margin for each Insu 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 4. Calculate the contribution margin ratio for each policy. Rank the Insurance T highest contribution margin ratio to lowest contribution margin ratio. Do the with the rankings you found in Requirement 3? Should these two rankings a same? Explain. 5. Calculate the contribution margin ratio for each state. Rank the states from contribution margin ratio to the lowest contribution margin ratio. Which sta a contribution margin ratio greater than 75%? 6. Within each region, what was the most profitable state in the most recent y the contribution margin ratio? The least most profitable state in each region 7 all the info atic rather ated in the ding