Monarch Learning Series 2023 Exercise 4 - Healthcare Contract Labor Costs
Altair EmployeeExercise Info
- Application (Classic vs Data Prep Studio): Data Prep Studio
- Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
- Skills/Features Tested: Append, Unpivot, GroupBy, Analyze
- Systems of Record: Not Applicable
- Estimated Time to Solve: 10 mins
- Exercise files required are attached
- Vendor 1.xlsx
- Vendor 2.xlsx
- Vendor 3.xlsx
Exercise Overview
You are a new Financial Analyst at a Healthcare System, and the Budget and Planning Manager has asked you combine and streamline data from 3 different Contract Labor Vendors to answer the following questions:
- What is the Total Expenditure on Contract Labor Across the 3 Vendors?
- What Contract Labor Position is the most expensive?
- Which site (ICU, NICU, SURGERY, LAB, ER) spent the most on Contract Labor?
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.
Comments
-
What is the Total Expenditure on Contract Labor Across the 3 Vendors?:
Ans: $1495867.5
What Contract Labor Position is the most expensive? :
Ans: Emergency Medical Technician (EMT)
Which site (ICU, NICU, SURGERY, LAB, ER) spent the most on Contract Labor?
Ans: Sum(ICU) $ 3,66,052.50
Attached xlsx sheets:
Q1 and Q3: 1and3_Question.xlsx
Q2: Labour_postition.xlsx
0 -
-
Bhagyaraj Mullangi said:
What is the Total Expenditure on Contract Labor Across the 3 Vendors?:
Ans: $1495867.5
What Contract Labor Position is the most expensive? :
Ans: Emergency Medical Technician (EMT)
Which site (ICU, NICU, SURGERY, LAB, ER) spent the most on Contract Labor?
Ans: Sum(ICU) $ 3,66,052.50
Attached xlsx sheets:
Q1 and Q3: 1and3_Question.xlsx
Q2: Labour_postition.xlsx
Excellent work!
0 -
Margarethe Coelho_20640 said:
My answers to Exercise 4.
Excellent work!
0 -
-
-