Use the WBS from the table below , and use it to replace what is currently in the cost estimation template in the left-most column. DO NOT USE THE COLUMNS ALREADY THERE. Adjust the formulas accordingly to calculate the subtotals, etc.

Assume that Tony Prince, the project manager, will work on the project on a recurring basis for 2 days (0.4 weeks) each week, on task A-1.0 Project management, and that he will commit a total of 15 hours of work over those two days each week. Tonys pay rate is $90/hr. He will work for as many weeks as the project will last.

For all other tasks, assume that there are project team members available and that their pay rate is $60/hr.

Assume that for each full-time week of duration, the labor time is estimated to be 30 hours per week.

Assume that the only cost is labor, and therefore, do not estimate any other costs.

Answer the following questions:

What is the total estimate cost of the Recreation and Wellness project?

What percentage of the total project costs is being spent on a combination of Requirements definition and testing?

What is the cost of project management?

Task Id	Task Name	Duration
A	1.0 Project management	none
B	2.0 Requirements definition	3 weeks
C	3.0 Web site design
D	3.1 Registration for rec. programs	3w
E	3.2 Registration for classes & progs	5w
F	3.3 Tracking system	2w
G	3.4 Incentive system	3w
H	4.0 Web site development
I	4.1 Registration for rec. programs	6w
J	4.2 Registration for classes & progs	8w
K	4.3 Tracking system	5w
L	4.4 Incentive system	3w
M	5.0 Testing
N	5.1 Test registration systems	4w
O	5.2 Test tracking system	2w
P	5.3 Test incentive system	2w
Q	6.0 Training, rollout, & support	3w

File Home Insert Draw Page Layout Formulas Data Review View Help Team Tell me what you want to do | Times New Roma-12 A^ A- General Conditional Format as Cell FormattingTableStyles Paste Insert Delete B 1 u . H., . A $ . %, 8640 Mel e & Center . Clipboard Font Alignment Number Cells A16 3.2 Software development* 3 Note: Change the WBS items and other entries to meet your project needs. This data is from Figure 7-1 of Schwalbe's text 4 Information Technolo Fourth Edition. Also make sure the formulas work based on the data you enter # Units/Hrs. | Cost/Unit/Hr. Subtotals | WBS Level 1 Totals 1% of Total 6 WBS Items 7 1. Project Management 81.l Project imanager S306,300 20% 960 $100 S96.000 $75 $144.000 S66,300 9 1.2 Projec t team members 1920 10 Contractors (10% of software 11 2. Hardware 12 2.1Handheld devices 13 2.2 Servers 14 3. Software 15 3.1Licensed software 16 3.2 Software d 17 4. Testing (10% of total hardware and software costs) 18 5. Training and Support 19 5.1 Trainee cost 20 5.2 Travel cost 21 5.3 22 6. Reserves (20% of total estimate) 23 24* See software development estimate t and testing) S76,000 5% 100 $600 $60.000 $4.000$16.000 S614,000 100 $200 $20.000 $594.000 $69,000 $69,000 S202.400 5% 13% 100 12 1920 $500 $50.000 $700 S8.400 $75$144.000 $253,540 t team members $253,540 S1,521,240 17% Total project cost estimate