SCM 300 Lecture 5: SCM300 Lab 3 Help + Answers Complete Forumlas excel spread modules 5 6 7 8 9
Document Summary
This contains: questions, how to use excel (the formulas for the excel sheet, plain formulas for exam, answer checks. The purpose of this exercise is to discuss the situation facing a manager and help her determine how many servers to use and what the characteristics of the system will be. Communications, a long distance provider, is reevaluating its account management department for handling customer service questions and requests. During the 2:00 pm to 10:00pm time period, past data show that calls to the account management department occur at an average rate of one call every 7. 1 minutes. A study of past service times indicate that the average time to process a caller"s question/request is 5. 1 minutes. Like other phone systems, when a call comes in and all the servers are busy, the caller hears a message telling them to hold until the next server is available.