: You are to create a Housekeeping Schedule on an Excel Sheet. The schedule will be for one week only. These are your details: Full time employees: 10 @ $16.50/hr Part time employees: 5 @$14.00/hr Full time employees can only have a max of 40 hours a week Part time employees can only have up to 20 hours a week There are 9 floors There are 120 rooms Check-in is at 3pm and Check-out is at 12pm On Friday there will be 75 Check-ins and the hotel is at 100% capacity. Saturday the occupancy is at 100% with 25 Check-outs and 25 Check-ins On Sunday there will be 90 Check-outs On Wednesday there will be 29 Stayovers and 25 Check-outs Monday there will be 16 Check-ins and the capacity 25% Tuesday and Thursday the occupancy is at 75% The shifts are 7 am-3 pm, 3pm-11pm and 11pm-7am. The total budget for labour is $5000 for the week, do not go over budget What is your total labour cost for the week?