Health Care

1.Using the information in the table. Complete the columns provided by calculating the total hours of direct nursing care delivered per patient day for each month and for the total year1.Using the information in the table. Complete the columns provided by calculating the total hours of direct nursing care delivered per patient day for each month and for the total year2. Assuring that the productivity standard for this unit is nine hours per patient day,calculate the variance for each month. the first month is done as an example.4. some months will have a positive variance. Some months will have a negative variance5. After you complete each month, explain this unit variance. Note you want to analyze data over the entire year, not each month separately. use the table please
Step 1:If the unit’s actual patient days are lower or higher than the budgeted patient days, nursing hours should be adjusted for the upcoming year.  These adjusted hours are the adjusted/allowed nursing hours.
Calculate the Adjusted/allowed Nursing Hours based on the actual patient days:
Actual patient days x 9 hours per day = adjusted/allowed nursing hours Step 2:To determine productivity, we need to take the allowed/adjusted number of nursing hours divided by budgeted nursing hours to begin calculating productivity.
Calculate the Productivity Measure:
Adjusted/allowed nursing hours / Budgeted Nursing Hours x 100 = Productivity Measure
*Please round to nearest tens Step 3:Finally, we will calculate the variance between the nursing hours that were budgeted for the unit and the actual nursing hours that were needed
Calculate the Variance:
Productivity measure – 100 = VarianceMonth Actual Patient Days Budgeted Patient Days Actual Nursing Hours Budgeted Nursing Hours Adjusted/allowed Nursing Hours Productivity Measure VarianceJanuary 996 960 8642 8640 8964 104% +4%February 1030 1008 10,209 9074 March 974 896 8060 8064 April 876 960 8560 8640 May 930 868 7739 7812 June 864 840 7553 7560 July 942 868 7840 7812 August 831 868 7993 7812 September 888 840 7868 7560 October 967 868 8013 7812 November 1116 1116 10,965 10,044 December 1091 896 10,238 8064 TOTAL 11,505 10,988 103,680 98,894 How would you explain this unit’s productivity over the entire year?