Using the pivot table you created for Requirement $2$ in AssureAssure $$Insurance$,$ what was the contribution margincontribution$$margin of the homehome insurance policy sold by DougDoug on $5$ divided by $14$ divided by $20175/14/2017?$ A$.$$ $345\mathrm{.}49$ $ $345\mathrm{.}49$$$345\mathrm{.}49$ B$.$$ $95\mathrm{.}03$ $ $95\mathrm{.}03$$$95\mathrm{.}03$ C$.$$ $357\mathrm{.}49$ $ $357\mathrm{.}49$$$357\mathrm{.}49$ D$.$$ $452\mathrm{.}52$ $ $452\mathrm{.}52$$$452\mathrm{.}52$ Using the pivot table you created for Requirement $3$ in AssureAssure $$Insurance$,$ what was the average of the contribution margin for homeaverage$$of$$the$$contribution$$margin$$for$$home insurance$$ sales? A$.$$ $492\mathrm{.}30$ $ $492\mathrm{.}30$$$492\mathrm{.}30$ B$.$$ $6$ comma $294$ comma $115\mathrm{.}25$ $ $6$ comma $294$ comma $115\mathrm{.}25$$$6,294,115\mathrm{.}25$ C$.$$ $342\mathrm{.}15$ $ $342\mathrm{.}15$$$342\mathrm{.}15$ D$.$$ $8$ comma $167$ comma $762\mathrm{.}37$ $ $8$ comma $167$ comma $762\mathrm{.}37$$$8,167,762\mathrm{.}37$ Using the pivot table you created for Requirement $3$ in AssureAssure $$Insurance$,$ what was the sum of variable cost for disabilitysum$$of$$variable$$cost$$for$$disability insurance$$ sales? A$.$$ $6$ comma $155$ comma $297\mathrm{.}36$ $ $6$ comma $155$ comma $297\mathrm{.}36$$$6,155,297\mathrm{.}36$ B$.$$ $4$ comma $369$ comma $213\mathrm{.}26$ $ $4$ comma $369$ comma $213\mathrm{.}26$$$4,369,213\mathrm{.}26$ C$.$$ $1$ comma $873$ comma $647\mathrm{.}12$ $ $1$ comma $873$ comma $647\mathrm{.}12$$$1,873,647\mathrm{.}12$ D$.$$ $1$ comma $834$ comma $903\mathrm{.}23$ $ $1$ comma $834$ comma $903\mathrm{.}23$$$1,834,903\mathrm{.}23$ Using the pivot table you created for Requirement $4$ in AssureAssure $$Insurance$,$ which insurance type had the lowestlowest contribution margin$$ ratio? A$.$Auto AutoAuto B$.$Life LifeLife C$.$ Disability D$.$ Home E$.$ Professional Using the pivot table you created for Requirement $5$ in AssureAssure $$Insurance$,$ what state had the highest sum of contribution marginstate$$had$$the$$highest$$sum$$of$$contribution$$margin$?$ A$.$Pennsylvania PennsylvaniaPennsylvania B$.$Illinois IllinoisIllinois C$.$New Mexico New MexicoNew$$Mexico D$.$Virginia VirginiaVirginia Using the pivot table you created for Requirement $6$ in AssureAssure $$Insurance$,$ what was the sum of the contribution margin ratio for the SouthSouth $$region$?$ A$.70\mathrm{.}6970\mathrm{.}69\%$ B$.70\mathrm{.}9670\mathrm{.}96\%$ C$.71\mathrm{.}6271\mathrm{.}62\%$ D$.71\mathrm{.}1671\mathrm{.}16\%$ Using the pivot table you created for Requirement $2$ in Assure Insurance, what was the contribution margin of the home insurance policy sold by Doug on $5/14/2017?$Assureaverage of the contribution margin for homeUsing the pivot table you created for Requirement $3$ in Assure Insurance, what was the average of the contribution margin for home insurance sales?Assuresum of variable cost for disabilityUsing the pivot table you created for Requirement $3$ in Assure Insurance, what was the sum of variable cost for disability insurance sales?AssurelowestUsing the pivot table you created for Requirement $4$ in Assure Insurance, which insurance type had the lowest contribution margin ratio?Assurestate had the highest sum of contribution marginUsing the pivot table you created for Requirement $5$ in Assure Insurance, what state had the highest sum of contribution margin?AssureSouthUsing the pivot table you created for Requirement $6$ in Assure Insurance, what was the sum of the contribution margin ratio for the South region?