please show work and answer done in excel

fx P21 . X A B C 1 Problem # 7 (15 Pts) D E F G H I NO Use the Data below to create a pivot table and find the following: Parta Part b. Part Part d. The Project manger with the lowest Estimate cost, and how much was it The Project manger with the most Water/Sewer projects, and how many Water projects Value of Susan Woods lowest Transportation project Total income from all projects no nelle Prj. Project Manager Est. Time Act. Time OT OnTime? Est. Cost Act. Cost 1 Wolll, Carolyn 106.3 106,3 0.0 On Time $2,043,000 $2,043,000 1 Turnage, Leslie 100.9 100.9 0.0 On Time S 506,000 $ 506,000 1 Wolff, Carolyn 51. 9 5 1.9 0.0 On Time $ 390,000 $ 390,000 1 Jaffe, Jerry 60.0 0.0 0.0 On Time S 1,917,000 5 1,917,000 1 Boyce, Bruce 83.7 104.1 20.4 Delayed S 1,190,000 5 1,880,200 1 Turnage, Leslie 62.6 62.6 0.0 On Time S2,214,000 S 2,214,000 1 laffe, Jerry 61.3 61.3 0.0 On Time S 00,000 $600,000 1 Weaver, Diane 65.0 73.3 8.3 Delayed $ 658,000 S 658,000 1 Woods, Susan 27.9 27.9 0.0 On Time $352,000 $352,000 1 Marlow, Daniel 91.0 1.3 On Time $ 1,829,000 5 1,829,000 1 Degas, Josh 80.1 80.1 0.0 On Time $ 2,051,000 $2,051,000 1 Steele, Richard 32.3 32.3 0.0 On Time S 871,000 $ 871,000 1 Stone, Jeff 44.9 63.1 18.3 Delayed $ 294,000 $ 294,000 1 Weaver, Diane 28.3 28.3 0.0 On Time $ 847,000 $ 847,000 1 Colton, Gres 74.9 74.9 0.0 On Time $ 1,297,000 $1,582,340 1 Steele, Richard 49.1 0.0 On Time $ 431,000 $ 431.000 overtudy OnBudget? Category 0% As Budgeted Municipal Construction 0 As Budgeted Residential Construction O% As Budgeted Municipal Construction 0% As Budgeted Municipal Construction 58% Over Budget Transportation OX As Budgeted Transportation 0% As Budgeted Residential Construction 0% As Budgeted Water/Sewer 0% As Budgeted Residential Construction 0% As Budgeted Water/Sewer 0% As Budgeted Municipal Construction 0% As Budgeted Water/Sewer 0% As Budgeted Transportation 0% As Budgeted Commercial Construction 22% Over Bludget Residential Construction 0% As Budgeted Waterwer 89.7 49.1