2. Go to the tab titled "Direct Labor Summary.": a. Using PivotTable, calculate the total direct labor cost and total direct labor-hours for each of the 12 jobs. b. What is the total direct labor cost for Jobs 3 and 10? c. What are the total direct labor-hours for Jobs 3 and 10? Complete this question by entering your answers in the tabs below. Req 2B Req 2c What are the total direct labor-hours for Jobs 3 and 107 Job 3 Job 10 The total direct labor hours are 2 ? > ? ? ? 2 9 10 11 12 2 ? H Molding Employee Jepartmen Job Alison Variston Assembly 10 Alson Vanston Assembly 12 Cody Smith on Asteb 1 Cathy Smithton Assembly 6 Cathy Smithson Arroy 7 7. Cwhy Smithron Astebly 8 8. Christopher Tan Assembly 9 Christopher Tanaka Assemble 10 Christopher Tonak Aste 11 Damien Charles Fabion Damien Charles Fobrowon 13 Damien Charles Fabrication 6 14 Darren Charles FSbrio vion 9 15 David Chen Molding 4 16 Dwi Chen Molding 6 12 David Chen Molding 7 13 Em Evans Assembly 19 Emil Evan Astembly 6 20 Emily Evans Assembly 11 21 Em Evans Assembly 12 22 Ernest Koyman Assembly 2 23 Ernest Roman Assembly 3 24 Ernest Koman Assembly 12 25 Joe Durand Molding 2 26 Dwand Molding 5 27 Jeff Durand 10 28 Jeff Durand Molding 12 28 J Rhyme Asembly 5 30 James Assembly 11 31 Jan Thompson Molding 32 Jovan Thompson Molding 3 30 Jan Thompson Molding 9 34 Kayla Burke Assembly 35 Lotetta Hon Assembly 26 Loretta Hot Assembly 97 Loretta Hoyt Astembly 38 Loreta Assembly 39 Madison Rodriquez Fabronion 40 Madison Rodriquez Fabiowion 41 Moshal Toliver Molding 8 42 Marshall Toliver Melding 11 43 Mary Jo Have Fabrication 2 44 Mary Jo Hawley Fabiomion 10 45 Mary Jo Hawley Fabation 11 46 Mary Jo Havoy Fabroon 12 47 Michael Korshaw Fabiotion 4 48 Mohael Kershaw Fabrication 8 3 Rebecca Wit Assembly 50 Rebecca Wils Assembly 51 Pobecca Wil Assembly 6 52 Rebecca Was Assembly 8 53 Rebecca Wii Assembly 3 56 Rebeca Assembly 20 55 WAMark Asembly 3 56 W Maks Assembly 67 W Maks Assembly 7 58 69 Pivot Table D Direct Dueet Direct Labor Labor Labor Hours Wage Cost 17.00 20 + 340 3.25 1 201 65 250 + 201 50 0.75 20 15 2.25 + 20 + 45 250 200 70 19011 201 30 2.50 20 50 3.75 1 20 75 4.50 1 201 SO 28.50 20 0 530 1100 200 220 27.00 20 540 100+ 20 20 2001 20+ 240 225 20$ 45 30.00 1 200 800 20.500 20$ 410 800 20 350 5.00 201 100 75 00 201 300 3100 20+ 820 3.75 + 20 $ 75 10.500 20 0 210 2.750 20$ 55 10.00 . 20 200 4.00 + 20 80 6.50 $ 20 $ 130 100 $ 20 3 20 3.25 0 20 t 65 22.00 1 20 25.000 20 $ 500 3.25 + 201 65 13.50 20 270 18.500 201 370 2100 + 20 1 420 4.00 200 80 450 $ 201 90 3.25 : 201 65 0.750 201 IS 6.00 $ 20 t 120 1125 205 225 8.00 20 160 11005 20 220 6.00 20 $ 120 1.000 20 : 20 4.00 $ 200 80 3.28 20. 65 12.75 + 20 255 26.00 : 20 0 520 3.50 20$ 70 3200 20 $ 6.40 700 $ 200 140 15.50 1 20 30 1001 20 $ 20 125 1 20 25 440 VLOOKUP Direct Materials Requisitions
