ILEX19EOM1-2Jennifer kellyAsoanya2

Trusthaven Insurance COMPLETE A SALES WORKSHEET Author: Jennifer kelly Asoanya Illustrated Excel 2019 | Module 1: End of Module Project 2 Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy the file from the SAM website.

Trusthaven Insurance Life Insurance Sales Quarter 1 Agent: Tasha Sallah Commission: 0.4 Policy Type January Total Commission Term 3,200.00 2,750.00 3,400.00 9,350.00 3,740.00 Permanent 1,850.00 1,725.00 1,925.00 5,500.00 2,200.00 Whole 1,750.00 1,250.00 1,425.00 4,425.00 1,770.00 Universal 1,650.00 1,300.00 1,175.00 4,125.00 1,650.00 Variable 1,050.00 1,200.00 1,400.00 3,650.00 1,460.00 No Medical Exam 2,450.00 2,875.00 2,900.00 8,225.00 3,290.00 Total 11,950.00 11,100.00 12,225.00 35,275.00 14,110.00 Types of policies sold: 6.00 Average monthly sale: 1,959.72 Maximum sales: 3,400.00 Term Minimum sales: 1,050.00 Maximum commission: 3,740.00