things in red are not necessarily correct. please solve with excel. Thanks!

A B D E F G I J K 1 Kira LaBrew is irritated by staffing issues. She doesn't want to increase her labor costs, but she is starting to think 2 that she is losing customers because of too much waiting. So, the question is, should she add another person? 3 Right now customers arrive at a rate of 112 per 8 hour day. Each member of the staff can serve a person in a half hour 4 or 16 per 8 hour day. A staff member costs $200 per 8 hour day. She estimates cost of waiting per customer per 8 hour day to be $850 5 it costs $400 per week per person who is waiting for service to start. 6 7 Model used: Model B 8 arrival rate: 112 per 8 hour day 9 service rate: 16 per 8 hour day 10 11 cost per server per 8 hour day: 200 cost of waiting per customer per 8 hour day: 850 13 14 a. Kira currently has 8 members on her staff. What is the average number waiting in this system? (not counting those being served) 15 16 b. What is the system cost (capacity cost + wait cost) with the current staffing? 17 18 c. If she added another person to the staff, what would the system cost be? 19 20 d. Would you recommend that she add another person? 21 22 23 24 12 25 A B D E F G I J K 1 Kira LaBrew is irritated by staffing issues. She doesn't want to increase her labor costs, but she is starting to think 2 that she is losing customers because of too much waiting. So, the question is, should she add another person? 3 Right now customers arrive at a rate of 112 per 8 hour day. Each member of the staff can serve a person in a half hour 4 or 16 per 8 hour day. A staff member costs $200 per 8 hour day. She estimates cost of waiting per customer per 8 hour day to be $850 5 it costs $400 per week per person who is waiting for service to start. 6 7 Model used: Model B 8 arrival rate: 112 per 8 hour day 9 service rate: 16 per 8 hour day 10 11 cost per server per 8 hour day: 200 cost of waiting per customer per 8 hour day: 850 13 14 a. Kira currently has 8 members on her staff. What is the average number waiting in this system? (not counting those being served) 15 16 b. What is the system cost (capacity cost + wait cost) with the current staffing? 17 18 c. If she added another person to the staff, what would the system cost be? 19 20 d. Would you recommend that she add another person? 21 22 23 24 12 25