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 S23,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 Salary Expense June 3-5 Number of Hr Salary Hour Total Earnings Employee Michaela SI5.35 STR. 46 Sarah $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? 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 is Week 1 Employer MONDAY TUESDAY WEDNESDA THURDAY FRIDAY TOTAL Michaela 8.0 8.0 9.0 8.0 85 9,0 105 7530100 8.0 9.0 8.0 90 O RO Natasha 7.5 75 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 SIS.35 $18.46 $17.78 $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? 2. If so, who worked overtime and how many overtime hours did they work? Table 6-12 Hours for Week 1 Hours Worked per Employer in Week 1 Employee MONDAY TUESDAY WEDNESDA THURDAY FRIDAY TOTAL 6.25 105 Michaela Glenn Jerome Natasha Sarah 8.0 8.0 8.0 90 75 85 7.5 80 3.0 10.0 8.0 8.0 8.0 7.5 7.5 RO 90 8.0 Table 6-13 Hours for Week 2 Hours Worked per Employee in Week 1 Employee MONDAY TUESDAY WEDNESDA THURDAY FRIDAY TOTAL 80 8.0 8.0 7.75 8.25 Michaela Glenn Jerome Natasha Sarah 8.0 10.5 90 80 7.75 80 80 80 8.0 8.0 8.0 8.0 80 80 8.0 &o
