write my assignment 2433

Questions:

1. InAppendix 1, complete the calculation of the following:

i.      Primary, Secondary and Total Commissionsfor each contract (columns G, H, and I of tab “.1 Contracts by Year”).

ii.      Calculate the commissionspaid byyear for each individual in the “.2

Commissions Paid” tab.

iii.      Complete 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?

3. Quantify the amount lost by the company by the fraud occurring?

4.  List three recommendations you would provide to BMDC to prevent this fraud from occurring in the future?