Crescent Finance Ops
Use this skill when a task asks for a single JSON answer using Crescent Finance Ops payloads. The task input normally has:
payloads/environment_access.json with the API base URL and allowed endpoints
payloads/request_memo.json with the target branch, region, ensemble, scenario, or production
payloads/answer_template.json with required keys, rounding, sorting, and field types
Fast Path
Run the bundled solver from the task input directory:
python /work/skill/scripts/solve_finance_ops.py /path/to/input
It prints one JSON object. Before returning it, check that the top-level keys and list ordering match answer_template.json. If the payload base URL is a placeholder, the script falls back to http://task-env:9009/.
Manual Rules
Use only the endpoints listed in the task payload. Currency fields are rounded to 2 decimals; percent and ratio fields are rounded to 4 decimals. Keep stable ID lists ascending unless a rank field says descending.
Finance branch and regional reporting:
- Fetch
/api/finance/branches, /api/finance/period-map, /api/finance/accounts, and /api/finance/records.
- Sum finance records by account category.
revenue = product/service revenue; cogs = direct materials/labor; sga = sales/admin/occupancy; allocations = shared service allocations.
gross_margin = revenue - cogs; ebitda = gross_margin - sga - allocations; ebitda_margin = ebitda / revenue.
- ARPU uses
revenue / active_customers. Sales per labor headcount uses revenue / labor_headcount.
- Current fiscal year periods come from
period-map; do not assume the close period alone is the fiscal-year total.
- Branch sales growth rankings compare current FY revenue against prior FY revenue across all branches, sorted descending with branch ID as the tie-breaker.
- Branch region context uses the target branch's region. Region EBITDA rank is the region's rank among all regions by current FY EBITDA, not the branch rank within the region.
- Regional top and bottom EBITDA branches are ranked within the target region for the latest requested fiscal year.
Compensation summaries and forecasts:
- Fetch
/api/compensation/rate-book, /api/compensation/rosters, and, for forecasts, /api/compensation/scenarios.
- Use each roster row's
weeks_by_quarter; do not force a fixed 13-week quarter when partial-quarter rows are present.
- For each employee and quarter:
- Minimum weekly scale = rate-book minimum weekly scale times weeks.
- Title premium = minimum weekly scale times the title premium percent times weeks, unless
combined_overscale_includes_title is true.
- Seniority = the rate-book seniority band for years of service times weeks.
- Overscale =
overscale_weekly times weeks.
- Count combined overscale rows where
combined_overscale_includes_title is true. Count partial-quarter rows where any quarter weeks differ from the rate-book quarter weeks.
- Forecasts compound minimum-scale, overscale, and seniority growth year over year. Add one service year for Year + 1 and two service years for Year + 2 before selecting the seniority band. Apply
title_pct_multiplier directly for the forecast year.
- For compensation annual totals, reconcile to rounded quarter totals when a cent-level rounding difference appears.
largest_growth_pay_type is the pay type with the largest percentage growth from current annual pay-type total to Year + 2, using rate-book pay-type order as the tie-breaker.
Payroll reviews:
- Fetch
/api/payroll/rate-book and /api/payroll/productions.
- Rehearsal pay is hourly with a 3-hour minimum call. Performance, audit, and sound-check pay are per service.
- Base service categories are
performance, audit, rehearsal, and sound_check.
- Role premiums stack: principal or lead once, quartet, electronic, and any explicit concertmaster flag. Doubles are separate: first double plus additional double percentages from the rate book.
- Premiums are based on pre-vacation base service pay. Vacation is 4% of base service pay plus role and doubles premiums when
vacation_eligible is true. Guarantees are based on base service pay before premiums and vacation.
- Non-substitute regular players receive
guarantee_adjustment = max(0, weekly_guarantee - base_service_pay).
- Substitute players receive a substitute adjustment equal to two performance services; include that amount in both
performance and substitute_adjustment, and include it in the premium base.
- Conflict flags:
REHEARSAL_EARLY_START if any rehearsal starts before the rate-book earliest start.
REHEARSAL_LATE_END if any rehearsal ends after the latest end.
SERVICE_OVER_TIME_LIMIT if any service duration exceeds the service type limit.
SOUND_CHECK_DURATION_MISMATCH if a sound-check duration differs from its named duration.
1---2name: crescent-finance-ops-43description: Solve Crescent Finance Ops API reporting tasks for branch and regional finance, orchestra compensation summaries and forecasts, and weekly theatre payroll reviews from task payloads.4metadata:5 source: https://skillmd.com/skills/prism-shadow/crescent-finance-ops-46---78# Crescent Finance Ops910Use this skill when a task asks for a single JSON answer using Crescent Finance Ops payloads. The task input normally has:1112- `payloads/environment_access.json` with the API base URL and allowed endpoints13- `payloads/request_memo.json` with the target branch, region, ensemble, scenario, or production14- `payloads/answer_template.json` with required keys, rounding, sorting, and field types1516## Fast Path1718Run the bundled solver from the task input directory:1920```bash21python /work/skill/scripts/solve_finance_ops.py /path/to/input22```2324It prints one JSON object. Before returning it, check that the top-level keys and list ordering match `answer_template.json`. If the payload base URL is a placeholder, the script falls back to `http://task-env:9009/`.2526## Manual Rules2728Use only the endpoints listed in the task payload. Currency fields are rounded to 2 decimals; percent and ratio fields are rounded to 4 decimals. Keep stable ID lists ascending unless a rank field says descending.2930Finance branch and regional reporting:3132- Fetch `/api/finance/branches`, `/api/finance/period-map`, `/api/finance/accounts`, and `/api/finance/records`.33- Sum finance records by account category. `revenue = product/service revenue`; `cogs = direct materials/labor`; `sga = sales/admin/occupancy`; `allocations = shared service allocations`.34- `gross_margin = revenue - cogs`; `ebitda = gross_margin - sga - allocations`; `ebitda_margin = ebitda / revenue`.35- ARPU uses `revenue / active_customers`. Sales per labor headcount uses `revenue / labor_headcount`.36- Current fiscal year periods come from `period-map`; do not assume the close period alone is the fiscal-year total.37- Branch sales growth rankings compare current FY revenue against prior FY revenue across all branches, sorted descending with branch ID as the tie-breaker.38- Branch region context uses the target branch's region. Region EBITDA rank is the region's rank among all regions by current FY EBITDA, not the branch rank within the region.39- Regional top and bottom EBITDA branches are ranked within the target region for the latest requested fiscal year.4041Compensation summaries and forecasts:4243- Fetch `/api/compensation/rate-book`, `/api/compensation/rosters`, and, for forecasts, `/api/compensation/scenarios`.44- Use each roster row's `weeks_by_quarter`; do not force a fixed 13-week quarter when partial-quarter rows are present.45- For each employee and quarter:46 - Minimum weekly scale = rate-book minimum weekly scale times weeks.47 - Title premium = minimum weekly scale times the title premium percent times weeks, unless `combined_overscale_includes_title` is true.48 - Seniority = the rate-book seniority band for years of service times weeks.49 - Overscale = `overscale_weekly` times weeks.50- Count combined overscale rows where `combined_overscale_includes_title` is true. Count partial-quarter rows where any quarter weeks differ from the rate-book quarter weeks.51- Forecasts compound minimum-scale, overscale, and seniority growth year over year. Add one service year for Year + 1 and two service years for Year + 2 before selecting the seniority band. Apply `title_pct_multiplier` directly for the forecast year.52- For compensation annual totals, reconcile to rounded quarter totals when a cent-level rounding difference appears.53- `largest_growth_pay_type` is the pay type with the largest percentage growth from current annual pay-type total to Year + 2, using rate-book pay-type order as the tie-breaker.5455Payroll reviews:5657- Fetch `/api/payroll/rate-book` and `/api/payroll/productions`.58- Rehearsal pay is hourly with a 3-hour minimum call. Performance, audit, and sound-check pay are per service.59- Base service categories are `performance`, `audit`, `rehearsal`, and `sound_check`.60- Role premiums stack: principal or lead once, quartet, electronic, and any explicit concertmaster flag. Doubles are separate: first double plus additional double percentages from the rate book.61- Premiums are based on pre-vacation base service pay. Vacation is 4% of base service pay plus role and doubles premiums when `vacation_eligible` is true. Guarantees are based on base service pay before premiums and vacation.62- Non-substitute regular players receive `guarantee_adjustment = max(0, weekly_guarantee - base_service_pay)`.63- Substitute players receive a substitute adjustment equal to two performance services; include that amount in both `performance` and `substitute_adjustment`, and include it in the premium base.64- Conflict flags:65 - `REHEARSAL_EARLY_START` if any rehearsal starts before the rate-book earliest start.66 - `REHEARSAL_LATE_END` if any rehearsal ends after the latest end.67 - `SERVICE_OVER_TIME_LIMIT` if any service duration exceeds the service type limit.68 - `SOUND_CHECK_DURATION_MISMATCH` if a sound-check duration differs from its named duration.