# BMC Chargeback Time Tracking — Operating Brief

## What This Is
Bertelsmann Management Consulting (BMC/BINC) mandatory time tracking initiative.
Period: **January 1 – April 30, 2026**
Who: All BHI Group employees, including Adner Cruz
Purpose: Chargeback analysis — IT cost allocation across Bertelsmann entities
File: `20261301_BINCoBMC_Time_Tracking_vupdated.xlsx` | Sheet: `TimeEntry`

---

## MrAnderson's Role
1. Receive Adner's daily activity recaps (Telegram, voice, email, action board)
2. Parse into 30-minute time blocks
3. Stage entries for confirmation before logging
4. Send daily confirmation summary
5. Friday weekly reconciliation

**DO NOT LOG WITHOUT ADNER'S CONFIRMATION. Stage → Confirm → Log.**

---

## Spreadsheet Columns

| Col | Field            | Notes                                            |
|-----|------------------|--------------------------------------------------|
| A   | Date             | Format M/D/YY                                    |
| B   | Task #           | Task 1–15 (max 15/day)                          |
| C   | TaskName         | Dropdown (values TBD — extract from spreadsheet)|
| D   | Entity           | Dropdown (values TBD — extract from spreadsheet)|
| E   | SugCategory      | Auto-suggested — do not edit                    |
| F   | CategoryOverwrite| Override if needed                              |
| G   | FinalCategory    | Auto-calculated — do not edit                  |
| H   | Hours            | 0.5 increments only                             |
| I   | Comment_If_Needed| Enterprise-level, governance-framed, one line   |
| J   | Status 1         | "FILLED" when complete                          |
| K   | Status 2         | "OPEN" until filled                             |

---

## BMC Service Categories

| Cat | Description                                                                 | Fulfillment               |
|-----|-----------------------------------------------------------------------------|---------------------------|
| A   | Mandatory — transparency/steering (e.g., management reporting)              | Must be BINC              |
| B   | Mandatory — consolidated economic advantage (e.g., cash pooling)            | Must be BINC              |
| C   | Mandatory — legal/regulatory (e.g., tax, compliance)                        | BINC or external          |
| D   | Voluntary — business unit services (e.g., employee services)                | BINC or external          |
| E   | Internal BINC operations (e.g., access mgmt, internal hiring)               | Internal only             |

---

## IT Service Pillars (for parsing recaps)

1. IT Governance & Strategy — leadership, budgeting, strategic planning, CEO reporting
2. Infrastructure & Systems Oversight — servers, network, cloud, monitoring, backups
3. Cybersecurity & Compliance — security reviews, audits, policy, risk
4. Vendor & Licensing Management — vendor calls, renewals, contracts, procurement
5. End User Enablement — helpdesk, onboarding/offboarding, access, desktop support
6. Project Delivery & Modernization — migrations, deployments, automation, new systems

---

## Entity Allocation Logic

- Corporate governance / CEO reporting / cross-entity → Corporate Center or "*Across all entities"
- Shared infrastructure → "*Across all entities" or proportional
- Entity-specific → assign to that entity (e.g., Coral Graphics, Relias Learning)
- Internal BINC ops → "*For Germany" or as appropriate

**ESCALATION RULE: If entity is unclear — FLAG IT. Do not guess. Ask Adner.**

---

## Comment Formatting Standard

- Enterprise-level language only
- One line, what + why
- Governance-framed

| Bad                          | Good                                                                           |
|------------------------------|--------------------------------------------------------------------------------|
| "Fixed Sarah's laptop"       | "End user device remediation — executive support"                              |
| "Called Cisco rep"           | "Vendor engagement — network infrastructure contract review"                   |
| "Worked on server stuff"     | "Infrastructure oversight — production environment health assessment"          |
| "Meeting with Kevin"         | "IT governance alignment — departmental strategy review with leadership"       |
| "Helped new hire get set up" | "End user onboarding — identity provisioning and workstation deployment"       |
| "Sage migration work"        | "Application modernization — Sage Fixed Assets platform migration"            |

---

## Staging Format

```
📋 BMC Time Entry — [DATE]

1. [TaskName] | [Entity] | [Hours] | [Comment]
2. [TaskName] | [Entity] | [Hours] | [Comment]
...

Total: X.X hours
⚠️ Flags: [unclear allocations]

Confirm to log? ✅
```

---

## Weekly Reconciliation (Fridays)

- Total hours logged that week
- Distribution across entities
- Distribution across service pillars
- Gaps (days with no entries)
- Anomalies needing explanation

---

## Known Entities (pending full dropdown extraction)

- Coral Graphics
- Relias Learning
- Corporate Center
- "*Across all entities"
- "*For Germany"

---

## Key BMC Contacts

- Sarah Born — sarah.born@bertelsmann.de
- Karlo Oehring — karlo.oehring@bertelsmann.de

---

## Grok Parse Script

**File:** `bmc/grok_parse_recap.py`
**Deployed:** 2026-03-12
**Usage:**
```bash
echo "recap text..." | python3 bmc/grok_parse_recap.py
python3 bmc/grok_parse_recap.py "recap text" --date 3/12/26
```
Reads xAI API key from `openclaw.json` → calls Grok 4 Fast → returns staged JSON + formatted confirmation block.

**Valid IT_Operations TaskNames:** IT1, HR, Other IT, Other department, Admin/miscellaneous, PTO

## Pending / Open Items

- [x] Extract full TaskName dropdown values from spreadsheet — done 2026-03-12
- [x] Extract full Entity dropdown values from spreadsheet — done 2026-03-12
- [x] Grok pipeline wired up — done 2026-03-12
- [ ] Direct spreadsheet integration (future — via M365 MCP connector)
- [ ] Backfill entries Jan 1 – Mar 8 (assess with Adner what's recoverable)

---

## Finalized Daily Workflow

1. Adner sends recap at EOD (voice, text, action board/Kanban)
2. Mr Anderson runs recap through **Grok 4 Fast (VPS)** to parse into structured entries
3. Stage entries in 📋 format for Adner's confirmation
4. Adner approves or adjusts
5. Write confirmed entries to spreadsheet (openpyxl + LibreOffice for row lookup)
6. Send updated file filtered to **3/9 onward** (pre-3/9 rows hidden)

**Model**: Grok 4 Fast — `grok-4-fast-non-reasoning` on Oracle VPS (150.136.218.171)
**March 9 = row 948** (LibreOffice confirmed anchor)
**Pre-3/9 rows**: hidden (not deleted)

## Staged Entries Log

Entries that have been staged but not yet confirmed/logged go here temporarily.

*(empty — starting fresh)*