1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which...

  
 

Transcribed Image Text:

1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which is now called Pivot table 1, go to cell A1 then "insert" "pivot table" using the data range provided on the data sheet (including the heading lines). Drag "account to the row labels and "amount to the Values. You should now see the dollar amounts for sales revenue, direct materials, direct labor, variable overhead, and Grand Total (contribution margin). If you don't see the dollar amounts click the arrow next to amounts in the Values box and choose "Sum of amount". Next, answer the following: How much are total sales revenues? How much are total direct material costs? How much are total direct labor costs? How much are total overhead costs? How much is total contribution margin? 2. Add a sheet and rename "Pivot table 2". On the sheet which is now called Pivot table 2, insert a pivot table in cell A1 using the data range provided on the data sheet (including the heading lines). Drag "sales person to the Row Labels box, drag "account to the Column Labels box, and drag "amount to the Values box. Answer the following: Which sales person generated the highest sales revenue? Which sales person generated the highest contribution margin? Which sales person generated the lowest sales revenue? Which sales person generated the lowest contribution margin? 3. Add a sheet and rename it "Pivot table 3. On the sheet which is now called Pivot table 3 insert a pivot table at cell A1 using the data range provided on the data sheet (including the heading lines). Drag Job to the Row Labels box and "amount to the Values box. On the table select the data in the sum of amounts column and sort from highest to lowest. Answer the following: Which job number generated the highest contribution margin? Which job number generated the lowest contribution margin? 4. Add a sheet and rename "Pivot table 4. On the sheet which is now called Pivot table 4 insert a pivot table at cell A1 using the data range provided on the data sheet (including the heading lines). Drag "customer to the Row Labels box and "amount to the EValues box. On the table select the data in the sum of amounts column and sort from highest to lowest. Which customer generated the highest contribution margin? Which customer generated the lowest contribution margin? 5. Rename sheet 4 "Pivot table 5. On the sheet which is now called Pivot table 5 insert a pivot table at cell A1 using the data range provided on the data sheet (including the heading lines). Drag "location" to the Row Labels box and "amount to the EValues box. Which location generated the highest contribution margin? Which location generated the lowest contribution margin? Submit your Excel worksheet and answers to the above. Job # CUSTOMER 1008 Marut 1008 Marut 1008 Marut 1008 Marut 1011 Mihal 1011 Mihal 1011 Mihal TUTT MIN 1011 Mihal 1020 Lago 1020 Lago 1020 Lago 1020 Lago 1020 Lago 1020 Lago 1021 Williams 1021 Williams 1021 Williams or William 1021 Williams 1022 Zameer 1022 Zameer 1022 Zameer same 1022 Zameer 1025 Norm YO 1025 Norm 1025 Norm 1025 Norm 1026 Lerer 1026 Lerer 1026 Lerer 1026 Lerer 1029 Norm 1000 N 1029 Norm 1029 Norm TOES NOT 1029 Norm 1029 Louis 1029 Louis 1029 Louis 1029 Louis 1029 LOUIS 1030 Lago 1030 Lago 1030 Lago 1030 Lago 1030 Lago 1030 Lago 1030 Lago 1031 Norm 1031 Norm 1021 Norm 1031 Norm 1021 Norm 1031 Norm con wal 1044 Williams 1044 Willie 1044 Williams wwwwwww 1044 Williams 1044 Williams PEM 1048 Louis COMME 1048 Louis 1048 Louis 1048 Louis 1049 Junior 1049 Junior 1049 Junior 1049 Junior 1050 Lago 1050 Lago 1050 Lago 1050 Lago 1051 Williams SALES PERSON K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen M. Cohen M Cohon M. Cohen M. Cohen C. Mayer C. Mayer Ma C. Mayer C. Mayer F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Cohen M. Cohen Tom M. Cohen M. Cohen M.Ryan M. Ryan M.Ryan M. Ryan C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen M. Coben M. Cohen M Cohen M. Cohen M. Cohen Cohen M. Cohen Cohen M. Cohen M. Cohen M. Cohen F. Mc Govern F. Mc Govern. F. Mc Govern F. Mc Govern M.Ryan M.Ryan M.Ryan M. Ryan C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen ACCOUNT # 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor AZ 5050 Variable Overhea AZ 4000 Sales Revenue NJ 1000 Balt 5020 Direct Materials NJ 13020 Direct 5040 Direct Labor 3040 Direct Labor NJ INJ 5050 Variable Overhea NJ 4000 Sales Revenue LO CO 5020 Direct Materials CO 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue NJ 5020 Direct Materials NJ Direct Labor 5040 Direct Labor NJ 5050 Variable Overhea NJ Farhus 4000 Sales Revenue CO 5030 Die 5020 Direct Materials CO 5040 Direct Labor 2040 Direc со 5050 Variable Overhea CO 4000 Sales Revenue KA 2000 5020 Direct Materials KA OVED BITC 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue NJ 2030 5020 Direct Materials NJ POZO Direct NJ 5040 Direct Labor Fore 5050 Variable Overhea NJ 4000 Sales Revenue KA 2000 5020 Direct Materials KA de 5040 Direct Labor KA NA 5050 Variable Overhea KA 4000 Sales Revenue CO co 5020 Direct Materials CO 5040 Direct Labor CO CO 5050 Variable Overhea CO 4000 Sales Revenue KA KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 1000 Sales 4000 Sales Revenue NJ 5020 Direct Materia 5020 Direct Materials NJ NJ 5040 Direct Labor Vente 5050 Variable Overhea NJ 4000 Sales Revenue KA F030 Di KA 5020 Direct Materials KA 5040 Direct Labor 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ INT 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue NJ LOCATION AMOUNT 800 -2 -64 -400 700 -2 -56 -30 -350 1000 -70 -70 -90 -120 250 -20 -12.5 -10 000 800 -56 -72 -96 500 -20 -25 -45 700 700 -28 -20 -35 -63 2500 -200 -125 -100 000 800 -56 -30 -32 134 -40 BANTU 2200 -154 -134 -198 -264 2200 176 -176 -110 -88 1200 -96 -60 -48 500 -20 -25 -45 1800 -126 -72 -90 500 -35 -45 -60 400 1051 Williams 1051 Williams 1051 Williams 1052 Zameer 1052 Zameer 1052 Zameer 1052 Zameer 1055 DON 1055 1055 DON 1055 DON 1055 DON HOFF DON 1055 DON 1060 leve 1060 Lerer 1060 Lerer www. 1060 Leren Tove perer 1060 Lerer 1065 Junior 1009 Junior 1065 Junior www.mor 1065 Junior 1009 Junior 1065 Junior 1070 Marut 1070 Marut 1070 Marut marut 1070 Marut 1080 DON 1080 DON 1080 DON 1080 DON 1081 Louis 1081 Louis 1081 Louis LOUIS 1081 Louis TOOT LOUIS 1081 Mihal 1061 Mina 1081 Mihal 1061 Mila 1081 Mihal 1081 Mihal 1081 Minal 1099 Mihal 1099 Mihal 1099 Mihal 1099 Mihal 2043 2012 Marut 2012 Mot 2012 Marut 2012 Marut 2012 Marut ACTE Mate 2011 Mihal 2011 Mihal 2011 Mihal 2011 Mihal 2120 Lago 2120 Lago 2120 Lago 2120 Lago 2021 Williams 2021 Williams 2021 Williams 2021 Williams 2022 Zameer EVEL 2022 Zameer 2022 Zameer 2022 Zameer 2025 Norm 2025 Norm 2025 Norm M. Cohen M. Cohen M. Cohen C. Mayer C. Mayer C. Mayer C. Mayer M Ryan M.Ryan M.Ryan M.Ryan M.Ryan F. Mc Govern ₂ F. Mc Govern F. Mc Govern F. Mc Govern M.Ryan M.Ryan M.Ryan v.nyai M. Ryan K.Leeds K.Leeds K.Leeds K.Leeds M.Ryan M.Ryan M.Ryan M.Ryan F. Mc Govern F. Mc Govern F. Mc Govern 1. Me F. Mc Govern K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds Loode www K.Leeds w K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds ✓ Loods K.Leeds K.Leeds C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen C. Mayer C. Mayer C. Mayer C. Mayer F. Mc Govern F. Mc Govern F. Mc Govern 5020 Direct Materials NJ 5040 Direct Labor 5050 Variable Overhea NJ NJ 4000 Sales Revenue CO 5020 Direct Materials CO 5040 Direct Labor со 5050 Variable Overhea CO 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct VA 5040 Direct Labor. KA 5050 Variable Overhea KA 11000 Sales www 4000 Sales Revenue KA 30 D www 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 3000 variad P NJ 4000 Sales Revenue 4000 Sales 5020 Direct Materials NJ P NJ 5040 Direct Labor 3040 Direct www 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ NJ 5040 Direct Labor 5050 Variable Overhea NJ. 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA KA 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor. KA 5050 Variable Overhea KA 4000 Sales Revenue AZ AL 5020 Direct Materials AZ 3020 Direct Mater AL 5040 Direct Labor AZ 5050 Variable Overhea AZ 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor 17 AZ 5050 Variable Overhea AZ 4000 Sales Revenue AZ FOTO D P 5020 Direct Materials AZ t AZ 5040 Direct Labor FOCA V 5050 Variable Overhea AZ to 4000 Sales Revenue NJ Tree P 5020 Direct Materials NJ QUEO DIELE 5040 Direct Labor NJ Tre picc 5050 Variable Overhea NJ. 1000 6-1 4000 Sales Revenue CO FOR DINE co 5020 Direct Materials CO 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ. 4000 Sales Revenue CO 5020 Di 5020 Direct Materials CO 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue ΚΑ 5020 Direct Materials KA 5040 Direct Labor KA F -32 -20 -16 900 -63 -81 -108 2200 -154 154 00 -88 -110 750 -30 -37.5 -67.5 2200 -154 -88 -110 900 -2 -72 -450 3500 -245 -140 -175 1250 -50 -62.5 -112.5 1700 -2 -136 -850 1200 -2 O -96 -600 900 -2 -72 -450 820 -2 -65.6 -410 1400 -98 -126 -168 350 -28 -17.5 -14 700 -49 -63 -84 550 -22 -27.5 2025 Norm 2026 Lerer 2026 Lerer 2026 Lerer 2026 Lerer 2029 Norm 2029 Norm 2029 Norm 2029 Norm 2129 Louis 2129 Louis 2129 Louis 2129 Louis 2230 Lago 2230 Lago 2230 Lago 2230 Lago 2231 Norm 2231 Norm 2231 Norm 2231 Norm 2244 Williams 2244 Williams. 2244 Williams. 2244 Williams 2248 Louis 2248 Louis 2248 Louis: 2248 Louis 2249 Junior 2249 Junior 2249 Junior 2249 Junior 2250 Lago 2250 Lago 2250 Lago 2250 Lago 2251 Williams 2251 Williams 2251 Williams 2251 Williams 2252 Zameer 2252 Zameer 2252 Zameer 2252 Zameer 2255 DON 2255 DON 2255 DON 2255 DON 2260 Lerer 2260 Lerer 2260 Lerer 2260 Lerer 2265 Junior 2265 Junior 2265 Junior 2265 Junior 2270 Marut 2270 Marut 2270 Marut 2270 Marut F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Cohen M. Cohen M. Cohen M. Cohen M.Ryan M. Ryan M.Ryan M.Ryan C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen: M. Cohen M. Cohen M. Cohen M. Cohen F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Ryan M. Ryan M. Ryan M.Ryan C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen C. Mayer C. Mayer C. Mayer C. Mayer M.Ryan M.Ryan M. Ryan M. Ryan F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Ryan M.Ryan M.Ryan M. Ryan K.Leeds K.Leeds K.Leeds K.Leeds 5050 Variable Overhea KA 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor ΚΑ 5050 Variable Overhea KA 4000 Sales Revenue CO 5020 Direct Materials CO. 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor 5050 Variable Overhea NJ 4000 Sales Revenue KA NJ 5020 Direct Materials KA 5040 Direct Labor. 5050 Variable Overhea KA KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ. 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor 5050 Variable Overhea NJ NJ 4000 Sales Revenue CO 5020 Direct Materials CO 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ. 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ -49.5 725 -29 -36.25 -65.25 2800 -224 -140 -112 800 -56 -32 -40 1200 -84 -108 -144 1850 -148 -92.5 -74 1700 -136 -85 -68 400 -16 -20 -36 2200 -154 -88 -110 450 -31.5 -40.5 -54 900 -72 -45 -36 600 -42 -54 -72 3300 -231 -132 -165 680 -27.2 -34 -61.2 3400 -238 -136 -170 840 -2 -67.2 -420 2280 DON 2280 DON 2280 DON 2280 DON 2281 Louis 2281 Louis CAUT COULD 2281 Louis 420T LOUIS 2281 Louis 2221 Mihal LEET MIN 2221 Mihal 2221 Min 2221 Mihal 2221 Minat 2221 Mihal 2221 Minat 2299 Mihal 2299 Mihal Minal 2299 Mihal 2299 Mihal 3008 Marut 2008 Marut 3008 Marut 2009 Marut 3008 Marut 2008 Marut 3008 Marut Peppy Mibel 3011 Mihal 2014 Mihal 3011 Mihal 2044 Mikel 3011 Mihal 2014 Mibal 3011 Mihal Domina 3020 Lago 3020 Lago 3020 Lago 3020 Lago 3021 Williams 3021 Williams 3021 Williams 3021 Williams 3022 Zameer 2022 7amoor 3022 Zameer 3022 Zameer 3022 Zameer BOOK NOG 3025 Norm 3025 Norm SOON 3025 Norm Ska Homm 3025 Norm 3026 Lerer 3026 Lerer T 3026 Lerer 3020 Cerer 3026 Lerer jester 3029 Norm 3029 Nom 3029 Norm 3029 Norm 3029 Norm 3129 Louis 3129 Louis 3129 Louis 3129 Louis 3030 Lago 3030 Lago 3030 Lago 3030 Lago 3031 Norm 3031 Norm Norm 3031 Norm 3031 Norm 3044 Williams 3044 Williams BELL M.Ryan M. Ryan M. Ryan M.Ryan F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern K.Leeds K.Leeds K.Leeds Leeus K.Leeds R.Leeus K.Leeds A.Leeds K.Leeds A.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds Kloods K.Leeds Klondo K.Leeds viend K.Leeds K.Leeds Kloods K.Leeds CU C. Mayer fermayer C. Mayer C. Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen C. Mayer Mater C. Mayer C. Mayer may C. Mayer F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern. F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Cohen M. Cohen M. Cohen M. M. Cohen M. Ryan M.Ryan M.Ryan M.Ryan C. Mayer C. Mayer C. Mayer Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen M. Cohen M. Cohen 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue KA 5020 Direct Materials KA Direct 5040 Direct Labor 2010 Direct www KA 5050 Variable Overhea KA w for fal 100% 4000 Sales Revenue AZ mood Jait 5020 Direct Materials AZ 20 5040 Direct Labor AZ NE 5050 Variable Overhea AZ 3030 var AL 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor AZ 5050 Variable Overhea AZ 4000 Sales Revenue AZ 5020 Direct Materials AZ 17 AZ 5040 Direct Labor 5050 Variable Overhea AZ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ FOFO Velikle he 5050 Variable Overhea NJ 4000 Sales Revenue CO 2030 B 5020 Direct Materials CO poees ene 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue CO 5020 Di 5020 Direct Materials CO co 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue KA 2000 5020 Direct Materials KA FOTO DUEL 5040 Direct Labor. KA 5050 Variable Overhea KA var fa 20 4000 Sales Revenue KA 5020 Direct Materials KA Dieet 5040 Direct Labor Tom Direct KA foy 5050 Variable Overhea KA 3030 var INA 4000 Sales Revenue NJ 5020 Direct Materials NJ 3020 Direct 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue CO 5020 Direct Materials CO Love 5040 Direct Labor. trace CO 5050 Variable Overhea CO F 4000 Sales Revenue KA KA 5020 Direct Materials KA 5040 Direct Labor 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ Imam 3600 -252 -144 -180 1350 -54 -67.5 -121.5 1800 -2 2 -144 144 -900 1100 -2 2 -88 -550 800 -2 64 -64 -400 700 -2 F -56 -350 1000 -70 -90 -120 250 -20 -12.5 20 -10 800 -56 -72 -96 500 -20 -25 -45 700 100 -28 -35 -63 2500 2500 -200 -125 -100 800 -56 -32 32 10 -40 2200 -154 -198 -264 2200 -176 -110 -88 1200 -96 3044 Williams 3044 Williams 3048 Louis 3048 Louis 3048 Louis 3048 Louis 2010 Junior 3049 Junior 3049 Junior 3049 3049 Junior 3049 Junior para 3050 Lago 3050 3050 Lago 3000 la 3050 Lago 3000 3050 Lago 3051 Williams SOME 3051 Williams. 3091 Michae 3051 Williams 2004 Willi 3051 Williams witam 3052 Zameer 3050 3052 Zameer 2004 cam 3052 Zameer 2006 Lanc 3052 Zameer 3092 cam 3055 DON wood Bon 3055 DON 3055 DON 3055 DON 3060 Lerer 3060 Lerer 3060 Lerer 2060 Leror 3060 Lerer 20 3065 Junior 2045 watte 3065 Junior 3065 Junior so yo 3065 Junior 3070 Marut 2010 3070 Marut 3070 Marut gemp 3070 Marut 3080 DON www 3080 DON 3080 DON a 3080 DON 3081 Louis www.Louis 3081 Louis Door Code 3081 Louis DOUT LOUIS 3081 Louis 2001 Code 3181 310 mildt Mihal 3181 Mihal 3181 Mihal 3181 Mihal 3099 Mihal 3022 3099 Mihal vominor 3099 Mindl 3099 Mihal 4012 Marut 1040 Met 4012 Marut www 4012 Marut 4012 Marut 4011 Mihal 4011 Mihal 4011 Mihal 4011 Mihal M. Cohen M. Cohen F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Ryan M.Dune M. Ryan M Puzz M. Ryan M. Puan M. Ryan C. Mayer C. Mayer M C. Mayer Maver C. Mayer M. Caton M. Cohen M. Cohon M. Cohen M. Cohen Caban M. Cohen me conch C. Mayer Mayer C. Mayer maye C. Mayer C. Mayer M. Ryan many can M. Ryan M. Ryan M. Ryan F. Mc Govern F. Mc Govern F. Mc Govern E MO F. Mc Govern tw M. Ryan M. Ryan M. Ryan M. Ryan v Londo K.Leeds Me K.Leeds K.Leeds K.Leeds M. Ryan BA M. Ryan M. Ryan M. Ryan F. Mc Govern Lave F. Mc Govern F. Mc Govern Ne F. Mc Govern A.Leeds K.Leeds K.Leeds A.Lecos K.Leeds K.Leeds Inveccos K.Leeds Accecos K.Leeds K.Leeds K.Leeds Klante K.Leeds Kloods K.Leeds www.com K.Leeds praccom K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ Foto Direct labor 5040 Direct Labor NU NJ 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Material 5020 Direct Materials M NJ fo F040 Diet Labor 5040 Direct Labor pore Vantable Overh NJ 5050 Variable Overhea NJ Cover Fou 4000 Sales Revenue NJ FOR 5020 Direct Materials NJ NJ 5040 Direct Labor Foro Venie 5050 Variable Overhea NJ verand 4000 Sales Revenue CO 1000 sales nevend 7 5020 Direct Materials CO po bicce macon 5040 Direct Labor CO p 5050 Variable Overhea CO 2000 4000 Sales Revenue Food adica KA 5020 Direct Materials KA 5040 Direct Labor KA FOCO 5050 Variable Overhea KA 1000 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue NJ FORO D 5020 Direct Materials NJ FOTO P 5040 Direct Labor NJ 5050 Varia 5050 Variable Overhea NJ 1000 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ roro Ver T 5050 Variable Overhea NJ 4000 Sales Revenue KA F030 5020 Direct Materials KA acom 5040 Direct Labor KA FOFO Velikle 5050 Variable Overhea KA ar labie Over 4000 Sales Revenue KA o adics hevend 5020 Direct Materials KA 9040 DICOL 5040 Direct Labor KA For 5050 Variable Overhea KA Frame and 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor AZ 5050 Variable Overhea AZ varia are 4000 Sales Revenue AZ TAL 5020 Direct Materials AZ proces 5040 Direct Labor AZ 5050 Variable Overhea AZ 4000 Cale 4000 Sales Revenue AZ F030 5020 Direct Materials AZ 5040 Direct Labor. AZ 5050 Variable Overhea AZ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor. NJ 5050 Variable Overhea NJ -60 -48 500 -20 -20 -25 -45 1800 1800 -126 -72 00 -90 con 500 -35 -45 -60 400 33 -32 = -20 -16 900 -63 -81 -108 2200 2200 LAVO -154 -88 -110 750 -30 -37.5 -67.5 2200 -154 -88 -110 900 -2 20 -72 CO -450 500 3500 -245 -140 -175 1250 -50 -62.5 -112.5 1700 1700 -2 -136 -850 1200 -2 -96 -600 900 -2 -72 -450 820 -2 -65.6 -410 4120 Lago 4120 Lago 4120 Lago 4120 Lago 4021 Williams 4021 Williams 4021 Williams 4021 Williams 4022 Zameer 4022 4022 Zameer 1000 4022 Zameer 4022 Zameer TWEE Carnes 4025 Norm 1005 New 4025 Norm 4025 Norm FO 4025 Norm nom 4026 Lerer 4020 Lerer 4026 Lerer 4026 Lerer TUE 4026 Lerer T 4029 Norm 1000 4029 Norm 1000 NA 4029 Norm 4029 Norm Tanz 4129 Louis Bankom 4129 Louis 4129 Louis 4129 Louis 4230 Lago 4230 Lago 4230 Lago 4230 Lago cago 4231 Norm 4231 Norm 4231 Norm 4231 Norm www. 4244 Williams www 4244 Williams 4244 Williams 4244 Williams 4244 widn 4248 Louis 4240 LOUIS 4248 Louis 12 TO LOUIS 4240 LOUIS 4248 Louis 4248 Louis 4240 Louis 4249 Junior 4249 Junior 4249 Junior 4249 Junior 4249 Junior 4250 Lago 4250 Lago 4250 1986 4250 Lago 1250 1200 4250 Lago 4251 Williams 4251 Williams 4251 Williams 4251 Williams 4252 Zameer 4232 2all 4252 Zameer 4252 Zameer 4252 Zameer 4255 DON 4255 DON C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen M. Cohen to wa C. Mayer mayor C. Mayer C. Mayer C. Mayer 5 Me Con F. Mc Govern ENC F. Mc Govern F. Mc Govern coram F. Mc Govern me porem F. Mc Govern We Gates F. Mc Govern The con F. Mc Govern F. Mc Govern M. Cohen M. Cohen M. Cohen M. Cohen M.Ryan m.nyall M. Ryan M.Ryan M. Ryan C. Mayer C. Mayer to m C. Mayer C. Mayer for mayor M. Cohen Catan M. Cohen G M. Cohen C M. Cohen www.camcomm M. Cohen M. Cohen M. Cohen M. Cohen F. Mc Govern MIL DOV F. Mc Govern F. Mc Govern F. Mc Govern M.Ryan M.Ryan M.Ryan M. Ryan C. Mayer C. Mayer Maver C. Mayer Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen C. Mayer C. Mayer C. Mayer C. Mayer M.Ryan M.Ryan 8888 4000 Sales Revenue CO 5020 Direct Materials CO 5040 Direct Labor 5050 Variable Overhea CO 4000 Sales Revenue NJ 5020 Direct Materials NJ 5010 Direct labor 5040 Direct Labor NI NJ 5050 Variable Overhea NJ 4000 Sales Revenue CO 5020 Direct Materials CO 5040 Direct laber 5040 Direct Labor со FOFO Variable Over 5050 Variable Overhea CO JCO 100 4000 Sales Revenue KA 500 Die 5020 Direct Materials KA obiect mater 5040 Direct Labor Foro Valle KA 5050 Variable Overhea KA 4000 Sales Revenue KA 1000 Sales P 5020 Direct Materials KA 2040 Dieet mater 5040 Direct Labor Foro Venetle 5050 Variable Overhea KA KA 4000 Sales Revenue NJ 2030 5020 Direct Materials NJ 9040 Direct 5040 Direct Labor NJ 5050 Variable Overhea NJ. 4000 Sales Revenue KA 5020 Direct Materials KA POLD One 5040 Direct Labor. KA 5050 Variable Overhea KA 4000 Sales Revenue CO 5020 Direct Materials CO 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue KA nerend 5020 Direct Materials KA FOTO B 5040 Direct Labor KA 5050 Variable Overhea KA varian 4000 Sales Revenue NJ 14000 Banda 5020 Direct Materials NJ. NJ 5040 Direct Labor DOTO DICCE Copol 5050 Variable Overhea NJ Fa Overned Ng 4000 Sales Revenue KA KA 5020 Direct Materials KA 5040 Direct Labor KA NA 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor 9040 Direct Labor NJ [IND 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor 5050 Variable Overhea NJ NI NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor FOTO V NJ 5050 Variable Overhea NJ 4000 Sales Revenue CO 4000 Sales 5020 Direct Materials CO OVEV 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue KA 5020 Direct Materials KA CO 1400 -98 -126 -168 350 -28 177 -17.5 -14 700 700 -49 -63 24 -84 Za 550 -22 -27.5 -49.5 725 7 -29 -36.25 25 DE -65.25 3000 2800 201 -224 -140 -112 800 -56 -32 -40 1200 -84 -108 -144 1850 -148 -92.5 -74 1700 -136 -85 -68 400 -16 so -20 -20 -36 30 2200 -154 -88 -110 450 -31 5 -31.5 -40.5 -54 900 -72 -45 -36 600 -42 -54 -72 3300 -231 4255 DON 4255 DON 4260 Lerer 4260 Lerer 4260 Lerer 4260 Lerer 4265 Junior 4265 Junior 4265 Junior 4265 Junior 4270 Marut 4270 Marut 4270 Marut 4270 Marut 4280 DON 4280 DON 4280 DON 4280 DON 4281 Louis 4281 Louis 4281 Louis 4281 Louis 4221 Mihal 4221 Mihal 4221 Mihal 4221 Mihal 4299 Mihal 4299 Mihal 4299 Mihal 4299 Mihal M. Ryan M.Ryan F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Ryan M. Ryan M.Ryan M. Ryan K.Leeds K.Leeds K.Leeds K.Leeds M. Ryan M. Ryan M. Ryan M. Ryan F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor ΚΑ 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue ΚΑ 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue ΚΑ 5020 Direct Materials KA 5040 Direct Labor ΚΑ 5050 Variable Overhea KA 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor AZ 5050 Variable Overhea AZ 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor AZ 5050 Variable Overhea AZ -132 -165 680 -27.2 -34 -61.2 3400 -238 -136 -170 840 -2 -67.2 -420 3600 -252 -144 -180 1350 -54 -67.5 -121.5 1800 -2 -144 -900 1100 -2 -88 -550 1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which is now called Pivot table 1, go to cell A1 then "insert" "pivot table" using the data range provided on the data sheet (including the heading lines). Drag "account to the row labels and "amount to the Values. You should now see the dollar amounts for sales revenue, direct materials, direct labor, variable overhead, and Grand Total (contribution margin). If you don't see the dollar amounts click the arrow next to amounts in the Values box and choose "Sum of amount". Next, answer the following: How much are total sales revenues? How much are total direct material costs? How much are total direct labor costs? How much are total overhead costs? How much is total contribution margin? 2. Add a sheet and rename "Pivot table 2". On the sheet which is now called Pivot table 2, insert a pivot table in cell A1 using the data range provided on the data sheet (including the heading lines). Drag "sales person to the Row Labels box, drag "account to the Column Labels box, and drag "amount to the Values box. Answer the following: Which sales person generated the highest sales revenue? Which sales person generated the highest contribution margin? Which sales person generated the lowest sales revenue? Which sales person generated the lowest contribution margin? 3. Add a sheet and rename it "Pivot table 3. On the sheet which is now called Pivot table 3 insert a pivot table at cell A1 using the data range provided on the data sheet (including the heading lines). Drag Job to the Row Labels box and "amount to the Values box. On the table select the data in the sum of amounts column and sort from highest to lowest. Answer the following: Which job number generated the highest contribution margin? Which job number generated the lowest contribution margin? 4. Add a sheet and rename "Pivot table 4. On the sheet which is now called Pivot table 4 insert a pivot table at cell A1 using the data range provided on the data sheet (including the heading lines). Drag "customer to the Row Labels box and "amount to the EValues box. On the table select the data in the sum of amounts column and sort from highest to lowest. Which customer generated the highest contribution margin? Which customer generated the lowest contribution margin? 5. Rename sheet 4 "Pivot table 5. On the sheet which is now called Pivot table 5 insert a pivot table at cell A1 using the data range provided on the data sheet (including the heading lines). Drag "location" to the Row Labels box and "amount to the EValues box. Which location generated the highest contribution margin? Which location generated the lowest contribution margin? Submit your Excel worksheet and answers to the above. Job # CUSTOMER 1008 Marut 1008 Marut 1008 Marut 1008 Marut 1011 Mihal 1011 Mihal 1011 Mihal TUTT MIN 1011 Mihal 1020 Lago 1020 Lago 1020 Lago 1020 Lago 1020 Lago 1020 Lago 1021 Williams 1021 Williams 1021 Williams or William 1021 Williams 1022 Zameer 1022 Zameer 1022 Zameer same 1022 Zameer 1025 Norm YO 1025 Norm 1025 Norm 1025 Norm 1026 Lerer 1026 Lerer 1026 Lerer 1026 Lerer 1029 Norm 1000 N 1029 Norm 1029 Norm TOES NOT 1029 Norm 1029 Louis 1029 Louis 1029 Louis 1029 Louis 1029 LOUIS 1030 Lago 1030 Lago 1030 Lago 1030 Lago 1030 Lago 1030 Lago 1030 Lago 1031 Norm 1031 Norm 1021 Norm 1031 Norm 1021 Norm 1031 Norm con wal 1044 Williams 1044 Willie 1044 Williams wwwwwww 1044 Williams 1044 Williams PEM 1048 Louis COMME 1048 Louis 1048 Louis 1048 Louis 1049 Junior 1049 Junior 1049 Junior 1049 Junior 1050 Lago 1050 Lago 1050 Lago 1050 Lago 1051 Williams SALES PERSON K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen M. Cohen M Cohon M. Cohen M. Cohen C. Mayer C. Mayer Ma C. Mayer C. Mayer F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Cohen M. Cohen Tom M. Cohen M. Cohen M.Ryan M. Ryan M.Ryan M. Ryan C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen M. Coben M. Cohen M Cohen M. Cohen M. Cohen Cohen M. Cohen Cohen M. Cohen M. Cohen M. Cohen F. Mc Govern F. Mc Govern. F. Mc Govern F. Mc Govern M.Ryan M.Ryan M.Ryan M. Ryan C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen ACCOUNT # 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor AZ 5050 Variable Overhea AZ 4000 Sales Revenue NJ 1000 Balt 5020 Direct Materials NJ 13020 Direct 5040 Direct Labor 3040 Direct Labor NJ INJ 5050 Variable Overhea NJ 4000 Sales Revenue LO CO 5020 Direct Materials CO 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue NJ 5020 Direct Materials NJ Direct Labor 5040 Direct Labor NJ 5050 Variable Overhea NJ Farhus 4000 Sales Revenue CO 5030 Die 5020 Direct Materials CO 5040 Direct Labor 2040 Direc со 5050 Variable Overhea CO 4000 Sales Revenue KA 2000 5020 Direct Materials KA OVED BITC 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue NJ 2030 5020 Direct Materials NJ POZO Direct NJ 5040 Direct Labor Fore 5050 Variable Overhea NJ 4000 Sales Revenue KA 2000 5020 Direct Materials KA de 5040 Direct Labor KA NA 5050 Variable Overhea KA 4000 Sales Revenue CO co 5020 Direct Materials CO 5040 Direct Labor CO CO 5050 Variable Overhea CO 4000 Sales Revenue KA KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 1000 Sales 4000 Sales Revenue NJ 5020 Direct Materia 5020 Direct Materials NJ NJ 5040 Direct Labor Vente 5050 Variable Overhea NJ 4000 Sales Revenue KA F030 Di KA 5020 Direct Materials KA 5040 Direct Labor 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ INT 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue NJ LOCATION AMOUNT 800 -2 -64 -400 700 -2 -56 -30 -350 1000 -70 -70 -90 -120 250 -20 -12.5 -10 000 800 -56 -72 -96 500 -20 -25 -45 700 700 -28 -20 -35 -63 2500 -200 -125 -100 000 800 -56 -30 -32 134 -40 BANTU 2200 -154 -134 -198 -264 2200 176 -176 -110 -88 1200 -96 -60 -48 500 -20 -25 -45 1800 -126 -72 -90 500 -35 -45 -60 400 1051 Williams 1051 Williams 1051 Williams 1052 Zameer 1052 Zameer 1052 Zameer 1052 Zameer 1055 DON 1055 1055 DON 1055 DON 1055 DON HOFF DON 1055 DON 1060 leve 1060 Lerer 1060 Lerer www. 1060 Leren Tove perer 1060 Lerer 1065 Junior 1009 Junior 1065 Junior www.mor 1065 Junior 1009 Junior 1065 Junior 1070 Marut 1070 Marut 1070 Marut marut 1070 Marut 1080 DON 1080 DON 1080 DON 1080 DON 1081 Louis 1081 Louis 1081 Louis LOUIS 1081 Louis TOOT LOUIS 1081 Mihal 1061 Mina 1081 Mihal 1061 Mila 1081 Mihal 1081 Mihal 1081 Minal 1099 Mihal 1099 Mihal 1099 Mihal 1099 Mihal 2043 2012 Marut 2012 Mot 2012 Marut 2012 Marut 2012 Marut ACTE Mate 2011 Mihal 2011 Mihal 2011 Mihal 2011 Mihal 2120 Lago 2120 Lago 2120 Lago 2120 Lago 2021 Williams 2021 Williams 2021 Williams 2021 Williams 2022 Zameer EVEL 2022 Zameer 2022 Zameer 2022 Zameer 2025 Norm 2025 Norm 2025 Norm M. Cohen M. Cohen M. Cohen C. Mayer C. Mayer C. Mayer C. Mayer M Ryan M.Ryan M.Ryan M.Ryan M.Ryan F. Mc Govern ₂ F. Mc Govern F. Mc Govern F. Mc Govern M.Ryan M.Ryan M.Ryan v.nyai M. Ryan K.Leeds K.Leeds K.Leeds K.Leeds M.Ryan M.Ryan M.Ryan M.Ryan F. Mc Govern F. Mc Govern F. Mc Govern 1. Me F. Mc Govern K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds Loode www K.Leeds w K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds ✓ Loods K.Leeds K.Leeds C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen C. Mayer C. Mayer C. Mayer C. Mayer F. Mc Govern F. Mc Govern F. Mc Govern 5020 Direct Materials NJ 5040 Direct Labor 5050 Variable Overhea NJ NJ 4000 Sales Revenue CO 5020 Direct Materials CO 5040 Direct Labor со 5050 Variable Overhea CO 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct VA 5040 Direct Labor. KA 5050 Variable Overhea KA 11000 Sales www 4000 Sales Revenue KA 30 D www 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 3000 variad P NJ 4000 Sales Revenue 4000 Sales 5020 Direct Materials NJ P NJ 5040 Direct Labor 3040 Direct www 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ NJ 5040 Direct Labor 5050 Variable Overhea NJ. 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA KA 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor. KA 5050 Variable Overhea KA 4000 Sales Revenue AZ AL 5020 Direct Materials AZ 3020 Direct Mater AL 5040 Direct Labor AZ 5050 Variable Overhea AZ 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor 17 AZ 5050 Variable Overhea AZ 4000 Sales Revenue AZ FOTO D P 5020 Direct Materials AZ t AZ 5040 Direct Labor FOCA V 5050 Variable Overhea AZ to 4000 Sales Revenue NJ Tree P 5020 Direct Materials NJ QUEO DIELE 5040 Direct Labor NJ Tre picc 5050 Variable Overhea NJ. 1000 6-1 4000 Sales Revenue CO FOR DINE co 5020 Direct Materials CO 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ. 4000 Sales Revenue CO 5020 Di 5020 Direct Materials CO 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue ΚΑ 5020 Direct Materials KA 5040 Direct Labor KA F -32 -20 -16 900 -63 -81 -108 2200 -154 154 00 -88 -110 750 -30 -37.5 -67.5 2200 -154 -88 -110 900 -2 -72 -450 3500 -245 -140 -175 1250 -50 -62.5 -112.5 1700 -2 -136 -850 1200 -2 O -96 -600 900 -2 -72 -450 820 -2 -65.6 -410 1400 -98 -126 -168 350 -28 -17.5 -14 700 -49 -63 -84 550 -22 -27.5 2025 Norm 2026 Lerer 2026 Lerer 2026 Lerer 2026 Lerer 2029 Norm 2029 Norm 2029 Norm 2029 Norm 2129 Louis 2129 Louis 2129 Louis 2129 Louis 2230 Lago 2230 Lago 2230 Lago 2230 Lago 2231 Norm 2231 Norm 2231 Norm 2231 Norm 2244 Williams 2244 Williams. 2244 Williams. 2244 Williams 2248 Louis 2248 Louis 2248 Louis: 2248 Louis 2249 Junior 2249 Junior 2249 Junior 2249 Junior 2250 Lago 2250 Lago 2250 Lago 2250 Lago 2251 Williams 2251 Williams 2251 Williams 2251 Williams 2252 Zameer 2252 Zameer 2252 Zameer 2252 Zameer 2255 DON 2255 DON 2255 DON 2255 DON 2260 Lerer 2260 Lerer 2260 Lerer 2260 Lerer 2265 Junior 2265 Junior 2265 Junior 2265 Junior 2270 Marut 2270 Marut 2270 Marut 2270 Marut F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Cohen M. Cohen M. Cohen M. Cohen M.Ryan M. Ryan M.Ryan M.Ryan C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen: M. Cohen M. Cohen M. Cohen M. Cohen F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Ryan M. Ryan M. Ryan M.Ryan C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen C. Mayer C. Mayer C. Mayer C. Mayer M.Ryan M.Ryan M. Ryan M. Ryan F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Ryan M.Ryan M.Ryan M. Ryan K.Leeds K.Leeds K.Leeds K.Leeds 5050 Variable Overhea KA 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor ΚΑ 5050 Variable Overhea KA 4000 Sales Revenue CO 5020 Direct Materials CO. 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor 5050 Variable Overhea NJ 4000 Sales Revenue KA NJ 5020 Direct Materials KA 5040 Direct Labor. 5050 Variable Overhea KA KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ. 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor 5050 Variable Overhea NJ NJ 4000 Sales Revenue CO 5020 Direct Materials CO 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ. 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ -49.5 725 -29 -36.25 -65.25 2800 -224 -140 -112 800 -56 -32 -40 1200 -84 -108 -144 1850 -148 -92.5 -74 1700 -136 -85 -68 400 -16 -20 -36 2200 -154 -88 -110 450 -31.5 -40.5 -54 900 -72 -45 -36 600 -42 -54 -72 3300 -231 -132 -165 680 -27.2 -34 -61.2 3400 -238 -136 -170 840 -2 -67.2 -420 2280 DON 2280 DON 2280 DON 2280 DON 2281 Louis 2281 Louis CAUT COULD 2281 Louis 420T LOUIS 2281 Louis 2221 Mihal LEET MIN 2221 Mihal 2221 Min 2221 Mihal 2221 Minat 2221 Mihal 2221 Minat 2299 Mihal 2299 Mihal Minal 2299 Mihal 2299 Mihal 3008 Marut 2008 Marut 3008 Marut 2009 Marut 3008 Marut 2008 Marut 3008 Marut Peppy Mibel 3011 Mihal 2014 Mihal 3011 Mihal 2044 Mikel 3011 Mihal 2014 Mibal 3011 Mihal Domina 3020 Lago 3020 Lago 3020 Lago 3020 Lago 3021 Williams 3021 Williams 3021 Williams 3021 Williams 3022 Zameer 2022 7amoor 3022 Zameer 3022 Zameer 3022 Zameer BOOK NOG 3025 Norm 3025 Norm SOON 3025 Norm Ska Homm 3025 Norm 3026 Lerer 3026 Lerer T 3026 Lerer 3020 Cerer 3026 Lerer jester 3029 Norm 3029 Nom 3029 Norm 3029 Norm 3029 Norm 3129 Louis 3129 Louis 3129 Louis 3129 Louis 3030 Lago 3030 Lago 3030 Lago 3030 Lago 3031 Norm 3031 Norm Norm 3031 Norm 3031 Norm 3044 Williams 3044 Williams BELL M.Ryan M. Ryan M. Ryan M.Ryan F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern K.Leeds K.Leeds K.Leeds Leeus K.Leeds R.Leeus K.Leeds A.Leeds K.Leeds A.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds Kloods K.Leeds Klondo K.Leeds viend K.Leeds K.Leeds Kloods K.Leeds CU C. Mayer fermayer C. Mayer C. Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen C. Mayer Mater C. Mayer C. Mayer may C. Mayer F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern. F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Cohen M. Cohen M. Cohen M. M. Cohen M. Ryan M.Ryan M.Ryan M.Ryan C. Mayer C. Mayer C. Mayer Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen M. Cohen M. Cohen 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue KA 5020 Direct Materials KA Direct 5040 Direct Labor 2010 Direct www KA 5050 Variable Overhea KA w for fal 100% 4000 Sales Revenue AZ mood Jait 5020 Direct Materials AZ 20 5040 Direct Labor AZ NE 5050 Variable Overhea AZ 3030 var AL 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor AZ 5050 Variable Overhea AZ 4000 Sales Revenue AZ 5020 Direct Materials AZ 17 AZ 5040 Direct Labor 5050 Variable Overhea AZ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ FOFO Velikle he 5050 Variable Overhea NJ 4000 Sales Revenue CO 2030 B 5020 Direct Materials CO poees ene 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue CO 5020 Di 5020 Direct Materials CO co 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue KA 2000 5020 Direct Materials KA FOTO DUEL 5040 Direct Labor. KA 5050 Variable Overhea KA var fa 20 4000 Sales Revenue KA 5020 Direct Materials KA Dieet 5040 Direct Labor Tom Direct KA foy 5050 Variable Overhea KA 3030 var INA 4000 Sales Revenue NJ 5020 Direct Materials NJ 3020 Direct 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue CO 5020 Direct Materials CO Love 5040 Direct Labor. trace CO 5050 Variable Overhea CO F 4000 Sales Revenue KA KA 5020 Direct Materials KA 5040 Direct Labor 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ Imam 3600 -252 -144 -180 1350 -54 -67.5 -121.5 1800 -2 2 -144 144 -900 1100 -2 2 -88 -550 800 -2 64 -64 -400 700 -2 F -56 -350 1000 -70 -90 -120 250 -20 -12.5 20 -10 800 -56 -72 -96 500 -20 -25 -45 700 100 -28 -35 -63 2500 2500 -200 -125 -100 800 -56 -32 32 10 -40 2200 -154 -198 -264 2200 -176 -110 -88 1200 -96 3044 Williams 3044 Williams 3048 Louis 3048 Louis 3048 Louis 3048 Louis 2010 Junior 3049 Junior 3049 Junior 3049 3049 Junior 3049 Junior para 3050 Lago 3050 3050 Lago 3000 la 3050 Lago 3000 3050 Lago 3051 Williams SOME 3051 Williams. 3091 Michae 3051 Williams 2004 Willi 3051 Williams witam 3052 Zameer 3050 3052 Zameer 2004 cam 3052 Zameer 2006 Lanc 3052 Zameer 3092 cam 3055 DON wood Bon 3055 DON 3055 DON 3055 DON 3060 Lerer 3060 Lerer 3060 Lerer 2060 Leror 3060 Lerer 20 3065 Junior 2045 watte 3065 Junior 3065 Junior so yo 3065 Junior 3070 Marut 2010 3070 Marut 3070 Marut gemp 3070 Marut 3080 DON www 3080 DON 3080 DON a 3080 DON 3081 Louis www.Louis 3081 Louis Door Code 3081 Louis DOUT LOUIS 3081 Louis 2001 Code 3181 310 mildt Mihal 3181 Mihal 3181 Mihal 3181 Mihal 3099 Mihal 3022 3099 Mihal vominor 3099 Mindl 3099 Mihal 4012 Marut 1040 Met 4012 Marut www 4012 Marut 4012 Marut 4011 Mihal 4011 Mihal 4011 Mihal 4011 Mihal M. Cohen M. Cohen F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Ryan M.Dune M. Ryan M Puzz M. Ryan M. Puan M. Ryan C. Mayer C. Mayer M C. Mayer Maver C. Mayer M. Caton M. Cohen M. Cohon M. Cohen M. Cohen Caban M. Cohen me conch C. Mayer Mayer C. Mayer maye C. Mayer C. Mayer M. Ryan many can M. Ryan M. Ryan M. Ryan F. Mc Govern F. Mc Govern F. Mc Govern E MO F. Mc Govern tw M. Ryan M. Ryan M. Ryan M. Ryan v Londo K.Leeds Me K.Leeds K.Leeds K.Leeds M. Ryan BA M. Ryan M. Ryan M. Ryan F. Mc Govern Lave F. Mc Govern F. Mc Govern Ne F. Mc Govern A.Leeds K.Leeds K.Leeds A.Lecos K.Leeds K.Leeds Inveccos K.Leeds Accecos K.Leeds K.Leeds K.Leeds Klante K.Leeds Kloods K.Leeds www.com K.Leeds praccom K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ Foto Direct labor 5040 Direct Labor NU NJ 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Material 5020 Direct Materials M NJ fo F040 Diet Labor 5040 Direct Labor pore Vantable Overh NJ 5050 Variable Overhea NJ Cover Fou 4000 Sales Revenue NJ FOR 5020 Direct Materials NJ NJ 5040 Direct Labor Foro Venie 5050 Variable Overhea NJ verand 4000 Sales Revenue CO 1000 sales nevend 7 5020 Direct Materials CO po bicce macon 5040 Direct Labor CO p 5050 Variable Overhea CO 2000 4000 Sales Revenue Food adica KA 5020 Direct Materials KA 5040 Direct Labor KA FOCO 5050 Variable Overhea KA 1000 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue NJ FORO D 5020 Direct Materials NJ FOTO P 5040 Direct Labor NJ 5050 Varia 5050 Variable Overhea NJ 1000 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ roro Ver T 5050 Variable Overhea NJ 4000 Sales Revenue KA F030 5020 Direct Materials KA acom 5040 Direct Labor KA FOFO Velikle 5050 Variable Overhea KA ar labie Over 4000 Sales Revenue KA o adics hevend 5020 Direct Materials KA 9040 DICOL 5040 Direct Labor KA For 5050 Variable Overhea KA Frame and 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor AZ 5050 Variable Overhea AZ varia are 4000 Sales Revenue AZ TAL 5020 Direct Materials AZ proces 5040 Direct Labor AZ 5050 Variable Overhea AZ 4000 Cale 4000 Sales Revenue AZ F030 5020 Direct Materials AZ 5040 Direct Labor. AZ 5050 Variable Overhea AZ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor. NJ 5050 Variable Overhea NJ -60 -48 500 -20 -20 -25 -45 1800 1800 -126 -72 00 -90 con 500 -35 -45 -60 400 33 -32 = -20 -16 900 -63 -81 -108 2200 2200 LAVO -154 -88 -110 750 -30 -37.5 -67.5 2200 -154 -88 -110 900 -2 20 -72 CO -450 500 3500 -245 -140 -175 1250 -50 -62.5 -112.5 1700 1700 -2 -136 -850 1200 -2 -96 -600 900 -2 -72 -450 820 -2 -65.6 -410 4120 Lago 4120 Lago 4120 Lago 4120 Lago 4021 Williams 4021 Williams 4021 Williams 4021 Williams 4022 Zameer 4022 4022 Zameer 1000 4022 Zameer 4022 Zameer TWEE Carnes 4025 Norm 1005 New 4025 Norm 4025 Norm FO 4025 Norm nom 4026 Lerer 4020 Lerer 4026 Lerer 4026 Lerer TUE 4026 Lerer T 4029 Norm 1000 4029 Norm 1000 NA 4029 Norm 4029 Norm Tanz 4129 Louis Bankom 4129 Louis 4129 Louis 4129 Louis 4230 Lago 4230 Lago 4230 Lago 4230 Lago cago 4231 Norm 4231 Norm 4231 Norm 4231 Norm www. 4244 Williams www 4244 Williams 4244 Williams 4244 Williams 4244 widn 4248 Louis 4240 LOUIS 4248 Louis 12 TO LOUIS 4240 LOUIS 4248 Louis 4248 Louis 4240 Louis 4249 Junior 4249 Junior 4249 Junior 4249 Junior 4249 Junior 4250 Lago 4250 Lago 4250 1986 4250 Lago 1250 1200 4250 Lago 4251 Williams 4251 Williams 4251 Williams 4251 Williams 4252 Zameer 4232 2all 4252 Zameer 4252 Zameer 4252 Zameer 4255 DON 4255 DON C. Mayer C. Mayer C. Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen M. Cohen to wa C. Mayer mayor C. Mayer C. Mayer C. Mayer 5 Me Con F. Mc Govern ENC F. Mc Govern F. Mc Govern coram F. Mc Govern me porem F. Mc Govern We Gates F. Mc Govern The con F. Mc Govern F. Mc Govern M. Cohen M. Cohen M. Cohen M. Cohen M.Ryan m.nyall M. Ryan M.Ryan M. Ryan C. Mayer C. Mayer to m C. Mayer C. Mayer for mayor M. Cohen Catan M. Cohen G M. Cohen C M. Cohen www.camcomm M. Cohen M. Cohen M. Cohen M. Cohen F. Mc Govern MIL DOV F. Mc Govern F. Mc Govern F. Mc Govern M.Ryan M.Ryan M.Ryan M. Ryan C. Mayer C. Mayer Maver C. Mayer Mayer C. Mayer M. Cohen M. Cohen M. Cohen M. Cohen C. Mayer C. Mayer C. Mayer C. Mayer M.Ryan M.Ryan 8888 4000 Sales Revenue CO 5020 Direct Materials CO 5040 Direct Labor 5050 Variable Overhea CO 4000 Sales Revenue NJ 5020 Direct Materials NJ 5010 Direct labor 5040 Direct Labor NI NJ 5050 Variable Overhea NJ 4000 Sales Revenue CO 5020 Direct Materials CO 5040 Direct laber 5040 Direct Labor со FOFO Variable Over 5050 Variable Overhea CO JCO 100 4000 Sales Revenue KA 500 Die 5020 Direct Materials KA obiect mater 5040 Direct Labor Foro Valle KA 5050 Variable Overhea KA 4000 Sales Revenue KA 1000 Sales P 5020 Direct Materials KA 2040 Dieet mater 5040 Direct Labor Foro Venetle 5050 Variable Overhea KA KA 4000 Sales Revenue NJ 2030 5020 Direct Materials NJ 9040 Direct 5040 Direct Labor NJ 5050 Variable Overhea NJ. 4000 Sales Revenue KA 5020 Direct Materials KA POLD One 5040 Direct Labor. KA 5050 Variable Overhea KA 4000 Sales Revenue CO 5020 Direct Materials CO 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue KA nerend 5020 Direct Materials KA FOTO B 5040 Direct Labor KA 5050 Variable Overhea KA varian 4000 Sales Revenue NJ 14000 Banda 5020 Direct Materials NJ. NJ 5040 Direct Labor DOTO DICCE Copol 5050 Variable Overhea NJ Fa Overned Ng 4000 Sales Revenue KA KA 5020 Direct Materials KA 5040 Direct Labor KA NA 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor 9040 Direct Labor NJ [IND 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor 5050 Variable Overhea NJ NI NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor FOTO V NJ 5050 Variable Overhea NJ 4000 Sales Revenue CO 4000 Sales 5020 Direct Materials CO OVEV 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue KA 5020 Direct Materials KA CO 1400 -98 -126 -168 350 -28 177 -17.5 -14 700 700 -49 -63 24 -84 Za 550 -22 -27.5 -49.5 725 7 -29 -36.25 25 DE -65.25 3000 2800 201 -224 -140 -112 800 -56 -32 -40 1200 -84 -108 -144 1850 -148 -92.5 -74 1700 -136 -85 -68 400 -16 so -20 -20 -36 30 2200 -154 -88 -110 450 -31 5 -31.5 -40.5 -54 900 -72 -45 -36 600 -42 -54 -72 3300 -231 4255 DON 4255 DON 4260 Lerer 4260 Lerer 4260 Lerer 4260 Lerer 4265 Junior 4265 Junior 4265 Junior 4265 Junior 4270 Marut 4270 Marut 4270 Marut 4270 Marut 4280 DON 4280 DON 4280 DON 4280 DON 4281 Louis 4281 Louis 4281 Louis 4281 Louis 4221 Mihal 4221 Mihal 4221 Mihal 4221 Mihal 4299 Mihal 4299 Mihal 4299 Mihal 4299 Mihal M. Ryan M.Ryan F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern M. Ryan M. Ryan M.Ryan M. Ryan K.Leeds K.Leeds K.Leeds K.Leeds M. Ryan M. Ryan M. Ryan M. Ryan F. Mc Govern F. Mc Govern F. Mc Govern F. Mc Govern K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds K.Leeds 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor ΚΑ 5050 Variable Overhea KA 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NJ 5050 Variable Overhea NJ 4000 Sales Revenue ΚΑ 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue ΚΑ 5020 Direct Materials KA 5040 Direct Labor ΚΑ 5050 Variable Overhea KA 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor AZ 5050 Variable Overhea AZ 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor AZ 5050 Variable Overhea AZ -132 -165 680 -27.2 -34 -61.2 3400 -238 -136 -170 840 -2 -67.2 -420 3600 -252 -144 -180 1350 -54 -67.5 -121.5 1800 -2 -144 -900 1100 -2 -88 -550

Answer rating: 100% (QA)

1 How much are total sales revenues 131730 How much are total direct material costs 759340 How much are total direct labor costs 753610 How much are total overhead costs 1794490 How much is total cont... View the full answer