Robert Ariel Pedro Peralta | Freelancer Flying Drone Delivery Project: Cost Baseline.

Flying Drone Delivery Project: Cost Baseline.

DRONETECH ENGINEERING COST BASELINE FLYING DRONE DELIVERY PROJECT MARCH 20TH, 2021. DONE BY ROBERT PEDRO REVISION NO. 0 1 Cost Estimate Duration (in weeks) Total Costs 1. Build a pilot delivery system based on drones that will serve as both a breaking/innovative point and new way to continue with Wilmont’s vast catalogue of effective practices and businesses 1 to 4 $ 383,772.00 6 42 1 $ $ $ 13,200.00 2,600.00 3 2 2 1 1 3 $ $ $ $ $ $ 6,600.00 $ 4,400.00 $ 4,400.00 $ 2,200.00 8,-,000.00 0 - $ $ $ $ $ $ $ 3 3 3 2 5 to 8 3 9 to 12 4 13 to 16 17 to 20 Periods (4-week increment) 5 6 21 to 24 25 to 28 7 8 29 to 32 9 33 to 36 10 37 to 40 11 41 and 42 Totals 1.1 Initiating 1.1.1 Development of Scope and Plan 1.1.2 Engagement of stakeholders 1.1.3 Signatures on Required Contracts $ 8,800.00 $ 4,400.00 $ 2,600.00 $ $ $ 2,200.00 2,200.00 8,000.00 $ $ $ 13,200.00 2,600.00 $ $ $ $ $ $ 6,600.00 4,400.00 4,400.00 2,200.00 8,-,000.00 $ $ $ $ $ $ $ 15,-,-,-,200.00 9,600.00 6,400.00 - $ $ $ 99,972.00 9,600.00 9,600.00 $ $ $ 7,-,000.00 7,000.00 $ $ $ 7,-,600.00 3,600.00 $ $ $ $ 6,-,-,772.00 1.2 Planning 1.2.1 Create project scope 1.2.2 Determine Project Team 1.2.3 Develop Project Plan 1.2.4 Submit Project Plan 1.2.5 Approval of Project 1.2.6 Systems Design 6,600.00 4,400.00 2,200.00 $ 18,000.00 15,-,-,-,200.00 9,600.00 6,400.00 - $ 3,800.00 $ $ $ 99,972.00 9,600.00 9,600.00 $ 4 5 5 $ $ $ 7,-,000.00 7,000.00 3 33 2 $ $ $ 7,-,600.00 3,600.00 2 1 1 $ $ $ 6,-,200.00 1.3 Development- Creation of interface for communication. Creation of interface for online order entry Creation of interface for flight operating Creation of Information Security technologies and procedures Creation of delivery special packages Installation of delivery systems. Verification of requirements. $ $ $ 11,400.00 3,800.00 3,800.00 $ $ $ 11,-,400.00 3,200.00 $ 6,400.00 $ $ 6,400.00 6,400.00 $ 6,400.00 $ $ 6,400.00 6,400.00 $ $ 3,200.00 3,200.00 $ 1,800.00 $ $ $ 5,400.00 9,600.00 4,200.00 $ $ 6,400.00 2,800.00 $ 8,066.67 $ $ 5,200.00 8,066.67 1.4 Production 1.4.1 Procurement 1.4.2 Production of Drones 1.4.3 Production of Packs 99,972.00 1.5 Testing 1.5.1 Testing of customer interface 1.5.2 Testing of drone operation and subunits 1.5.3 Testing of drone flight operations 1.6 Operations 1.6.1 Management of Flight Operations 1.6.2 Cost Control and Management 1.6.3 User/Pharmacy Leader Training $ 8,066.67 $ 8,066.67 $ 8,066.67 $ 8,066.67 $ 8,066.67 $ $ $ 2,600.00 8,066.67 3,600.00 $ 8,066.67 $ 3,200.00 $ 3,200.00 1.7 Closure Per-period Totals Cumulative totals $ $ 22,-,000.00 $ $ 19,-,400.00 $ $ 129,-,238.67 $ $ 27,-,305.33 $ $ 34,-,372.00 $ $ 27,-,638.67 Expenditure Chart $140,000.00 $400,000.00 $350,000.00 $120,000.00 $300,000.00 Per-period Totals $100,000.00 $250,000.00 $80,000.00 $200,000.00 $60,000.00 $150,000.00 $40,000.00 $100,000.00 $20,000.00 $50,000.00 $- $1 2 3 4 5 6 Periods 7 8 9 10 11 Cumulative totals 1.7.1 Complexion of production 1.7.2 Project Termination 1.7.3 Establishment of future goals/objectives $ $ 29,-,705.33 $ 33,666.67 $ 322,372.00 $ $ 22,-,838.67 $ 17,466.67 $ 362,305.33 $ 10,200.00 $ 21,466.67 $ 383,772.00 DRONETECH ENGINEERING ACTUAL COSTS REPORT FLYING DRONE DELIVERY PROJECT MARCH 20TH, 2021. DONE BY ROBERT PEDRO REVISION NO. 0 1 Cost Estimate Duration (in weeks) Total Costs 1. Build a pilot delivery system based on drones that will serve as both a breaking/innovative point and new way to continue with Wilmont’s vast catalogue of effective practices and businesses 1 to 4 $ 383,772.00 6 42 1 $ $ $ 13,200.00 2,600.00 3 2 2 1 1 3 $ $ $ $ $ $ 6,600.00 $ 4,400.00 $ 4,400.00 $ 2,200.00 8,-,000.00 0 - $ $ $ $ $ $ $ 3 3 3 2 5 to 8 3 9 to 12 Periods (4-week increment) 5 6 21 to 24 25 to 28 4 13 to 16 17 to 20 7 8 29 to 32 9 33 to 36 10 37 to 40 11 41 and 42 Totals 1.1 Initiating 1.1.1 Development of Scope and Plan 1.1.2 Engagement of stakeholders 1.1.3 Signatures on Required Contracts $ 8,800.00 $ 4,400.00 $ 2,600.00 $ $ $ 2,200.00 2,200.00 8,000.00 $ $ $ 13,200.00 2,600.00 $ $ $ $ $ $ 6,600.00 4,400.00 4,400.00 2,200.00 8,-,000.00 $ $ $ $ $ $ $ 15,-,-,-,200.00 9,600.00 6,400.00 - $ $ $ 99,972.00 6,400.00 6,400.00 1.2 Planning 1.2.1 Create project scope 1.2.2 Determine Project Team 1.2.3 Develop Project Plan 1.2.4 Submit Project Plan 1.2.5 Approval of Project 1.2.6 Systems Design 6,600.00 4,400.00 2,200.00 $ 18,000.00 15,-,-,-,200.00 9,600.00 6,400.00 - $ 3,800.00 $ $ $ 99,972.00 9,600.00 9,600.00 $ 4 5 5 $ $ $ 7,-,000.00 7,000.00 3 33 2 $ $ $ 7,-,600.00 3,600.00 $ $ $ 6,-,200.00 1.3 Development- Creation of interface for communication. Creation of interface for online order entry Creation of interface for flight operating Creation of Information Security technologies and procedures Creation of delivery special packages Installation of delivery systems. Verification of requirements. $ $ $ 11,400.00 3,800.00 3,800.00 $ $ $ 11,-,400.00 3,200.00 $ 6,400.00 $ $ 6,400.00 6,400.00 $ 6,400.00 $ $ 6,400.00 6,400.00 1.4 Production 1.4.1 Procurement 1.4.2 Production of Drones 1.4.3 Production of Packs 99,972.00 1.5 Testing 1.5.1 Testing of customer interface 1.5.2 Testing of drone operation and subunits 1.5.3 Testing of drone flight operations $ $ $ - 1.6 Operations 1.6.1 Management of Flight Operations 1.6.2 Cost Control and Management 1.6.3 User/Pharmacy Leader Training $ 8,066.67 $ 8,066.67 $ 8,066.67 $ 8,066.67 $ $ $ 32,266.67 - $ $ $ $ 278,838.67 $ 383,772.00 1.7 Closure 2 1 1 Total Incremental Actual Cost Per Period Total Cumulative Actual Cost Per Period Total Incremental Planned Cost Per Period Total Cumulative Planned Cost Per Period $ $ $ $ 22,-,-,-,000.00 $ $ $ $ 19,-,-,-,400.00 $ $ $ $ 129,-,-,-,238.67 $ $ $ $ 27,-,-,-,305.33 $ $ $ $ 34,-,-,-,372.00 $ $ $ $ 27,-,-,-,638.67 Expenditure Chart $140,000.00 $400,000.00 $350,000.00 $120,000.00 $250,000.00 $80,000.00 $200,000.00 $60,000.00 $150,000.00 $40,000.00 $100,000.00 $20,000.00 $50,000.00 $- $1 2 3 4 5 6 7 8 9 10 11 Periods Total Incremental Actual Cost Per Period Total Incremental Planned Cost Per Period Total Cumulative Actual Cost Per Period Total Cumulative Planned Cost Per Period Cumulative totals $300,000.00 $100,000.00 Per-period Totals 1.7.1 Complexion of production 1.7.2 Project Termination 1.7.3 Establishment of future goals/objectives $ $ $ $ 19,-,-,-,705.33 $ - $ 33,666.67 $ 322,372.00 $ $ $ $ 22,-,838.67 $ $ $ 17,466.67 $ 362,305.33 $ $ $ 21,466.67 $ 383,772.00 DRONETECH ENGINEERING EARNED VALUE REPORT FLYING DRONE DELIVERY PROJECT MARCH 20TH, 2021. Cost Estimate DONE BY ROBERT PEDRO REVISION NO. 0 Duration (in weeks) 1 1 to 4 Total Costs Total Earned Value 2 5 to 8 Total % Complete Total Earned Value 3 9 to 12 Total % Complete Total Earned Value 4 13 to 16 Total % Complete Total Earned Value 5 17 to 20 Total % Complete Total Earned Value Periods (4-week increment) 6 21 to 24 Total % Total Earned Complete Value Total % Complete 7 25 to 28 Total Earned Value 8 29 to 32 Total % Complete Total Earned Value 9 33 to 36 Total % Total Earned Complete Value 10 37 to 40 Total % Total Earned Complete Value 11 41 and 42 Total % Total Earned Complete Value Totals Total % Complete 1. Build a pilot delivery system based on drones that will serve as both a breaking/innovative point and new way to continue with Wilmont’s vast catalogue of effective practices and businesses $ 383,772.00 6 42 1 $ $ $ 13,200.00 2,600.00 $ $ $ 8,800.00 - 67% $ $ $ 4,400.00 2,600.00 33% $ $ 100% $ 3 2 2 1 1 3 $ $ $ $ $ $ 6,600.00 4,400.00 4,400.00 2,200.00 8,-,000.00 0 $ $ $ $ $ $ $ $ 6,600.00 4,400.00 2,200.00 - $ 100% $ 100% $ 50% $ $ $ $ $ 2,200.00 2,200.00 8,000.00 - $ $ $ 50% $ 100% $ 100% $ $ $ - $ $ $ $ $ $ $ 15,-,-,-,200.00 9,600.00 6,400.00 - $ $ $ $ $ $ $ - $ $ $ $ $ $ $ - 3 3 3 $ $ $ 99,972.00 9,600.00 9,600.00 $ $ $ $ - $ $ $ $ 4 5 5 $ $ $ 7,-,000.00 7,000.00 $ $ $ $ - 3 33 2 $ $ $ 7,-,600.00 3,600.00 $ $ $ $ $ - 2 1 1 $ $ $ 6,-,200.00 $ $ $ $ $ 1.1 Initiating 1.1.1 Development of Scope and Plan 1.1.2 Engagement of stakeholders 1.1.3 Signatures on Required Contracts 1.2 Planning 1.2.1 Create project scope 1.2.2 Determine Project Team 1.2.3 Develop Project Plan 1.2.4 Submit Project Plan 1.2.5 Approval of Project 1.2.6 Systems Design - $ $ $ - $ $ $ - $ $ $ - $ $ $ - $ $ $ 13,200.00 2,600.00 18,000.00 - $ $ $ $ $ $ 100% $ $ - $ $ $ $ $ $ $ $ - $ $ $ $ $ $ $ $ - $ $ $ $ $ $ $ $ - $ $ $ $ $ $ 6,600.00 4,400.00 4,400.00 2,200.00 8,-,000.00 $ $ $ $ $ $ $ 3,800.00 - 25% $ $ $ $ $ $ $ $ $ $ $ $ $ $ 15,-,200.00 8,-,200.00 9,600.00 6,400.00 - - $ $ $ $ 99,972.00 - $ 100% $ $ $ - $ $ $ $ $ $ $ 99,972.00 6,400.00 6,400.00 $ $ $ $ - $ $ $ $ $ $ $ $ - $ $ $ $ $ $ $ $ $ - $ $ $ $ $ 8,066.67 - $ $ 11% $ $ $ 8,066.67 - $ $ 11% $ $ $ 8,066.67 - $ $ 11% $ $ $ $ $ $ $ $ 129,838.67 $ $ $ $ $ 27,066.67 $ $ $ $ $ 34,066.67 $ $ $ $ $ 10 362,305.33 $ $ $ 11 383,772.00 - 1.3 Development- Creation of interface for communication. Creation of interface for online order entry Creation of interface for flight operating Creation of Information Security technologies and procedures Creation of delivery special packages Installation of delivery systems. Verification of requirements. 1.4 Production 1.4.1 Procurement 1.4.2 Production of Drones 1.4.3 Production of Packs 11,400.00 3,800.00 3,800.00 - 75% $ 25% $ $ 25% $ $ $ $ 11,-,400.00 3,200.00 - $ 75% $ $ 75% $ 33% $ $ $ 6,400.00 6,400.00 6,400.00 - $ $ 50% $ $ 67% $ 100% $ $ 2,560.00 - - $ $ $ $ 6,400.00 6,400.00 $ $ 67% $ 67% $ - - $ $ $ $ $ $ $ $ - 8,066.67 - $ $ 11% $ $ $ - 40,066.67 $ $ $ $ $ 20% 1.5 Testing 1.5.1 Testing of customer interface 1.5.2 Testing of drone operation and subunits 1.5.3 Testing of drone flight operations 1.6 Operations 1.6.1 Management of Flight Operations 1.6.2 Cost Control and Management 1.6.3 User/Pharmacy Leader Training 1.7 Closure 1.7.1 Complexion of production 1.7.2 Project Termination 1.7.3 Establishment of future goals/objectives Total Earned Value Period Total Cumulative Planned Cost Total Cumulative Actual Cost Total Earned Value Schedule Variance per Period $ $ $ $ 1 22,000.00 $ 22,000.00 $ 22,000.00 $ - 2 41,400.00 $ 41,400.00 $ 41,400.00 $ 22,000.00 3 171,238.67 $ 171,238.67 $ 171,238.67 $ $ $ $ $ $ 19,400.00 4 198,305.33 $ 198,305.33 $ 198,305.33 $ 5 232,372.00 $ 232,372.00 $ 232,372.00 $ - 6 259,638.67 $ 259,638.67 $ 272,438.67 $ 7 288,705.33 $ 278,838.67 $ 274,998.67 $ 8 322,372.00 $ $ $ 9 344,838.67 $ $ $ $400,000.00 Schedule Indices (As of June 2021) Total Earned Value of the Project(EV) Total Planned Value of the Project (PV) Schedule Variance (SV = EV - PV) Schedule Performance Index (SV = EV/PV) Actual Costs (AC) Cost Variance (CV = EV - AC) Cost Performance Index (CPI = EV/AC) $ $ $ $ $ 274,-,705.33 -13,-,838.67 -3,- $350,000.00 $300,000.00 $250,000.00 $200,000.00 Observations about status and indices: According to the CPI and SPI, the project is on a good run, with just a little variance in scheduling (not overtly overscheduled, due to the process of production still being unfinished. Training hasn't been done yet, along with testing. Operation procedures are still not completed. $150,000.00 $100,000.00 $50,000.00 $1 2 3 4 Total Cumulative Planned Cost 5 6 7 Total Cumulative Actual Cost 8 9 Total Earned Value 10 11 - 2,560.00 $ $ $ $ - $ - $ - $ - - $ $ $ 32,266.67 - $ $ $ $ 274,998.67