A program to recognize and reward our most engaged community members
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?:
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
My answers to Exercise 4.
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!
I found this difficult to determine what the "right" way to answer the questions.
Attempt.
1 attachment
