A 1 B 2 Note, the staff hours listed for the various people must be input into the budget 3 5 4 Software and Database Personnel Estimates 9/24/21 Total Hours Software e s Technician Activity number & Description Durafion S Weeks Lead | Senior | Database |Comments: & 6 Software Architecture Design 4 40 124 124 Software Staff 7 T Proprietary Database Design 2 32 124 124 Database Staff 2 |8 Open Database link Design 3 40 124 124 Lead Link and Database Staff o 9 Specify Hardware 1 10 24 10 hrs Sr. Software, 12 hrs Software and 12 hours Database 10 10 Purchase Hardware 3 10 24 10 hrs Sr. Software, 12 hrs Software and 12 hours Database 11 11 Business Data Exchange to/from PMIS 4 40 124 124 Database Staff 12 12 Data Exchange to/from Open Database 4 40 124 124 Database Staff 13 13 Report Format Design 4 40 124 124 Software Staff 14 14 Documentation, Manual, Prepared Training provided 4 40 124 124 Software Staff 15 15 Legacy Data Archived 4 40 124 124 Database Staff 16 16 Project Mgt Activities 23 No charge to this line item it's covered in other acfivities. 17|17 Weekly Meetings 1 23 12 11 Lead and Senior alternate 12 18 Monthly Progress Reports 20 No additional charge to this line item it's covered in other aclivities. 19 19 Project Closeout 2 No additional charge to this line item i's covered in other activities 20 The above is the staff-hour estimates for various activities. Assignment 5 Project Budget In Assignment 5, we are preparing the project budget. Use the template provided and follow the mare detailed instructions. Remember to include additional hours for Administrative Technicians on various activities described in the background. One of the cutputs from last week's risk database is the threat management costs are input inte next week's budget. Remember to include the Threat management estimate calculated in Assignment 4. If you don't understand the requirements for Assignment 5, please ask a Maximum Role Name Availability (hours/week) Lead Software Architect Dr. Jackson 16 Lead Database Architect Nancy Blue 24 Lead Link Designer Mike Green 24 Project Manager Student's Name 24 Sr Software Developer Dave White 36 Sr Database Developer Emilio Blanco 36 Software Technician TBD 36 Database Technician TBD 36 Administrative Technicians (2) TBD 72 PMO Advisor Pam Black 16 Outsourced Staff Firm Training developer Soft Consulting 36 Cyber Security Analyst Soft Consulting 36Cost per hour (3 times hourly pay) Max 22 Weeks $300 $105,600 $225 $118,800 $225 $118,800 3210 $110,880 $180 $142,560 $180 $142,560 $150 $118,800 $150 $118,800 $120 $380,160 $180 $63,360 Hourly Flat Rate $250 $198,000 $300 $237,600 Grand total Labc $1,855,920 ive about three times the budget of staff availability. PMIS Project Budget Prepared by, (Student's Name) Approved by (PMO) Date First approved: Date and version of Current version 47 Sep 21 Version Lead Lead Software Database Lead Link |Project S Software S Database Software Architect Architect Designer Manager Developer Developer Technician Database Administrative Administrative PMO Role Technician Technician Technician Advisor Mike Student's Emilio Name Dr. Jackson Nancy Blue Areer Name Dave White Blanco TBO TBC TBD TBD Hourly Rate 300 $ 225 $ 225 210 $ 180 $ 180$ 150$ 150$ 120$ 120 $ 180 Activity Start Duration Pobuty Total 1 Prepare Rag, Trage, Matrix 2 Prepare WBS Prepare Activity Logo Diagram & Gantt 4 Prepare Budget 5 Prepare Risk Mot Plan 3 Software Architecture Design 40 124 124 $ 52,920 Proprietary Database Design 3 Open Database link Design 3 Specify Hardware 10 12 12 2,8:80 10 Purchase Hardware [ Purchasing hours, no frect cost ] 11 Business Data Exchange tofrom PMIS 12 Data Exchange tofrom Open Database 13 Report Format Design 40 $ 7,200 14 Documentation, Manual, Prepared Training provided [ By Consultart] 22 15 Legacy Data Archived 16 Project Mat Activities 23 63,390 17 Weekly Meetings 10 ,350 18 Monthly Progress Reports 26 4.980 19 Project Closeout 8.520 Total Hours per person and Total Labor Cost 40 230 124 124 157 157 63 $ 150,240 Expenses Hardware $50,000 Consultants $40,000 Other Direct Expenses 30,0100 Threat Management Cost ( From Assignment 4) Total remaining $250.240 Cost to date $20,000 Contingency & Reserves (10% of Budget roundedto the nearest $1000) Grand Total $ 310,240 Notes: 1. Activities 1-5 are complete for a cost of $20 DOD. 2. IT 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 b. Type your name in Student's Name cell