Need help with preparing a budget for assignment 5 based on the information and template attached.

Note, the staff hours listed for the various people must be input into the budget Software and Database Personnel Estimates 9/24/21 Total Hours Activity number & Description Duration Weeks Software Technician or Database Comments: 6 Software Architecture Design 124 Software Staff 18 Monthly Progress Reports Mo additional charge to this line item it's covered in other activities. 4 7 Proprietary Database Design 2 Database Staff 8 Open Database link Design 3 Lead Link and Database Staff 9 Specify Hardware 1 10 hrs Sr. Software, 12 hrs Software and 12 hours Database 10 Purchase Hardware 3 10 hrs Sr. Software, 12 hrs Software and 12 hours Database 11 Business Data Exchange to/from PMIS 4 Database Staff 12 Data Exchange tolfrom Open Database 4 40 124 124 Database Staff 13 Report Format Design 4 40 Software Staff 14 Documentation, Manual, Prepared Training provided 4 40 Software Staff 15 Legacy Data Archived 4 40 Database Staff 16 Project Mgt Activities 23 No charge to this line item it's covered in other activities. 17 Weekly Meetings 23 12 Lead and Senior alternate 20 2 19 Project Closeout Mo additional charge to this line item it's covered in other activities. Note: the above does not include the Administrative technicians, project manager (you) or PMO estimated hours. See course project background and partially completed Budget Estimate for ideas of how many hours to include. Maximum Cost per hour Role Name Availability (3 times hourly (hours/week) pay) Max 22 Weeks Lead Software Architect Dr. Jackson 16 $300 $105,600 Lead Database Architect Nancy Blue 24 $225 $118,800 Lead Link Designer Mike Green 24 $225 $1 18,800 Project Manager Student's Name 24 $210 $110,880 Sr Software Developer Dave White 36 $180 $142,560 Sr Database Developer Emilio Blanco 36 $180 $142,560 Software Technician TBD 36 $150 $118,800 Database Technician TBD 36 $150 $118,800 Administrative Technicians (2) TBD 72 $120 $380,160 PMO Advisor Pam Black 16 $180 $63,360 Outsourced Staff Firm Hourly Flat Rate Training developer Soft Consulting 36 $250 $198,000 Cyber Security Analyst Soft Consulting 36 $300 $237,600 Grand total Lab $1,855,920 Obviously, every one can't work the max available each week, but we have about three times the budget of staff availability.Notes: 1. Activities 1-5 are complete for a cost of $20,000. 21T Director will supervise Consultants out of their overhead account 3. Purchasing will be funded out of their overhead account 4_Initial Budget in Charter did not include the proprietary - open database effort. 5. Change the date and Call your assignment Version 2 6. Type your name in Student's Name cell Date and version of Current Version 27 Sep 21 Version 1 Lead Lead Lead Sr Sr Software Database Link Project Software Database Software Architect Architect Designer Manager Developer Developer Technician Database Administrativ Administrativ PMO Role Technician |e Technician e Technician Advisor Dr. Mike Student's Dave Emilio Name Jackson Nancy Blue Green Name White Blanco TBD TBD TBD TBD Hourly Rate S 300 $ 225 $ 225 $ 210 $ 180 180 150 150 $ 120 $ 180 Activity Start Duration Activity Total 1 Prepare Req. Trace. Matrix 2 Prepare WBS 3 Prepare Activity Logic Diagram & Gantt 2 4 Prepare Budget 3 Complete 5 Prepare Risk Mgt Plan 4 6 Software Architecture Design 5 4 40 124 124 52,920 7 Proprietary Database Design 2 8 Open Database link Design 3 9 Specify Hardware 10 1 12 12 2.880 10 Purchase Hardware (Purchasing hours, no direct cost 11 3 11 Business Data Exchange to/from PMIS 14 12 Data Exchange tolfrom Open Database 18 13 Report Format Design 18 4 40 7,200 14 Documentation, Manual, Prepared Training provided (By Consultant) 22 15 Legacy Data Archived 18 16 Project Mgt Activities 23 63,390 17 Weekly Meetings 10,350 18 Monthly Progress Reports 4,980 19 Project Closeout 8.520 Total Hours per person and Total Labor Cost 40 0 0 230 124 0 124 157 157 63 $ 150.240 Expenses Hardware 50.000 Consultants 60,000 Other Direct Expenses 30.000 Threat Management Cost (From Assignment 4) $ 9,261,000 Total remaining $ 9.551,240 Cost to date 20,000 Contingency & Reserves (10% of Budget rounded to the nearest $1,000) Grand Total $ 9.571,240