please provide formulas how to solve this problem!

File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot Share Comments P12 - A B Formulas X C fix E D F G H I J K L M N O P Q R S T U V 1 2 Profits Pairs Price COGS Product Bellen Carlota Quad Sunshine Sunset $750.00 $375.00 $350.00 $334.00 $333.00 This table "Transaction Entry" keeps e Background representatives. The SalesPrice and C goods.COGS: Cost of Goods Sold Use the table "COGS" to Complete the Step 1 Entry" table. Profit = Units X (SalesP Calculate the profits in the "Transac transaction.(5%) WSD Step 2 # of Transanctions Profit Percentage In table "Profit" column "# of Transa transactions conducted by each of Step 3 Profit SalesRep Sioux Gault Pham Peng Chin Lin Franks Smith Peng 3 Transaction Entry 4 Date Product Region SalesRep Custome, Units SalesPrice COGS 5 1/1/2011 Quad East Sioux | 16 $432.00 6 1/2/2011 Bellen South Gault KBTB 24 $528.00 7 1/2/2011 Quad West Pham AST 30 $810.00 8 1/2/2011 Bellen West Peng SFWK 19 $ 418.00 9 1/3/2011 Sunshine East Pham FM 38 $722.00 10 1/3/2011 Carlota MidWest Chin FM 20 $460.00 11 1/3/2011 Sunset South Pham 23 $483.00 12 1/3/2011 Sunshine South Sioux PCC 6 $514.00 13 1/4/2011 Sunset MidWest Lin BBT 29 $609.00 14 1/5/2011 Sunset South Pham TIT 57 $1,197.00 15 1/5/2011 Sunshine West Franks ET 12 $1,228.00 16 1/5/2011 Carlota West ITTW 60 $1,380.00 17 1/6/2011 Sunshine East Franks PSA 54 $1,026.00 18 1/6/2011 Sunshine South Smith QT 40 $760.00 19 1/6/2011 Carlota West Lin KPSA 18 $414.00 20 1/6/2011 Quad West Sioux PCC 64 $1,728.00 21 1/7/2011 Carlota MidWest Franks HHH 12 $476.00 22 1/7/2011 Sunset MidWest Sioux PCC 22 $462.00 23 1/7/2011 Sunset West Peng T 61 $1,281.00 24 1/7/2011 Sunset West Pham WT 53 $1,113.00 25 1/7/2011 Bellen West Smith I 27 $594.00 26 1/8/2011 Quad West Chin HII 16 $432.00 27 1/9/2011 Carlota East Franks WSD 38 $874.00 28 1/9/2011 Bellen East Pham 40 $880.00 29 1/9/2011 Sunshine East Lin | 42 $798.00 30 1/9/2011 Bellen South Chin WSD 26 $572.00 31 1/9/2011 Bellen South Sioux QT 15 $330.00 32 ######## Sunset East Gault TRU 27 $567.00 33 ######## Carlota East Pham AA 63 $1,449.00 34 ####### Quad East | Peng DER 171 $459.00 | Step 4 In table "Profit" column "Profit", cal by each sales representatives. Hint similar to the countif formula. (5%) In table "Profit" column "Percentage generated by each Sales Rep overt Step 5 Step 6 In the "Pairs" column in the "Transa transactions between Sales Rep "Si "No" otherwise (5%) File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot Share Comments P12 - A B Formulas X C fix E D F G H I J K L M N O P Q R S T U V 1 2 Profits Pairs Price COGS Product Bellen Carlota Quad Sunshine Sunset $750.00 $375.00 $350.00 $334.00 $333.00 This table "Transaction Entry" keeps e Background representatives. The SalesPrice and C goods.COGS: Cost of Goods Sold Use the table "COGS" to Complete the Step 1 Entry" table. Profit = Units X (SalesP Calculate the profits in the "Transac transaction.(5%) WSD Step 2 # of Transanctions Profit Percentage In table "Profit" column "# of Transa transactions conducted by each of Step 3 Profit SalesRep Sioux Gault Pham Peng Chin Lin Franks Smith Peng 3 Transaction Entry 4 Date Product Region SalesRep Custome, Units SalesPrice COGS 5 1/1/2011 Quad East Sioux | 16 $432.00 6 1/2/2011 Bellen South Gault KBTB 24 $528.00 7 1/2/2011 Quad West Pham AST 30 $810.00 8 1/2/2011 Bellen West Peng SFWK 19 $ 418.00 9 1/3/2011 Sunshine East Pham FM 38 $722.00 10 1/3/2011 Carlota MidWest Chin FM 20 $460.00 11 1/3/2011 Sunset South Pham 23 $483.00 12 1/3/2011 Sunshine South Sioux PCC 6 $514.00 13 1/4/2011 Sunset MidWest Lin BBT 29 $609.00 14 1/5/2011 Sunset South Pham TIT 57 $1,197.00 15 1/5/2011 Sunshine West Franks ET 12 $1,228.00 16 1/5/2011 Carlota West ITTW 60 $1,380.00 17 1/6/2011 Sunshine East Franks PSA 54 $1,026.00 18 1/6/2011 Sunshine South Smith QT 40 $760.00 19 1/6/2011 Carlota West Lin KPSA 18 $414.00 20 1/6/2011 Quad West Sioux PCC 64 $1,728.00 21 1/7/2011 Carlota MidWest Franks HHH 12 $476.00 22 1/7/2011 Sunset MidWest Sioux PCC 22 $462.00 23 1/7/2011 Sunset West Peng T 61 $1,281.00 24 1/7/2011 Sunset West Pham WT 53 $1,113.00 25 1/7/2011 Bellen West Smith I 27 $594.00 26 1/8/2011 Quad West Chin HII 16 $432.00 27 1/9/2011 Carlota East Franks WSD 38 $874.00 28 1/9/2011 Bellen East Pham 40 $880.00 29 1/9/2011 Sunshine East Lin | 42 $798.00 30 1/9/2011 Bellen South Chin WSD 26 $572.00 31 1/9/2011 Bellen South Sioux QT 15 $330.00 32 ######## Sunset East Gault TRU 27 $567.00 33 ######## Carlota East Pham AA 63 $1,449.00 34 ####### Quad East | Peng DER 171 $459.00 | Step 4 In table "Profit" column "Profit", cal by each sales representatives. Hint similar to the countif formula. (5%) In table "Profit" column "Percentage generated by each Sales Rep overt Step 5 Step 6 In the "Pairs" column in the "Transa transactions between Sales Rep "Si "No" otherwise (5%)