Please complete each page of the excel file and show your work.
Ch13-1 The answers are in row 55 of each sheet (except for solved problems in the book.) Answers a) 0.667 b) 2.28% c) 0.086% &F &A Pioneer Chicken “lite” chicken breast is supposed to contain 400 calories. In reality, the specification limits call for the calories to be 400 ± 50 calories, so the chicken breast is considered acceptable if it contains between 350 and 450 calories. Suppose the calories content was measured from a sample of chicken breasts. The mean from the sample was 420 calories, and the standard deviation was 15 calories. a) What is the process capability index, Cpk? Based on this, is this process considered capable? b) According to the given sample data, what percent of the output from the process would be considered unacceptable? c) Suppose Pioneer Chicken was able to improve the process so that the process mean is now at 400 calories (standard deviation is still 15 calories). Now what percent of the output will be unacceptable? Ch13-2 No.x1x2x3x4 127.3466727.5008529.9441228.21249 227.7969526.1500631.2129531.33272 333.5325529.3297129.704631.053 437.9840932.2694231.9174129.44279 533.8272230.3254328.3811733.70124 629.6835629.5667727.2307734.00417 732.626426.320332.0789236.17198 830.2957530.5286824.4331526.85241 928.4385630.4825132.4308330.76162 1028.277933.9491630.4740628.87447 1126.9188527.6613331.4693629.66928 1228.4654728.2993728.9944131.14511 1332.4267726.104129.4771837.20079 1428.8427330.5180132.2361430.47104 1530.7513632.9992228.0845226.19981 1632.2575421.2947337.4647728.41126 1731.2492128.5795435.0086531.23591 1831.4155438.8004933.6090924.82131 1932.202332.0200532.7101829.3762 2026.9160329.7777533.9269633.78366 Ans: (a) Control limits for x-bar: 25.58 and 35.35, Control limits for R: 0 and 15.29 (c) No, R chart has one point that is higher than the UCL. You are given measurements for 20 samples. Each sample has 4 measurements. (a) Find the upper and lower control limits for X-bar chart and R chart. (b) Create x-bar and r charts. (c) Is the process in control? Ch13-3 SampleNumber of Defects in Sample 111 28 312 49 56 613 718 85 916 104 1111 128 1312 144 156 Ans: LCL0.001795 UCL0.074471 Yes, in control The data processing department for the Arizona Bank has 5 data entry clerks. Each day their supervisor verifies the accuracy of a random sample of 250 records. A record containing one or more errors is considered defective and must be redone. The results of the last 15 samples are shown here. Compute the control limits, LCL and UCL, for a p-chart using z = 3. Is this process in control? Ch20-1 Ans: a) number of units sold30 ending inventory10 units shortage0 total cost870 b) total cost880 c) Team 1 In the inventory simulation from class, recall for each month, you had to decide whether to place an order (for hockey sticks) and how many to order. The order quantity was assumed to arrive in the same month the order is placed. So it would be available to satisfy the demand for that month. No backorders were allowed. Suppose the selling price is $60/unit, the unit cost is $30, the cost to place an order is $100 per order, cost of shortage is $10 per unit, and holding cost of ending inventory each month is $2 per unit. In one month, suppose beginning inventory = 15 units, order quantity = 25 units, and demand = 30 units. a) Determine the following 4 values. Number of units sold: Units of ending inventory: Units short: Total cost for that month (ordering + holding + shortage): b) If the demand is actually 43 units instead of 30, what is the total cost for that month? c) Suppose the total order quantity for the year is the same for team 1 and team 2, but team 1 ordered more frequently. Which team will incur the higher total holding cost for the year? Ch20-2 Ans. a) $1688 b) 118.39 -> 118 c) 45.2 -> 46 Inventory A museum of natural history has opened a gift shop two years ago. One of the top-selling items at the museum’s gift shop is a bird feeder. The annual demand is 1,460 units, and the supplier charges $50 per unit. The cost of placing an order with the supplier is $60. Annual holding cost per unit is 25% of the unit cost, and the museum operates all 365 days in a year. Under fixed-order quantity policy, management chose to order 200 units each time when the inventory goes down to certain point. a) With Q of 200 units, what is the total annual relevant cost of the current policy (ordering + holding cost)? b) Instead of Q of 200, the management could adopt the economic order quantity (EOQ) to lower the inventory related costs. What is the EOQ? c) Suppose the daily demand has average of 4 units, but it fluctuates according to a normal distribution with standard deviation of 1 unit. The lead time is 10 days. To achieve 95% service level, what is the appropriate reorder point?