You are responsible for determining the settings for your company’s stamping machine. The target is for the stamping machine to place the stamp exactly 3.000 inches from the left edge (the horizontal direction) and 5.000 inches from the top edge (the vertical direction). Unfortunately, the stamping machine does not always place the stamp exactly at (3.000, 5.000) Part 1 Open the Excel workbook “Stamping machine” and enable macros. When you click on the button “Stamping Machine,” you are requested to enter the horizontal setting and vertical setting for the stamping machine. After clicking OK, you will see where the stamp is actually placed in columns D and E of the worksheet. You are testing 4 different decision rules for determining the settings for the stamping machine. The metric to judge the accuracy of the stamping machine will be the distance from the stamp to the target, or where x is the horizontal position (column D) and y is the vertical position (column E). Decision Rule 1: Always set the stamping machine to the target (3.000 inches horizontal, 5.000 inches vertical). Decision Rule 2: If the stamping machine places the stamp from the target, set the stamping machine from its most recent setting. For example, if the stamping machine is currently set at (3.001,4.985) and the machine places the stamp at (3.010, 5.020), the next setting should be (3.001-3.010-3).4985- (5.020-5)) (2.991,4.965). Decision Rule 3: If the stamping machine places the stamp from the target, set the stamping machine from the target. For example, if the machine places the stamp at (3.010, 5.020), the next setting should be (3-(3.010-3), 5-(5.020-5) (2.990,4.980). Decision Rule 4: Set the stamping machine at the stamp’s most recent location. For example, if the machine places the stamp at (3.010, 5.020), the next setting should be (3.010,5.020) Use the Excel sheet to run 30 trials for each one of the decision rules. Create a run chart based on the 30 trials for each decision rule. The run chart should have the trial number on the x-axis and the distance from the stamp to the target on the y-axis. Use the run charts to answer the following questions. You should turn in the results of the 30 trials and the run charts as part of your assignment. Which decision rules result in a stable process? Which decision rules do not result in a stable process? Which decision rule results in the smallest variation? Based on this information, which decision rule should be followed? Part 2 Your company purchases a new stamping machine. Open up the Excel workbook “New stamping machine.” Use the decision rule that you decided should be followed from Part 1 on the new stamping machine and run 30 trials. After running the 30 trials, where should you set the new stampingClick here to order this assignment @Essaybay.net. 100% Original.Written from scratch by professional writers.
Click here to order this assignment @Essaybay.net. 100% Original.Written from scratch by professional writers.