1. In Appendix 1, complete the calculation of the following (20 Points]: 1. Primary, Secondary and Total Commissions for each contract (columns G, H, and I of tab \".1 Contracts by Year\"). ii. Calculate the commissions paid by year for each individual in the \".2 Commissions Paid\" tab. iii. Complete a count of the number of contracts by individual by year in the \".3 Total Contracts by Ind.\" Tab. 2. Describe how the fraud was perpetuated and by whom? {30 points) 3. Quantify the amount lost by the company by the fraud occurring?(30 points) 4. List three recommendations you would provide to BMDC to prevent this fraud from occurring in the future? {20 points)