Question

1 Approved Answer

Posted on Jul 13, 2024

please provide formulas how to solve this problem! File Home Insert Draw Page Layout Formulas Data Review View Help Power Pivot Share Comments P12 -

please provide formulas how to solve this problem! image text in transcribed

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%)