Please answer with detailed calcualation and step by step prcoess. Please give me a in detailed post answer together with an attached word or excle working sheet document which show all the calculations and formulas for my understanding, thank you!!!

Case study (questions, data and instrucstions) as below.

Instructions

• Carefully read the case study and answer the related questions.
• Use complete sentences and paragraphs to answer the questions and explain your answers.
• Use at least 2 sources beyond your textbook. Make sure to cite your sources in the text and also in a reference list at the end of the document using APA 7 format.
• Do not copy and paste directly from your sources. Paraphrase using your own words.
• Save this completed assignment as YourLastName_FirstInitial_CS1
• Submit your completed document to the eCentennial dropbox for this assignment on or before Saturday 11:59 pm of the week of Module 7.

Case Study

Bayfield Mud Company

In November 2015, John Wells, a customer service representative of Bayfield Mud Company, was summoned to the Houston warehouse of Wet-Land Drilling, Inc., to inspect three boxcars of mud treating agents that Bayfield had shipped to the Houston firm. (Bayfields corporate offices and its largest plant are located in Orange, Texas, which is just west of the LouisianaTexas border.) Wet-Land had filed a complaint that the 50-pound bags of treating agents just received from Bayfield were short-weight by approximately 5%.

The short-weight bags were initially detected by one of Wet-Lands receiving clerks, who noticed that the railroad scale tickets indicated that net weights were significantly less on all three boxcars than those of identical shipments received on October 25, 2015. Bayfields traffic department was called to determine if lighter-weight pallets were used on the shipments. (This might explain the lighter net weights.) Bayfield indicated, however, that no changes had been made in loading or palletizing procedures. Thus, Wet-Land engineers randomly checked 50 bags and discovered that the average net weight was 47.51 pounds. They noted from past shipments that the process yielded bag net weights averaging exactly 50.0 pounds, with an acceptable standard deviation of 1.2 pounds. Consequently, they concluded that the sample indicated a significant short weight. (The reader may wish to verify this conclusion.) Bayfield was then contacted, and Wells was sent to investigate the complaint. Upon arrival, Wells verified the complaint and issued a 5% credit to Wet-Land.

Wet-Land management, however, was not completely satisfied with the issuance of credit. The charts followed by their mud engineers on the drilling platforms were based on 50-pound bags of treating agents. Lighter-weight bags might result in poor chemical control during the drilling operation and thus adversely affect drilling efficiency. (Mud treating agents are used to control the pH and other chemical properties of the core during drilling operation.) This defect could cause severe economic consequences because of the extremely high cost of oil and natural gas well-drilling operations. Consequently, special-use instructions had to accompany the delivery of these shipments to the drilling platforms. Moreover, the short-weight shipments had to be isolated in Wet-Lands warehouse, causing extra handling and poor space utilization. Thus, Wells was informed that Wet-Land might seek a new supplier of mud-treating agents if, in the future, it received bags that deviated significantly from 50 pounds.

The quality control department at Bayfield suspected that the lightweight bags might have resulted from growing pains at the Orange plant. Because of the earlier energy crisis, oil and natural gas exploration activity had greatly increased. In turn, this increased activity created increased demand for products produced by related industries, including drilling muds. Consequently, Bayfield had to expand from a one shift (6:00 A.M. to 2:00 P.M.) to a two-shift (2:00 P.M. to 10:00 P.M.) operation in mid2010, and finally to a three-shift operation (24 hours per day) in the fall of 2015.

The additional nightshift bagging crew was staffed entirely by new employees. The most experienced foremen were temporarily assigned to supervise the night-shift employees. Most emphasis was placed on increasing the output of bags to meet ever increasing demand. It was suspected that only occasional reminders were made to double-check the bag weight-feeder. (A double-check is performed by systematically weighing a bag on a scale to determine if the proper weight is being loaded by the weight-feeder. If there is significant deviation from 50 pounds, corrective adjustments are made to the weight-release mechanism.)

To verify this expectation, the quality control staff randomly sampled the bag output and prepared the chart on the previous page. Six bags were sampled and weighed each hour.

Questions

1. Use Statistical Process Control tools to provide an analysis of the bag-weight problem and explain your results.
2. Based on your analysis results, what procedures would you recommend for maintaining proper quality control?
3. Operations Managers are responsible for 10 strategic management decisions. Explain which of those 10 decisions apply in this particular situation and what the Operations Manager needs to do to prevent the situation from occurring in the future.

RANGE RANGE RANGE TIME SMALLEST LARGEST TIME SMALLEST LARGEST TIME SMALLEST LARGEST AVERAGE WEIGHT (POUNDS) Day Shift 49.6 AVERAGE WEIGHT (POUNDS) Day Shift 48.6 50.2 50.0 Monday 6:00 am 7:00 8:00 9:00 10:00 11:00 12:00 pm 1:00 48.7 49.1 49.6 50.2 Tuesday 6:00 am 7:00 8:00 9:00 10:00 11:00 12:00 pm 1:00 50.7 51.2 51.4 51.8 52.3 51.7 50.4 50.0 45.0 44.8 48.0 48.1 50.6 50.8 49.9 50.3 48.6 49.0 AVERAGE WEIGHT (POUNDS) Day Shift 48.4 48.8 49.6 50.0 51.0 50.4 50.0 48.9 47.4 49.2 49.0 49.4 49.6 49.0 48.8 49.4 Wednesday 6:00 am 7:00 8:00 9:00 10:00 11:00 12:00 pm 1:00 52.0 52.2 52.4 51.7 51.8 52.3 52.4 53.6 49.8 50.3 50.2 50.0 50.0 50.1 49.2 49.0 49.7 51.8 52.7 55.2 54.1 50.9 51.2 48.1 48.6 46.2 46.4 49.5 48.7 47.6 Evening shift Evening shift Evening shift 48.4 49.7 48.4 47.2 48.8 49.1 2:00 pm 3:00 4:00 5:00 6:00 7:00 8:00 46.8 46.0 48.2 49.2 50.0 49.2 50.0 48.6 49.4 50.6 50.8 52.7 55.3 54.7 55.6 53.2 52.4 2:00 pm 3:00 4:00 5:00 6:00 7:00 8:00 9:00 48.6 47.2 45.3 44.1 41.0 46.2 44.0 44.2 51.0 51.7 50.9 49.0 51.2 51.7 48.7 48.9 2:00 pm 3:00 4:00 5:00 6:00 7:00 8:00 9:00 45.2 51.0 50.8 50.6 51.2 49.7 50.0 48.9 49.5 44.0 44.4 46.6 9:00 472 49.0 49.8 50.3 51.4 51.6 51.8 51.0 50.5 Night shift 49.2 49.0 48.4 47.6 47.4 48.2 48.0 48.4 49.8 49.8 50.0 47.8 46.4 46.4 47.2 48.4 Night shift 49.2 48.4 47.2 47.4 48.8 49.6 51.0 50.5 46.6 47.0 48.1 47.0 46.8 50.0 47.4 47.0 Night shift 47.2 48.6 49.8 49.6 50.0 50.0 47.2 47.0 48.2 10:00 pm 11:00 12:00 am 1:00 2:00 3:00 4:00 5:00 46.4 46.1 46.3 45.4 44.3 44.1 45.2 45.5 47.1 50.7 50.8 50.2 49.7 49.6 49.0 49.1 49.6 10:00 pm 11:00 12:00 am 1:00 2:00 3:00 4:00 5:00 48.4 49.0 49.2 46.3 44.1 50.2 50.0 50.4 51.7 52.2 50.0 50.5 49.7 10:00 pm 11:00 12:00 am 1:00 2:00 3:00 4:00 5:00 46.8 47.2 49.0 50.5 50.0 50.7 50.8 49.2 49.0 51.4 50.6 51.5 51.9 RANGE RANGE RANGE TIME SMALLEST LARGEST TIME SMALLEST LARGEST TIME SMALLEST LARGEST AVERAGE WEIGHT (POUNDS) Day Shift 49.6 AVERAGE WEIGHT (POUNDS) Day Shift 48.6 50.2 50.0 Monday 6:00 am 7:00 8:00 9:00 10:00 11:00 12:00 pm 1:00 48.7 49.1 49.6 50.2 Tuesday 6:00 am 7:00 8:00 9:00 10:00 11:00 12:00 pm 1:00 50.7 51.2 51.4 51.8 52.3 51.7 50.4 50.0 45.0 44.8 48.0 48.1 50.6 50.8 49.9 50.3 48.6 49.0 AVERAGE WEIGHT (POUNDS) Day Shift 48.4 48.8 49.6 50.0 51.0 50.4 50.0 48.9 47.4 49.2 49.0 49.4 49.6 49.0 48.8 49.4 Wednesday 6:00 am 7:00 8:00 9:00 10:00 11:00 12:00 pm 1:00 52.0 52.2 52.4 51.7 51.8 52.3 52.4 53.6 49.8 50.3 50.2 50.0 50.0 50.1 49.2 49.0 49.7 51.8 52.7 55.2 54.1 50.9 51.2 48.1 48.6 46.2 46.4 49.5 48.7 47.6 Evening shift Evening shift Evening shift 48.4 49.7 48.4 47.2 48.8 49.1 2:00 pm 3:00 4:00 5:00 6:00 7:00 8:00 46.8 46.0 48.2 49.2 50.0 49.2 50.0 48.6 49.4 50.6 50.8 52.7 55.3 54.7 55.6 53.2 52.4 2:00 pm 3:00 4:00 5:00 6:00 7:00 8:00 9:00 48.6 47.2 45.3 44.1 41.0 46.2 44.0 44.2 51.0 51.7 50.9 49.0 51.2 51.7 48.7 48.9 2:00 pm 3:00 4:00 5:00 6:00 7:00 8:00 9:00 45.2 51.0 50.8 50.6 51.2 49.7 50.0 48.9 49.5 44.0 44.4 46.6 9:00 472 49.0 49.8 50.3 51.4 51.6 51.8 51.0 50.5 Night shift 49.2 49.0 48.4 47.6 47.4 48.2 48.0 48.4 49.8 49.8 50.0 47.8 46.4 46.4 47.2 48.4 Night shift 49.2 48.4 47.2 47.4 48.8 49.6 51.0 50.5 46.6 47.0 48.1 47.0 46.8 50.0 47.4 47.0 Night shift 47.2 48.6 49.8 49.6 50.0 50.0 47.2 47.0 48.2 10:00 pm 11:00 12:00 am 1:00 2:00 3:00 4:00 5:00 46.4 46.1 46.3 45.4 44.3 44.1 45.2 45.5 47.1 50.7 50.8 50.2 49.7 49.6 49.0 49.1 49.6 10:00 pm 11:00 12:00 am 1:00 2:00 3:00 4:00 5:00 48.4 49.0 49.2 46.3 44.1 50.2 50.0 50.4 51.7 52.2 50.0 50.5 49.7 10:00 pm 11:00 12:00 am 1:00 2:00 3:00 4:00 5:00 46.8 47.2 49.0 50.5 50.0 50.7 50.8 49.2 49.0 51.4 50.6 51.5 51.9