Question 31 (16 points) As Continuous Improvement Consultant, you have been asked by BC Hydro to lead your key stakeholders (mostly engineers) through a Decision Matrix process. Below are the scores you and your key stakeholders have assigned each process improvement Alternative. Your team is looking to choose the alternative that has the highest TOTAL SCORE. (12 marks) Decision Matrix: EVALUATION CRITERIA WEIGHT Alternative Alternative Alternative Alternative TOTAL COST TIME TO IMPLEMENT JOB SATISFACTION 00 SAFETY LIKELIHOOD TO ADOPT A1 Total Cost: TOTAL SCORE Alternative 1 $ 298,500 Alternative 2 $400,000 Alternative 3 $305,000 Alternative 4 $317,000 TOTAL COST (1) complete the "Decision Matrix" above; by noting your answer corresponding to the letter noted in the question (2) specify the Alternative number that you would recommend based on the completed decision matrix? Question 32 (10 points) A ceramics company makes vases for a chain of retail stores, The output and cost figures for the previous four weeks are shown here. Regular and Overtime hourly rates (the overtime rate would apply to all hours worked above 40 hours in a week for an employee) are shown, as well as the per kilogram cost of materials. For the week of Feb 8-12 & Feb 22-26 calculate the labour, materials and multifactor productivity (the other week's information has already been calculated for you). Calculate and list your answers clearly noting the corresponding letter on the table shown below. (10 marks) Week Feb 1-5 3,000 Feb 8-12 3,500 Feb 15-19 4,000 Feb 22-26 4,000 Vases made Number of workers Hours worked per week per worker Regular hourly labour rate Overtime hourly labour rate Total materials used (kg) Material cost (per kg) 40 $15.00 $22.50 430 $4 $15.00 $22.50 500 $4 48 $15.00 $22.50 575 $4 40 $15.00 $22.50 580 Total Weekly Labour Cost Labour Productivity for Labour cost $2,400 1.25 3,900 1.03 $1,720 $2,300 Total weekly materials cost Materials productivity for Materials 1.74 0.65 Multifactor Productivity Results Question 31 (16 points) As Continuous Improvement Consultant, you have been asked by BC Hydro to lead your key stakeholders (mostly engineers) through a Decision Matrix process. Below are the scores you and your key stakeholders have assigned each process improvement Alternative. Your team is looking to choose the alternative that has the highest TOTAL SCORE. (12 marks) Decision Matrix: EVALUATION CRITERIA WEIGHT Alternative Alternative Alternative Alternative TOTAL COST TIME TO IMPLEMENT JOB SATISFACTION 00 SAFETY LIKELIHOOD TO ADOPT A1 Total Cost: TOTAL SCORE Alternative 1 $ 298,500 Alternative 2 $400,000 Alternative 3 $305,000 Alternative 4 $317,000 TOTAL COST (1) complete the "Decision Matrix" above; by noting your answer corresponding to the letter noted in the question (2) specify the Alternative number that you would recommend based on the completed decision matrix? Question 32 (10 points) A ceramics company makes vases for a chain of retail stores, The output and cost figures for the previous four weeks are shown here. Regular and Overtime hourly rates (the overtime rate would apply to all hours worked above 40 hours in a week for an employee) are shown, as well as the per kilogram cost of materials. For the week of Feb 8-12 & Feb 22-26 calculate the labour, materials and multifactor productivity (the other week's information has already been calculated for you). Calculate and list your answers clearly noting the corresponding letter on the table shown below. (10 marks) Week Feb 1-5 3,000 Feb 8-12 3,500 Feb 15-19 4,000 Feb 22-26 4,000 Vases made Number of workers Hours worked per week per worker Regular hourly labour rate Overtime hourly labour rate Total materials used (kg) Material cost (per kg) 40 $15.00 $22.50 430 $4 $15.00 $22.50 500 $4 48 $15.00 $22.50 575 $4 40 $15.00 $22.50 580 Total Weekly Labour Cost Labour Productivity for Labour cost $2,400 1.25 3,900 1.03 $1,720 $2,300 Total weekly materials cost Materials productivity for Materials 1.74 0.65 Multifactor Productivity Results