BantayBaybay Puerto Alon Case Study
Day 5 S-Curve Midpoint Diagnostic, Cost & Schedule Indices (CPI/SPI) & Estimate at Completion
Direct Step-by-Step Continuation of Your Agri-Fisheries IT Hackathon Project
CRITICAL INSTRUCTION: Do not invent a new, disconnected project topic. During the Agri-Fisheries IT Hackathon Workshop, your student team selected a real-world coastal or agricultural hazard and produced an initial Hackathon Project Charter (e.g., LandingWatch, BantayBaybay, PalayTrust, AgriTrack).
In Day 5: Earned Value Control, Stress-Testing & Closure, your team takes that exact same project charter and advances it through today's graduate-level governance stage. Every day in this 5-day curriculum builds one unified, audit-ready master project dossier!
Open your team's Hackathon Charter from the Hackathon Panel above. Identify your selected Problem Statement, Target Beneficiary Group, and Core Technical Innovation.
Check the checklist in Tab 2 (Deliverables Checklist & Rubric). It provides clear instructions, formulas, and quality criteria for each section you must produce.
Review Tab 3 (Puerto Alon Exemplar). It demonstrates how a graduate team took the BantayBaybay Hackathon concept and produced full mathematical appraisals, matrices, and audit sign-offs.
Switch to Tab 4 (Blank Submission Form). Fill in your team's project details using the turnkey Markdown template. Use the 1-Click Copy Markdown or Download .md File buttons to save your work.
Explicit benefit chain connecting technical outputs to measurable public/citizen outcomes without vague generalities.
Defensible calculations (PERT durations, Payback, NPV, EVM, EMV, or TCO) with honest operational buffers.
Strict adherence to Philippine RA 9184 public procurement rules and COA asset capitalization guidelines.
Clear consideration of grassroots realities: device constraints (2G phones), local dialects, and operational stress.
Complete each deliverable for your team's Hackathon initiative. Check each item off as you complete your dossier.
Compute Earned Value diagnostic metrics at Month 3: Cost Variance (CV), Schedule Variance (SV), Cost Performance Index (CPI), and Schedule Performance Index (SPI).
Forecast Estimate at Completion ($EAC = BAC / CPI$), evaluate overrun absorption via Contingency Reserves, and formulate a crashing/fast-tracking recovery plan.
Document actual operational verification under monsoon storm conditions, testing telemetry sensor uptime, broadcast speed (6.4 min target), and zero citizen casualties.
Transition asset from Construction-in-Progress (CIP) to Fixed Assets under COA rules, including signed Certificates of Completion, Acceptance, and Property Asset Tagging.
Establish audit metrics for evaluating benefit realization (casualty elimination, municipal rescue expense savings) 6 to 12 months following formal handover.
This is an authentic, graduate-level reference dossier illustrating how the BantayBaybay team executed Day 5. Use this as your benchmark for rigor, formatting, and depth.
During the severe monsoon verification drill, BantayBaybay broadcast warnings in 6.4 minutes (beating the 8.0-minute target). All 8 coastal barangays received alerts, 218 fishing vessels docked safely, and Puerto Alon recorded ZERO CASUALTIES. The project was capitalized as a permanent municipal fixed asset under COA rules.
Copy or download this pre-formatted Markdown template, fill in your team's Hackathon data, and submit for evaluation.
# [PROJECT NAME] — Earned Value Control, Stress-Testing & Closure Dossier
*(Continuation of Hackathon Project Charter · Round 1–4)*
**Team Name:** [Enter Hackathon Team Name]
**Academic Program:** MIT 704 · IT Project Management & Governance
**Sponsoring Entity:** [e.g., Municipal Agriculture Office / MDRRMO / Coastal Fisherfolk Federation]
**Primary Authors:** [Student Team Members & Designated Roles]
---
## 🧭 HACKATHON CONTINUITY BRIEF
*In Day 5, your team concludes your Hackathon project lifecycle: diagnosing midterm variance using Earned Value Management, stress-testing under monsoon conditions, capitalizing assets under COA rules, and establishing a benefits realization audit.*
---
## 1. Midterm Earned Value Management (EVM) Status Report
*Evaluated at Month 3 (Baseline Budget at Completion \$\text{BAC} = ₱1,100,000\$)*
* **Planned Value (PV):** ₱600,000 (Work scheduled to be completed by Month 3)
* **Earned Value (EV):** ₱480,000 (Actual verified work completed)
* **Actual Cost (AC):** ₱520,000 (Actual funds disbursed)
### 1.1 Variances and Performance Indices
* **Cost Variance:** \$\text{CV} = \text{EV} - \text{AC} = ₱480,000 - ₱520,000 = -₱40,000\$ (Over budget by ₱40,000)
* **Schedule Variance:** \$\text{SV} = \text{EV} - \text{PV} = ₱480,000 - ₱600,000 = -₱120,000\$ (Behind schedule by ₱120,000)
* **Cost Performance Index:** \$\text{CPI} = \frac{\text{EV}}{\text{AC}} = \frac{480,000}{520,000} = \mathbf{0.923}\$
* **Schedule Performance Index:** \$\text{SPI} = \frac{\text{EV}}{\text{PV}} = \frac{480,000}{600,000} = \mathbf{0.800}\$
### 1.2 Forecasting & Corrective Action
* **Estimate at Completion:** \$\text{EAC} = \frac{\text{BAC}}{\text{CPI}} = \frac{₱1,100,000}{0.923} = \mathbf{₱1,191,766}\$
* **Projected Overrun:** ₱91,766. This is fully covered by the approved ₱90k Contingency Reserve + ₱70k Management Reserve.
* **Corrective Action:** Authorize ₱35,000 from Contingency Reserves to fast-track sensor installation crews (crashing) to recover schedule lag before monsoon season begins.
---
## 2. Severe Weather Field Stress-Test Protocol (Typhoon Simulation)
* **Environmental Conditions:** Actual monsoon weather drill, 65 km/h sustained wind, rain squalls, partial cellular tower brownouts.
* **Test Results:**
* **Ocean Sensor Telemetry:** 100% transmission uptime via solar backup batteries.
* **Alert Broadcast Speed:** **6.4 Minutes** from MDRRMO trigger to 2,000+ recipient handsets (Target was \$\le 8.0\$ minutes).
* **Barangay Reception:** 8 out of 8 barangays confirmed receipt; backup VHF radio reached outer islands.
* **Operational Impact:** All 218 coastal pump boats docked safely ashore; **ZERO CASUALTIES** recorded.
---
## 3. Formal Handover & Asset Capitalization Package (COA Transition)
* **Accounting Reclassification:** Asset reclassified from *Construction-in-Progress (CIP)* to *Municipal Property, Plant & Equipment (PPE)* under COA Circular rules.
* **Handover Checklist:**
* [x] **Certificate of Final Completion:** Signed by Lead Technical Contractor certifying all 6 masts and software are complete.
* [x] **Certificate of User Acceptance:** Signed by MDRRMO Head and Municipal ICT Officer verifying operational compliance.
* [x] **COA Property Asset Tagging:** Barcode property tags affixed to all solar panels, telemetry enclosures, and servers.
* [x] **SOP & Disaster Runbook:** Standard operating procedures officially handed over to municipal operations staff.
---
## 4. Post-Implementation Review (PIR) Benefit Realization Framework
* **Evaluation Schedule:** Scheduled for 9 months post-handover (following completion of annual typhoon season).
* **Key Audit Metrics:**
* Reduction in search-and-rescue municipal expenditures (Target: ₱1.8M saved per year).
* Community compliance rate (Target: \$\ge 95\%\$ of registered fisherfolk remain ashore during gale alerts).
* Maintenance costs tracked against the 5-Year TCO budget envelope.
See how your Hackathon concept advances across all 5 days of the ISUFST MIT 704 curriculum.
Establish statutory justification, 3-way options appraisal, 5-year NPV (+₱207k), and 26-week CPM baseline.
Form Scrum team, craft BDD acceptance criteria, define DoD quality contract, and size Sprint 1 (78 task hrs).
Price risk exposure with EMV, prioritize via RRL (>1.0), assign single-A RACI accountability, and enforce RA 9184 SLAs.
Separate governance (EDM) from management (PBR), trace COBIT Goals Cascade, and budget full ₱2.41M 5-year TCO.
Diagnose midterm EVM variance (CPI 0.92, SPI 0.80), execute live monsoon storm test, and capitalize fixed assets under COA rules.
Teams of 3 to 5 graduate students working simultaneously across 3 workstreams. Every team develops and pitches one fundable, field-tested IT solution for Philippine artisanal agriculture or fisheries.
Open the class scoring spreadsheet and write five grassroots problems in your community. Every problem must be framed from the fisher's or farmer's point of view, backed with empirical field evidence (no jumping to solutions).
Score each problem 1 to 5 on the 6 weighted criteria. Before locking in the #1 winner, the team's designated Devil's Advocate delivers the strongest objection, and the team must defend it in one sentence.
Split into 3 workstreams to fill the 11-section Project Charter: SMART criteria, Level-2 WBS, System Context Diagram, Milestones, and a preliminary budget with a mandatory 10% contingency reserve.
3-minute 1-slide pitch to municipal stakeholder roles (Mayor, MAO, BFAR, Fisherfolk Co-op, ICT/DPO) followed by a 2-minute defense defending operational and financial feasibility.
If your team needs empirical inspiration, draw from these real-world coastal and rural municipal challenges:
• FishR and BoatR municipal registries severely out of date.
• Zero recorded catch logs for municipal waters under 15km.
• Late gale warnings fail to reach fishers without smartphone 4G.
• Red tide shellfish harvesting bans arrive after market dispatch.
• Farmers missing from RSBSA registry, blocking DA fuel subsidies.
• PCIC crop insurance claim verification stuck on physical paper.
• Armyworm and blast pest outbreaks reported days too late.
• Estuary water salinity and pH tested manually once a week.
• Ice-ice seaweed blight spreads without predictive environmental warning.
• Severe price asymmetry: fishers sell at buyer price without market feeds.
• 30% post-harvest loss from inadequate ice logistics at municipal piers.
• Thousands of mangrove saplings planted with zero survival monitoring.
• Marine Protected Area (MPA) patrol logs kept on paper notebooks.
| Criterion | Weight | Anchor: Score 1 (Weak) | Anchor: Score 5 (Exemplary) |
|---|---|---|---|
| Livelihood Impact | 25% | Touches <20 households; minor economic inconvenience | Directly protects hundreds of livelihoods, food security, or life safety |
| Feasibility | 20% | Requires unavailable satellite arrays or 4G LTE at sea | Feasible in 12 months using 2G SMS, solar batteries, and local LGU staff |
| Urgency & Vulnerability | 15% | Can wait 3 years with negligible public impact | Critical immediate hazard: loss of life, harvest failure, or stock collapse |
| Sustainability & Climate | 15% | Zero ecological or climate resilience benefit | Directly reduces disaster risk, preserves fish stocks, or restores mangroves |
| Data Readiness | 15% | No registries exist; Data Privacy Act compliance impossible | Empirical registries exist (FishR, RSBSA) and are legally accessible |
| Policy Alignment | 10% | Not mentioned in any municipal or national plans | Explicitly prioritized in LGU AIP, Coastal Resource Plan, or BFAR mandate |
The project chosen today does not end today. Here is exactly how your team will advance this exact project across Days 2 to 5:
Problem discovery, SMART success criteria, 1-box Context Boundary, 3-level WBS, Three-Point PERT, 26-week Critical Path & 10% Reserves.
Decompose the Charter into Scrum Epics, write BDD User Stories for Mang Ramon & Ate Liza, and calculate 78 focus hours for Sprint 1.
Score typhoon and political risks with EMV ($P imes I$), prove Risk Reduction Leverage (RRL > 1.0), and establish RA 9184 SLA penalty clauses.
Align project with municipal objectives using COBIT Goals Cascade, calculate the 5-Year TCO Iceberg (CapEx vs OpEx), and score against portfolio competitors.
Conduct Month 3 EVM audit ($PV, EV, AC, CPI, SPI, EAC$), execute crisis schedule crashing during typhoons, and execute COA asset capitalization handover.
ISUFST School of Graduate Studies · Master in Information Technology · BantayBaybay Puerto Alon Framework
Foundations of public-sector IT investment appraisal, strategic benefit chains, and predictive scope planning for the BantayBaybay Puerto Alon early-warning network.
Distinguishing capital initiatives from ongoing IT operations; establishing the PM accountability boundary (Outputs vs Capabilities vs Outcomes vs Strategic Benefits).
Financial justification models, options analysis under LGU fiscal constraints, and hierarchical decomposition into Work Breakdown Structures.
Translating municipal requirements into INVEST-compliant user stories, Given-When-Then BDD acceptance tests, story point sizing, and probabilistic velocity burndown.
Empirical process control (Transparency, Inspection, Adaptation), Scrum 3 accountabilities, INVEST backlog decomposition, and Behavior-Driven Development (BDD).
Separating effort from duration using relative story points, historical velocity forecasting, team focus factor, and real-time burndown tracking.
Mitigating supply chain and community risks in municipal IT projects, pricing risk quantitatively with Expected Monetary Value (EMV), Philippine RA 9184 compliance, and cross-functional RACI matrices.
Systematic hazard taxonomy, probability-impact rating, quantitative Expected Monetary Value (EMV), and sizing contingency vs management reserves.
Engaging fisherfolk cooperatives and MDRRMO officials, navigating Philippine public procurement (RA 9184), vendor SLAs, and organizational RACI governance.
Aligning municipal IT investments to LGU strategic vision, implementing the COBIT 2019 Goals Cascade, modeling 5-Year Total Cost of Ownership (TCO), and IT Balanced Scorecard prioritization.
Distinguishing enterprise governance from management; applying the COBIT 2019 Goals Cascade to map municipal stakeholder needs into concrete IT objectives.
Holistic lifecycle financial analysis factoring recurring cellular telemetry, solar battery replacement, cloud compute, maintenance contracts, and IT Balanced Scorecards.
Executing Earned Value Management (EVM) to detect project drift, executing midpoint recovery, validating resiliency during the Typhoon Ambo trial deployment, and formal administrative closure.
Tracking objective work progress using Planned Value ($PV$), Earned Value ($EV$), and Actual Cost ($AC$); diagnosing cost/schedule variances and forecasting final completion costs ($EAC$).
Validating sensor telemetry under extreme typhoon weather, executing formal administrative closeout, asset handover to MDRRMO, and conducting Post-Implementation Reviews.
Select any day below to inspect its academic curriculum, lecture breakdown, deliverables, and launch its interactive module.