1 a. Multi-factor analysis for each week using all input of labor, materials and overhead together. See 'hint' below. b. Single factor analysis for each week on labor and materials separately. c. What do analyses a & b indicate about the health of this process? Is it gaining in productivity over time or not? If not, which of the factors seem to be the problem? 3. Compute the multifactor productivity measure for each of the weeks shown for production of chocolate bars. What do the productivity figures suggest? Assume 40-hours work in a week and 10 an hourly wage of $12. Overhead is 1.5 times weekly labor cost. Material cost is $6 per pound. 12 Given 13 DATA: Input Week Output Labor Amt Matis Ibs 30,000 450.0 33,600 470.0 W N 32,20 460.0 35,400 480.0 21 Materials = $6.00 per pound (#) 22 Labor hours/day 5 days/wk @ 12$ per hour 23 Overhead = $1.50 per labor hour 24 MULTI FACTOR ANALYSIS WITH LABOR AND MATERIALS: LABOR MATERIALS Ovhd Total Ratio Rankings # Week Output Amt hrs Rate Cost Amt Rate Cost Cost Cost Out/Input Labor Matls Multi 0 0 DO OC 35 36 Tot = 0.0 0.00 0.00 37 Avg= 0.0 0.0 0.O 38 A 39 SINGLE FACTOR ANALYSIS WITH LABOR: Ratio / $1 41 Week Output Crew Labor Cost Ratio / Amt Input Rank # 1 0 $0.00 #DIV/O! #DIV/O! o $0.00 #DIV/O! #DIV/0! o $0.00 # #DIV/O! 45 $0.00 #DIV/O! #DIV /O! 46 Tot = 0.0 0.0 $0.00 47 Avg= 0.0 $0.00 48 Analysis: 49 50 SINGLE FACTOR ANALYSIS WITH MATERIALS: Ratio / $1 51 Week Output Matis Amt Matis Cost Ratio / Amt Input Rank # 52 0.0 $0.00 #DIV/O! #DIV/O! 0 0.0 $0.00 #DIV/O! #DIV /O! 0 0.0 $0.00 #DIV/O! #DIV/O! o 0.0 $0.00 #DIV/O! #DIV/O! 0.0 0.00 $0.00 57 Avg= 0.0 0.00 $0.00 Conditional Formatting 58 Analysis