AGC Training Center Ops

The pre-phase record for the new AGC subsidiary: registration, requirements, money, payroll, compliance and the road to the first class. Every tick, amount and file is saved for everyone, with who changed it and when.
Connecting…
Start here. Management and investors: read the Report tab (one page, plain language, downloadable). Admin: work from Registration, Requirements, People and Compliance. Finance: Finance and Payroll. Unfamiliar terms are explained in the glossary at the bottom of the Report.

Phases on the calendar bar = phase window, green = progress, amount = money to release · Phase plan

Needs attention overdue, blocked, due in 14 days · edit right here

Spending: plan vs actual click a month for its budget lines

Task progress vs plan click a month for its tasks

Progress by area “Not needed” items don't count

Program readiness

Funding: cash needed vs capital calls Funding

To confirm placeholders still in the plan: edit, then confirm

Next milestones

Recent changes

Figures update live from the rest of the dashboard.

Snapshots a copy of the key numbers, saved each week automatically and whenever you click “Save snapshot now”

Spending: plan vs actual cumulative, with buffer

Monthly cash out by type with buffer

Task progress vs plan registration, requirements, people, decisions

3-year projection after the first classes · edit the assumptions

A planning model, not a forecast. Every assumption below is a placeholder until fees, trainers and enrollment are confirmed. Change any value and the charts and numbers update for everyone.

Cash position over time, three scenarios

Money in vs money out by quarter (base case)

Money in by who pays, per year (base case)

Registration to first graduates. Solid bars are dates we control or TESDA publishes; striped bars are estimates. The red line is today. Click a bar to change its dates.
PlannedDoneEstimateToday
One card per program. The checklist follows TESDA's program registration form (F04); the equipment list follows the inspection forms for equipment, tools and consumables (F13–F15). Upload a program's Training Regulation to keep it with the program; add the items it lists below. If you already own something, set “On site” to the quantity you have, or press “Have all”: it stops counting toward the money to spend. Mark a requirement “Not needed” instead of deleting it, so the record shows why.

By category

Cash out by month planned with buffer (bar) vs actual (green)

Budget lines every line shows its basis and source

Rates and salary change here, then apply to the budget

Monthly employer cost per person

Payroll lines in the budget

Deadlines the company owes once it is registered and has an employee. Ticking a recurring item files the next one automatically. Dates are internal targets set on or before the legal deadline.
The whole journey on one page, from company set-up to the first graduates. Colours follow the real tasks and timeline: green done, blue in progress, orange blocked or behind, white not started. Click any step for what to do, who does it and the documents needed.

Steps in order same flow as a list

Edit steps guidance, owners, lanes, links to tasks and timeline
Organizational structure of the training center, ready to print for TESDA. Edit positions below; names left blank show as “to be hired”.

Positions

201 files: one personnel record per employee, with every required document uploaded and downloadable here, including the signed contract. Government numbers and personal details are kept out of the change history.

Brand name, colour and logo used across the dashboard, reports and Excel

Document register policies, SOPs, forms, TESDA submissions, contracts and brand files, with version, status and review date

Files requirements, TRs, receipts, signed copies

Backup a complete copy of every record, history included

Download one at each month end and save it to the company Drive. Restoring brings back changed or deleted records; anything added since the backup is kept.

Audit trail who changed what, when, from what to what · deleted records can be restored

Delivery and results. Before the TESDA certificate the work here is the trainer pool and the national assessment set-up; once Batch 1 starts, log each batch and the results fill in by themselves.

Learner funnel all batches

Targets

Batches one row per batch

Trainer coverage TESDA needs a qualified trainer per program

National assessment set-up

Trainer and assessor pool credentials and status

How much money each phase needs, when, and what has to be true before moving on. Amounts come straight from the Budget lines and the dates from the Timeline, so they update when either changes. "To release" includes the buffer.

Phases on the calendar bar = window, green = progress, amount = money to release

Money per phase

Release calendar what to give each month, against capital calls

Edit phases rename, reorder, add a phase, or change which budget lines and timeline items belong to it
Record a payment by opening its budget line (Finance tab): actual amount, date paid, OR or invoice number.
Who puts money in, how much and when, against what the plan needs. Contributor names are placeholders: rename them to the actual shareholder groups and adjust the split once the board agrees it.

Cash needed vs capital calls cumulative, Dec 2026 to Dec 2027

By contributor

Who approves spending approval matrix

Ownership % sets each contributor's share of every capital call

Capital calls enter the amount received and the date when money lands

The risk register: what could hurt the plan, how likely, how bad, who owns it and what we do about it. High-likelihood, high-impact open risks are shaded and appear in the Report.

Risk register

Flags from the data automatic, refreshed with every change

Item
Proof (receipt, signed copy, screenshot)
Change history of this item
Budget line
Change history of this line
Equipment item

↑ ↓ to move · Enter to open · Esc to close

Import from Excel check the changes before applying

Add a program

Creates the program with TESDA's standard program checklist, a ₱2,000 registration-fee line, and an empty equipment list. Then upload the TR to fill the equipment list.

Milestone
Requirements found