PLEASE READ!!
PLEASE DO EVERYTHING ON GOOGLE EXCEL SHEETS AND POST THE LINK TO IT.
Chapter 6 - Managing Quality 20 points Use Pareto analysis to investigate the following data collected on Defect Number of Defect Occurences a printed-circuit-board assembly Components not adhering 143 Excessive Adhesive 71 (a) Prepare a Pareto chart of the data Misplaced transistors 601 Defective board dimension 146 (b) What conclusions do you reach? Mounting holes improperly positioned 12 Circuitry problems on final test 90 Wrong component 212Chapter 7 - Process Strategies 20 points Borges Machine Shop, Inc., has a 1-year contract for the production of 200,000 gear housings for a new off-road vehicle. Owner Luis Borges hopes the contract will be extended and the volume increased next year. Borges has developed costs for three alternatives. They are general-purpose-equipment (GPE), flexible manufacturing system (FMS), and expensive, but efficient, dedicated machine (DM). The cost data follow: Flexible General Purpose Dedicated Equipment (GPE) Manufacturing Machine System Annual Contacted Units 200,000 200,000 200,000 Annual Fixed Cost 100,000 $ 200,000 $ 500,000 Per Unit Variable Cost 15 | $ 14 | $ 13 1) Which process is best for this contract? Explain 2) What is the economical volume for each process (at what volume is each process the cheapest alternative?)Chapter 8 - Location Strategies 20 points Ken Gilbert owns the Knoxville Warriors, a Factor Weight Mobile Jackson minor league baseball team in Tennessee. He wishes to move the Warriors south, to Incentive 0.4 80 60 either Mobile (Alabama) or Jackson Player Satisfaction 0.3 20 50 (Mississippie on the right gives the Sports Interest 0.2 40 90 factors that Gilbert thinks are important, Size of the City 0.1 70 30 their weights, and the scores for Mobile and Jackson. 1) Which site should be selected? 2) Jackson just raised its incentive package and the new score is 75. Why doesn't this impact your decision in #1?Chapter 9 - Layout Strategies 20 points Stanford Rosenberg Computing Company wants to establish Immediate an assembly line for producing a new product. Personal Task Time (Sec) Predecessors Digital Executive (PDE). The tasks, task times, and immediate predecessors are on the right table. Rosenberg's goal is to A 12 produce 180 PDEs per hour B 15 A C 8 A D 5 B, C E 20 D 1) What is the cycle time?(in seconds/ PDE) Hint: Cycle 2) What is the theoretical minimum for the number of 3) Can the theoretical minimum be actually achieved v 4) What is the efficiency of the line?Chapter 10 - Human Resource Strategy 20 points A hotel housekeeper, Alison Harvey, was observed five times on each of four task elements (please refer to table). On the basis of these observations, find the standard time for the process. Assume 10% allowance factor. Observations (Minutes per cycle) Performance Element Rating (%) 1 2 3 4 5 Check minibar 100 1.5 1.6 1.4 1.5 1.5 Make on bed 90 2.3 2.5 2.1 2.2 2.4 Vacuum floor 120 1.7 1.9 1.9 1.4 1.6 Clean bath 100 3.5 3.6 3.6 3.6 3.2