Case Scenario 3: Scenario: The Foodservice Department at Ruby Falls Medical Center (RFMC) is divided into 5 operating areas: Patient Foodservice, Employee Cafeteria, Visitor Caf, Vending and Catering. Each month, information on the number of guests and patients served in each area is collected except for "vending". The Director uses a Vending Equivalent to estimate the average customers that make vending purchases. The number of vending customers is calculated by using the following equation: 1 vending guest equivalent = $1.75 sales". The information from revenue and expenses are also recorded and presented below in an Income Statement. Scenario 3: Questions 1-19 Instructions to Receive Credit: (Submit in-class on Nov. 5) 1. Write your answer in the "ANSWER column", in the table below. Write/print clearly. 2. Must attach your calculation work (stapled) with the answer sheet. No points given if work is not attached Answer Ruby Falls Medical Center (RFMC) Foodservice Department Income Statement - May 20XX Operating Areas Patient Employee Visitor Vending Foodservice Cafeteria Cafe Catering TOTAL $395,232 Employee Cafeteria 44,255 # patients/Guests Income 55,611 $ 272,244 5 ,857 $ 47,725 12,462 $ 21,810 5,324 123,510 $ 45,725 $ 387,504 Questions (based on Scenario 3) 1. What is the total revenue earned from patient foodservice if the department is reimbursed at a rate of $3.20 per patient meal? 2. The operating area that made the largest percentage of contribution to the total income earned is? 3. Which operating area has the largest Food Cost Percentage? 4. Total dept. labor cost represents % of total dept. expenses. 5. Total dairy expense represents_ _ % of total dept. food cost 6. What is catering's contribution sales mix to the total income earned in May? Expenses Food Meat Dairy Grocery Fresh/Frozen Bakery Supplements Other Total $30,301 $39,590 $21,032 $14,570 $17.794 $15,569 $21,115 $18,296 $14,571 $16,248 $11,822 $0 $6,940 $8,542 3,5752312.8157 $5,088 $1,890 $2,035 $2,326 $1,894 7. Vending sales is equal to how many Euest equivalent? 8. Which area has the highest average check? 9. What is the average check for the Employee caf, Visitor cafe, and $1,803 $5,389 $82,171 $938 $2,002 $40,432 $1,001 $2,156 $38,555 $721 $1,463 $43,921 $936 $1,694 $35,343 $0 $11,822 $1,804 $1,548 $20,449 T72021432? 5222,672 So So Catering? $1,615 Bug? Labor Salaried Hourly $175,469 $142,185 $373,380 $157,390 $20,437 53.770 $16,314 $187 5405 $250 10. RFMC's labor cost standard for hourly employees is 42.5% per month Did the foodservice department meet the labor cost standard in May? 11. "Salaried labor cost represents what percentage of total labor cost? 12. Total "Labor cost" represents what percentage of total costs? 13. What is the food cost per patient for May? 14. At the reimbursement rate of $3.20 per patient meal, did the patient foodservice operating area break even? 15. Which operating areas) exceeded the monthly food cost percentage goal of 32.50%? 16. What is the overall food cost percentage for the department in May? 17. Did the department make a profit how much?) or loss how much?) for May? 18. Based on the total cost incurred in each operating area, which area was most efficient in serving the # of customers or patients in its respective area? Plastify your response, chat incest 19. What are 3-4 things the manager could do to improve the overall operating effectiveness and efficiency of the department Miscellaneous Cleaning Supplies Paper Repairs/Maint Office Supplies China/silver Books/Mac Other Total Expenses $400 $1,260 $2,256 $230 $382 $59 $479 $5066 2 $425 $1,629 SO $169 $258 SO 50 $0 $97 $0 $90 $176 $1,278 $598 $4,142 $0 $2,256 $83 $579 $0 $640 $25 $84 $25 $149 36. 57 1103) 73.474 ? 5258 $995 12754213773 ? Case Scenario 3: Scenario: The Foodservice Department at Ruby Falls Medical Center (RFMC) is divided into 5 operating areas: Patient Foodservice, Employee Cafeteria, Visitor Caf, Vending and Catering. Each month, information on the number of guests and patients served in each area is collected except for "vending". The Director uses a Vending Equivalent to estimate the average customers that make vending purchases. The number of vending customers is calculated by using the following equation: 1 vending guest equivalent = $1.75 sales". The information from revenue and expenses are also recorded and presented below in an Income Statement. Scenario 3: Questions 1-19 Instructions to Receive Credit: (Submit in-class on Nov. 5) 1. Write your answer in the "ANSWER column", in the table below. Write/print clearly. 2. Must attach your calculation work (stapled) with the answer sheet. No points given if work is not attached Answer Ruby Falls Medical Center (RFMC) Foodservice Department Income Statement - May 20XX Operating Areas Patient Employee Visitor Vending Foodservice Cafeteria Cafe Catering TOTAL $395,232 Employee Cafeteria 44,255 # patients/Guests Income 55,611 $ 272,244 5 ,857 $ 47,725 12,462 $ 21,810 5,324 123,510 $ 45,725 $ 387,504 Questions (based on Scenario 3) 1. What is the total revenue earned from patient foodservice if the department is reimbursed at a rate of $3.20 per patient meal? 2. The operating area that made the largest percentage of contribution to the total income earned is? 3. Which operating area has the largest Food Cost Percentage? 4. Total dept. labor cost represents % of total dept. expenses. 5. Total dairy expense represents_ _ % of total dept. food cost 6. What is catering's contribution sales mix to the total income earned in May? Expenses Food Meat Dairy Grocery Fresh/Frozen Bakery Supplements Other Total $30,301 $39,590 $21,032 $14,570 $17.794 $15,569 $21,115 $18,296 $14,571 $16,248 $11,822 $0 $6,940 $8,542 3,5752312.8157 $5,088 $1,890 $2,035 $2,326 $1,894 7. Vending sales is equal to how many Euest equivalent? 8. Which area has the highest average check? 9. What is the average check for the Employee caf, Visitor cafe, and $1,803 $5,389 $82,171 $938 $2,002 $40,432 $1,001 $2,156 $38,555 $721 $1,463 $43,921 $936 $1,694 $35,343 $0 $11,822 $1,804 $1,548 $20,449 T72021432? 5222,672 So So Catering? $1,615 Bug? Labor Salaried Hourly $175,469 $142,185 $373,380 $157,390 $20,437 53.770 $16,314 $187 5405 $250 10. RFMC's labor cost standard for hourly employees is 42.5% per month Did the foodservice department meet the labor cost standard in May? 11. "Salaried labor cost represents what percentage of total labor cost? 12. Total "Labor cost" represents what percentage of total costs? 13. What is the food cost per patient for May? 14. At the reimbursement rate of $3.20 per patient meal, did the patient foodservice operating area break even? 15. Which operating areas) exceeded the monthly food cost percentage goal of 32.50%? 16. What is the overall food cost percentage for the department in May? 17. Did the department make a profit how much?) or loss how much?) for May? 18. Based on the total cost incurred in each operating area, which area was most efficient in serving the # of customers or patients in its respective area? Plastify your response, chat incest 19. What are 3-4 things the manager could do to improve the overall operating effectiveness and efficiency of the department Miscellaneous Cleaning Supplies Paper Repairs/Maint Office Supplies China/silver Books/Mac Other Total Expenses $400 $1,260 $2,256 $230 $382 $59 $479 $5066 2 $425 $1,629 SO $169 $258 SO 50 $0 $97 $0 $90 $176 $1,278 $598 $4,142 $0 $2,256 $83 $579 $0 $640 $25 $84 $25 $149 36. 57 1103) 73.474 ? 5258 $995 12754213773