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). Country Canada Canada Canada Canada Canada Canada Canada France France France France France France Germany Germany Germany Germany Germany Spain Spain Spain Spain Spain Spain USA USA USA USA USA Customer Company 1 Company 9 Company 17 Company 19 Company 20 Company 24 Company 27 Company 3 Company 8 Company 12 Company 13 Company 25 Company 26 Company 4 Company 7 Company 11 Company 15 Company 28 Company 5 Company 6 Company 14 Company 16 Company 21 Company 28 Company 2 Company 10 Company 18 Company 22 Company 23 Total Contract Value (CAD) 14,000 10,000 90,000 57,000 22,000 35,000 35,000 70,000 50,000 6,000 20,000 34,000 15,000 65,000 65,000 75,000 20,000 25,000 20,000 10,000 65,000 20,000 25,000 60,000 40,000 40,000 125,000 120,000 120,000 Invoice Number A1 A9 A17 A19 A20 A24 A3 A8 A12 A13 A25 A4 AZ A11 A15 Company Name Company 1 Company 9 Company 17 Company 19 Company 20 Company 24 Company 3 Company 8 Company 12 Company 13 Company 25 Company 4 Company 7 Company 11 Company 15 Company 5 Company 6 Company 14 Company 16 Company 21 Company 2 Company 10 Company 18 Company 22 Company 23 Country Canada Canada Canada Canada Canada Canada France France France France France Germany Germany Germany Germany Spain Spain Spain Spain Spain USA USA USA USA USA Invoice Amount (CAD) 10,000 10,000 45,000 23,000 22,000 25,000 35,000 40,000 6,000 20,000 34,000 50,000 65,000 50,000 12,000 15,000 10,000 50,000 13,000 16,000 25,000 20,000 75,000 80,000 100,000 AS A6 A14 A16 A21 A2 A10 A18 A22 A23 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). Country Canada Canada Canada Canada Canada Canada Canada France France France France France France Germany Germany Germany Germany Germany Spain Spain Spain Spain Spain Spain USA USA USA USA USA Customer Company 1 Company 9 Company 17 Company 19 Company 20 Company 24 Company 27 Company 3 Company 8 Company 12 Company 13 Company 25 Company 26 Company 4 Company 7 Company 11 Company 15 Company 28 Company 5 Company 6 Company 14 Company 16 Company 21 Company 28 Company 2 Company 10 Company 18 Company 22 Company 23 Total Contract Value (CAD) 14,000 10,000 90,000 57,000 22,000 35,000 35,000 70,000 50,000 6,000 20,000 34,000 15,000 65,000 65,000 75,000 20,000 25,000 20,000 10,000 65,000 20,000 25,000 60,000 40,000 40,000 125,000 120,000 120,000 Invoice Number A1 A9 A17 A19 A20 A24 A3 A8 A12 A13 A25 A4 AZ A11 A15 Company Name Company 1 Company 9 Company 17 Company 19 Company 20 Company 24 Company 3 Company 8 Company 12 Company 13 Company 25 Company 4 Company 7 Company 11 Company 15 Company 5 Company 6 Company 14 Company 16 Company 21 Company 2 Company 10 Company 18 Company 22 Company 23 Country Canada Canada Canada Canada Canada Canada France France France France France Germany Germany Germany Germany Spain Spain Spain Spain Spain USA USA USA USA USA Invoice Amount (CAD) 10,000 10,000 45,000 23,000 22,000 25,000 35,000 40,000 6,000 20,000 34,000 50,000 65,000 50,000 12,000 15,000 10,000 50,000 13,000 16,000 25,000 20,000 75,000 80,000 100,000 AS A6 A14 A16 A21 A2 A10 A18 A22 A23
