A department works eight hours per day, five days per week, 52 weeks per year. The company provides eight paid holidays and ten days of vacation. Five additional days are allowed for sick leave. Unemployment insurance is $65 per month. FICA is at the current rate for this calendar year (2017) workmen's compensation is 3% of the first $50,000, accident insurance is $1000, and medical insurance is $1200. An annual bonus of $1300 is scheduled to be given to all employees. Set up a program in EXCEL similar to Table 2.5 in the text. Use a wage rate of $52.60 per hour, the performance subsidy is 10%, and overtime is scheduled for eight hours per day for 30 Saturdays. Profit-sharing is expected to be 5% of regular paid clock hours. A department works eight hours per day, five days per week, 52 weeks per year. The company provides eight paid holidays and ten days of vacation. Five additional days are allowed for sick leave. Unemployment insurance is $65 per month. FICA is at the current rate for this calendar year (2017) workmen's compensation is 3% of the first $50,000, accident insurance is $1000, and medical insurance is $1200. An annual bonus of $1300 is scheduled to be given to all employees. Set up a program in EXCEL similar to Table 2.5 in the text. Use a wage rate of $52.60 per hour, the performance subsidy is 10%, and overtime is scheduled for eight hours per day for 30 Saturdays. Profit-sharing is expected to be 5% of regular paid clock hours