I need help with my financial assignment homework because I don't understand chegg

Patient Data

Average Daily Census $($ADC$)$: $55$

Budget based on $6\mathrm{.}2$ Avg. Hours per patient day $($HPPD$)$

$(6\mathrm{.}2$ HPPD excludes Nurse Manager and unit secretaries$)$

Staff Data

Total FTEs $40$ Variable FTEs

$1$ Nurse Manager

$3$ Unit Secretaries

$44$ Total FTEs

Staffing Mix

RN $75\%$

LVN $10\%$

NA $15\%$

Salary Scale per Employees

Benefits are $35\%$ of annual salaries

Nurse Manager $$88,500\mathrm{.}00$ per year

Registered Nurses $($RN$)$ $$36\mathrm{.}00$ per hour

Licensed Vocational Nurses $($LVN$)$ $$24\mathrm{.}00$ per hour

Nurse Aides $($NA$)$ $$14\mathrm{.}00$ per hour

Questions

$1.$ How many RNs$,$ LVNs$,$ and NAs, by category, are on the staff of $3$ West? $($Round FTEs to the nearest tenth.$)$ Compute totals for each column. $($All of the totals will be calculated on total FTE$$s not a single FTE$).$

Positions Variable FTEs $\%$ by Position FTEs by Position

RN $400\mathrm{.}7530$

LVN $40$

NA $40$

Totals

$2.$ Compute the annual salary budget for $3$ West.

Compute totals for appropriate columns. $($Salaries can be located above in the case study$)$

Positions FTEs Salary Hours Salary Subtotals Amount of Benefits Total

MANAGER $1\mathrm{.}0$ XXXX

RN $302080$

LVN $2080$

NA $2080$

Sec $2080$

Totals XXXXX XXXXXX

$3.$ Your hospital unit, $3$ West, is a $60-$bed general medical$-$surgical unit. Over the past year, the ADC $($Ave$.$ Daily Census$)$ was $53$ patients.

Use the following data on $3$ West during the last year to perform these calculations and answer these questions.

A$.$ Complete this table to calculate the actual average hours of care required per patient day $($HPPD$)$ for the patients in $3$ West. Round to the nearest tenth

Acuity Mix Average Hours of Care Required Average Daily Census

$($ADC$)$ Total Hours of Care Per Day

I $1\mathrm{.}4811\mathrm{.}2$

II $3\mathrm{.}921$

III $5\mathrm{.}619$

IV $8\mathrm{.}85$

Totals $53$

Hours per patient day $($HPPD$)$

B$.$ Remember that your established personnel budget for $3$ West assumes a HPPD of $6\mathrm{.}2.$ If your calculated HPPD is different, explain the significance of the variance. $($If your calculated HPPD is different than $6\mathrm{.}2,$ you must write more than, $$We need more$/$less nurses.$)$

What is the Significance of the variance? If you believe you need more staff, what will be your rationale for making this requires? If you have too much staff, what would your proposal be for bringing your staffing into a better balance?

C$.$ What are the implications for the Nurse Manager? As an example, based on your conclusions in Section B$,$ what other observations would you make as you review your total budget and what would you expect to see as a result? $($Ex: supply costs; overtime hours, average census of $50$ on a $60$ bed unit, etc.$)$

$4.$ You have set two new goals for your unit for the next year related to personnel:

$$ Provide stronger unit management support on evening and night shifts and in the absence of the manager.

$$ Correct unfavorable efficiency variances due to overtime.

To accomplish these goals, you plan to make these changes:

$$ Add $1\mathrm{.}0$ RN FTE position

$$ Eliminate $1\mathrm{.}5$ LVN positions

$$ Add $1\mathrm{.}5$ FTEs NA positions

$$ Add $1\mathrm{.}0$ Assistant HN position at $$68,500/$year

Calculate ONLY the cost of the proposed recommendations for $3$ West. Compute totals for each column. If the change represents a reduction in the budget for that category, record the total as a negative number. If it represents an increase in the budget for that category, record the total as a positive number. $($Salaries can be located above and in case study$).$

Positions FTEs Salary Hours Salary Subtotals Benefits Total

RN $1$

LVN $-1\mathrm{.}5$

NA $1\mathrm{.}5$

AHN $1$ XXXXX

Totals $2$ XXXXX XXXXX

$5.$ Assume your proposal was approved. Calculate the new personnel budget $($You will use your budget from question $2$ and account for the changes you requested in question $4).$ Compute totals for each column.

Positions FTEs Salary Hours Salary Subtotals Benefits Total

Manager $1$ XXXXX

AHN $1$ XXXXX

RN $2080$

LVN $2080$

NA $2080$

Sec $2080$

Totals XXXXX XXXXX

Unit Secretary $($US$)$ $$12\mathrm{.}00$ per hour