I would appreciate help on how to figure out these questions in excel for the Jobs Stat section given the data and what formulas should be used.

B9 B10 B11 In C13, use the values in the Completed Jobs sheet to calculate the number of jobs managed by Amir that made a loss (negative margin). Copy the formula down for Toni and Martin. In D13, use the values in the Completed Jobs sheet to calculate the average revenue of jobs managed by Amir. Copy the formula down for Toni and Martin. In E13, use the values in the Completed Jobs sheet to calculate the total $ profit for jobs managed by Amir. Copy the formula down for Toni and Martin. In the Stats sheet, create a 2-D Pie Chart showing the % revenue for each manager. Ensure there is only one chart and that it has the title Revenue by Manager. Show data labels as percentages on the pie segments and show the legend at the bottom of the chart. (Please follow instructions exactly.) B9 Job Stats for 2019 2 5 3 Total Days Work Total Revenue Average Material Cost 6 Highest Labour Cost 7 Lowest Labour Cost 8 Number of Completed Jobs 9 Highest Revenue Job No. 231 $7,252.22 37,451.8 $21,120.00 $1,640.00 21 JOB_4968 10 Number of Jobs Jobs with a loss Average Revenue Total $ Profit 11 12 Manager 13 Amir 14 Toni 15 Martin 16 A E Days Tak 13 44 Man Ho - 135 704 23 49 Completed Job Summary for 2019 2 3 Job No. -Manager - Date Star - Date Complel - 4 JOB_4950 Amir 2/1/19 15/1/19 5 JOB_4951 Martin 25/1/19 10/3/19 6 JOB_4952 Toni 26/1/19 25/2/19 7 JOB_4953 Amir 26/1/19 25/2/19 8 JOB_4954 Martin 11/2/19 6/3/19 9 JOB_4955 Martin 16/2/19 6/4/19 10 JOB_4956 Toni 20/2/19 26/2/19 11 JOB_4957 Amir 22/2/19 9/4/19 12 JOB_4958 Amir 6/3/19 23/3/19 13 JOB_4959 Amir 19/3/19 5/4/19 14 JOB_4960 Martin 2/4/19 13/5/19 15 JOB_4961 Toni 15/4/19 28/4/19 16 JOB_4962 Martin 17/4/19 9/5/19 17 JOB_4963 Martin 27/4/19 13/5/19 18 JOB_4964 Toni 12/5/19 2/6/19 19 JOB_4965 Amir 5/6/19 21/6/19 20 JOB_4966 Amir 7/6/19 14/7/19 21 JOB_4967 Amir 13/6/19 27/6/19 22 JOB_4968 Toni 26/7/19 13/9/19 23 JOB_4969 Amir 1/8/19 15/8/19 24 JOB_4970 Amir 3/8/19 21/8/19 17 17 Material C- $24,856.00 $74,448.00 $54,330.00 $54,210.00 $28,888.00 $44,737.00 $5,946.00 $68,632.00 $20,434.00 $17,153.00 $77,613.00 $13,923.00 $20,526.00 $27,920.00 $37,779.00 $24,288.00 $53,687.00 $18,578.00 $76,538.00 $24,416.00 $17,586.00 Labour - $3,375.00 $21,120.00 $11,040.00 $ 12,000.00 $5,160.00 $14,120.00 $1,640.00 $9,724.00 $4,071.00 $5,712.00 $17,700.00 $2,736.00 $5,808.00 $7,801.00 $7,801.00 $3,486.00 $7,824.00 $6,110.00 $13,986.00 $7,482.00 $6,670.00 480 480 258 706 82 442 177 272 590 114 264 269 269 166 326 235 666 258 230 Overhe $1,216.78 $6,345.26 $4,326.32 $4,326.32 $2,325.39 $6,363.29 $739.08 $3,983.82 $1,595.33 $2,451.58 $5,317.76 $1,027.50 $2,379.47 $2,424.54 $2,424.54 $1,496.18 $2,938.29 $2,118.09 $6,002.76 $2,325.39 $2,073.03 Total C - $29,447.78 $101,913.26 $69,696.32 $70,536.32 $36,373.39 $65,220.29 $8,325.08 $82,339.82 $26,100.33 $25,316.58 $100,630.76 $17,686.50 $28,713.47 $38,145.54 $48,004.54 $29,270.18 $64,449.29 $26,806.09 $96,526.76 $34,223.39 $26,329.03 Invoice Amor || $36,700.00 $ 101,300.00 $64,060.00 $77,470.00 $41,200.00 $69,450.00 $8,720.00 $83,060.00 $28,430.00 $22,180.00 $98,170.00 $21,820.00 $28,440.00 $42,510.00 $53,780.00 $34,720.00 $63,970.00 $29,870.00 $105,910.00 $33,490.00 $28,380.00 $ Mar - $7,252.22 -$613.26 -$5,636.32 $6,933.68 $4,826.61 $4,229.71 $394.92 $720.18 $2,329.67 -$3,136.58 -$2,460.76 $4,133.50 -$273.47 $4,364.46 $5,775.46 $5,449.82 -$479.29 $3,063.91 $9,383.24 - $733.39 $2,050.97 GP Pero 19.76% -0.61% -8.80% 8.95% 11.72% 6.09% 4.53% 0.87% 8.19% - 14.14% -2.51% 18.94% -0.96% 10.27% 10.74% 15.70% -0.75% 10.26% 8.86% -2.19% 7.23% 41 13 22 16 21 14 49 14 18 25 26 B9 B10 B11 In C13, use the values in the Completed Jobs sheet to calculate the number of jobs managed by Amir that made a loss (negative margin). Copy the formula down for Toni and Martin. In D13, use the values in the Completed Jobs sheet to calculate the average revenue of jobs managed by Amir. Copy the formula down for Toni and Martin. In E13, use the values in the Completed Jobs sheet to calculate the total $ profit for jobs managed by Amir. Copy the formula down for Toni and Martin. In the Stats sheet, create a 2-D Pie Chart showing the % revenue for each manager. Ensure there is only one chart and that it has the title Revenue by Manager. Show data labels as percentages on the pie segments and show the legend at the bottom of the chart. (Please follow instructions exactly.) B9 Job Stats for 2019 2 5 3 Total Days Work Total Revenue Average Material Cost 6 Highest Labour Cost 7 Lowest Labour Cost 8 Number of Completed Jobs 9 Highest Revenue Job No. 231 $7,252.22 37,451.8 $21,120.00 $1,640.00 21 JOB_4968 10 Number of Jobs Jobs with a loss Average Revenue Total $ Profit 11 12 Manager 13 Amir 14 Toni 15 Martin 16 A E Days Tak 13 44 Man Ho - 135 704 23 49 Completed Job Summary for 2019 2 3 Job No. -Manager - Date Star - Date Complel - 4 JOB_4950 Amir 2/1/19 15/1/19 5 JOB_4951 Martin 25/1/19 10/3/19 6 JOB_4952 Toni 26/1/19 25/2/19 7 JOB_4953 Amir 26/1/19 25/2/19 8 JOB_4954 Martin 11/2/19 6/3/19 9 JOB_4955 Martin 16/2/19 6/4/19 10 JOB_4956 Toni 20/2/19 26/2/19 11 JOB_4957 Amir 22/2/19 9/4/19 12 JOB_4958 Amir 6/3/19 23/3/19 13 JOB_4959 Amir 19/3/19 5/4/19 14 JOB_4960 Martin 2/4/19 13/5/19 15 JOB_4961 Toni 15/4/19 28/4/19 16 JOB_4962 Martin 17/4/19 9/5/19 17 JOB_4963 Martin 27/4/19 13/5/19 18 JOB_4964 Toni 12/5/19 2/6/19 19 JOB_4965 Amir 5/6/19 21/6/19 20 JOB_4966 Amir 7/6/19 14/7/19 21 JOB_4967 Amir 13/6/19 27/6/19 22 JOB_4968 Toni 26/7/19 13/9/19 23 JOB_4969 Amir 1/8/19 15/8/19 24 JOB_4970 Amir 3/8/19 21/8/19 17 17 Material C- $24,856.00 $74,448.00 $54,330.00 $54,210.00 $28,888.00 $44,737.00 $5,946.00 $68,632.00 $20,434.00 $17,153.00 $77,613.00 $13,923.00 $20,526.00 $27,920.00 $37,779.00 $24,288.00 $53,687.00 $18,578.00 $76,538.00 $24,416.00 $17,586.00 Labour - $3,375.00 $21,120.00 $11,040.00 $ 12,000.00 $5,160.00 $14,120.00 $1,640.00 $9,724.00 $4,071.00 $5,712.00 $17,700.00 $2,736.00 $5,808.00 $7,801.00 $7,801.00 $3,486.00 $7,824.00 $6,110.00 $13,986.00 $7,482.00 $6,670.00 480 480 258 706 82 442 177 272 590 114 264 269 269 166 326 235 666 258 230 Overhe $1,216.78 $6,345.26 $4,326.32 $4,326.32 $2,325.39 $6,363.29 $739.08 $3,983.82 $1,595.33 $2,451.58 $5,317.76 $1,027.50 $2,379.47 $2,424.54 $2,424.54 $1,496.18 $2,938.29 $2,118.09 $6,002.76 $2,325.39 $2,073.03 Total C - $29,447.78 $101,913.26 $69,696.32 $70,536.32 $36,373.39 $65,220.29 $8,325.08 $82,339.82 $26,100.33 $25,316.58 $100,630.76 $17,686.50 $28,713.47 $38,145.54 $48,004.54 $29,270.18 $64,449.29 $26,806.09 $96,526.76 $34,223.39 $26,329.03 Invoice Amor || $36,700.00 $ 101,300.00 $64,060.00 $77,470.00 $41,200.00 $69,450.00 $8,720.00 $83,060.00 $28,430.00 $22,180.00 $98,170.00 $21,820.00 $28,440.00 $42,510.00 $53,780.00 $34,720.00 $63,970.00 $29,870.00 $105,910.00 $33,490.00 $28,380.00 $ Mar - $7,252.22 -$613.26 -$5,636.32 $6,933.68 $4,826.61 $4,229.71 $394.92 $720.18 $2,329.67 -$3,136.58 -$2,460.76 $4,133.50 -$273.47 $4,364.46 $5,775.46 $5,449.82 -$479.29 $3,063.91 $9,383.24 - $733.39 $2,050.97 GP Pero 19.76% -0.61% -8.80% 8.95% 11.72% 6.09% 4.53% 0.87% 8.19% - 14.14% -2.51% 18.94% -0.96% 10.27% 10.74% 15.70% -0.75% 10.26% 8.86% -2.19% 7.23% 41 13 22 16 21 14 49 14 18 25 26