Scheduling / Inventory Project

You are the Executive Housekeeper at a Resort Hotel. Your General Manager has asked you to prepare two reports for the Budget Committee. Usin" rel="nofollow">ing Excel spreadsheets, in" rel="nofollow">include the followin" rel="nofollow">ing in" rel="nofollow">information to prepare the reports: Report #1 – Annual Staffin" rel="nofollow">ing / Payroll Number of Hotel Rooms 3500 Projected Occupancy % (assume same for all 52 weeks) Average Occupancy Sunday – Thursday 80% Average Occupancy on Fri, Saturday 90% Average Room Rate Sun – Thursday $ 99 Fri, Saturday $ 129 Housekeepin" rel="nofollow">ing Staff Considerations 1 Exec. Housekeeper @ $75,000 annual Salary 2 Assistant Housekeepers @ $50,000 annual salary 2 Warehouse Managers @ $40,000 annual salary 2 Lin" rel="nofollow">inen Managers @ $35,000 annual salary 4 Status Board Operators / Pay rate is $11.00 p/hour Each GRA completes 15 rooms daily / Pay rate is $12.00 per hour Each House Porter is responsible for assistin" rel="nofollow">ing 6 GRAs / Pay rate is $15.00 per hour Each Utility Porter is responsible for 100 occupied rooms / Pay rate is $17.00 p/hour Each Floor Inspector supervises 12 GRAs / Pay rate is $18.00 p/hour Employee benefits for Full-time employees = 40% of base pay rate Hotel / Housekeepin" rel="nofollow">ing operates 24/7/ 365 Part-time employees receive no benefits All Full-time employees work 8 hours shifts, 5 days p/week Part time / Relief employees work 8 hour shifts, but not necessarily 5 days p/week Round all Employees, Rooms Sold to whole numbers. Calculate Payroll costs in" rel="nofollow">in actual numbers. Report 2: Annual Lin" rel="nofollow">inen Inventory cost Room Types: 70% of rooms have 2 queen size beds, 30% have 1 kin" rel="nofollow">ing-size bed. Rollaway beds are 10% of total rooms Lin" rel="nofollow">inen Requirement p/Bed Type Kin" rel="nofollow">ing Beds – 1 kin" rel="nofollow">ing bedpad, 2 kin" rel="nofollow">ing sheets, 1 kin" rel="nofollow">ing blanket, 1 kin" rel="nofollow">ing bedspread, 4 regular pillows with cases Queen Beds -2 queen sheets 1 queen blanket, 1 queen bedspread, 2 regular pillows with cases Rollaway Beds – 2 double sheets, 1 double blanket, 1 regular pillow with case Terry Requirement p/room Each room requires 4 Bath Towels, 4 Face Towels, 2 Washcloths, 1 Bathmat, 1 Shower curtain" rel="nofollow">in Par Stock Requirements Kin" rel="nofollow">ing: Sheets – 3 Par, blankets 2 Par, bedspreads 1.5 Par, Pillows 1.5 Par, Bedpads 1.5 Par Queen: Sheets – 3 par, blankets 1.5 Par, bedspreads 1.5 Par, Pillows 1.5 Par, Bedpads 1.5 par Roll away beds – Double sheets 1.5 Par, Double blankets 1.5 Par, Pillows 1.5 Par Pillow cases - 3 par Bath towels - 3 Par Face towels - 3 Par Washcloths - 2 Par Bathmats - 1.5 Par Shower curtain" rel="nofollow">ins - 1.5 Par Lin" rel="nofollow">inen Purchase Cost Kin" rel="nofollow">ing: sheets $ 8.00 each, blankets $12.00 each, bedpads $ 5.00 each, bedspreads $20.00 each Queen: sheets $ 6.00 each, blankets $10.00 each, bedpads $ 4.00 each, Beadspreads $18.00 each Pillows $5.00 each, Pillow cases $ 2.00 each Double sheets $5.00 each Double Blankets $7.00 each Double Pads $3.00 each Terry Purchase Cost Bath Towels $ 8.00 each Face towels $ 5.00 each Washcloths $ 1.00 each Bathmats $ 3.00 each Shower curtain" rel="nofollow">ins $ 6.00 each Round all Lin" rel="nofollow">inen goods to whole numbers. Calculate Purchase costs in" rel="nofollow">in actual numbers.