Using Excel, solve the following:
During registration at State University every semester, students in the college of business must have their courses approved by the college advisor. It takes the adviser an average of 2 minutes to approve each schedule, and students arrive at the advisors office at the rate of 28 per hour.
1) Compute L, Lq, W, Wq, and U
2) The dean of the college has received a number of complaints from students about the length of time they must wait to have their schedules approved. The dean feels that waiting 10.00 minutes to get a schedule approved is not unreasonable. Each assistant to the dean assigns to the advisor’s office will reduce the average wait time required to approve a schedule by .25 minute, down to a minimum time of 1.0 minute to approve a schedule. How many assistants should the dean assign to the advisor?