invoice number	Sales Person	Type of Car	Date Sold	Sales Price	Purchase Price at Auction	Gross Profit	Commission	Net Profit
1002	Franco	commercial	1-Jan-17	$24,000.00	$23,000.00
1003	Helen	hatch	1-Jan-17	$3,500.00	$2,500.00
1004	Franco	prestige	2-Jan-17	$25,237.00	$20,000.00
1005	Patricia	hatch	3-Jan-17	$5,500.00	$3,000.00
1006	Jim	hatch	5-Jan-17	$26,000.00	$22,200.00
1007	Patricia	hatch	5-Jan-17	$23,700.00	$22,000.00
1008	Franco	hatch	6-Jan-17	$12,700.00	$9,000.00
1009	Franco	four wheel drive	7-Jan-17	$32,000.00	$26,400.00
1010	Helen	commercial	7-Jan-17	$25,500.00	$22,500.00
1011	Jim	four wheel drive	8-Jan-17	$72,999.00	$62,000.00
1012	Jim	hatch	8-Jan-17	$26,000.00	$22,000.00

Please help me find gross profit, commission and net profit. Or please show me the formula for it.

THank you

B 1 BIS Auto Sales, Inc. Gross Profit Target-Quarter 1, 2017 $50,000.00 $100,000.00 $75,000.00 $75,000.00 Jim 3 Input Static Information 4 5 Sales Staff 6 7 Name Name used Position 8 Patricia Jacob Patricia Sales manager 9 Franco Nguyen Franco Sales executive 10 Jim Jones Sales executive 11 Helen Tran Helen Sales executive 12 13 Commission 14 15 Type of Car Commission on gross profit Notes 16 hatch 4.00% hatchback vehicle, like Kia Morning 17 four wheel drive 4.00% SUV or pickup truck, like Ford Ranger 18 commercial 3.00% vehicle used for commerical purposes 19 prestige 5.00% luxury vehicle 20 sedan 3.00% sedan 4 door, like Toyota Corolla 21 27 28 Static Information Raw Car Sales B 1 BIS Auto Sales, Inc. Gross Profit Target-Quarter 1, 2017 $50,000.00 $100,000.00 $75,000.00 $75,000.00 Jim 3 Input Static Information 4 5 Sales Staff 6 7 Name Name used Position 8 Patricia Jacob Patricia Sales manager 9 Franco Nguyen Franco Sales executive 10 Jim Jones Sales executive 11 Helen Tran Helen Sales executive 12 13 Commission 14 15 Type of Car Commission on gross profit Notes 16 hatch 4.00% hatchback vehicle, like Kia Morning 17 four wheel drive 4.00% SUV or pickup truck, like Ford Ranger 18 commercial 3.00% vehicle used for commerical purposes 19 prestige 5.00% luxury vehicle 20 sedan 3.00% sedan 4 door, like Toyota Corolla 21 27 28 Static Information Raw Car Sales