Above \& Beyond Overtime spreadsheet You work for Bradley and Cohen, a large air conditioner manufacturer and installation company, One of your many duties as office manager is to keep track of the office overtime schedule and hudget. Today you will prepare a monthly summary and a chart. a. Open the Microsoft" Excei file CH6 Overtime Hours from the data files, b. Look at the formula for overtime pay for the fint employee. The lF function is used to calculate the pay at 11/2 times the hourly rate if the overtime hours are 12 or fewer. If the overtime hours are more than 12 , the formula calculates the pay at two times the hourly rate. Copy the overtime pay formula down to the next three rows to calculate pay for the other employees. c. Enter a formula to calculate the total overtime pay for the week. d. In cell E13, enter a foenu!' that uses che IF function. If the total overtime pay for the week is lers than orequal to the overtime budget, display "Yes" in the cell. If the overtime pay for the weakismore than the overtime badget, display "No" in the cell. (Flint: Place quoses avecind "Y"u" and "No in the formula.) Q. Make copies cit the worksheet to record the hours for the next three weeks. Change the dates at the top of the worksheets and on the worksheet tabs. Enter these hours for the enployees: Above \& Beyond Overtime spreadsheet You work for Bradley and Cohen, a large air conditioner manufacturer and installation company, One of your many duties as office manager is to keep track of the office overtime schedule and hudget. Today you will prepare a monthly summary and a chart. a. Open the Microsoft" Excei file CH6 Overtime Hours from the data files, b. Look at the formula for overtime pay for the fint employee. The lF function is used to calculate the pay at 11/2 times the hourly rate if the overtime hours are 12 or fewer. If the overtime hours are more than 12 , the formula calculates the pay at two times the hourly rate. Copy the overtime pay formula down to the next three rows to calculate pay for the other employees. c. Enter a formula to calculate the total overtime pay for the week. d. In cell E13, enter a foenu!' that uses che IF function. If the total overtime pay for the week is lers than orequal to the overtime budget, display "Yes" in the cell. If the overtime pay for the weakismore than the overtime badget, display "No" in the cell. (Flint: Place quoses avecind "Y"u" and "No in the formula.) Q. Make copies cit the worksheet to record the hours for the next three weeks. Change the dates at the top of the worksheets and on the worksheet tabs. Enter these hours for the enployees