I need the Excel worksheet and answers please, help me 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 I need the Excel worksheet and answers to the above Job CUSTOMER SALES PERSON ACCOUNT LOCATION AMOUNT 1008 Marut K Leeds 4000 Sales Revenue AZ 800 1008 Marut K Leeds 5020 Direct Materials AZ 2 1008 Marut K Leeds 5040 Direct Labor AZ 64 1008 Marut K Leeds 5050 Variable Overhea AZ 400 1011 Mihal K Leeds 4000 Sales Revenue NJ 700 1011 Mihal K Leeds 5020 Direct Materials NJ 2 1011 Mihal K Leeds 5040 Direct Labor NJ 56 1011 Mihal K Leeds 5050 Variable Overhea NJ 350 1020 Lago C Mayer 4000 Sales Revenue CO 1000 1020 Lago C Mayer 5020 Direct Materials CO 70 1020 Lago C Mayer 5040 Direct Labor CO 90 1020 Lago C Mayer 5050 Variable Overhea CO 120 1021 Williams M Cohen 4000 Sales Revenue NJ 250 1021 Williams M Cohen 5020 Direct Materials NJ 20 1021 Williams M Cohen 5040 Direct Labor NJ 12 5 1021 Williams M Cohen 5050 Variable Overhea NJ 10 1022 Zameer C Mayer 4000 Sales Revenue CO 800 1022 Zameer C Mayer 5020 Direct Materials CO 56 1022 Zameer C Mayer 5040 Direct Labor CO 72 1022 Zameer C Mayer 5050 Variable Overhea CO 96 1025 Norm F Mc Govern 4000 Sales Revenue KA 500 1025 Norm F Mc Govern 5020 Direct Materials KA 20 1025 Norm F Mc Govern 5040 Direct Labor KA 25 1025 Norm F Mc Govern 5050 Variable Overhea KA 45 1026 Lerer F Mc Govern 4000 Sales Revenue KA 700 1026 Lerer F Mc Govern 5020 Direct Materials KA 28 1026 Lerer F Mc Govern 5040 Direct Labor KA 35 1026 Lerer F Mc Govern 5050 Variable Overhea KA 63 1029 Norm M Cohen 4000 Sales Revenue NJ 2500 1029 Norm M Cohen 5020 Direct Materials NJ 200 1029 Norm M Cohen 5040 Direct Labor NJ 125 1029 Norm M Cohen 5050 Variable Overhea NJ 100 1029 Louis M Ryan 4000 Sales Revenue KA 800 1029 Louis M Ryan 5020 Direct Materials KA 56 1029 Louis M Ryan 5040 Direct Labor KA 32 1029 Louis M Ryan 5050 Variable Overhea KA 40 1030 Lago C Mayer 4000 Sales Revenue CO 2200 1030 Lago C Mayer 5020 Direct Materials CO 154 1030 Lago C Mayer 5040 Direct Labor CO 198 1030 Lago C Mayer 5050 Variable Overhea CO 264 1031 Norm M Cohen 4000 Sales Revenue KA 2200 1031 Norm M Cohen 5020 Direct Materials KA 176 1031 Norm M Cohen 5040 Direct Labor KA 110 1031 Norm M Cohen 5050 Variable Overhea KA 88 Job CUSTOMER SALES PERSON ACCOUNT LOCATION AMOUNT 1044 Williams M Cohen 4000 Sales Revenue NJ 1200 1044 Williams M Cohen 5020 Direct Materials NJ 96 1044 Williams M Cohen 5040 Direct Labor NJ 60 1044 Williams M Cohen 5050 Variable Overhea NJ 48 1048 Louis F Mc Govern 4000 Sales Revenue KA 500 1048 Louis F Mc Govern 5020 Direct Materials KA 20 1048 Louis F Mc Govern 5040 Direct Labor KA 25 1048 Louis F Mc Govern 5050 Variable Overhea KA 45 1049 Junior M Ryan 4000 Sales Revenue NJ 1800 1049 Junior M Ryan 5020 Direct Materials NJ 126 1049 Junior M Ryan 5040 Direct Labor NJ 72 1049 Junior M Ryan 5050 Variable Overhea NJ 90 1050 Lago C Mayer 4000 Sales Revenue NJ 500 1050 Lago C Mayer 5020 Direct Materials NJ 35 1050 Lago C Mayer 5040 Direct Labor NJ 45 1050 Lago C Mayer 5050 Variable Overhea NJ 60 1051 Williams M Cohen 4000 Sales Revenue NJ 400 1051 Williams M Cohen 5020 Direct Materials NJ 32 1051 Williams M Cohen 5040 Direct Labor NJ 20 1051 Williams M Cohen 5050 Variable Overhea NJ 16 1052 Zameer C Mayer 4000 Sales Revenue CO 900 1052 Zameer C Mayer 5020 Direct Materials CO 63 1052 Zameer C Mayer 5040 Direct Labor CO 81 1052 Zameer C Mayer 5050 Variable Overhea CO 108 1055 DON M Ryan 4000 Sales Revenue KA 2200 1055 DON M Ryan 5020 Direct Materials KA 154 1055 DON M Ryan 5040 Direct Labor KA 88 1055 DON M Ryan 5050 Variable Overhea KA 110 1060 Lerer F Mc Govern 4000 Sales Revenue KA 750 1060 Lerer F Mc Govern 5020 Direct Materials KA 30 1060 Lerer F Mc Govern 5040 Direct Labor KA 37 5 1060 Lerer F Mc Govern 5050 Variable Overhea KA 67 5 1065 Junior M Ryan 4000 Sales Revenue NJ 2200 1065 Junior M Ryan 5020 Direct Materials NJ 154 1065 Junior M Ryan 5040 Direct Labor NJ 88 1065 Junior M Ryan 5050 Variable Overhea NJ 110 1070 Marut K Leeds 4000 Sales Revenue NJ 900 1070 Marut K Leeds 5020 Direct Materials NJ 2 1070 Marut K Leeds 5040 Direct Labor NJ 72 1070 Marut K Leeds 5050 Variable Overhea NJ 450 1080 DON M Ryan 4000 Sales Revenue KA 3500 1080 DON M Ryan 5020 Direct Materials KA 245 1080 DON M Ryan 5040 Direct Labor KA 140 1080 DON M Ryan 5050 Variable Overhea KA 175 1081 Louis F Mc Govern 4000 Sales Revenue KA 1250 Job CUSTOMER SALES PERSON ACCOUNT LOCATION AMOUNT 1081 Louis F Mc Govern 5020 Direct Materials KA 50 1081 Louis F Mc Govern 5040 Direct Labor KA 62 5 1081 Louis F Mc Govern 5050 Variable Overhea KA 112 5 1081 Mihal K Leeds 4000 Sales Revenue AZ 1700 1081 Mihal K Leeds 5020 Direct Materials AZ 2 1081 Mihal K Leeds 5040 Direct Labor AZ 136 1081 Mihal K Leeds 5050 Variable Overhea AZ 850 1099 Mihal K Leeds 4000 Sales Revenue AZ 1200 1099 Mihal K Leeds 5020 Direct Materials AZ 2 1099 Mihal K Leeds 5040 Direct Labor AZ 96 1099 Mihal K Leeds 5050 Variable Overhea AZ 600 2012 Marut K Leeds 4000 Sales Revenue AZ 900 2012 Marut K Leeds 5020 Direct Materials AZ 2 2012 Marut K Leeds 5040 Direct Labor AZ 72 2012 Marut K Leeds 5050 Variable Overhea AZ 450 2011 Mihal K Leeds 4000 Sales Revenue NJ 820 2011 Mihal K Leeds 5020 Direct Materials NJ 2 2011 Mihal K Leeds 5040 Direct Labor NJ 65 6 2011 Mihal K Leeds 5050 Variable Overhea NJ 410 2120 Lago C Mayer 4000 Sales Revenue CO 1400 2120 Lago C Mayer 5020 Direct Materials CO 98 2120 Lago C Mayer 5040 Direct Labor CO 126 2120 Lago C Mayer 5050 Variable Overhea CO 168 2021 Williams M Cohen 4000 Sales Revenue NJ 350 2021 Williams M Cohen 5020 Direct Materials NJ 28 2021 Williams M Cohen 5040 Direct Labor NJ 17 5 2021 Williams M Cohen 5050 Variable Overhea NJ 14 2022 Zameer C Mayer 4000 Sales Revenue CO 700 2022 Zameer C Mayer 5020 Direct Materials CO 49 2022 Zameer C Mayer 5040 Direct Labor CO 63 2022 Zameer C Mayer 5050 Variable Overhea CO 84 2025 Norm F Mc Govern 4000 Sales Revenue KA 550 2025 Norm F Mc Govern 5020 Direct Materials KA 22 2025 Norm F Mc Govern 5040 Direct Labor KA 27 5 2025 Norm F Mc Govern 5050 Variable Overhea KA 49 5 2026 Lerer F Mc Govern 4000 Sales Revenue KA 725 2026 Lerer F Mc Govern 5020 Direct Materials KA 29 2026 Lerer F Mc Govern 5040 Direct Labor KA 36 25 2026 Lerer F Mc Govern 5050 Variable Overhea KA 65 25 2029 Norm M Cohen 4000 Sales Revenue NJ 2800 2029 Norm M Cohen 5020 Direct Materials NJ 224 2029 Norm M Cohen 5040 Direct Labor NJ 140 2029 Norm M Cohen 5050 Variable Overhea NJ 112 2129 Louis M Ryan 4000 Sales Revenue KA 800 2129 Louis M Ryan 5020 Direct Materials KA 56 3page Job CUSTOMER SALES PERSON ACCOUNT LOCATION AMOUNT 2129 Louis M Ryan 5040 Direct Labor KA 32 2129 Louis M Ryan 5050 Variable Overhea KA 40 2230 Lago C Mayer 4000 Sales Revenue CO 1200 2230 Lago C Mayer 5020 Direct Materials CO 84 2230 Lago C Mayer 5040 Direct Labor CO 108 2230 Lago C Mayer 5050 Variable Overhea CO 144 2231 Norm M Cohen 4000 Sales Revenue KA 1850 2231 Norm M Cohen 5020 Direct Materials KA 148 2231 Norm M Cohen 5040 Direct Labor KA 92 5 2231 Norm M Cohen 5050 Variable Overhea KA 74 2244 Williams M Cohen 4000 Sales Revenue NJ 1700 2244 Williams M Cohen 5020 Direct Materials NJ 136 2244 Williams M Cohen 5040 Direct Labor NJ 85 2244 Williams M Cohen 5050 Variable Overhea NJ 68 2248 Louis F Mc Govern 4000 Sales Revenue KA 400 2248 Louis F Mc Govern 5020 Direct Materials KA 16 2248 Louis F Mc Govern 5040 Direct Labor KA 20 2248 Louis F Mc Govern 5050 Variable Overhea KA 36 2249 Junior M Ryan 4000 Sales Revenue NJ 2200 2249 Junior M Ryan 5020 Direct Materials NJ 154 2249 Junior M Ryan 5040 Direct Labor NJ 88 2249 Junior M Ryan 5050 Variable Overhea NJ 110 2250 Lago C Mayer 4000 Sales Revenue NJ 450 2250 Lago C Mayer 5020 Direct Materials NJ 31 5 2250 Lago C Mayer 5040 Direct Labor NJ 40 5 2250 Lago C Mayer 5050 Variable Overhea NJ 54 2251 Williams M Cohen 4000 Sales Revenue NJ 900 2251 Williams M Cohen 5020 Direct Materials NJ 72 2251 Williams M Cohen 5040 Direct Labor NJ 45 2251 Williams M Cohen 5050 Variable Overhea NJ 36 2252 Zameer C Mayer 4000 Sales Revenue CO 600 2252 Zameer C Mayer 5020 Direct Materials CO 42 2252 Zameer C Mayer 5040 Direct Labor CO 54 2252 Zameer C Mayer 5050 Variable Overhea CO 72 2255 DON M Ryan 4000 Sales Revenue KA 3300 2255 DON M Ryan 5020 Direct Materials KA 231 2255 DON M Ryan 5040 Direct Labor KA 132 2255 DON M Ryan 5050 Variable Overhea KA 165 2260 Lerer F Mc Govern 4000 Sales Revenue KA 680 2260 Lerer F Mc Govern 5020 Direct Materials KA 27 2 2260 Lerer F Mc Govern 5040 Direct Labor KA 34 2260 Lerer F Mc Govern 5050 Variable Overhea KA 61 2 2265 Junior M Ryan 4000 Sales Revenue NJ 3400 2265 Junior M Ryan 5020 Direct Materials NJ 238 2265 Junior M Ryan 5040 Direct Labor NJ 136 4page Job CUSTOMER SALES PERSON ACCOUNT LOCATION AMOUNT 2265 Junior M Ryan 5050 Variable Overhea NJ 170 2270 Marut K Leeds 4000 Sales Revenue NJ 840 2270 Marut K Leeds 5020 Direct Materials NJ 2 2270 Marut K Leeds 5040 Direct Labor NJ 67 2 2270 Marut K Leeds 5050 Variable Overhea NJ 420 2280 DON M Ryan 4000 Sales Revenue KA 3600 2280 DON M Ryan 5020 Direct Materials KA 252 2280 DON M Ryan 5040 Direct Labor KA 144 2280 DON M Ryan 5050 Variable Overhea KA 180 2281 Louis F Mc Govern 4000 Sales Revenue KA 1350 2281 Louis F Mc Govern 5020 Direct Materials KA 54 2281 Louis F Mc Govern 5040 Direct Labor KA 67 5 2281 Louis F Mc Govern 5050 Variable Overhea KA 121 5 2221 Mihal K Leeds 4000 Sales Revenue AZ 1800 2221 Mihal K Leeds 5020 Direct Materials AZ 2 2221 Mihal K Leeds 5040 Direct Labor AZ 144 2221 Mihal K Leeds 5050 Variable Overhea AZ 900 2299 Mihal K Leeds 4000 Sales Revenue AZ 1100 2299 Mihal K Leeds 5020 Direct Materials AZ 2 2299 Mihal K Leeds 5040 Direct Labor AZ 88 2299 Mihal K Leeds 5050 Variable Overhea AZ 550 3008 Marut K Leeds 4000 Sales Revenue AZ 800 3008 Marut K Leeds 5020 Direct Materials AZ 2 3008 Marut K Leeds 5040 Direct Labor AZ 64 3008 Marut K Leeds 5050 Variable Overhea AZ 400 3011 Mihal K Leeds 4000 Sales Revenue NJ 700 3011 Mihal K Leeds 5020 Direct Materials NJ 2 3011 Mihal K Leeds 5040 Direct Labor NJ 56 3011 Mihal K Leeds 5050 Variable Overhea NJ 350 3020 Lago C Mayer 4000 Sales Revenue CO 1000 3020 Lago C Mayer 5020 Direct Materials CO 70 3020 Lago C Mayer 5040 Direct Labor CO 90 3020 Lago C Mayer 5050 Variable Overhea CO 120 3021 Williams M Cohen 4000 Sales Revenue NJ 250 3021 Williams M Cohen 5020 Direct Materials NJ 20 3021 Williams M Cohen 5040 Direct Labor NJ 12 5 3021 Williams M Cohen 5050 Variable Overhea NJ 10 3022 Zameer C Mayer 4000 Sales Revenue CO 800 3022 Zameer C Mayer 5020 Direct Materials CO 56 3022 Zameer C Mayer 5040 Direct Labor CO 72 3022 Zameer C Mayer 5050 Variable Overhea CO 96 3025 Norm F Mc Govern 4000 Sales Revenue KA 500 3025 Norm F Mc Govern 5020 Direct Materials KA 20 3025 Norm F Mc Govern 5040 Direct Labor KA 25 3025 Norm F Mc Govern 5050 Variable Overhea KA 45 5page Job CUSTOMER SALES PERSON ACCOUNT LOCATION AMOUNT 3026 Lerer F Mc Govern 4000 Sales Revenue KA 700 3026 Lerer F Mc Govern 5020 Direct Materials KA 28 3026 Lerer F Mc Govern 5040 Direct Labor KA 35 3026 Lerer F Mc Govern 5050 Variable Overhea KA 63 3029 Norm M Cohen 4000 Sales Revenue NJ 2500 3029 Norm M Cohen 5020 Direct Materials NJ 200 3029 Norm M Cohen 5040 Direct Labor NJ 125 3029 Norm M Cohen 5050 Variable Overhea NJ 100 3129 Louis M Ryan 4000 Sales Revenue KA 800 3129 Louis M Ryan 5020 Direct Materials KA 56 3129 Louis M Ryan 5040 Direct Labor KA 32 3129 Louis M Ryan 5050 Variable Overhea KA 40 3030 Lago C Mayer 4000 Sales Revenue CO 2200 3030 Lago C Mayer 5020 Direct Materials CO 154 3030 Lago C Mayer 5040 Direct Labor CO 198 3030 Lago C Mayer 5050 Variable Overhea CO 264 3031 Norm M Cohen 4000 Sales Revenue KA 2200 3031 Norm M Cohen 5020 Direct Materials KA 176 3031 Norm M Cohen 5040 Direct Labor KA 110 3031 Norm M Cohen 5050 Variable Overhea KA 88 3044 Williams M Cohen 4000 Sales Revenue NJ 1200 3044 Williams M Cohen 5020 Direct Materials NJ 96 3044 Williams M Cohen 5040 Direct Labor NJ 60 3044 Williams M Cohen 5050 Variable Overhea NJ 48 3048 Louis F Mc Govern 4000 Sales Revenue KA 500 3048 Louis F Mc Govern 5020 Direct Materials KA 20 3048 Louis F Mc Govern 5040 Direct Labor KA 25 3048 Louis F Mc Govern 5050 Variable Overhea KA 45 3049 Junior M Ryan 4000 Sales Revenue NJ 1800 3049 Junior M Ryan 5020 Direct Materials NJ 126 3049 Junior M Ryan 5040 Direct Labor NJ 72 3049 Junior M Ryan 5050 Variable Overhea NJ 90 3050 Lago C Mayer 4000 Sales Revenue NJ 500 3050 Lago C Mayer 5020 Direct Materials NJ 35 3050 Lago C Mayer 5040 Direct Labor NJ 45 3050 Lago C Mayer 5050 Variable Overhea NJ 60 3051 Williams M Cohen 4000 Sales Revenue NJ 400 3051 Williams M Cohen 5020 Direct Materials NJ 32 3051 Williams M Cohen 5040 Direct Labor NJ 20 3051 Williams M Cohen 5050 Variable Overhea NJ 16 3052 Zameer C Mayer 4000 Sales Revenue CO 900 3052 Zameer C Mayer 5020 Direct Materials CO 63 3052 Zameer C Mayer 5040 Direct Labor CO 81 3052 Zameer C Mayer 5050 Variable Overhea CO 108 3055 DON M Ryan 4000 Sales Revenue KA 2200 6page Job CUSTOMER SALES PERSON ACCOUNT LOCATION AMOUNT 3055 DON M Ryan 5020 Direct Materials KA 154 3055 DON M Ryan 5040 Direct Labor KA 88 3055 DON M Ryan 5050 Variable Overhea KA 110 3060 Lerer F Mc Govern 4000 Sales Revenue KA 750 3060 Lerer F Mc Govern 5020 Direct Materials KA 30 3060 Lerer F Mc Govern 5040 Direct Labor KA 37 5 3060 Lerer F Mc Govern 5050 Variable Overhea KA 67 5 3065 Junior M Ryan 4000 Sales Revenue NJ 2200 3065 Junior M Ryan 5020 Direct Materials NJ 154 3065 Junior M Ryan 5040 Direct Labor NJ 88 3065 Junior M Ryan 5050 Variable Overhea NJ 110 3070 Marut K Leeds 4000 Sales Revenue NJ 900 3070 Marut K Leeds 5020 Direct Materials NJ 2 3070 Marut K Leeds 5040 Direct Labor NJ 72 3070 Marut K Leeds 5050 Variable Overhea NJ 450 3080 DON M Ryan 4000 Sales Revenue KA 3500 3080 DON M Ryan 5020 Direct Materials KA 245 3080 DON M Ryan 5040 Direct Labor KA 140 3080 DON M Ryan 5050 Variable Overhea KA 175 3081 Louis F Mc Govern 4000 Sales Revenue KA 1250 3081 Louis F Mc Govern 5020 Direct Materials KA 50 3081 Louis F Mc Govern 5040 Direct Labor KA 62 5 3081 Louis F Mc Govern 5050 Variable Overhea KA 112 5 3181 Mihal K Leeds 4000 Sales Revenue AZ 1700 3181 Mihal K Leeds 5020 Direct Materials AZ 2 3181 Mihal K Leeds 5040 Direct Labor AZ 136 3181 Mihal K Leeds 5050 Variable Overhea AZ 850 3099 Mihal K Leeds 4000 Sales Revenue AZ 1200 3099 Mihal K Leeds 5020 Direct Materials AZ 2 3099 Mihal K Leeds 5040 Direct Labor AZ 96 3099 Mihal K Leeds 5050 Variable Overhea AZ 600 4012 Marut K Leeds 4000 Sales Revenue AZ 900 4012 Marut K Leeds 5020 Direct Materials AZ 2 4012 Marut K Leeds 5040 Direct Labor AZ 72 4012 Marut K Leeds 5050 Variable Overhea AZ 450 4011 Mihal K Leeds 4000 Sales Revenue NJ 820 4011 Mihal K Leeds 5020 Direct Materials NJ 2 4011 Mihal K Leeds 5040 Direct Labor NJ 65 6 4011 Mihal K Leeds 5050 Variable Overhea NJ 410 4120 Lago C Mayer 4000 Sales Revenue CO 1400 4120 Lago C Mayer 5020 Direct Materials CO 98 4120 Lago C Mayer 5040 Direct Labor CO 126 4120 Lago C Mayer 5050 Variable Overhea CO 168 4021 Williams M Cohen 4000 Sales Revenue NJ 350 4021 Williams M Cohen 5020 Direct Materials NJ 28 7page Job CUSTOMER SALES PERSON ACCOUNT LOCATION AMOUNT 4021 Williams M Cohen 5040 Direct Labor NJ 17 5 4021 Williams M Cohen 5050 Variable Overhea NJ 14 4022 Zameer C Mayer 4000 Sales Revenue CO 700 4022 Zameer C Mayer 5020 Direct Materials CO 49 4022 Zameer C Mayer 5040 Direct Labor CO 63 4022 Zameer C Mayer 5050 Variable Overhea CO 84 4025 Norm F Mc Govern 4000 Sales Revenue KA 550 4025 Norm F Mc Govern 5020 Direct Materials KA 22 4025 Norm F Mc Govern 5040 Direct Labor KA 27 5 4025 Norm F Mc Govern 5050 Variable Overhea KA 49 5 4026 Lerer F Mc Govern 4000 Sales Revenue KA 725 4026 Lerer F Mc Govern 5020 Direct Materials KA 29 4026 Lerer F Mc Govern 5040 Direct Labor KA 36 25 4026 Lerer F Mc Govern 5050 Variable Overhea KA 65 25 4029 Norm M Cohen 4000 Sales Revenue NJ 2800 4029 Norm M Cohen 5020 Direct Materials NJ 224 4029 Norm M Cohen 5040 Direct Labor NJ 140 4029 Norm M Cohen 5050 Variable Overhea NJ 112 4129 Louis M Ryan 4000 Sales Revenue KA 800 4129 Louis M Ryan 5020 Direct Materials KA 56 4129 Louis M Ryan 5040 Direct Labor KA 32 4129 Louis M Ryan 5050 Variable Overhea KA 40 4230 Lago C Mayer 4000 Sales Revenue CO 1200 4230 Lago C Mayer 5020 Direct Materials CO 84 4230 Lago C Mayer 5040 Direct Labor CO 108 4230 Lago C Mayer 5050 Variable Overhea CO 144 4231 Norm M Cohen 4000 Sales Revenue KA 1850 4231 Norm M Cohen 5020 Direct Materials KA 148 4231 Norm M Cohen 5040 Direct Labor KA 92 5 4231 Norm M Cohen 5050 Variable Overhea KA 74 4244 Williams M Cohen 4000 Sales Revenue NJ 1700 4244 Williams M Cohen 5020 Direct Materials NJ 136 4244 Williams M Cohen 5040 Direct Labor NJ 85 4244 Williams M Cohen 5050 Variable Overhea NJ 68 4248 Louis F Mc Govern 4000 Sales Revenue KA 400 4248 Louis F Mc Govern 5020 Direct Materials KA 16 4248 Louis F Mc Govern 5040 Direct Labor KA 20 4248 Louis F Mc Govern 5050 Variable Overhea KA 36 4249 Junior M Ryan 4000 Sales Revenue NJ 2200 4249 Junior M Ryan 5020 Direct Materials NJ 154 4249 Junior M Ryan 5040 Direct Labor NJ 88 4249 Junior M Ryan 5050 Variable Overhea NJ 110 4250 Lago C Mayer 4000 Sales Revenue NJ 450 4250 Lago C Mayer 5020 Direct Materials NJ 31 5 4250 Lago C Mayer 5040 Direct Labor NJ 40 5 8page Job CUSTOMER SALES PERSON ACCOUNT LOCATION AMOUNT 4250 Lago C Mayer 5050 Variable Overhea NJ 54 4251 Williams M Cohen 4000 Sales Revenue NJ 900 4251 Williams M Cohen 5020 Direct Materials NJ 72 4251 Williams M Cohen 5040 Direct Labor NJ 45 4251 Williams M Cohen 5050 Variable Overhea NJ 36 4252 Zameer C Mayer 4000 Sales Revenue CO 600 4252 Zameer C Mayer 5020 Direct Materials CO 42 4252 Zameer C Mayer 5040 Direct Labor CO 54 4252 Zameer C Mayer 5050 Variable Overhea CO 72 4255 DON M Ryan 4000 Sales Revenue KA 3300 4255 DON M Ryan 5020 Direct Materials KA 231 4255 DON M Ryan 5040 Direct Labor KA 132 4255 DON M Ryan 5050 Variable Overhea KA 165 4260 Lerer F Mc Govern 4000 Sales Revenue KA 680 4260 Lerer F Mc Govern 5020 Direct Materials KA 27 2 4260 Lerer F Mc Govern 5040 Direct Labor KA 34 4260 Lerer F Mc Govern 5050 Variable Overhea KA 61 2 4265 Junior M Ryan 4000 Sales Revenue NJ 3400 4265 Junior M Ryan 5020 Direct Materials NJ 238 4265 Junior M Ryan 5040 Direct Labor NJ 136 4265 Junior M Ryan 5050 Variable Overhea NJ 170 4270 Marut K Leeds 4000 Sales Revenue NJ 840 4270 Marut K Leeds 5020 Direct Materials NJ 2 4270 Marut K Leeds 5040 Direct Labor NJ 67 2 4270 Marut K Leeds 5050 Variable Overhea NJ 420 4280 DON M Ryan 4000 Sales Revenue KA 3600 4280 DON M Ryan 5020 Direct Materials KA 252 4280 DON M Ryan 5040 Direct Labor KA 144 4280 DON M Ryan 5050 Variable Overhea KA 180 4281 Louis F Mc Govern 4000 Sales Revenue KA 1350 4281 Louis F Mc Govern 5020 Direct Materials KA 54 4281 Louis F Mc Govern 5040 Direct Labor KA 67 5 4281 Louis F Mc Govern 5050 Variable Overhea KA 121 5 4221 Mihal K Leeds 4000 Sales Revenue AZ 1800 4221 Mihal K Leeds 5020 Direct Materials AZ 2 4221 Mihal K Leeds 5040 Direct Labor AZ 144 4221 Mihal K Leeds 5050 Variable Overhea AZ 900 4299 Mihal K Leeds 4000 Sales Revenue AZ 1100 4299 Mihal K Leeds 5020 Direct Materials AZ 2 4299 Mihal K Leeds 5040 Direct Labor AZ 88 4299 Mihal K Leeds 5050 Variable Overhea AZ 550 9page I need fill in the blanks of Excel

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 08, 2024

I need the Excel worksheet and answers. please, help me. 1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet

I need the Excel worksheet and answers. please, help me.

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?

I need the Excel worksheet and answers to the above.

Job #	CUSTOMER	SALES PERSON	ACCOUNT #	LOCATION	AMOUNT
1008	Marut	K.Leeds	4000 Sales Revenue	AZ	800
1008	Marut	K.Leeds	5020 Direct Materials	AZ	-2
1008	Marut	K.Leeds	5040 Direct Labor	AZ	-64
1008	Marut	K.Leeds	5050 Variable Overhea	AZ	-400
1011	Mihal	K.Leeds	4000 Sales Revenue	NJ	700
1011	Mihal	K.Leeds	5020 Direct Materials	NJ	-2
1011	Mihal	K.Leeds	5040 Direct Labor	NJ	-56
1011	Mihal	K.Leeds	5050 Variable Overhea	NJ	-350
1020	Lago	C. Mayer	4000 Sales Revenue	CO	1000
1020	Lago	C. Mayer	5020 Direct Materials	CO	-70
1020	Lago	C. Mayer	5040 Direct Labor	CO	-90
1020	Lago	C. Mayer	5050 Variable Overhea	CO	-120
1021	Williams	M. Cohen	4000 Sales Revenue	NJ	250
1021	Williams	M. Cohen	5020 Direct Materials	NJ	-20
1021	Williams	M. Cohen	5040 Direct Labor	NJ	-12.5
1021	Williams	M. Cohen	5050 Variable Overhea	NJ	-10
1022	Zameer	C. Mayer	4000 Sales Revenue	CO	800
1022	Zameer	C. Mayer	5020 Direct Materials	CO	-56
1022	Zameer	C. Mayer	5040 Direct Labor	CO	-72
1022	Zameer	C. Mayer	5050 Variable Overhea	CO	-96
1025	Norm	F. Mc Govern	4000 Sales Revenue	KA	500
1025	Norm	F. Mc Govern	5020 Direct Materials	KA	-20
1025	Norm	F. Mc Govern	5040 Direct Labor	KA	-25
1025	Norm	F. Mc Govern	5050 Variable Overhea	KA	-45
1026	Lerer	F. Mc Govern	4000 Sales Revenue	KA	700
1026	Lerer	F. Mc Govern	5020 Direct Materials	KA	-28
1026	Lerer	F. Mc Govern	5040 Direct Labor	KA	-35
1026	Lerer	F. Mc Govern	5050 Variable Overhea	KA	-63
1029	Norm	M. Cohen	4000 Sales Revenue	NJ	2500
1029	Norm	M. Cohen	5020 Direct Materials	NJ	-200
1029	Norm	M. Cohen	5040 Direct Labor	NJ	-125
1029	Norm	M. Cohen	5050 Variable Overhea	NJ	-100
1029	Louis	M.Ryan	4000 Sales Revenue	KA	800
1029	Louis	M.Ryan	5020 Direct Materials	KA	-56
1029	Louis	M.Ryan	5040 Direct Labor	KA	-32
1029	Louis	M.Ryan	5050 Variable Overhea	KA	-40
1030	Lago	C. Mayer	4000 Sales Revenue	CO	2200
1030	Lago	C. Mayer	5020 Direct Materials	CO	-154
1030	Lago	C. Mayer	5040 Direct Labor	CO	-198
1030	Lago	C. Mayer	5050 Variable Overhea	CO	-264
1031	Norm	M. Cohen	4000 Sales Revenue	KA	2200
1031	Norm	M. Cohen	5020 Direct Materials	KA	-176
1031	Norm	M. Cohen	5040 Direct Labor	KA	-110
1031	Norm	M. Cohen	5050 Variable Overhea	KA	-88

Job #	CUSTOMER	SALES PERSON	ACCOUNT #	LOCATION	AMOUNT
1044	Williams	M. Cohen	4000 Sales Revenue	NJ	1200
1044	Williams	M. Cohen	5020 Direct Materials	NJ	-96
1044	Williams	M. Cohen	5040 Direct Labor	NJ	-60
1044	Williams	M. Cohen	5050 Variable Overhea	NJ	-48
1048	Louis	F. Mc Govern	4000 Sales Revenue	KA	500
1048	Louis	F. Mc Govern	5020 Direct Materials	KA	-20
1048	Louis	F. Mc Govern	5040 Direct Labor	KA	-25
1048	Louis	F. Mc Govern	5050 Variable Overhea	KA	-45
1049	Junior	M.Ryan	4000 Sales Revenue	NJ	1800
1049	Junior	M.Ryan	5020 Direct Materials	NJ	-126
1049	Junior	M.Ryan	5040 Direct Labor	NJ	-72
1049	Junior	M.Ryan	5050 Variable Overhea	NJ	-90
1050	Lago	C. Mayer	4000 Sales Revenue	NJ	500
1050	Lago	C. Mayer	5020 Direct Materials	NJ	-35
1050	Lago	C. Mayer	5040 Direct Labor	NJ	-45
1050	Lago	C. Mayer	5050 Variable Overhea	NJ	-60
1051	Williams	M. Cohen	4000 Sales Revenue	NJ	400
1051	Williams	M. Cohen	5020 Direct Materials	NJ	-32
1051	Williams	M. Cohen	5040 Direct Labor	NJ	-20
1051	Williams	M. Cohen	5050 Variable Overhea	NJ	-16
1052	Zameer	C. Mayer	4000 Sales Revenue	CO	900
1052	Zameer	C. Mayer	5020 Direct Materials	CO	-63
1052	Zameer	C. Mayer	5040 Direct Labor	CO	-81
1052	Zameer	C. Mayer	5050 Variable Overhea	CO	-108
1055	DON	M.Ryan	4000 Sales Revenue	KA	2200
1055	DON	M.Ryan	5020 Direct Materials	KA	-154
1055	DON	M.Ryan	5040 Direct Labor	KA	-88
1055	DON	M.Ryan	5050 Variable Overhea	KA	-110
1060	Lerer	F. Mc Govern	4000 Sales Revenue	KA	750
1060	Lerer	F. Mc Govern	5020 Direct Materials	KA	-30
1060	Lerer	F. Mc Govern	5040 Direct Labor	KA	-37.5
1060	Lerer	F. Mc Govern	5050 Variable Overhea	KA	-67.5
1065	Junior	M.Ryan	4000 Sales Revenue	NJ	2200
1065	Junior	M.Ryan	5020 Direct Materials	NJ	-154
1065	Junior	M.Ryan	5040 Direct Labor	NJ	-88
1065	Junior	M.Ryan	5050 Variable Overhea	NJ	-110
1070	Marut	K.Leeds	4000 Sales Revenue	NJ	900
1070	Marut	K.Leeds	5020 Direct Materials	NJ	-2
1070	Marut	K.Leeds	5040 Direct Labor	NJ	-72
1070	Marut	K.Leeds	5050 Variable Overhea	NJ	-450
1080	DON	M.Ryan	4000 Sales Revenue	KA	3500
1080	DON	M.Ryan	5020 Direct Materials	KA	-245
1080	DON	M.Ryan	5040 Direct Labor	KA	-140
1080	DON	M.Ryan	5050 Variable Overhea	KA	-175
1081	Louis	F. Mc Govern	4000 Sales Revenue	KA	1250

Job #	CUSTOMER	SALES PERSON	ACCOUNT #	LOCATION	AMOUNT
1081	Louis	F. Mc Govern	5020 Direct Materials	KA	-50
1081	Louis	F. Mc Govern	5040 Direct Labor	KA	-62.5
1081	Louis	F. Mc Govern	5050 Variable Overhea	KA	-112.5
1081	Mihal	K.Leeds	4000 Sales Revenue	AZ	1700
1081	Mihal	K.Leeds	5020 Direct Materials	AZ	-2
1081	Mihal	K.Leeds	5040 Direct Labor	AZ	-136
1081	Mihal	K.Leeds	5050 Variable Overhea	AZ	-850
1099	Mihal	K.Leeds	4000 Sales Revenue	AZ	1200
1099	Mihal	K.Leeds	5020 Direct Materials	AZ	-2
1099	Mihal	K.Leeds	5040 Direct Labor	AZ	-96
1099	Mihal	K.Leeds	5050 Variable Overhea	AZ	-600
2012	Marut	K.Leeds	4000 Sales Revenue	AZ	900
2012	Marut	K.Leeds	5020 Direct Materials	AZ	-2
2012	Marut	K.Leeds	5040 Direct Labor	AZ	-72
2012	Marut	K.Leeds	5050 Variable Overhea	AZ	-450
2011	Mihal	K.Leeds	4000 Sales Revenue	NJ	820
2011	Mihal	K.Leeds	5020 Direct Materials	NJ	-2
2011	Mihal	K.Leeds	5040 Direct Labor	NJ	-65.6
2011	Mihal	K.Leeds	5050 Variable Overhea	NJ	-410
2120	Lago	C. Mayer	4000 Sales Revenue	CO	1400
2120	Lago	C. Mayer	5020 Direct Materials	CO	-98
2120	Lago	C. Mayer	5040 Direct Labor	CO	-126
2120	Lago	C. Mayer	5050 Variable Overhea	CO	-168
2021	Williams	M. Cohen	4000 Sales Revenue	NJ	350
2021	Williams	M. Cohen	5020 Direct Materials	NJ	-28
2021	Williams	M. Cohen	5040 Direct Labor	NJ	-17.5
2021	Williams	M. Cohen	5050 Variable Overhea	NJ	-14
2022	Zameer	C. Mayer	4000 Sales Revenue	CO	700
2022	Zameer	C. Mayer	5020 Direct Materials	CO	-49
2022	Zameer	C. Mayer	5040 Direct Labor	CO	-63
2022	Zameer	C. Mayer	5050 Variable Overhea	CO	-84
2025	Norm	F. Mc Govern	4000 Sales Revenue	KA	550
2025	Norm	F. Mc Govern	5020 Direct Materials	KA	-22
2025	Norm	F. Mc Govern	5040 Direct Labor	KA	-27.5
2025	Norm	F. Mc Govern	5050 Variable Overhea	KA	-49.5
2026	Lerer	F. Mc Govern	4000 Sales Revenue	KA	725
2026	Lerer	F. Mc Govern	5020 Direct Materials	KA	-29
2026	Lerer	F. Mc Govern	5040 Direct Labor	KA	-36.25
2026	Lerer	F. Mc Govern	5050 Variable Overhea	KA	-65.25
2029	Norm	M. Cohen	4000 Sales Revenue	NJ	2800
2029	Norm	M. Cohen	5020 Direct Materials	NJ	-224
2029	Norm	M. Cohen	5040 Direct Labor	NJ	-140
2029	Norm	M. Cohen	5050 Variable Overhea	NJ	-112
2129	Louis	M.Ryan	4000 Sales Revenue	KA	800
2129	Louis	M.Ryan	5020 Direct Materials	KA	-56

-3page-

Job #	CUSTOMER	SALES PERSON	ACCOUNT #	LOCATION	AMOUNT
2129	Louis	M.Ryan	5040 Direct Labor	KA	-32
2129	Louis	M.Ryan	5050 Variable Overhea	KA	-40
2230	Lago	C. Mayer	4000 Sales Revenue	CO	1200
2230	Lago	C. Mayer	5020 Direct Materials	CO	-84
2230	Lago	C. Mayer	5040 Direct Labor	CO	-108
2230	Lago	C. Mayer	5050 Variable Overhea	CO	-144
2231	Norm	M. Cohen	4000 Sales Revenue	KA	1850
2231	Norm	M. Cohen	5020 Direct Materials	KA	-148
2231	Norm	M. Cohen	5040 Direct Labor	KA	-92.5
2231	Norm	M. Cohen	5050 Variable Overhea	KA	-74
2244	Williams	M. Cohen	4000 Sales Revenue	NJ	1700
2244	Williams	M. Cohen	5020 Direct Materials	NJ	-136
2244	Williams	M. Cohen	5040 Direct Labor	NJ	-85
2244	Williams	M. Cohen	5050 Variable Overhea	NJ	-68
2248	Louis	F. Mc Govern	4000 Sales Revenue	KA	400
2248	Louis	F. Mc Govern	5020 Direct Materials	KA	-16
2248	Louis	F. Mc Govern	5040 Direct Labor	KA	-20
2248	Louis	F. Mc Govern	5050 Variable Overhea	KA	-36
2249	Junior	M.Ryan	4000 Sales Revenue	NJ	2200
2249	Junior	M.Ryan	5020 Direct Materials	NJ	-154
2249	Junior	M.Ryan	5040 Direct Labor	NJ	-88
2249	Junior	M.Ryan	5050 Variable Overhea	NJ	-110
2250	Lago	C. Mayer	4000 Sales Revenue	NJ	450
2250	Lago	C. Mayer	5020 Direct Materials	NJ	-31.5
2250	Lago	C. Mayer	5040 Direct Labor	NJ	-40.5
2250	Lago	C. Mayer	5050 Variable Overhea	NJ	-54
2251	Williams	M. Cohen	4000 Sales Revenue	NJ	900
2251	Williams	M. Cohen	5020 Direct Materials	NJ	-72
2251	Williams	M. Cohen	5040 Direct Labor	NJ	-45
2251	Williams	M. Cohen	5050 Variable Overhea	NJ	-36
2252	Zameer	C. Mayer	4000 Sales Revenue	CO	600
2252	Zameer	C. Mayer	5020 Direct Materials	CO	-42
2252	Zameer	C. Mayer	5040 Direct Labor	CO	-54
2252	Zameer	C. Mayer	5050 Variable Overhea	CO	-72
2255	DON	M.Ryan	4000 Sales Revenue	KA	3300
2255	DON	M.Ryan	5020 Direct Materials	KA	-231
2255	DON	M.Ryan	5040 Direct Labor	KA	-132
2255	DON	M.Ryan	5050 Variable Overhea	KA	-165
2260	Lerer	F. Mc Govern	4000 Sales Revenue	KA	680
2260	Lerer	F. Mc Govern	5020 Direct Materials	KA	-27.2
2260	Lerer	F. Mc Govern	5040 Direct Labor	KA	-34
2260	Lerer	F. Mc Govern	5050 Variable Overhea	KA	-61.2
2265	Junior	M.Ryan	4000 Sales Revenue	NJ	3400
2265	Junior	M.Ryan	5020 Direct Materials	NJ	-238
2265	Junior	M.Ryan	5040 Direct Labor	NJ	-136

-4page-

Job #	CUSTOMER	SALES PERSON	ACCOUNT #	LOCATION	AMOUNT
2265	Junior	M.Ryan	5050 Variable Overhea	NJ	-170
2270	Marut	K.Leeds	4000 Sales Revenue	NJ	840
2270	Marut	K.Leeds	5020 Direct Materials	NJ	-2
2270	Marut	K.Leeds	5040 Direct Labor	NJ	-67.2
2270	Marut	K.Leeds	5050 Variable Overhea	NJ	-420
2280	DON	M.Ryan	4000 Sales Revenue	KA	3600
2280	DON	M.Ryan	5020 Direct Materials	KA	-252
2280	DON	M.Ryan	5040 Direct Labor	KA	-144
2280	DON	M.Ryan	5050 Variable Overhea	KA	-180
2281	Louis	F. Mc Govern	4000 Sales Revenue	KA	1350
2281	Louis	F. Mc Govern	5020 Direct Materials	KA	-54
2281	Louis	F. Mc Govern	5040 Direct Labor	KA	-67.5
2281	Louis	F. Mc Govern	5050 Variable Overhea	KA	-121.5
2221	Mihal	K.Leeds	4000 Sales Revenue	AZ	1800
2221	Mihal	K.Leeds	5020 Direct Materials	AZ	-2
2221	Mihal	K.Leeds	5040 Direct Labor	AZ	-144
2221	Mihal	K.Leeds	5050 Variable Overhea	AZ	-900
2299	Mihal	K.Leeds	4000 Sales Revenue	AZ	1100
2299	Mihal	K.Leeds	5020 Direct Materials	AZ	-2
2299	Mihal	K.Leeds	5040 Direct Labor	AZ	-88
2299	Mihal	K.Leeds	5050 Variable Overhea	AZ	-550
3008	Marut	K.Leeds	4000 Sales Revenue	AZ	800
3008	Marut	K.Leeds	5020 Direct Materials	AZ	-2
3008	Marut	K.Leeds	5040 Direct Labor	AZ	-64
3008	Marut	K.Leeds	5050 Variable Overhea	AZ	-400
3011	Mihal	K.Leeds	4000 Sales Revenue	NJ	700
3011	Mihal	K.Leeds	5020 Direct Materials	NJ	-2
3011	Mihal	K.Leeds	5040 Direct Labor	NJ	-56
3011	Mihal	K.Leeds	5050 Variable Overhea	NJ	-350
3020	Lago	C. Mayer	4000 Sales Revenue	CO	1000
3020	Lago	C. Mayer	5020 Direct Materials	CO	-70
3020	Lago	C. Mayer	5040 Direct Labor	CO	-90
3020	Lago	C. Mayer	5050 Variable Overhea	CO	-120
3021	Williams	M. Cohen	4000 Sales Revenue	NJ	250
3021	Williams	M. Cohen	5020 Direct Materials	NJ	-20
3021	Williams	M. Cohen	5040 Direct Labor	NJ	-12.5
3021	Williams	M. Cohen	5050 Variable Overhea	NJ	-10
3022	Zameer	C. Mayer	4000 Sales Revenue	CO	800
3022	Zameer	C. Mayer	5020 Direct Materials	CO	-56
3022	Zameer	C. Mayer	5040 Direct Labor	CO	-72
3022	Zameer	C. Mayer	5050 Variable Overhea	CO	-96
3025	Norm	F. Mc Govern	4000 Sales Revenue	KA	500
3025	Norm	F. Mc Govern	5020 Direct Materials	KA	-20
3025	Norm	F. Mc Govern	5040 Direct Labor	KA	-25
3025	Norm	F. Mc Govern	5050 Variable Overhea	KA	-45

-5page-

Job #	CUSTOMER	SALES PERSON	ACCOUNT #	LOCATION	AMOUNT
3026	Lerer	F. Mc Govern	4000 Sales Revenue	KA	700
3026	Lerer	F. Mc Govern	5020 Direct Materials	KA	-28
3026	Lerer	F. Mc Govern	5040 Direct Labor	KA	-35
3026	Lerer	F. Mc Govern	5050 Variable Overhea	KA	-63
3029	Norm	M. Cohen	4000 Sales Revenue	NJ	2500
3029	Norm	M. Cohen	5020 Direct Materials	NJ	-200
3029	Norm	M. Cohen	5040 Direct Labor	NJ	-125
3029	Norm	M. Cohen	5050 Variable Overhea	NJ	-100
3129	Louis	M.Ryan	4000 Sales Revenue	KA	800
3129	Louis	M.Ryan	5020 Direct Materials	KA	-56
3129	Louis	M.Ryan	5040 Direct Labor	KA	-32
3129	Louis	M.Ryan	5050 Variable Overhea	KA	-40
3030	Lago	C. Mayer	4000 Sales Revenue	CO	2200
3030	Lago	C. Mayer	5020 Direct Materials	CO	-154
3030	Lago	C. Mayer	5040 Direct Labor	CO	-198
3030	Lago	C. Mayer	5050 Variable Overhea	CO	-264
3031	Norm	M. Cohen	4000 Sales Revenue	KA	2200
3031	Norm	M. Cohen	5020 Direct Materials	KA	-176
3031	Norm	M. Cohen	5040 Direct Labor	KA	-110
3031	Norm	M. Cohen	5050 Variable Overhea	KA	-88
3044	Williams	M. Cohen	4000 Sales Revenue	NJ	1200
3044	Williams	M. Cohen	5020 Direct Materials	NJ	-96
3044	Williams	M. Cohen	5040 Direct Labor	NJ	-60
3044	Williams	M. Cohen	5050 Variable Overhea	NJ	-48
3048	Louis	F. Mc Govern	4000 Sales Revenue	KA	500
3048	Louis	F. Mc Govern	5020 Direct Materials	KA	-20
3048	Louis	F. Mc Govern	5040 Direct Labor	KA	-25
3048	Louis	F. Mc Govern	5050 Variable Overhea	KA	-45
3049	Junior	M.Ryan	4000 Sales Revenue	NJ	1800
3049	Junior	M.Ryan	5020 Direct Materials	NJ	-126
3049	Junior	M.Ryan	5040 Direct Labor	NJ	-72
3049	Junior	M.Ryan	5050 Variable Overhea	NJ	-90
3050	Lago	C. Mayer	4000 Sales Revenue	NJ	500
3050	Lago	C. Mayer	5020 Direct Materials	NJ	-35
3050	Lago	C. Mayer	5040 Direct Labor	NJ	-45
3050	Lago	C. Mayer	5050 Variable Overhea	NJ	-60
3051	Williams	M. Cohen	4000 Sales Revenue	NJ	400
3051	Williams	M. Cohen	5020 Direct Materials	NJ	-32
3051	Williams	M. Cohen	5040 Direct Labor	NJ	-20
3051	Williams	M. Cohen	5050 Variable Overhea	NJ	-16
3052	Zameer	C. Mayer	4000 Sales Revenue	CO	900
3052	Zameer	C. Mayer	5020 Direct Materials	CO	-63
3052	Zameer	C. Mayer	5040 Direct Labor	CO	-81
3052	Zameer	C. Mayer	5050 Variable Overhea	CO	-108
3055	DON	M.Ryan	4000 Sales Revenue	KA	2200

- 6page-

Job #	CUSTOMER	SALES PERSON	ACCOUNT #	LOCATION	AMOUNT
3055	DON	M.Ryan	5020 Direct Materials	KA	-154
3055	DON	M.Ryan	5040 Direct Labor	KA	-88
3055	DON	M.Ryan	5050 Variable Overhea	KA	-110
3060	Lerer	F. Mc Govern	4000 Sales Revenue	KA	750
3060	Lerer	F. Mc Govern	5020 Direct Materials	KA	-30
3060	Lerer	F. Mc Govern	5040 Direct Labor	KA	-37.5
3060	Lerer	F. Mc Govern	5050 Variable Overhea	KA	-67.5
3065	Junior	M.Ryan	4000 Sales Revenue	NJ	2200
3065	Junior	M.Ryan	5020 Direct Materials	NJ	-154
3065	Junior	M.Ryan	5040 Direct Labor	NJ	-88
3065	Junior	M.Ryan	5050 Variable Overhea	NJ	-110
3070	Marut	K.Leeds	4000 Sales Revenue	NJ	900
3070	Marut	K.Leeds	5020 Direct Materials	NJ	-2
3070	Marut	K.Leeds	5040 Direct Labor	NJ	-72
3070	Marut	K.Leeds	5050 Variable Overhea	NJ	-450
3080	DON	M.Ryan	4000 Sales Revenue	KA	3500
3080	DON	M.Ryan	5020 Direct Materials	KA	-245
3080	DON	M.Ryan	5040 Direct Labor	KA	-140
3080	DON	M.Ryan	5050 Variable Overhea	KA	-175
3081	Louis	F. Mc Govern	4000 Sales Revenue	KA	1250
3081	Louis	F. Mc Govern	5020 Direct Materials	KA	-50
3081	Louis	F. Mc Govern	5040 Direct Labor	KA	-62.5
3081	Louis	F. Mc Govern	5050 Variable Overhea	KA	-112.5
3181	Mihal	K.Leeds	4000 Sales Revenue	AZ	1700
3181	Mihal	K.Leeds	5020 Direct Materials	AZ	-2
3181	Mihal	K.Leeds	5040 Direct Labor	AZ	-136
3181	Mihal	K.Leeds	5050 Variable Overhea	AZ	-850
3099	Mihal	K.Leeds	4000 Sales Revenue	AZ	1200
3099	Mihal	K.Leeds	5020 Direct Materials	AZ	-2
3099	Mihal	K.Leeds	5040 Direct Labor	AZ	-96
3099	Mihal	K.Leeds	5050 Variable Overhea	AZ	-600
4012	Marut	K.Leeds	4000 Sales Revenue	AZ	900
4012	Marut	K.Leeds	5020 Direct Materials	AZ	-2
4012	Marut	K.Leeds	5040 Direct Labor	AZ	-72
4012	Marut	K.Leeds	5050 Variable Overhea	AZ	-450
4011	Mihal	K.Leeds	4000 Sales Revenue	NJ	820
4011	Mihal	K.Leeds	5020 Direct Materials	NJ	-2
4011	Mihal	K.Leeds	5040 Direct Labor	NJ	-65.6
4011	Mihal	K.Leeds	5050 Variable Overhea	NJ	-410
4120	Lago	C. Mayer	4000 Sales Revenue	CO	1400
4120	Lago	C. Mayer	5020 Direct Materials	CO	-98
4120	Lago	C. Mayer	5040 Direct Labor	CO	-126
4120	Lago	C. Mayer	5050 Variable Overhea	CO	-168
4021	Williams	M. Cohen	4000 Sales Revenue	NJ	350
4021	Williams	M. Cohen	5020 Direct Materials	NJ	-28

-7page-

Job #	CUSTOMER	SALES PERSON	ACCOUNT #	LOCATION	AMOUNT
4021	Williams	M. Cohen	5040 Direct Labor	NJ	-17.5
4021	Williams	M. Cohen	5050 Variable Overhea	NJ	-14
4022	Zameer	C. Mayer	4000 Sales Revenue	CO	700
4022	Zameer	C. Mayer	5020 Direct Materials	CO	-49
4022	Zameer	C. Mayer	5040 Direct Labor	CO	-63
4022	Zameer	C. Mayer	5050 Variable Overhea	CO	-84
4025	Norm	F. Mc Govern	4000 Sales Revenue	KA	550
4025	Norm	F. Mc Govern	5020 Direct Materials	KA	-22
4025	Norm	F. Mc Govern	5040 Direct Labor	KA	-27.5
4025	Norm	F. Mc Govern	5050 Variable Overhea	KA	-49.5
4026	Lerer	F. Mc Govern	4000 Sales Revenue	KA	725
4026	Lerer	F. Mc Govern	5020 Direct Materials	KA	-29
4026	Lerer	F. Mc Govern	5040 Direct Labor	KA	-36.25
4026	Lerer	F. Mc Govern	5050 Variable Overhea	KA	-65.25
4029	Norm	M. Cohen	4000 Sales Revenue	NJ	2800
4029	Norm	M. Cohen	5020 Direct Materials	NJ	-224
4029	Norm	M. Cohen	5040 Direct Labor	NJ	-140
4029	Norm	M. Cohen	5050 Variable Overhea	NJ	-112
4129	Louis	M.Ryan	4000 Sales Revenue	KA	800
4129	Louis	M.Ryan	5020 Direct Materials	KA	-56
4129	Louis	M.Ryan	5040 Direct Labor	KA	-32
4129	Louis	M.Ryan	5050 Variable Overhea	KA	-40
4230	Lago	C. Mayer	4000 Sales Revenue	CO	1200
4230	Lago	C. Mayer	5020 Direct Materials	CO	-84
4230	Lago	C. Mayer	5040 Direct Labor	CO	-108
4230	Lago	C. Mayer	5050 Variable Overhea	CO	-144
4231	Norm	M. Cohen	4000 Sales Revenue	KA	1850
4231	Norm	M. Cohen	5020 Direct Materials	KA	-148
4231	Norm	M. Cohen	5040 Direct Labor	KA	-92.5
4231	Norm	M. Cohen	5050 Variable Overhea	KA	-74
4244	Williams	M. Cohen	4000 Sales Revenue	NJ	1700
4244	Williams	M. Cohen	5020 Direct Materials	NJ	-136
4244	Williams	M. Cohen	5040 Direct Labor	NJ	-85
4244	Williams	M. Cohen	5050 Variable Overhea	NJ	-68
4248	Louis	F. Mc Govern	4000 Sales Revenue	KA	400
4248	Louis	F. Mc Govern	5020 Direct Materials	KA	-16
4248	Louis	F. Mc Govern	5040 Direct Labor	KA	-20
4248	Louis	F. Mc Govern	5050 Variable Overhea	KA	-36
4249	Junior	M.Ryan	4000 Sales Revenue	NJ	2200
4249	Junior	M.Ryan	5020 Direct Materials	NJ	-154
4249	Junior	M.Ryan	5040 Direct Labor	NJ	-88
4249	Junior	M.Ryan	5050 Variable Overhea	NJ	-110
4250	Lago	C. Mayer	4000 Sales Revenue	NJ	450
4250	Lago	C. Mayer	5020 Direct Materials	NJ	-31.5
4250	Lago	C. Mayer	5040 Direct Labor	NJ	-40.5

-8page-

Job #	CUSTOMER	SALES PERSON	ACCOUNT #	LOCATION	AMOUNT
4250	Lago	C. Mayer	5050 Variable Overhea	NJ	-54
4251	Williams	M. Cohen	4000 Sales Revenue	NJ	900
4251	Williams	M. Cohen	5020 Direct Materials	NJ	-72
4251	Williams	M. Cohen	5040 Direct Labor	NJ	-45
4251	Williams	M. Cohen	5050 Variable Overhea	NJ	-36
4252	Zameer	C. Mayer	4000 Sales Revenue	CO	600
4252	Zameer	C. Mayer	5020 Direct Materials	CO	-42
4252	Zameer	C. Mayer	5040 Direct Labor	CO	-54
4252	Zameer	C. Mayer	5050 Variable Overhea	CO	-72
4255	DON	M.Ryan	4000 Sales Revenue	KA	3300
4255	DON	M.Ryan	5020 Direct Materials	KA	-231
4255	DON	M.Ryan	5040 Direct Labor	KA	-132
4255	DON	M.Ryan	5050 Variable Overhea	KA	-165
4260	Lerer	F. Mc Govern	4000 Sales Revenue	KA	680
4260	Lerer	F. Mc Govern	5020 Direct Materials	KA	-27.2
4260	Lerer	F. Mc Govern	5040 Direct Labor	KA	-34
4260	Lerer	F. Mc Govern	5050 Variable Overhea	KA	-61.2
4265	Junior	M.Ryan	4000 Sales Revenue	NJ	3400
4265	Junior	M.Ryan	5020 Direct Materials	NJ	-238
4265	Junior	M.Ryan	5040 Direct Labor	NJ	-136
4265	Junior	M.Ryan	5050 Variable Overhea	NJ	-170
4270	Marut	K.Leeds	4000 Sales Revenue	NJ	840
4270	Marut	K.Leeds	5020 Direct Materials	NJ	-2
4270	Marut	K.Leeds	5040 Direct Labor	NJ	-67.2
4270	Marut	K.Leeds	5050 Variable Overhea	NJ	-420
4280	DON	M.Ryan	4000 Sales Revenue	KA	3600
4280	DON	M.Ryan	5020 Direct Materials	KA	-252
4280	DON	M.Ryan	5040 Direct Labor	KA	-144
4280	DON	M.Ryan	5050 Variable Overhea	KA	-180
4281	Louis	F. Mc Govern	4000 Sales Revenue	KA	1350
4281	Louis	F. Mc Govern	5020 Direct Materials	KA	-54
4281	Louis	F. Mc Govern	5040 Direct Labor	KA	-67.5
4281	Louis	F. Mc Govern	5050 Variable Overhea	KA	-121.5
4221	Mihal	K.Leeds	4000 Sales Revenue	AZ	1800
4221	Mihal	K.Leeds	5020 Direct Materials	AZ	-2
4221	Mihal	K.Leeds	5040 Direct Labor	AZ	-144
4221	Mihal	K.Leeds	5050 Variable Overhea	AZ	-900
4299	Mihal	K.Leeds	4000 Sales Revenue	AZ	1100
4299	Mihal	K.Leeds	5020 Direct Materials	AZ	-2
4299	Mihal	K.Leeds	5040 Direct Labor	AZ	-88
4299	Mihal	K.Leeds	5050 Variable Overhea	AZ	-550