The steps you will follow for this project are as follows:

Review the video and$/$or the scripted PDF$\text{'}$s for Windows or Mac.

Download the Excel data file. $($After you download the file, YOU NEED TO "SAVE" YOUR ASSIGNMENT BY CLICKING THE SAVE BUTTON IN THE

RIGHT HAND CORNER BEFORE YOU EXIT. If you do not save your assignment, the next time you enter, you may see a different company and set of da

Perform the requirements on the data file using the video or pdf$\text{'}$s$.$

Check your work in the Excel file with these check figures.

Use your Excel file to answer the six multiple choice questions below. $($You will have to scroll down to see all of the questions.$)$

Resources

A$)$ Information on how to update Excel and Office $365.$

B$)$ If you do not have Office $365,$ click here to learn how to get it for free.

C$)$ Information on data column headings.

D$)$ Information on data table descriptions.

E$)$ Troubleshooting FAQ.

$.$ $$8\frac{,}{{?}_{73}},454\mathrm{.}44$

Using the pivot table you created for Requirement $3$ in Family Insurance, what was the sum of variable cost for disability insurance sales?

A$.$ $$6,190,248\mathrm{.}50$

B$.$ $$4,121,267\mathrm{.}59$

C$.$ $$1,661,999\mathrm{.}92$

D$.$ $$1,825,470\mathrm{.}11$

Using the pivot table you created for Requirement $4$ in Family Insurance, which insurance type had the lowest contribution margin ratio?