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

Baba_Majekodunmi_703
Baba_Majekodunmi_703
Altair Employee
edited August 21 in Altair RapidMiner

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.
Tagged:

Categories