Evaluation of company Business Mangement
RockPaper555
kc_sales_ppl_graph.xlsxSheet1
| Number of Sales People | 1 | 2 | 3 | 4 | 5 | 6 |
| average # of Customers / shift | 40 | 40 | 40 | 40 | 40 | 40 |
| average wait time/ customer | 10 | 9 | 8.45 | 7.15 | 6.45 | 6.15 |
| Total waiting time/ shift | 400 | 360 | 338 | 286 | 285 | 246 |
| estimated cost/min of wait | 4 | 4 | 4 | 4 | 4 | 4 |
| value of time lost | 1600 | 1440 | 1352 | 1144 | 1032 | 984 |
| ompensation cost/ shift/perso | 80 | 160 | 240 | 320 | 400 | 480 |
| total cost/ shift | 1680 | 1600 | 1592 | 1464 | 1432 | 1464 |
| cheaper to have 4 and 6 sales people at $1464 |
