Altair Monarch Learning Series 2023 Exercise 4 Solution: Healthcare Contract Labor Costs

Exercise Info

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:

  1. What is the Total Expenditure on Contract Labor Across the 3 Vendors?
  2. What Contract Labor Position is the most expensive?
  3. Which site (ICU, NICU, SURGERY, LAB, ER) spent the most on Contract Labor?

Exercise Answer

Not sure you got the correct answer? No problem. Watch the video below for a demonstration of this exercise from start to finish.