Savita A time study was conducted on a job that contains four elements. The observed times and performance ratings for six cycles areshown in the following table.Element1234PerformanceRating90%9095105Element123410.531.530.881.13OBSERVATIONS (minutes per cycle)Click here for the Excel Data File230.580.481.531.480.88 0.781.181.13540.48 0.481.481.480.83 0.881.181.18a. Determine the average cycle time for each element. (Round your answers to 3 decimal places.)Average cycle60.481.530.831.23 b. Find the normal time for each element. (Round your answers to 3 decimal places.)Element1234c. Assuming an allowance factor of 23 percent of job time, compute the standard time for this job. (Round your answers to 3 decimalplaces.)Element12Normal time34Standard time

I have solved the problem using Excel and Here are the Excel formulas:

A time study was conducted on a job that contains four elements. The observed times and performance ratings for six cycles are shown in the following table. Element 1 2 3 Performance Rating 90% 90 95 105 Element 1 2 3 1 0.53 1.53 0.88 1.13 OBSERVATIONS (minutes per cycle) 3 5 0.48 0.48 0.48 1.48 1.48 1.48 0.88 0.78 0.88 0.83 0.83 1.18 1.13 1.18 1.18 1.23 2 0.58 1.53 Click here for the Excel Data File a. Determine the average cycle time for each element. (Round your answers to 3 decimal places.) Average cycle 6 0.48 1.53

A time study was conducted on a job that contains four elements. The observed times and performance ratings for six cycles are shown in the following table. Element 1 2 3 Performance Rating 90% 90 95 105 Element 1 2 3 1 0.53 1.53 0.88 1.13 OBSERVATIONS (minutes per cycle) 3 5 0.48 0.48 0.48 1.48 1.48 1.48 0.88 0.78 0.88 0.83 0.83 1.18 1.13 1.18 1.18 1.23 2 0.58 1.53 Click here for the Excel Data File a. Determine the average cycle time for each element. (Round your answers to 3 decimal places.) Average cycle 6 0.48 1.53

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Yelp Dog Food produces specialized dog foods in 1-pound packages. The amount of dog food in each package should be 1 pound, and Yelp has determined that the standard deviation of the machine filling these packages is half an ounce, and the confidence interval is 14.85% (2= 1872). In order to confirm that the machine is operating properly, Yelp takes 16 sample bags every hour and weighs them. The means of these 16 bags for an 8-hr shift is given below. 1. 2. 3. 4 5. 6. 8 0.98 1.01 0.97 1.03 1.01 0.94 1.02 1.02 13. For this one day's worth of filling bags, what would be the upper control limit? A. 1.0000 B. 1.0209 C. 1.0324 D. 1.0913 14. What would be the lower control limit? A. .9038 B. 9567 C.9741 D..9892 15. How many, if any, of the hours were out of control? A.O B. 2 C.3 D. 7
The mean service time (x¯) of a physician is 25 minutes with a standard deviation (σ) of 1 minute. Upper specification limit (USL) is 30 minutes, whereas lower specification limit (LSL) is 20 for this process. What is the process capability ratio (cp) for this process? Is the process capable? Cp=1, barely capable Cp=1.5, capable Cp=1, not capable Cp=1.67, not capable Cp=1.67, definitely capable
As part of an insurance company’s training program, participants learn how to conduct an analysis of clients’ insurability. The goal is to have participants achieve a time in the range of 30 to 45minutes. Test results for three participants were: Armand, a mean of 38 minutes and a standarddeviation of 3 minutes; Jerry, a mean of 37 minutes and a standard deviation of 2.5 minutes; andMelissa, a mean of 37.5 minutes and a standard deviation of 1.8 minutes.a. Which of the participants would you judge to be capable? Explain.b. Can the value of the Cpk exceed the value of Cp for a given participant? Explain.
Yelp Dog Food produces specialized dog foods in 1-pound packages. The amount of dog food in each package should be 1 pound, and Yelp has determined that the standard deviation of the machine filling these packages is half an ounce, and the confidence interval is 14.85% (z = .1872). In order to confirm that the machine is operating properly, Yelp takes 16 sample bags every hour and weighs them. The means of these 16 bags for an 8-hr shift is given below. 1 2 3 4 5 6 7 8 0.98 1.01 0.97 1.03 1.01 0.94 1.02 1.02 NARREND What would be the lower control limit? .9038 .9567 .9741 .9892
Yelp Dog Food produces specialized dog foods in 1-pound packages. The amount of dog food in each package should be 1 pound, and Yelp has determined that the standard deviation of the machine filling these packages is half an ounce, and the confidence interval is 14.85% (z = .1872). In order to confirm that the machine is operating properly, Yelp takes 16 sample bags every hour and weighs them. The means of these 16 bags for an 8-hr shift is given below. 1 2 3 4 5 6 7 8 0.98 1.01 0.97 1.03 1.01 0.94 1.02 1.02 NARREND How many, if any, of the hours were out of control? 0 2 3 7
This exercise contains only parts a and b. a) For the given data, the x= ____ hours (round your response to three decimal places). For the given data, mean range =_____hours (round your response to two decimal places). With z=3, the control limits for the mean chart are: UCLx= ____hours (round your response to three decimal places). LCLx=____hours (round your response to three decimal places). The control limits for the range chart are: UCLR=____hours (round your response to two decimal places). LCLR=h____ours (round your response to two decimal places). With these limits established, West now takes 5 more hours of data, which are shown in the following table. Calculate the mean and range for each hour that the sample data is taken. (Enter your responses for the mean to…
Management at Deluxe Diner is in process of establishing a quality control system for the time it takes to initially make contact with a table of patrons. A sample of size 3 is taken on each of the five different days. The following data table presents the results (all times listed are in seconds). Time 1 Time 2 Time 3 Service Encounter day 1 day 2 day 3 day 4 day 5 200 120 83 68 110 150 85 93 150 90 175 105 130 145 75
The mean processing time (x¯) of a job on a machine is 11 minutes with a standard deviation (σ)of 0.23 minutes. Upper specification limit (USL) is 11.5 minutes, whereas lower specification limit (LSL) is 10.5 minutes. What is the process capability ratio (cp) for this process? Is the process capable? Cp=1, not capable Cp=1.5, capable Cp=0.72, capable Cp=1, capable Cp=0.72, not capable
As part of an insurance company’s training program, participants learn how to conduct an analysis of clients’ insurability. The goal is to have participants achieve a time in the range of 30 to 45 minutes. Test results for three participants were the following: Armand, a mean of 36.0 minutes and a standard deviation of 2.0 minutes; Jerry, a mean of 37.0 minutes and a standard deviation of 2.0 minutes; and Melissa, a mean of 37.5 minutes and a standard deviation of 2.6 minutes. a.Compute process capability for the participants and determine whether each is capable, given 4-sigma quality standards. (Do not round intermediate calculations. Round your answers to 2 decimal places.)
As part of an insurance company’s training program, participants learn how to conduct an analysis of clients’ insurability. The goal is to have participants achieve a time in the range of 30 to 45 minutes. Test results for three participants were the following: Armand, a mean of 36.0 minutes and a standard deviation of 3.0 minutes; Jerry, a mean of 34.0 minutes and a standard deviation of 2.0 minutes; and Melissa, a mean of 37.5 minutes and a standard deviation of 1.7 minutes. a.Compute process capability for the participants and determine whether each is capable. (Do not round intermediate calculations. Round your answers to 2 decimal places.) Melissa ? Cp what is it
Management of Mittel Rhein AG of Köln, Germany, would like to reduce the amount of time between when a customer places an order and when the order is shipped. For the first quarter of operations during the current year the following data were reported: Inspection time- 0.7 daysWait time (from order to start of production) -16.6 daysProcess time -2.7 daysMove time -1.3 daysQueue time- 4.5 daysRequired:1. Compute the throughput time. (Round your answer to 1 decimal place.) 2. Compute the manufacturing cycle efficiency (MCE) for the quarter. (Round your answer to the nearest whole percentage (i.e., 0.12 should be entered as 12).) 3. What percentage of the throughput time was spent in non–value-added activities? (Round your answer to the nearest whole percentage (i.e., 0.12 should be entered as 12).) 4. Compute the delivery cycle time. (Round your intermediate calculations and final answer to 1 decimal place.) 5. If by using Lean Production all queue…
The pulp and paper factory is one of the longest industrial sectors in the world. Thus, international paper company wants to increase their output. Based on its product, the thickness of 500 sheet of papers is 2.027558055 inch. Without decreasing its quality according to scientific experiments they had done, they decided to use rounding off formula from 9 decimal places to 6 decimal places based on thickness of the paper. Discuss the above study in view of absolute and relative errors. If you are quality control manager of the factory, what is your BEST action towards production line with above decision. Justify your answer.