All the attachmets are required in order to complete the question (this is a 10 question assignment). The excel spreadsheet is the model (numbers/values) that you have to have in order to answer the question/analysis. I am not asking the tutors to provide external information, but to answer and explain Q7 in relationship to the Model (excel tab) which is why this is uploaded.

1. In the model, what rows/cells represent the staffing variances into rate and efficiency variances both for each product line
2. Based on the variances please expalin how variance vs. forecasted budget P&L is beter (inpatient and outpatient)

Excel (Model Tab, Tabs 1-10 which correlate to the questions).

https://docs.google.com/document/d/1DAhuDPTLh1XIdF2iEYlrvamGioimAcklh1w06sDqZ-c/edit?usp=sharing

This is the narrative questions to 1-10. Note 1-6 are completed. I am asking you to complete # 7.

https://docs.google.com/spreadsheets/d/1u86bkRn9EejO5lS2vkPbGAS2zf4AcJ9JSF145YijD2Q/edit?usp=sharing

Case 10 Model is found in the cases workbook, George Pink and Paula Song "Gapenski's Cases in Healthcare Finance" 6th Edition for the course