Toolkit Store Courses Take Assessment About Blog
Take Assessment

Full-cost P&Ls, built in minutes

Cost Allocation Engine

Full-cost P&Ls, built in minutes

Get the Engine

How to Upload a Claude Skill

 
 

Cost Allocation Engine: BP Case Study Walkthrough

Features List

8

Tabs, one formula-driven workbook

$52M

Shared costs allocated in the BP case study

19

Recipients across 5 cost pools, one run

Why Finance Teams Use This Skill

Full-Cost P&Ls, Fast

Stop building allocation schedules by hand. Describe your cost pools and driver data, and the skill produces fully-loaded P&Ls for every business unit โ€” with allocated overhead, margin calculations, and a reconciliation check โ€” in a single session.

Driver-Based, Not Arbitrary

Every cost pool is allocated using an appropriate activity driver โ€” headcount for HR and IT, square footage for facilities, revenue for finance and legal. The skill picks the right driver for each pool and falls back to alternatives when data is missing.

Multi-Layer Allocation

Handle step-down and cascading allocations. Corporate costs flow to regions, regional costs flow to business units, and BU costs flow to products โ€” all in sequence, with each layer picking up the costs above it.

Audit-Ready Documentation

Every run produces a Methodology tab that documents the driver selected for each cost pool, the rationale for that selection, the rates calculated, and a reconciliation proving total allocated equals total cost pools. Ready for auditors and tax authorities.

Transfer Pricing Built In

For intercompany allocations, the skill applies arm's length cost-plus markups and produces the documentation structure required under OECD guidelines and local transfer pricing rules โ€” including the benefit test and comparability analysis.

What You Get

  • Cost Allocation Engine (.skill file)

    The Claude Custom Skill file. Upload it to your Claude account and run it directly โ€” no coding, no external tools. Works with any cost pool structure across any industry.

  • 8-Tab Excel Workbook Output

    Every run produces a formula-driven Excel workbook: Summary, Cost Pools, Drivers, Allocation Rates, Allocations Detail, BU P&Ls, Methodology, and Validation. All tabs are cross-referenced โ€” change an input in Cost Pools and the BU P&Ls update automatically.

  • Methodology Documentation

    A structured Methodology tab ready for audit and tax authority review. Documents each cost pool, the driver selected and why, the allocation rates calculated, and a line-by-line reconciliation confirming total allocated equals total cost pools.

  • BP Case Study Dataset (Excel)

    The synthetic BP dataset used in the walkthrough video: $52M in shared costs across IT, HR, Facilities, Finance, and Corporate Overhead, with 19 receiving entities and intentional data quality issues included for training purposes. Use it to test the skill before running your own data.

  • BP Allocation Output Workbook

    The completed Excel output from the BP case study โ€” all 7 tabs populated, with cost pool-to-driver mappings, per-unit allocation rates, the full allocation matrix, and the BU P&L summaries. Use it as a reference model for your own workbook.

When to Run This Skill

Monthly Management Reporting

Your BU heads want to see fully-loaded P&Ls, not just direct margin. Run the skill with each period's cost pool actuals and driver data and get updated allocated schedules and BU P&Ls in the same session โ€” no rebuilding the spreadsheet each month.

Product Profitability Deep Dive

Gross margin looks fine. But once you push IT, HR, and facilities costs down to the product level, the picture changes. The skill handles multi-layer allocation from corporate to BU to product, showing you which products are genuinely profitable on a fully-loaded basis.

Transfer Pricing Documentation

Your intercompany services need arm's length pricing and supporting documentation. The skill applies cost-plus markups, runs the benefit test, and generates the documentation structure required by OECD guidelines and local tax authorities โ€” in the same run as the allocation.

Post-Merger Cost Integration

You've acquired a business and need to allocate your shared service costs across a combined entity. Upload both org hierarchies and cost pools, and the skill builds a consolidated allocation across the merged structure โ€” identifying where legacy methodologies conflict.

Allocation Fairness Challenge

A business unit is pushing back on its allocated costs. Run alternative driver scenarios โ€” headcount vs. revenue vs. square footage โ€” and show the BU head what their allocation looks like under each methodology. The Methodology tab documents the rationale for the approach you've chosen.

What's in the Workbook

Tab Type What It Contains
Summary Dashboard Total allocations by recipient, % of total, key metrics (cost pools, recipients, drivers used)
Cost Pools Data Entry Editable input: cost pool name, total amount, fiscal year, driver type assigned to each pool
Drivers Data Entry Editable input: driver type, value, and unit by recipient entity (headcount, sq ft, revenue, transactions)
Allocation Rates Calculated Per-unit cost rate for each driver โ€” auto-calculated from Cost Pools รท total driver values
Allocations Detail Calculated Full matrix: every cost pool ร— every recipient, with allocated amount and % share
BU P&Ls Calculated Fully-loaded P&L per business unit: revenue, direct costs, gross profit, allocated overhead, operating income
Methodology Documentation Audit-ready narrative: cost pools listed, driver rationale documented, rates shown, reconciliation included
Validation Controls Balance checks: total allocated = total cost pools per pool, flags rounding differences and zero-driver issues

Common Questions

Your Overhead Is Already Paid. Now Find Out Who Owes What.

Full-cost P&Ls for every business unit, with audit-ready methodology docs. Includes the BP case study dataset. Updated for 2026.

Get the Engine