using an excel sheet, sovle the problem above.

Problem 2 Prepare a salary budget for the fiscal year 7//X1 to 6/30/X2. Staffing levels are based on the need for six hours of hands-on work per patient day. Volume in the budget year is to be 3,600 patient days. Productive time is 80 percent of total paid time. For purposes of this solution, staff can be hired only in half FTE in- crements; thus if there is a need for 7.4 FTEs, 7.5 must be budgeted. The follow- ing are the current staff with FTE values and hourly rates of pay as of 4/1/Xl $14.00 13.80 13.50 14.00 12.75 1.0 1.0 King Law Rogers Ruby Russell 0.5 A pay raise will be given to all staff on May 1 of each year at a rate of 6 per- cent. The starting rate of pay for new hires is $13.00 regardless of hire date Problem 2 Prepare a salary budget for the fiscal year 7//X1 to 6/30/X2. Staffing levels are based on the need for six hours of hands-on work per patient day. Volume in the budget year is to be 3,600 patient days. Productive time is 80 percent of total paid time. For purposes of this solution, staff can be hired only in half FTE in- crements; thus if there is a need for 7.4 FTEs, 7.5 must be budgeted. The follow- ing are the current staff with FTE values and hourly rates of pay as of 4/1/Xl $14.00 13.80 13.50 14.00 12.75 1.0 1.0 King Law Rogers Ruby Russell 0.5 A pay raise will be given to all staff on May 1 of each year at a rate of 6 per- cent. The starting rate of pay for new hires is $13.00 regardless of hire date