Table 6-11 Salary Expense Calculation Employee Michaela Glenn Jerome Natasha Sarah Salary Expense June 2-8 Number...

Transcribed Image Text:

Table 6-11 Salary Expense Calculation Employee Michaela Glenn Jerome Natasha Sarah Salary Expense June 2-8 Number of Hrs Salary/Hour Total Earnings Worked 40 $15.35 40 $18.46 22 $17.78 32 $16.88 40 $19.66 Budget Decision 4 You are required to report your staff payroll for the imaging area of the department. Overtime is based on 80 hours per 2 weeks. The weekly hours for the past 2 weeks are shown in Table 6- 12 and Table 6-13. 1. Did you have any overtime for this payroll? McCuen, C., Sayles, N. B., & McCuen, C. (2014). Case studies in health information management. Stamford, CT: Cengage Learning. Case 6-18 Payroll Budget Decisions 2. If so, who worked overtime and how many overtime hours did they work? Table 6-12 Hours for Week 1 Hours Worked per Employee in Week 1 Employee MONDAY TUESDAY WEDNESDAY THURDAY FRIDAY TOTAL Michaela 8.0 7.5 8.5 6.25 8.0 Glenn 8.0 8.5 9.0 10.5 8.0 Jerome 8.0 7.5 3.0 10.0 8.0 Natasha 9.0 8.0 9.0 8.0 7.5 Sarah 8.0 9.0 8.0 8.0 7.5 Table 6-13 Hours for Week 2 Employee MONDAY Hours Worked per Employee in Week 1 TUESDAY WEDNESDAY THURDAY FRIDAY TOTAL Michaela 8.0 8.0 8.0 8.0 7.75 Glenn 10.5 8.0 8.0 8.0 8.25 Jerome 9.0 8.0 8.0 8.0 8.5 Natasha 8.0 8.0 8.0 8.0 8.0 Sarah 7.75 8.0 8.0 8.0 7.5 Case 6-18 Payroll Budget Decisions You have been approached by administration with personnel budget concerns and given constraints to apply. Review the 4 budgeting issues presented and make calculations as appropriate. Budget Decision 1 You have been given $15,000 for the overtime needs to catch up on work in the department. If the average salary for the clerical staff is $15.75, how many hours of overtime can be worked? Budget Decision 2 You have been given $23,500 to hire temporary employees. If the temporary agency is charging $28 per hour, how many hours of temporary help will be available? Budget Decision 3 You have been given instructions that you cannot go over $8,100 in salary (overtime) for the week of June 2-9. Based on the information provided in Table 6-11, how close to using the allotted overtime are you? Table 6-11 Salary Expense Calculation Employee Michaela Glenn Jerome Natasha Sarah Salary Expense June 2-8 Number of Hrs Salary/Hour Total Earnings Worked 40 $15.35 40 $18.46 22 $17.78 32 $16.88 40 $19.66 Budget Decision 4 You are required to report your staff payroll for the imaging area of the department. Overtime is based on 80 hours per 2 weeks. The weekly hours for the past 2 weeks are shown in Table 6- 12 and Table 6-13. 1. Did you have any overtime for this payroll? McCuen, C., Sayles, N. B., & McCuen, C. (2014). Case studies in health information management. Stamford, CT: Cengage Learning. Case 6-18 Payroll Budget Decisions 2. If so, who worked overtime and how many overtime hours did they work? Table 6-12 Hours for Week 1 Hours Worked per Employee in Week 1 Employee MONDAY TUESDAY WEDNESDAY THURDAY FRIDAY TOTAL Michaela 8.0 7.5 8.5 6.25 8.0 Glenn 8.0 8.5 9.0 10.5 8.0 Jerome 8.0 7.5 3.0 10.0 8.0 Natasha 9.0 8.0 9.0 8.0 7.5 Sarah 8.0 9.0 8.0 8.0 7.5 Table 6-13 Hours for Week 2 Employee MONDAY Hours Worked per Employee in Week 1 TUESDAY WEDNESDAY THURDAY FRIDAY TOTAL Michaela 8.0 8.0 8.0 8.0 7.75 Glenn 10.5 8.0 8.0 8.0 8.25 Jerome 9.0 8.0 8.0 8.0 8.5 Natasha 8.0 8.0 8.0 8.0 8.0 Sarah 7.75 8.0 8.0 8.0 7.5 Case 6-18 Payroll Budget Decisions You have been approached by administration with personnel budget concerns and given constraints to apply. Review the 4 budgeting issues presented and make calculations as appropriate. Budget Decision 1 You have been given $15,000 for the overtime needs to catch up on work in the department. If the average salary for the clerical staff is $15.75, how many hours of overtime can be worked? Budget Decision 2 You have been given $23,500 to hire temporary employees. If the temporary agency is charging $28 per hour, how many hours of temporary help will be available? Budget Decision 3 You have been given instructions that you cannot go over $8,100 in salary (overtime) for the week of June 2-9. Based on the information provided in Table 6-11, how close to using the allotted overtime are you?