# Please complete each page of the excel file and show your work.

Please complete each page of the excel file and show your work.
Ch13-1The answers are in row 55 of each sheet (except for solved problems in the book.)Answersa) 0.667b) 2.28%c) 0.086%&F&APioneer 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-2No.x1x2x3x4127.3466727.5008529.9441228.21249227.7969526.1500631.2129531.33272333.5325529.3297129.704631.053437.9840932.2694231.9174129.44279533.8272230.3254328.3811733.70124629.6835629.5667727.2307734.00417732.626426.320332.0789236.17198830.2957530.5286824.4331526.85241928.4385630.4825132.4308330.761621028.277933.9491630.4740628.874471126.9188527.6613331.4693629.669281228.4654728.2993728.9944131.145111332.4267726.104129.4771837.200791428.8427330.5180132.2361430.471041530.7513632.9992228.0845226.199811632.2575421.2947337.4647728.411261731.2492128.5795435.0086531.235911831.4155438.8004933.6090924.821311932.202332.0200532.7101829.37622026.9160329.7777533.9269633.78366Ans: (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-3SampleNumber of Defects in Sample1112831249566137188591610411111281312144156Ans:LCL0.001795UCL0.074471Yes, in controlThe 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-1Ans: a)number of units sold30ending inventory10units shortage0total cost870b)total cost880c)Team 1In 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-2Ans.a) \$1688b) 118.39 -> 118c) 45.2 -> 46InventoryA 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?
Answered 2 days AfterJun 29, 2022

Sultana answered on Jul 01 2022
Ch13-1
The answers are in row 55 of each sheet (except for solved problems in the book.)
a)
Upper    450
Lower    350
Process Mean    420
Standard Deviation    15
Cpk = MINIMUM((UPPER
- MEAN) / 3 * STANDARD DEVIATION), (MEAN - LOWER ) / 3 * STANDARD DEVIATION)
Cpk     0.667
b)
PROBABILITY OF BEING UNDER 350
Z-LSL = (LOWER - MEAN) / STANDARD DEVIATION
Z-LSL     -4.6666666667
Probability     0.0000
PROBABILITY OF BEING OVER 450:
Z-USL = (UPPER - MEAN) / STANDARD DEVIATION
Z-USL     2
Probability     0.0228
PROBABILITY = PROBABILITY OF BEING UNDER LSL + PROBABILITY OF BEING OVER USL
Probability     0.0228
2.28%
c)
PROBABILITY OF BEING UNDER 350
Z-LSL = (LOWER - MEAN) / STANDARD DEVIATION
Z-LSL     -3.3333
Probability     0.0004
PROBABILITY OF BEING OVER 450:
Z-USL = (UPPER - MEAN) / STANDARD DEVIATION
Z-USL     3.3333333333
Probability     0.0004
PROBABILITY = PROBABILITY OF BEING UNDER LSL + PROBABILITY OF BEING OVER USL
Probability     0.0009
0.086%
a) 0.667
b) 2.28%
c) 0.086%
&F
&A
Pioneer Chicken “lite” chicken
east is supposed to contain 400 calories. In reality, the specification limits call for the calories to be 400 ± 50 calories, so the chicken
east is considered acceptable if it contains between 350 and 450 calories.
Suppose the calories content was measured from a sample of chicken
easts. 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?

) 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.    x1    x2    x3    x4    x...
SOLUTION.PDF