- Questions & Answers
- Accounting
- Computer Science
- Automata or Computationing
- Computer Architecture
- Computer Graphics and Multimedia Applications
- Computer Network Security
- Data Structures
- Database Management System
- Design and Analysis of Algorithms
- Information Technology
- Linux Environment
- Networking
- Operating System
- Software Engineering
- Big Data
- Android
- iOS
- Matlab

- Economics
- Engineering
- Finance
- Thesis
- Management
- Science/Math
- Statistics
- Writing
- Dissertations
- Essays
- Programming
- Healthcare
- Law

- Log in | Sign up

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?

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

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

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%

Answers

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## Answer To This Question Is Available To Download

- Table of ContentsModule Nine9-2 Final Project Presentation and Speaker Notes Submission9-2 Final Project Presentation and Speaker Notes SubmissionPreviousNextInstructionsSubmit the final draft of your...SolvedAug 06, 2022
- Discuss the types of primary data 5-Hour Energy might use and support your position.SolvedAug 05, 2022
- Student Assessment BookletSTUDENT ASSESSMENT BOOKLETBSBMKG623 Develop marketing plansStudent Name: Date Commenced: © 2021 Eduworks Resources Eduworks Resources is a...SolvedAug 03, 2022
- untitledSolvedAug 02, 2022
- Q1. First find an Out of Home Interactive Advertisement (like Honda's Interactive Billboard,) share a copy of it on the discussion board. (Remember, the advertisement must be out of home - and must be...Jul 31, 2022
- Q1. First find an Out of Home Interactive Advertisement (like Honda's Interactive Billboard,) share a copy of it on the discussion board. (Remember, the advertisement must be out of home - and must be...Jul 31, 2022
- In this blog assignment, select a brand that faced ethical or legal issues. Determine how these issues influenced consumer perceptions of the brand and how it impacted their engagement with the brand....SolvedJul 29, 2022
- Sent all the 51 attachments to the chat box. We are restricted to download assignment so had to screen shot. Please follow the instructions for the word count. Question should be covered.TAELED803 -...Jul 27, 2022
- BSBMKG627 - Execute advertising campaignsTask 2 –Portfolio of EvidenceTask summaryThis assessment is to becompleted using the Bounce Fitness simulated work environment. This assessment task requires...SolvedJul 25, 2022
- Overview: For this second milestone, you will identify key attributes of a brand in the growth stage, assess how the marketing mix is used at this stage todevelop brand equity and how it may impact...SolvedJul 24, 2022

Copy and Paste Your Assignment Here

Copyright © 2022. All rights reserved.