A B c D E r G H | J K L M N o P Form ula: Multlp , Add; Absolute Cell Referenclm Using Excel to Calculate Labor, Material, and Multifactor Productivity Student Work Area 1 2 3 4 PROBLEM , Required: Provide input into cells shaded in yellow in this template. Input 5 'Lanen Frames makes ceramic frames for a chain of department stores. The output and the required mathematical formulas or functions with cell references to the 6 7 8 9 cost figures over the past four weeks are shown here. Problem area or work area as indicated. i ' Labor cost per hour 5 12.00 Materials cost per pound s 380 Calculate the labor productivity in hours, material productive in pounds, and 10 multifactor productivity for each week 11 1 Week 1 2 ~ 3 4 12 Units of output 2,100 4,200 5,200 7,100 Week 1 2 3 4 13 I Number of workers 4 4 5 6 Labor productivity I 'II 14 ' Hours per week per worked 40 48 56 70 15 1 Material (pounds) 289 560 732 1,040 Material productivity ' ' ' ' 16 17 % Multifactor productivity ' ' ' ' 18 E 19 20 21 i 22 23 L ' 24 25 26 27 28 29 ' i 30 I 31 32 ' ' 33 34 ' 35 36 38 ' 39