Healthcare

Hospital Administration

You work in the operations office of a mid-size hospital. The board meets on Friday and wants a Q1 picture of 120 admissions: how long patients stay, which departments are busiest and most expensive, how much is insured, and whether weekend admissions are a staffing problem.

Deliverable: Length of stay, age group and admission-day columns, a department table, a KPI block, highlighted long stays, a PivotTable of average cost and a titled chart.

1. 1Length of stay10 pts
2. 2Age group10 pts
3. 3Weekend admissions10 pts
4. 4Department table20 pts
5. 5Board KPIs20 pts
6. 6Flag long stays10 pts
7. 7Average cost by department10 pts
8. 8Patients by department10 pts