BUS309: Excel

AutoSave OFF ... MidTerm 2 Part 2 Questions ~ Q OP Home Insert Draw Page Layout Formulas Data Review View Automate Developer Tell me Comments Share Calibri (Body) 11 A A Conditional Formatting Format as Table v Paste BIUV Alignment Number Cells Editing Analyze Automate Reference Translator Solver Cell Styles v Data Content F14 X v fx B D E F G H 1 Chapter 6 - Managing Quality 20 points Use Pareto analysis to investigate the following data Defect Number of Defect Occurences collected on a printed-circuit-board assembly Components not adhering 143 Excessive Adhesive 71 (a) Prepare a Pareto chart of the data (10 pts) Misplaced transistors 601 Defective board dimension 146 (b) What conclusions do you reach? (10 pts) Mounting holes improperly positioned 12 Circuitry problems on final test 90 10 Wrong component 212 11 12 13 14 27 28 Q1 Q2 Q3 Q4 Q5 + Ready iT Accessibility: Good to go + 110%AutoSave OFF ... MidTerm 2 Part 2 Questions ~ Q OP Home Insert Draw Page Layout Formulas Data Review View Automate Developer Tell me Comments Share Calibri (Body) 11 A A Conditional Formatting Format as Table v Paste BIUV MVA Alignment Number Cells Editing Analyze Automate Reference Translator Solver Cell Styles v Data Content D18 X V fx B C D E F G H K M N O P R 1 Chapter 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: 10 11 Flexible General Purpose Dedicated Equipment (GPE) Manufacturing Machine 12 System 13 Annual Contacted Units 200,000 200,000 200,000 14 Annual Fixed Cost $ 100,000 $ 200,000 $ 500,000 15 Per Unit Variable Cost 15 $ 14 $ 13 16 17 1) Which process is best for 18 this contract? Explain (10 pts) 2) What is the economical volume for each process (at what volume is each process the cheapest alternative?) (10 pts) Q1 Q2 Q3 Q4 Q5 + Ready i Accessibility: Good to go + 100%OP AutoSave OFF ... MidTerm 2 Part 2 Questions ~ Q Home Insert Draw Page Layout Formulas Data Review View Automate Developer Tell me Comments Share 11 A Conditional Formatting Calibri (Body) A Format as Table v Solver Paste BIUV VA Alignment Number Cells Editing Analyze Automate Reference Translator Cell Styles v Data Content Co X V fx A B C D E F G H M N O P Q R 1 Chapter 8 - Location Strategies 20 points (X, Y) Bases Tonnage A contractor for the military is looking for a new location for a supply depot. The depot will supply four bases whose tonnage (demand) 3 Coordinates and map coordinates are shown below. If management wants the depot to have a central location, what should be its map coordinates? Fort Able -40,110 30,000 5 Base Baker (70, 50) 60,000 6 Camp Charlie 90, 20) 35,000 Camp Delta (70, 80) 75,000 8 9 10 11 12 13 14 15 27 Q1 Q3 Q4 25 + Ready i Accessibility: Good to go + 110%AutoSave OFF ... MidTerm 2 Part 2 Questions ~ Q OP Home Insert Draw Page Layout Formulas Data Review View Automate Developer Tell me Comments Share Calibri (Body) 11 A A Conditional Formatting Format as Table v Paste BIUV MVA Alignment Number Cells Editing Analyze Automate Reference Translator Solver Cell Styles v Data Content J17 X V fx B D E F G H K M N O P Q R S 1 Chapter 9 - Layout Strategies 20 points Stanford Rosenberg Computing Company wants to Immediate establish an assembly line for producing a new product. Task Time (Sec) Predecessors Personal Digital Executive (PDE). The tasks, task times, and immediate predecessors are on the right table. A 12 Rosenberg's goal is to produce 180 PDEs per hour 15 A A mon w B, C 20 D 10 11 (5 pts) 1) What is the cycle time?(in seconds/ PDE) Hint: Cycle time using 180 PDEs/ hr is 1 hr/ 180 PDEs or 60 mins/ 180 PDEs; convert it to seconds / PDEs (5 pts) 2) What is the theoretical minimum for the number of workstattions that Rosemary can achieve in this assembly line? (5 pts) 3) Can the theoretical minimum be actually achieved when work stattions are assigned? (5 pts) 4) What is the efficiency of the line? Q1 Q2 Q3 Q4 Q5 + Ready i Accessibility: Good to go + 100%AutoSave OFF ... MidTerm 2 Part 2 Questions ~ Q OP Home Insert Draw Page Layout Formulas Data Review View Automate Developer Tell me Comments Share Calibri (Body) 11 A A Conditional Formatting Format as Table v BIUV Cells Editing Analyze Automate Reference Translator Solver Paste Alignment Number Cell Styles v Data Content BH X V fx C D E F G H M N O P Q B 1 Chapter 10 - Human Resource Strategy 20 points w A hotel housekeeper, Alison Harvey, was observed five times on each of four task elements (please refer to 4 table). On the basis of these observations, find the standard time for the process. Assume 10% allowance factor. Observations (Minutes per cycle) Performance 8 Element Rating (%) 2 3 4 5 9 Check minibar 100 1.5 1.6 1.4 1.5 1.5 10 Make on bed 90 2.3 2.5 2.1 2.2 2.4 11 Vacuum floor 120 1.7 1.9 1.9 1.4 1.6 12 Clean bath 100 3.5 3.6 3.6 3.6 3.2 13 14 15 16 17 18 Q1 Q2 Q3 Q4 Q5 + Ready i Accessibility: Good to go 110%