534 Chapter 10 Required: 1. Use a spreadsheet to show the expected sales for meals by day for each meal period. Assume the first day of April 20X4 is a Monday. 2. Determine the forecasted sales from appetizers and desserts for the month. Problem 16 For the week of June 6, Melvin Mince, the manager of Melvin's Hotel in northwestern Illinois, budgeted 600 hours for room attendants to clean rooms. This budget was based on a work standard of cleaning one room every 36 minutes. The rooms attendants actually worked 660 hours cleaning 1,050 rooms. The budgeted wage rate for room attendants is $3.40 per hour. The wages paid to room attendants totaled $2,178.00. Required: 1. What is the amount of the budget variance? 2. What is the amount of the volume variance? 3. What is the amount of the efficiency variance? 4. What is the amount of the rate variance? Problem 17 Bill Smith is the dining room manager of the Cycle Club. The wages budget for his department is divided between fixed and variable expenses. The work standard for servers is to serve 10 meals per hour. The average wage rate per hour is $12.00. The variable wages budget for servers for the first week of February is $4,800 based on $12.00 per hour. Given the work standard, this is also based on serving 4,000 people. During the first week February, the server wages totaled $5,200. During the first week of February, hours were worked, and the average hourly pay was $11.50 per hour. In addition, 4,200 members were provided service by the servers. Required: 1. Determine the budget variance for server variable wage expense. 2. Is the budget variance determined in #1 significant? Explain. 3. Rate Bill Smith's performance in specific numho