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

 
 
 
 
 
 
 
 

Transcribed Image Text:

INSTRUCTIONS: 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 Values 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 Values 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 Gear 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 wil 1044 Williams 1044 Wille 1044 Williams wwwwwww 1044 Williams 1044 Williams PEM 1048 Louis 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 The com 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 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 LOCATION AMOUNT 5020 Direct Materials NJ 13020 Direct 5040 Direct Labor 3040 Direct Labor 5050 Variable Overhea NJ 4000 Sales Revenue CO LO 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 INJ 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 5040 Direct Labor NJ Fore 5050 Variable Overhea NJ 4000 Sales Revenue KA 200 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 5040 Direct Labor Veuse NJ 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 800 -2 -64 -400 700 -2 -56 -30 -350 1000 -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 34 -40 ANTO 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 Love parer 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 2042 2012 Marut 2012 Mot 2012 Marut 2012 Marut 2012 Marut ACTE Mate 2011 Mihal 2011 Mihal 2011 Mihal 2011 Mihal 2120 Lago 2120 Lago p 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 t 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 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 NJ 5050 Variable Overhea 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 5040 Direct Labor. 5050 Variable Overhea KA 11000 Sales 4000 Sales Revenue 30 D 5020 Direct Materials VA KA www KA 5040 Direct Labor 3040 Direct www KA 5040 Direct Labor KA 5050 Variable Overhea KA 3000 variab F 4000 Sales Revenue NJ 4000 Sales 5020 Direct Materials F NJ P NJ 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 to 5040 Direct Labor FOCA V 5050 Variable Overhea AZ AZ to 4000 Sales Revenue NJ Tree P 5020 Direct Materials NJ QUEO DIELE 5040 Direct Labor Tre picc NJ 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 -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 0 -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 ΚΑ 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 ΚΑ 5050 Variable Overhea KA 5040 Direct Labor 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor 5050 Variable Overhea NJ NJ 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor. 5050 Variable Overhea KA KA 4000 Sales Revenue NJ 5020 Direct Materials NJ NJ 5040 Direct Labor 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 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 -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 Mikel 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 Hom 3025 Norm 3026 Lerer 3026 Lerer Ter 3026 Lerer 3020 Cerer 3026 Lerer Lecter 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 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 Klonde K.Leeds vient 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. 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 Eve 5040 Direct Labor 5050 Variable Overhea AZ 3030 var AL 4000 Sales Revenue AZ 5020 Direct Materials AZ AZ AZ NE 5040 Direct Labor 5050 Variable Overhea AZ 4000 Sales Revenue AZ A7 5020 Direct Materials AZ 5040 Direct Labor 5050 Variable Overhea AZ 4000 Sales Revenue NJ 5020 Direct Materials NJ 17 AZ 5040 Direct Labor NJ FOFO Velikle he 5050 Variable Overhea NJ 4000 Sales Revenue CO 15030 B 5020 Direct Materials CO Joves 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 co 5020 Direct Materials CO 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue KA 2000 5020 Direct Materials KA FOTO QUEE 5040 Direct Labor KA 5050 Variable Overhea KA var fa 120 4000 Sales Revenue KA 5020 Direct Materials KA Dieet 5040 Direct Labor Tom Direct KA fo 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 CO 5040 Direct Labor. trace 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 -00 -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 30 ME 3051 Williams. 3091 Michae 3051 Williams 2004 Willi 3051 Williams www.wan 3052 Zameer 3050 3052 Zameer 2004 camm 3052 Zameer 209 Camic 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 you 3065 Junior 3070 Marut 2010 3070 Marut 3070 Marut pepp 3070 Marut 3080 DON www 3080 DON 3080 DON ma 3080 DON 3081 Louis www.Louis 3081 Louis Door Code 3081 Louis DOUT LOUIS 3081 Louis 2001 Code 3181 Mihal 310 mildt 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 The conch C. Mayer Mayer C. Mayer emaye 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 w M. Ryan M. Ryan M.Ryan v Londo K.Leeds Men K.Leeds K.Leeds K.Leeds M. Ryan T M. Ryan M. Ryan M. Ryan F. Mc Govern Lave F. Mc Govern F. Mc Govern Ne F. Mc Govern T K.Leeds A.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 M 5020 Direct Material 5020 Direct Materials NJ F040 Diet Labor 5040 Direct Labor to NJ pore Vantable Overh 5050 Variable Overhea NJ Cover Fou 4000 Sales Revenue NJ FOR 5020 Direct Materials NJ 5040 Direct Labor NJ Foro Venie 5050 Variable Overhea NJ verand 4000 Sales Revenue CO 1000 sales nevend = 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 vand 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor AZ 5050 Variable Overhea AZ varia are 4000 Sales Revenue AZ TAE 5020 Direct Materials AZ Perdance 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 Que -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 Sarkom 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 widan 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 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 way.com 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 WC- M. Cohen www.coaccomm M. Cohen M. Cohen T 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 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 CO 5040 Direct Labor 5050 Variable Overhea CO 4000 Sales Revenue NJ 5020 Direct Materials NJ NI NJ 5010 Direct labor 5040 Direct Labor 5050 Variable Overhea NJ 4000 Sales Revenue CO 5020 Direct Materials CO 5040 Direct leben 5040 Direct Labor со FOFO Variable Over co 5050 Variable Overhea CO 1000 4000 Sales Revenue KA 500 Die www. 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 9040 Dieet mater 5040 Direct Labor Foro Venetle KA 5050 Variable Overhea 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 11000 Banda 5020 Direct Materials NJ. 5040 Direct Labor NJ DOTO DICCE Cupor 5050 Variable Overhea NJ Fara 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 [NE 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NI NJ 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor FOTO V NJ 5050 Variable Overhea NJ 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 1400 -98 -126 -168 350 20 -28 177 -17.5 -14 700 700 -49 -63 24 -84 Za 550 -22 -27.5 -49.5 725 720 -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 -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 KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue ΚΑ 5020 Direct Materials KA 5040 Direct Labor KA 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 AZ 5040 Direct Labor 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 INSTRUCTIONS: 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 Values 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 Values 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 Gear 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 wil 1044 Williams 1044 Wille 1044 Williams wwwwwww 1044 Williams 1044 Williams PEM 1048 Louis 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 The com 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 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 LOCATION AMOUNT 5020 Direct Materials NJ 13020 Direct 5040 Direct Labor 3040 Direct Labor 5050 Variable Overhea NJ 4000 Sales Revenue CO LO 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 INJ 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 5040 Direct Labor NJ Fore 5050 Variable Overhea NJ 4000 Sales Revenue KA 200 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 5040 Direct Labor Veuse NJ 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 800 -2 -64 -400 700 -2 -56 -30 -350 1000 -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 34 -40 ANTO 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 Love parer 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 2042 2012 Marut 2012 Mot 2012 Marut 2012 Marut 2012 Marut ACTE Mate 2011 Mihal 2011 Mihal 2011 Mihal 2011 Mihal 2120 Lago 2120 Lago p 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 t 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 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 NJ 5050 Variable Overhea 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 5040 Direct Labor. 5050 Variable Overhea KA 11000 Sales 4000 Sales Revenue 30 D 5020 Direct Materials VA KA www KA 5040 Direct Labor 3040 Direct www KA 5040 Direct Labor KA 5050 Variable Overhea KA 3000 variab F 4000 Sales Revenue NJ 4000 Sales 5020 Direct Materials F NJ P NJ 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 to 5040 Direct Labor FOCA V 5050 Variable Overhea AZ AZ to 4000 Sales Revenue NJ Tree P 5020 Direct Materials NJ QUEO DIELE 5040 Direct Labor Tre picc NJ 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 -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 0 -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 ΚΑ 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 ΚΑ 5050 Variable Overhea KA 5040 Direct Labor 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor 5050 Variable Overhea NJ NJ 4000 Sales Revenue KA 5020 Direct Materials KA 5040 Direct Labor. 5050 Variable Overhea KA KA 4000 Sales Revenue NJ 5020 Direct Materials NJ NJ 5040 Direct Labor 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 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 -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 Mikel 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 Hom 3025 Norm 3026 Lerer 3026 Lerer Ter 3026 Lerer 3020 Cerer 3026 Lerer Lecter 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 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 Klonde K.Leeds vient 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. 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 Eve 5040 Direct Labor 5050 Variable Overhea AZ 3030 var AL 4000 Sales Revenue AZ 5020 Direct Materials AZ AZ AZ NE 5040 Direct Labor 5050 Variable Overhea AZ 4000 Sales Revenue AZ A7 5020 Direct Materials AZ 5040 Direct Labor 5050 Variable Overhea AZ 4000 Sales Revenue NJ 5020 Direct Materials NJ 17 AZ 5040 Direct Labor NJ FOFO Velikle he 5050 Variable Overhea NJ 4000 Sales Revenue CO 15030 B 5020 Direct Materials CO Joves 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 co 5020 Direct Materials CO 5040 Direct Labor CO 5050 Variable Overhea CO 4000 Sales Revenue KA 2000 5020 Direct Materials KA FOTO QUEE 5040 Direct Labor KA 5050 Variable Overhea KA var fa 120 4000 Sales Revenue KA 5020 Direct Materials KA Dieet 5040 Direct Labor Tom Direct KA fo 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 CO 5040 Direct Labor. trace 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 -00 -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 30 ME 3051 Williams. 3091 Michae 3051 Williams 2004 Willi 3051 Williams www.wan 3052 Zameer 3050 3052 Zameer 2004 camm 3052 Zameer 209 Camic 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 you 3065 Junior 3070 Marut 2010 3070 Marut 3070 Marut pepp 3070 Marut 3080 DON www 3080 DON 3080 DON ma 3080 DON 3081 Louis www.Louis 3081 Louis Door Code 3081 Louis DOUT LOUIS 3081 Louis 2001 Code 3181 Mihal 310 mildt 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 The conch C. Mayer Mayer C. Mayer emaye 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 w M. Ryan M. Ryan M.Ryan v Londo K.Leeds Men K.Leeds K.Leeds K.Leeds M. Ryan T M. Ryan M. Ryan M. Ryan F. Mc Govern Lave F. Mc Govern F. Mc Govern Ne F. Mc Govern T K.Leeds A.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 M 5020 Direct Material 5020 Direct Materials NJ F040 Diet Labor 5040 Direct Labor to NJ pore Vantable Overh 5050 Variable Overhea NJ Cover Fou 4000 Sales Revenue NJ FOR 5020 Direct Materials NJ 5040 Direct Labor NJ Foro Venie 5050 Variable Overhea NJ verand 4000 Sales Revenue CO 1000 sales nevend = 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 vand 4000 Sales Revenue AZ 5020 Direct Materials AZ 5040 Direct Labor AZ 5050 Variable Overhea AZ varia are 4000 Sales Revenue AZ TAE 5020 Direct Materials AZ Perdance 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 Que -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 Sarkom 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 widan 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 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 way.com 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 WC- M. Cohen www.coaccomm M. Cohen M. Cohen T 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 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 CO 5040 Direct Labor 5050 Variable Overhea CO 4000 Sales Revenue NJ 5020 Direct Materials NJ NI NJ 5010 Direct labor 5040 Direct Labor 5050 Variable Overhea NJ 4000 Sales Revenue CO 5020 Direct Materials CO 5040 Direct leben 5040 Direct Labor со FOFO Variable Over co 5050 Variable Overhea CO 1000 4000 Sales Revenue KA 500 Die www. 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 9040 Dieet mater 5040 Direct Labor Foro Venetle KA 5050 Variable Overhea 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 11000 Banda 5020 Direct Materials NJ. 5040 Direct Labor NJ DOTO DICCE Cupor 5050 Variable Overhea NJ Fara 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 [NE 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor NI NJ 5050 Variable Overhea NJ 4000 Sales Revenue NJ 5020 Direct Materials NJ 5040 Direct Labor FOTO V NJ 5050 Variable Overhea NJ 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 1400 -98 -126 -168 350 20 -28 177 -17.5 -14 700 700 -49 -63 24 -84 Za 550 -22 -27.5 -49.5 725 720 -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 -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 KA 5020 Direct Materials KA 5040 Direct Labor KA 5050 Variable Overhea KA 4000 Sales Revenue ΚΑ 5020 Direct Materials KA 5040 Direct Labor KA 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 AZ 5040 Direct Labor 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)

INSTRUCTIONS 1 Add a sheet to the worksheet and rename sheet Pivot table 1 On sheet which is now cal... View the full answer