Introduction to Management Science 12th Edition Chapter 11, Problem 36 ***NEED H

Question

Introduction to Management Science 12th Edition

Chapter 11, Problem 36

***NEED HELP WITH SOLVING THIS USING EXCEL'S SOLVER TOOL - PLEASE PROVIDE SCREEN SHOTS ON HOW TO SETUP AND WHAT TO ENTER IN APPROPRIATE CELLS****

THE PALACE HOTEL BELIEVES ITS CUSTOMERS MAY BE WAITING TOO LONG FOR ROOM SERVICE. THE HOTEL OPERATIONS MANAGER KNOWS THAT THE TIME FOR ROOM SERVICE ORDERS IS NORMALLY DISTRIBUTED, AND HE SAMPLED 10 ROOM SERVICE ORDERS DURING A 3 DAY PERIOD AND TIMED EACH (IN MINUTES) AS FOLLOWS:

23

23

15

12

26

16

19

18

30

25

THE OPERATIONS MANAGER BELIEVES THAT ONLY 10% OF THE ROOM SERVICES ORDERS SHOULD TAKE LONGER THAN 25 MINUTES IF THE HOTEL HAS GOOD CUSTOMER SERVICE. DOES THE HOTEL ROOM SERVICE MEET THIS GOAL?

23

23

15

12

26

16

19

18

30

25

Explanation / Answer

Mean    = 20.7

Std dev = 5.61842208     

We need to find the percentage of the orders being served within 25 minutes                      

x    =       25

P(X<x) =NORMDIST(25, 20.7, 5.6184, 1)

= 78%

This means currently only 78% of the orders are being served within 25 minutes.              

So the Hotel room service does not meet this goal          

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.