Monarch Exercise 38 - UKG Pro, Detail Labor Allocations by Project

Baba_Majekodunmi_703

Exercise Info

• Application (Classic vs Data Prep Studio): Data Prep Studio
  
• Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
• Skills/Features Tested:  Worksheet Design, Group, Pivot, Analyze
  
• Systems of Record: Salesforce, Workday, Oracle etc.
  
• Estimated Time to Solve: 15 mins
• Exercise files required are attached Below;
  
  • Detail Labor Allocations by Project.xlsx

Exercise Overview

You are a Payroll Tax Accountant at a Global Manufacturing Company and your manager has asked you to perform the following tasks based on the XYZ Payroll.xlsx file:

1. What were the Total Taxes by Project for the Company?
2. Which Employee had the Largest Deductions?
3. Which Employee had the Largest Net Pay?

Answer

• Please upload your answers below in the comment section for the exercise
• A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Exercises' section.

Detail Labor Allocations by Project.xlsx