Determine a proper control chart use a spreadsheet to


Answer the following questions. Show detailed solutions

1.       The following data is collected from customer complaints about service problems at a hotel. Complaint types are coded A-G. Use a spreadsheet to construct a Pareto chart for this data.

Categories            Frequency

A                             5    

B                             9

C                             22
D                            5
E                            18
F                             9
G                            7                                                                   

 

2. In your own words explain principles of lean thinking. Use a logistics related example toshow where and how those concepts apply.

 

3. You are managing an order processing facility where employees pick the customer ordersfrom the warehouse, package, and deliver them to postal services. There are bar-codescanners and conveyors to facilitate finding and moving items through the facility.Deliveries to each state are grouped together as part of your deal with postal services fora lower rate. There are problems in order processing, including orders filled with wrongitems, orders with right items but wrong number of some items, and finding packagesbeing shipped to the wrong state. Prepare a cause-and-effect diagram to show causes ofthese problems and explain your solution for each.

4. The following data is collected at a carpet production facility to show the number offlaws per 100 yards of carpet:

Sample # 1 2 34 5 6 7 8 9 10

Flaws7 5 0 10 12 5 9 4 6 2

Determine a proper control chart. Use a spreadsheet to calculate the upper and lowercontrol limits for the control chart and draw it. Suppose that the next carpet sample of100 yards has 14 flaws. What can you say about the process?

Solution Preview :

Prepared by a verified Expert
Management Information Sys: Determine a proper control chart use a spreadsheet to
Reference No:- TGS01092686

Now Priced at $10 (50% Discount)

Recommended (94%)

Rated (4.6/5)