PLEASE PLEASE HELP ASAP

CTS 2142-Lab 2 Total Points Available -50 Scenario 1:015 points You are the project manager for McDowell's The project you to new network cable betwork and serve and workstations throughout the chest part of the badget planning exercises you need to calculate the hourly rate wher Follow these steps to complete Scenario 1. On this Assignment page you will find a Microsoft Excel file named Estimating Watches 2 The Excel document has several pradsheets. The first worksheet is titled Time costite to this worksheet if you're not there already 1. Hover your mouse over the comment markerince A and read the comments. Click este S. Rick Gordon's hourly rate is calculated for you based on a salary.divided by week and then divided again by 40 hour. Press tal pai tee to call For the first tank,ester 15 for the optimidiam. Press the more Enter 24 for the likely value and press tab to me to call 3 For the worst tinte, enter 37 and press tal The time and cost for any scale. Presto have to cell 9. Notice that cell Ga has already calculated the time for Gender and the confort WA Ridea. 3500 to complete the signed to displayed Units 10 Complete the remainder of the space with the following information Team Member Yearly Salary Optimiste Multi Pem Samantha Murray firadey Kiser 42200 25 Harriet Sutherland 39600 17 16 Fred Stephens 57000 Ruth Care 67500 11. Based on your tries, answer the following question 4. What is the three-point estimate cost of Samantha May's time the What is the cost of Bradley Ker's time heals the pressimisticamente What is the cost of Harriet Sutherlands time she beats the best times by w What is the average cost of Fred Stephens' time? Scenario 2: (15 points In the Estimating Worksheet that you completed in Sea, wiate to the west called Estimate This worksheets based on the intes you made in Soesano 1. You will this file called "PEKT and TEXT 3P 1 What is the three point estimate result for Ruth Game on the entry! 1ERT This is based on the west * What is the PERTfouth Care Return to the Time cost analysed change their haben S. Compare the three point result and the PET result forth Caree with disewa & Navigate to the worksheed PET versus Post 7. On this worksheet there are two charts that will compare the the three pointed PERT. Have your ever the first har hatt Paul Smither chart What is the value that's played Now have your mouse over the first for that Pad Samms in the PERTE art. What is the walue that's displayed? Why there a difference between the PET and the three plate Scenario 11/20 points You are the project manager for Donaldson investment and Holdings. The project is totam mail server and the mail clients on all the workstations. Here is the projects will be the software package. Project Lire to organize the tasks and create the projecte per conditie 11. Based on your entries the following questi a What is the three point estimate cost of Samantha May's time the med What is the cost of Bradley Ker's time it hetkes the pressimix amous licensime What is the cast of Harriet Sutherlands time if she beat the best time estimate the d. What is the average cost of Fred Spentie! Scenario 2.015 pointal In the Estimate Worksheet that you completed in scena 1, navigate to the worksheet called Estimate. This worksheet is based on the entries you made in Sorsario 1. You will the sheets this file called "PERT and "PERT versus 3 Point What is the three pointestinate result for Ruth Carey WW 1 Return to the Time consis' worksheet and change the primitives for at Compare the three-porld the PEXTrendforuth Care with the 6 Navigate to the worksheet titled "PERT Versi 7. On the worldhet there are two charts that will compare them of the thread PERT. Hover your meer the first har that represents Paul Smith Petter * Never your meneer the first har that represen. Same the PERThanes What is the value that's displayed the value that's displayed Way is the dirence between the PET value and the sheepvalus Scenario 1:120 points hare the project manager for Donaldsonment and Holding the procent mail server and the maildes on all the workstation here's the Software package. Promet Libreto organize the tasks and create the role wong An Network Diagram induded on the powed on your mon powderwood different and that is ok. Task Name Install Windows Server Install Exchange Server Configure Exchange Server Link to other servers Create test user accounts Set maibox rules Create client installation packages Create system computer policies Test policies Develop installation procedures Test installation procedures Create CD image for remote accesses Test CD image Hostpilot users class Create class workbook for training Hostpilot users training class (groups of ten Send image to pilot users Hold plot users forum to discuss usage Analyze pilot user feedback Finalice and test install image Hold use training classes Roll out based on attendance Time cost analysis 3 Point Estimate PERT Team Member Paul Samas Yearly Salary Hourly Rate $56.700 Optimiste Most Likely 24 $27.26 $0.00 50.00 $0.00 $0.00 $0.00 $0.00 PERT versus 3 Point Pessimistic Three-Point Time Estimate Three-Point Cost Estimate 30 35 29.67 5809 0.00 000 0.00 0.00 0.00 000 50 888888 Time cost analysis 3 Point Estimate PERT PERT versus 3 Point Team member Paul Samms Optimistic 24 30 Most Likely Pessimistic Three-point estimate results 30 35 0 0 0 OOOOOO OOOOOO OOOOOO8 OOO Optimistic Team member Paul Samms PERT result 35 0 0 0 0 0 0 0 0 Most Likely Pessimistic 24 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29.83 0.00 0.00 0.00 0.00 0.00 0.00 Time cost analysis 3 Point Estimate PERT PERT versus 3 Point 3 Point Estimate 40 30 20 10 o Paul Sanne PERT Estimate 10 Palun 0 CTS 2142-Lab 2 Total Points Available -50 Scenario 1:015 points You are the project manager for McDowell's The project you to new network cable betwork and serve and workstations throughout the chest part of the badget planning exercises you need to calculate the hourly rate wher Follow these steps to complete Scenario 1. On this Assignment page you will find a Microsoft Excel file named Estimating Watches 2 The Excel document has several pradsheets. The first worksheet is titled Time costite to this worksheet if you're not there already 1. Hover your mouse over the comment markerince A and read the comments. Click este S. Rick Gordon's hourly rate is calculated for you based on a salary.divided by week and then divided again by 40 hour. Press tal pai tee to call For the first tank,ester 15 for the optimidiam. Press the more Enter 24 for the likely value and press tab to me to call 3 For the worst tinte, enter 37 and press tal The time and cost for any scale. Presto have to cell 9. Notice that cell Ga has already calculated the time for Gender and the confort WA Ridea. 3500 to complete the signed to displayed Units 10 Complete the remainder of the space with the following information Team Member Yearly Salary Optimiste Multi Pem Samantha Murray firadey Kiser 42200 25 Harriet Sutherland 39600 17 16 Fred Stephens 57000 Ruth Care 67500 11. Based on your tries, answer the following question 4. What is the three-point estimate cost of Samantha May's time the What is the cost of Bradley Ker's time heals the pressimisticamente What is the cost of Harriet Sutherlands time she beats the best times by w What is the average cost of Fred Stephens' time? Scenario 2: (15 points In the Estimating Worksheet that you completed in Sea, wiate to the west called Estimate This worksheets based on the intes you made in Soesano 1. You will this file called "PEKT and TEXT 3P 1 What is the three point estimate result for Ruth Game on the entry! 1ERT This is based on the west * What is the PERTfouth Care Return to the Time cost analysed change their haben S. Compare the three point result and the PET result forth Caree with disewa & Navigate to the worksheed PET versus Post 7. On this worksheet there are two charts that will compare the the three pointed PERT. Have your ever the first har hatt Paul Smither chart What is the value that's played Now have your mouse over the first for that Pad Samms in the PERTE art. What is the walue that's displayed? Why there a difference between the PET and the three plate Scenario 11/20 points You are the project manager for Donaldson investment and Holdings. The project is totam mail server and the mail clients on all the workstations. Here is the projects will be the software package. Project Lire to organize the tasks and create the projecte per conditie 11. Based on your entries the following questi a What is the three point estimate cost of Samantha May's time the med What is the cost of Bradley Ker's time it hetkes the pressimix amous licensime What is the cast of Harriet Sutherlands time if she beat the best time estimate the d. What is the average cost of Fred Spentie! Scenario 2.015 pointal In the Estimate Worksheet that you completed in scena 1, navigate to the worksheet called Estimate. This worksheet is based on the entries you made in Sorsario 1. You will the sheets this file called "PERT and "PERT versus 3 Point What is the three pointestinate result for Ruth Carey WW 1 Return to the Time consis' worksheet and change the primitives for at Compare the three-porld the PEXTrendforuth Care with the 6 Navigate to the worksheet titled "PERT Versi 7. On the worldhet there are two charts that will compare them of the thread PERT. Hover your meer the first har that represents Paul Smith Petter * Never your meneer the first har that represen. Same the PERThanes What is the value that's displayed the value that's displayed Way is the dirence between the PET value and the sheepvalus Scenario 1:120 points hare the project manager for Donaldsonment and Holding the procent mail server and the maildes on all the workstation here's the Software package. Promet Libreto organize the tasks and create the role wong An Network Diagram induded on the powed on your mon powderwood different and that is ok. Task Name Install Windows Server Install Exchange Server Configure Exchange Server Link to other servers Create test user accounts Set maibox rules Create client installation packages Create system computer policies Test policies Develop installation procedures Test installation procedures Create CD image for remote accesses Test CD image Hostpilot users class Create class workbook for training Hostpilot users training class (groups of ten Send image to pilot users Hold plot users forum to discuss usage Analyze pilot user feedback Finalice and test install image Hold use training classes Roll out based on attendance Time cost analysis 3 Point Estimate PERT Team Member Paul Samas Yearly Salary Hourly Rate $56.700 Optimiste Most Likely 24 $27.26 $0.00 50.00 $0.00 $0.00 $0.00 $0.00 PERT versus 3 Point Pessimistic Three-Point Time Estimate Three-Point Cost Estimate 30 35 29.67 5809 0.00 000 0.00 0.00 0.00 000 50 888888 Time cost analysis 3 Point Estimate PERT PERT versus 3 Point Team member Paul Samms Optimistic 24 30 Most Likely Pessimistic Three-point estimate results 30 35 0 0 0 OOOOOO OOOOOO OOOOOO8 OOO Optimistic Team member Paul Samms PERT result 35 0 0 0 0 0 0 0 0 Most Likely Pessimistic 24 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 29.83 0.00 0.00 0.00 0.00 0.00 0.00 Time cost analysis 3 Point Estimate PERT PERT versus 3 Point 3 Point Estimate 40 30 20 10 o Paul Sanne PERT Estimate 10 Palun 0