A) Using the revenue and invoice data tabs, please provide the following: 1) Summary table by country that lists total customer revenues, total invoiced and the balance to be invoiced on the contract (example template below). 2)Determine the percentage invoiced against total revenues by market and assess against our global target of 70% for year to date. 3) If the variance for the country is greater than 5% from the target provide a brief note on which customer(s) are driving the variance. Total Contract Value (Revenue) Total Invoiced YTD Balance to Invoice Variance From Target % Invoiced #DIV/01 Notes on Variance (where applicable) Country Customer Customer Country Customer #DIV/0! Customer B) Using the data provided on the payroll tab, determine which employees are eligible for overtime pay and for those eligible, the amount of earnings that should be paid out. All employees are based in Ontario (Ontario.ca has resources on regulations if you are not familiar). Thursday Friday Employee B Type Junior Junior Manager Manager Junior Junior Hourly Rate $ 20.00 $ 25.00 $ 30.00 $ 30.00 $ 20.00 $ 25.00 Monday Tuesday Wednesday 9 9 9 8.5 8.5 10 10 10 8 10 7.5 7.5 7.5 006 in 00 in 0000 in LLL 00 OOO 00 D 9 9 10 8 7.5 10 10 7.5 F A) Using the revenue and invoice data tabs, please provide the following: 1) Summary table by country that lists total customer revenues, total invoiced and the balance to be invoiced on the contract (example template below). 2)Determine the percentage invoiced against total revenues by market and assess against our global target of 70% for year to date. 3) If the variance for the country is greater than 5% from the target provide a brief note on which customer(s) are driving the variance. Total Contract Value (Revenue) Total Invoiced YTD Balance to Invoice Variance From Target % Invoiced #DIV/01 Notes on Variance (where applicable) Country Customer Customer Country Customer #DIV/0! Customer B) Using the data provided on the payroll tab, determine which employees are eligible for overtime pay and for those eligible, the amount of earnings that should be paid out. All employees are based in Ontario (Ontario.ca has resources on regulations if you are not familiar). Thursday Friday Employee B Type Junior Junior Manager Manager Junior Junior Hourly Rate $ 20.00 $ 25.00 $ 30.00 $ 30.00 $ 20.00 $ 25.00 Monday Tuesday Wednesday 9 9 9 8.5 8.5 10 10 10 8 10 7.5 7.5 7.5 006 in 00 in 0000 in LLL 00 OOO 00 D 9 9 10 8 7.5 10 10 7.5 F