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.