| WBS | Marley Dental Clinic IT System Project | Labor | Hours | Rate | % Work | Labor Total | Supplies | Qty | Units | Price | Supplies Total | Total | Notes |
| | Develop Budget |
| | Determine Support Cost | Purchase Controller | 16 | $22.00 | 100% | $352.00 | | | | | $0.00 | $352.00 |
| | Determine Software Cost | Purchase Controller | 16 | $22.00 | 100% | $352.00 | | | | | $0.00 | $352.00 |
| | Determine Hardware Cost | Purchase Controller | 16 | $22.00 | 100% | $352.00 | | | | | $0.00 | $352.00 |
| | Determine Labor and Human Resources Costs | Purchase Controller | 16 | $22.00 | 100% | $352.00 | | | | | $0.00 | $352.00 |
| | Create Annual Budget Recommendation | Purchase Controller | 16 | $22.00 | 100% | $352.00 | | | | | $0.00 | $352.00 |
| | Retrieve Budget Acceptance Document | Project Manager | 4 | $35.00 | 100% | $140.00 | | | | | $0.00 | $140.00 |
| | | Purchase Controller | 4 | $22.00 | 100% | $88.00 | | | | | $0.00 | $88.00 |
| | Design of the IT system |
| | Design data access | Cybersecurity Analyst | 16 | $40.00 | 100% | $640.00 | | | | | $0.00 | $640.00 |
| | Establish who can access data | Network Consultant | 8 | $30.00 | 100% | $240.00 | | | | | $0.00 | $240.00 |
| | Develop secure systems for data storage | Cybersecurity Analyst | 48 | $40.00 | 100% | $1,920.00 | | | | | $0.00 | $1,920.00 |
| | Develop data back-up system | Cybersecurity Analyst | 32 | $40.00 | 100% | $1,280.00 | | | | | $0.00 | $1,280.00 |
| | Develop how to provide electronic version of patient data to patients | Cybersecurity Analyst | 16 | $40.00 | 100% | $640.00 | | | | | $0.00 | $640.00 |
| | Develop separate ID for data attained via telemedicine | Cybersecurity Analyst | 8 | $40.00 | 100% | $320.00 | | | | | $0.00 | $320.00 |
| | Determine Security and Commercial Software | Cybersecurity Analyst | 16 | $40.00 | 100% | $640.00 | | | | | $0.00 | $640.00 |
| | Create Security Policies | Cybersecurity Analyst | 8 | $40.00 | 100% | $320.00 | | | | | $0.00 | $320.00 |
| | Determine Firewall Configuration | Network Consultant | 8 | $30.00 | 100% | $240.00 | | | | | $0.00 | $240.00 |
| | Order software |
| | Write up purchase orders and purchase software | Business Administrator | 8 | $23.00 | 100% | $184.00 | Intuit QuickBooks | 1 | EA | $1,600.00 | $1,600.00 | $1,784.00 | http://accessories.dell.com |
| | | | | | | | Symantec Antivirus | 14 | EA | $36.32 | $508.48 | $508.48 | http://accessories.dell.com |
| | | | | | | | Claims Software | 14 | EA | $42.63 | $596.82 | $596.82 | http://accessories.dell.com |
| | | | | | | | Google Apps | 14 | EA | $10.00 | $140.00 | $140.00 |
| | | | | | | | Oracle Database Software | 1 | EA | $3,850.00 | $3,850.00 | $3,850.00 | http://oracle.com |
| | Order hardware, networking, and peripherals |
| | Compare and write up purchase orders | Business Administrator | 8 | $23.00 | 100% | $184.00 | | | | | $0.00 | $184.00 |
| | Purchase laptops | Purchase Controller | 8 | $22.00 | 100% | $176.00 | Laptop | 14 | EA | $899.00 | $12,599.86 | $12,775.86 |
| | Purchase printers | Purchase Controller | 8 | $22.00 | 100% | $176.00 | Printer | 1 | EA | $432.55 | $432.55 | $608.55 |
| | Purchase Rack Router | Purchase Controller | 8 | $22.00 | 100% | $176.00 | Router | 1 | EA | $119.99 | $119.99 | $295.99 |
| | Purchase Server Room Switch | Purchase Controller | 8 | $22.00 | 100% | $176.00 | Switch | 1 | 14 | $127.99 | $127.99 | $303.99 |
| | Purchase WiFi Router | Purchase Controller | 8 | $22.00 | 100% | $176.00 | WiFi Router | 1 | EA | $51.99 | $51.99 | $227.99 |
| | Purchase WiFi Range Extender | Purchase Controller | 8 | $22.00 | 100% | $176.00 | WiFi Range Extender | 1 | EA | $148.12 | $148.12 | $324.12 |
| | Purchase Firewall | Purchase Controller | 8 | $22.00 | 100% | $176.00 | Firewall | 1 | EA | $184.99 | $184.99 | $360.99 | www.newegg.com |
| | | | | | | | Junction Box | 2 | EA | $151.60 | $303.20 | $303.20 | www.newegg.com |
| | | | | | | | RJ-45 Outlet | 14 | EA | $4.62 | $64.68 | $64.68 | www.newegg.com |
| | | | | | | | RJ-45 Connector Tips | 2 | 100 Pack | $9.49 | $18.98 | $18.98 | www.newegg.com |
| | | | | | | | Cat 6e Cable | 1 | 1000' Spool | $169.99 | $169.99 | $169.99 | www.newegg.com |
| | | | | | | | Docking Station | 14 | EA | $219.99 | $3,079.86 | $3,079.86 |
| | | | | | | | Keyboard/Mouse | 14 | EA | $79.99 | $1,119.86 | $1,119.86 |
| | | | | | | | Monitor | 14 | EA | $99.99 | $1,399.86 | $1,399.86 |
| | | | | | | | Broadband Service | 1 | EA | $450.00 | $450.00 | $450.00 |
| | | | | | | | Surge Protector | 14 | EA | $20.99 | $293.86 | $293.86 | http://www.dell.com |
| | Install hardware |
| | Determine needs for each office | Project Manager | 24 | $35.00 | 100% | $840.00 | | | | | $0.00 | $840.00 |
| | Determine room readiness | Infrastructure Engineer | 8 | $35.00 | 100% | $280.00 | | | | | $0.00 | $280.00 |
| | Determine room layouts and specifications | Infrastructure Engineer | 16 | $35.00 | 100% | $560.00 | | | | | $0.00 | $560.00 |
| | Configure hardware | Infrastructure Engineer | 24 | $35.00 | 100% | $840.00 | | | | | $0.00 | $840.00 |
| | Determine technical defects | Infrastructure Engineer | 32 | $35.00 | 100% | $1,120.00 | | | | | $0.00 | $1,120.00 |
| | Determine defects and make fixes | Infrastructure Engineer | 24 | $35.00 | 100% | $840.00 | | | | | $0.00 | $840.00 |
| | Remedy technical defects | Infrastructure Engineer | 24 | $35.00 | 100% | $840.00 | | | | | $0.00 | $840.00 |
| | Verify defect fixes | Infrastructure Engineer | 8 | $35.00 | 100% | $280.00 | | | | | $0.00 | $280.00 |
| | Install Software |
| | Install patient registration component | Infrastructure Engineer | 40 | $35.00 | 100% | $1,400.00 | | | | | $0.00 | $1,400.00 |
| | Check on Cisco Vital Software Interface requirements | Network Consultant | 8 | $30.00 | 100% | $240.00 | | | | | $0.00 | $240.00 |
| | Verify that Cisco Vital Software and Third Party medical devices meet HIPAA requirements | Project Manager | 24 | $35.00 | 100% | $840.00 | HIPAA Audit | 1 | EA | $20,000.00 | $20,000.00 | $20,840.00 |
| | Produce mockups with hyperlinks to requirements | Network Consultant | 24 | $30.00 | 100% | $720.00 | | | | | $0.00 | $720.00 |
| | System testing | Network Consultant | 40 | $30.00 | 100% | $1,200.00 | | | | | $0.00 | $1,200.00 |
| | Develop user interface | Infrastructure Engineer | 32 | $35.00 | 100% | $1,120.00 | | | | | $0.00 | $1,120.00 |
| | Configure the software | Infrastructure Engineer | 32 | $35.00 | 100% | $1,120.00 | | | | | $0.00 | $1,120.00 |
| | Perform integration testing | Infrastructure Engineer | 40 | $35.00 | 100% | $1,400.00 | | | | | $0.00 | $1,400.00 |
| | Install networking |
| | Determine network needs | Infrastructure Engineer | 8 | $35.00 | 100% | $280.00 | | | | | $0.00 | $280.00 |
| | Determine networking infrastructure needs | Infrastructure Engineer | 8 | $35.00 | 100% | $280.00 | | | | | $0.00 | $280.00 |
| | Configure Financial Management Software | Software Development Manager | 24 | $28.00 | 100% | $672.00 | | | | | $0.00 | $672.00 |
| | Configure Insurance Management Software | Software Development Manager | 24 | $28.00 | 100% | $672.00 | | | | | $0.00 | $672.00 |
| | Configure X-ray Management Software | Software Development Manager | 24 | $28.00 | 100% | $672.00 | | | | | $0.00 | $672.00 |
| | Test all software | QA Engineer 2 | 40 | $25.00 | 100% | $1,000.00 | | | | | $0.00 | $1,000.00 |
| | Create management protocol |
| | Create maintenance plan | Cybersecurity Analyst | 8 | $40.00 | 100% | $320.00 | | | | | $0.00 | $320.00 |
| | Create maintenance notification messaging | Cybersecurity Analyst | 8 | $40.00 | 100% | $320.00 | | | | | $0.00 | $320.00 |
| | Manage the project and team |
| | Review of the work plan |
| | Identify completed activities | Project Manager | 24 | $35.00 | 100% | $840.00 | | | | | | $840.00 |
| | Check for variances in the schedule | Associate Project Manager | 24 | $28.00 | 100% | $672.00 | | | | | $0.00 | $672.00 |
| | Review the team morale | Associate Project Manager | 24 | $28.00 | 100% | $672.00 | | | | | $0.00 | $672.00 |
| | Control of the Project |
| | Guard against scope creep | Project Manager | 24 | $35.00 | 100% | $840.00 | | | | | | $840.00 |
| | Check for the need for scope changes | Project Manager | 24 | $35.00 | 100% | $840.00 | | | | | | $840.00 |
| | Monitor the Project |
| | Evaluate project deliverables | Project Manager | 24 | $35.00 | 100% | $840.00 | | | | | | $840.00 |
| | Check on the budget | Finance Manager | 24 | $40.00 | 100% | $960.00 | | | | | | $960.00 |
| | Project Meetings and Training |
| | Define users | Network Consultant | 8 | $30.00 | 100% | $240.00 | | | | | $0.00 | $240.00 |
| | Explain in basic terms how systems hardware and software works | Software Manager | 8 | $28.00 | 100% | $224.00 | | | | | | $224.00 |
| | Explain how to interpret data | Database Manager | 8 | $32.00 | 100% | $256.00 | | | | | | $256.00 |
| | Explain how to store data properly | Database Manager | 8 | $32.00 | 100% | $256.00 | | | | | | $256.00 |
| | Receptionist Training | Trainer | 8 | $15.00 | 100% | $120.00 | | | | | $0.00 | $120.00 |
| | Dental Staff Training | Trainer | 32 | $15.00 | 100% | $480.00 | | | | | $0.00 | $480.00 |
| | Accounting and Administrative Training | Trainer | 32 | $15.00 | 100% | $480.00 | | | | | $0.00 | $480.00 |
| | Quiz session | Business Administrator | 8 | $23.00 | 100% | $184.00 | | | | | | $184.00 |
| | List responsibilities of IT liaison | Project Manager | 8 | $35.00 | 100% | $280.00 | | | | | $0.00 | $280.00 |
| | Project Close-Out |
| | Establish Feedback System | Project Manager | 8 | $35.00 | 100% | $280.00 | | | | | | $280.00 |
| | Outline lessons learned | Project Manager | 8 | $35.00 | 100% | $280.00 | | | | | | $280.00 |
| | Close out documentation with signatures | Associate Project Manager [50%] | 4 | $28.00 | 100% | $112.00 | | | | | $0.00 | $112.00 |
| | | Project Manager [50%] | 4 | $35.00 | 100% | $140.00 | | | | | $0.00 | $140.00 |
| | | | | | | | | | | | | Grand Total |
| | | | | | | | | | | | | $83,941.08 |
John_matt
project_resources__costs2.xlsx
