W.L. Brown, a direct marketer of women’s clothing must determine how many telephone operators to schedule during each part of the day. The firm estimates that the number of phone calls received each hour of a typical eight-hour shift can be described by the probability distribution in the template. Each operator can handle 15 calls per hour and costs the company $20 per hour. Each phone call that is not handled is assumed to cost the company $6 in lost profit. Considering the options of employing 6, 8, 10, 12, 14, or 16 operators, use simulation to determine the number of operators that minimizes the expected hourly cost (labor costs plus lost profits).

**If you cannot solve, atleast provide with the formula used to get Number of Cells, Max number of that can be handled, Lost call, Lost Call cost, Operator Cost, and Total Cost**

 

Excel File Edit View Insert Format Tools Data Window Help **D 70% I Thu 5:24 PM Soha Ali Q Homework #14 Q- Search Sheet Home Insert Page Layout Formulas Data Review View Developer + Share Cut Calibri A. Ar 2 AutoSum 11 5) Wrap Text General Copy O Fill , A E Merge & Center $- % > Paste B Conditional Format Formatting as Table Cell Insert Delote Format V Format O Clear Sort & Filter Styles 133 v fx A D E G. K L M. P R 2 Problem 10.33 (p. 589). Scheduling telephone operators - Create 500 simulations 4 Calls per hour per operator 15 Distribution of number of calls per hour Comulative Calls Probability 5 Cost per hour per operator 6 Cost per lost call 20 Probs 80 120 160 6 0.10 0.40 0.30 0.10 8 Number of operators (a trial value) 6 0.50 Number of Expected 0.80 200 0.15 Operators Total Cost 0.95 300 0.05 10 11 Expected Total Cost 2 12 13 14 15 10 16 12 14 17 18 16 19 Minimum: 20 21 Simulation Max number Number Jof that can be of calls handled Lost Call Operator Total cost 22 Simulation Lost calls Cost Cost 23 24 25 26 27 28 29 30 Template + Ready IT 100% 12