Which province has the better utilization and why? Compare to overall for Canada. Create graphs in Excel to show your analysis and provide a Word document describing your analysis.



HIMII-27 (week 79) Utilization Management Assign.

Under the Assignments section you will find an Excel resource. This is your source data needed for the assignment.

1.       Click on the “PCE_resultsen 2010-13” file and an Excel spreadsheet will open.

2.       On the Excel spreadsheet, click on the Fiscal Year field down arrow, select 2010 only

3.       Click on the Jurisdiction field, select the following:

o    Ontario

o    Quebec

o    Alberta

o    Manitoba

o    Canada


4.       Click on the CMG field, select the following:

1.       CMG 163 Major Cardiothoracic Intervention with Pump (18-59 years)

2.       CMG 164  Major Cardiothoracic Intervention without Pump (18-59 years)


5.       Sort the data by 1) CMG & 2) Jurisdiction.

6.       Copy and paste (values and number formats) this data into a new Excel file.

7.       Save this file for Fiscal 2010-11.

8.       Click on the Fiscal year field, choose 2011 only.

9.       Ensure the other fields you changed and the sorting remain the same.

10.   Save the file for Fiscal 2011-12 (same as step 6).


 Analyze the 4 provinces by comparing:

1)      The Estimated Average cost

2)      Average Acute LOS

3)      Volume of Typical Cases

4)      2 CMGS -please describe the CMGs –on PUMP and without PUMP what does this mean.


Which province has the better utilization and why?  Compare to overall for Canada.  Create graphs in Excel to show your analysis and provide a Word document describing your analysis.  As part of the Excel document – there should be a “Readme” tab that describes the criteria and the source.

Please provide the necessary details/labels in your graphs – such as titles, legends, etc.

Note:  Estimated Average Cost.  Cost comes from the financial costs reported to CIHI from each of the hospitals within the province.


Instruction Files

Related Questions in science category

The ready solutions purchased from Library are already used solutions. Please do not submit them directly as it may lead to plagiarism. Once paid, the solution file download link will be sent to your provided email. Please either use them for learning purpose or re-write them in your own language. In case if you haven't get the email, do let us know via chat support.