The focus of the report should be your recommendation(s) to address the problems presented in the case.

· A one-page, single-spaced recommendation, i.e., given the information from the case, what would you recommend the company do.

· 12 point Times New Roman font, 1” margins all around.

· You may include an appendix for charts, tables, and diagrams, etc., but they must be labeled, have a title, and be mentioned in your recommendation.

· The cases must include the Excel Spreadsheets if applicable. Upload the Excel Spreadsheets separately; do not paste them into the Word document.

Cases often contain a number of questions. These questions will help you analyze the case and prepare your recommendations. Therefore, do not prepare a list of answers to the questions but write your report as if you were preparing it for the CEO of the company. The focus of the report should be your recommendation(s) to address the problems presented in the case. Be sure you state your recommendation(s) and then provide the support for your recommendation(s). You will be graded on how well you support your recommendation(s).

solve the case, the case is attached

Sheet1

A2 1.88 D4 3.276 D3 0
Observation 1 Observation 2
Time Smallest Largest average Range Smallest Largest average Range X-doublebar R-bar UCLX LCLX UCLR LCLR
6AM 48.7 50.7 49.7 2 6PM 41 51.2 46.1 10.2 48.325 1.725 51.568 45.082 5.6511 0
7 49.1 51.2 50.15 2.1 7 46.2 51.7 48.95 5.5 48.325 1.725 51.568 45.082 5.6511 0
8 49.6 51.4 50.5 1.8 8 44 48.7 46.35 4.7 48.325 1.725 51.568 45.082 5.6511 0
9 50.2 51.8 51 1.6 9 44.2 48.9 46.55 4.7 48.325 1.725 51.568 45.082 5.6511 0
10 49.2 52.3 50.75 3.1 10 46.6 50.2 48.4 3.6 48.325 1.725 51.568 45.082 5.6511 0
11 48.6 51.7 50.15 3.1 11 47 50 48.5 3 48.325 1.725 51.568 45.082 5.6511 0
12(Noon) 46.2 50.4 48.3 4.2 12 (Midnight) 48.2 50.4 49.3 2.2 48.325 1.725 51.568 45.082 5.6511 0
1PM 46.4 50 48.2 3.6 1AM 48.4 51.7 50.05 3.3 48.325 1.725 51.568 45.082 5.6511 0
2 46 50.6 48.3 4.6 2 49 52.2 50.6 3.2 48.325 1.725 51.568 45.082 5.6511 0
3 48.2 50.8 49.5 2.6 3 49.2 50 49.6 0.8 48.325 1.725 51.568 45.082 5.6511 0
4 49.2 52.7 50.95 3.5 4 46.3 50.5 48.4 4.2 48.325 1.725 51.568 45.082 5.6511 0
5 50 55.3 52.65 5.3 5 44.1 49.7 46.9 5.6 48.325 1.725 51.568 45.082 5.6511 0
6 49.2 54.7 51.95 5.5 6 45 49 47 4 48.325 1.725 51.568 45.082 5.6511 0
7 50 55.6 52.8 5.6 7 44.8 49.7 47.25 4.9 48.325 1.725 51.568 45.082 5.6511 0
8 48.6 53.2 50.9 4.6 8 48 51.8 49.9 3.8 48.325 1.725 51.568 45.082 5.6511 0
9 49.4 52.4 50.9 3 9 48.1 52.7 50.4 4.6 48.325 1.725 51.568 45.082 5.6511 0
10 46.1 50.7 48.4 4.6 10 48.1 55.2 51.65 7.1 48.325 1.725 51.568 45.082 5.6511 0
11 46.3 50.8 48.55 4.5 11 49.5 54.1 51.8 4.6 48.325 1.725 51.568 45.082 5.6511 0
12(Midnight) 45.4 50.2 47.8 4.8 12 (Noon) 48.7 50.9 49.8 2.2 48.325 1.725 51.568 45.082 5.6511 0
1AM 44.3 49.7 47 5.4 1PM 47.6 51.2 49.4 3.6 48.325 1.725 51.568 45.082 5.6511 0
2 44.1 49.6 46.85 5.5 2 48.4 51 49.7 2.6 48.325 1.725 51.568 45.082 5.6511 0
3 45.2 49 47.1 3.8 3 48.8 50.8 49.8 2 48.325 1.725 51.568 45.082 5.6511 0
4 45.5 49.1 47.3 3.6 4 49.1 50.6 49.85 1.5 48.325 1.725 51.568 45.082 5.6511 0
5 47.1 49.6 48.35 2.5 5 45.2 51.2 48.2 6 48.325 1.725 51.568 45.082 5.6511 0
6 47.4 52 49.7 4.6 6 44 49.7 46.85 5.7 48.325 1.725 51.568 45.082 5.6511 0
7 49.2 52.2 50.7 3 7 44.4 50 47.2 5.6 48.325 1.725 51.568 45.082 5.6511 0
8 49 52.4 50.7 3.4 8 46.6 48.9 47.75 2.3 48.325 1.725 51.568 45.082 5.6511 0
9 49.4 51.7 50.55 2.3 9 47.2 49.5 48.35 2.3 48.325 1.725 51.568 45.082 5.6511 0
10 49.6 51.8 50.7 2.2 10 48.1 50.7 49.4 2.6 48.325 1.725 51.568 45.082 5.6511 0
11 49 52.3 50.65 3.3 11 47 50.8 48.9 3.8 48.325 1.725 51.568 45.082 5.6511 0
12 (Noon) 48.8 52.4 50.6 3.6 12(Midnight) 46.4 49.2 47.8 2.8 48.325 1.725 51.568 45.082 5.6511 0
1 49.4 53.6 51.5 4.2 1AM 46.8 49 47.9 2.2 48.325 1.725 51.568 45.082 5.6511 0
2 48.6 51 49.8 2.4 2 47.2 51.4 49.3 4.2 48.325 1.725 51.568 45.082 5.6511 0
3 47.2 51.7 49.45 4.5 3 49 50.6 49.8 1.6 48.325 1.725 51.568 45.082 5.6511 0
4 45.3 50.9 48.1 5.6 4 50.5 51.5 51 1 48.325 1.725 51.568 45.082 5.6511 0
5 44.1 49 46.55 4.9 5 50 51.9 50.95 1.9 48.325 1.725 51.568 45.082 5.6511 0
48.125 3.45 48.525 6.05

X-Bar chart Comparisson

46.1 48.95 46.35 46.55 48.40000000000001 48.5 49.3 50.05 50.6 49.6 48.4 46.90000000000001 47.0 47.25 49.9 50.40000000000001 51.65000000000001 51.8 49.8 49.40000000000001 49.7 49.8 49.85 48.2 46.85 47.2 47.75 48.35 49.40000000000001 48.9 47.8 47.9 49.3 49.8 51.0 50.95 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 49.7 50.15000000000001 50.5 51.0 50.75 50.15000000000001 48.3 48.2 48.3 49.5 50.95 52.65 51.95 52.8 50.90000000000001 50.9 48.40000000000001 48.55 47.8 47.0 46.85 47.1 47.3 48.35 49.7 50.7 50.7 50.55 50.7 50.65 50.6 51.5 49.8 49.45 48.1 46.55 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082R-Chart Comparisson

10.2 5.5 4.700000000000003 4.699999999999996 3.600000000000001 3.0 2.199999999999996 3.300000000000004 3.200000000000003 0.799999999999997 4.200000000000003 5.600000000000001 4.0 4.900000000000005 3.799999999999997 4.600000000000001 7.100000000000001 4.600000000000001 2.199999999999996 3.600000000000001 2.600000000000001 2.0 1.5 6.0 5.700000000000003 5.600000000000001 2.299999999999997 2.299999999999997 2.600000000000001 3.799999999999997 2.800000000000004 2.200000000000003 4.199999999999996 1.600000000000001 1.0 1.899999999999999 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 2.100000000000001 1.799999999999997 1.599999999999994 3.099999999999994 3.100000000000001 4.199999999999996 3.600000000000001 4.600000000000001 2.599999999999994 3.5 5.299999999999997 5.5 5.600000000000001 4.600000000000001 3.0 4.600000000000001 4.5 4.800000000000004 5.400000000000005 5.5 3.799999999999997 3.600000000000001 2.5 4.600000000000001 3.0 3.399999999999999 2.300000000000004 2.199999999999996 3.299999999999997 3.600000000000001 4.200000000000003 2.399999999999999 4.5 5.600000000000001 4.899999999999999 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0X-Bar chart Comparisson

46.1 48.95 46.35 46.55 48.40000000000001 48.5 49.3 50.05 50.6 49.6 48.4 46.90000000000001 47.0 47.25 49.9 50.40000000000001 51.65000000000001 51.8 49.8 49.40000000000001 49.7 49.8 49.85 48.2 46.85 47.2 47.75 48.35 49.40000000000001 48.9 47.8 47.9 49.3 49.8 51.0 50.95 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 49.7 50.15000000000001 50.5 51.0 50.75 50.15000000000001 48.3 48.2 48.3 49.5 50.95 52.65 51.95 52.8 50.90000000000001 50.9 48.40000000000001 48.55 47.8 47.0 46.85 47.1 47.3 48.35 49.7 50.7 50.7 50.55 50.7 50.65 50.6 51.5 49.8 49.45 48.1 46.55 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 48.325 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 51.568 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082 45.082R-Chart Comparisson

10.2 5.5 4.700000000000003 4.699999999999996 3.600000000000001 3.0 2.199999999999996 3.300000000000004 3.200000000000003 0.799999999999997 4.200000000000003 5.600000000000001 4.0 4.900000000000005 3.799999999999997 4.600000000000001 7.100000000000001 4.600000000000001 2.199999999999996 3.600000000000001 2.600000000000001 2.0 1.5 6.0 5.700000000000003 5.600000000000001 2.299999999999997 2.299999999999997 2.600000000000001 3.799999999999997 2.800000000000004 2.200000000000003 4.199999999999996 1.600000000000001 1.0 1.899999999999999 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 2.0 2.100000000000001 1.799999999999997 1.599999999999994 3.099999999999994 3.100000000000001 4.199999999999996 3.600000000000001 4.600000000000001 2.599999999999994 3.5 5.299999999999997 5.5 5.600000000000001 4.600000000000001 3.0 4.600000000000001 4.5 4.800000000000004 5.400000000000005 5.5 3.799999999999997 3.600000000000001 2.5 4.600000000000001 3.0 3.399999999999999 2.300000000000004 2.199999999999996 3.299999999999997 3.600000000000001 4.200000000000003 2.399999999999999 4.5 5.600000000000001 4.899999999999999 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 1.725 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 5.651099999999999 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0

 

"Get yourself this Paper or a similar one at an unbeatable discount!"

"Order a similar paper and get 15% discount on your first order with us
Use the following coupon
"FIRST15"

Order Now