01 / Learn the method
Learning outcomes
Correct segment profit and separate control failures from allocation choices. Calculate the result, reconcile it and communicate its limitations.
Method
Segment profit depends on both measurement and allocation. Correct unsupported revenue and inventory cost before applying the agreed overhead key. An allocation change redistributes group profit but cannot create it. Rank controls by the risk they address, evidence needed and operational owner.
Smaller worked example
Two divisions share $10,000 overhead. Changing A’s share from 40% to 60% lowers A profit $2,000 and raises B profit $2,000; group profit is unchanged.
02 / Put it to work
Business context and rules
Fictional Summit Distribution, September 2026. A reported revenue 120,000 and direct cost 70,000; B revenue 100,000 and direct cost 65,000. Shared overhead 30,000 was allocated equally. Evidence: A includes 8,000 October services incorrectly recognized in September; assume no associated direct cost. B inventory count identifies 4,000 additional September cost not recorded. Final signed allocation policy uses service tickets: A 70%, B 30%. The revenue override lacked approval; inventory count lacked independent sign-off; allocation file was manually overwritten. Use these explicit case adjustments, not a universal accounting conclusion.
Original synthetic inputs
| Input | Value | Unit |
|---|---|---|
| A reported revenue | 120000 | USD |
| A reported direct cost | 70000 | USD |
| B reported revenue | 100000 | USD |
| B reported direct cost | 65000 | USD |
| Shared overhead | 30000 | USD |
| A revenue cutoff correction | 8000 | USD |
| B additional inventory cost | 4000 | USD |
| A final allocation share | 0.7 | fraction |
| B final allocation share | 0.3 | fraction |
Required deliverables
Produce a reported-to-corrected segment bridge separating measurement from allocation. Deliver a three-row control register: failure, risk, preventive / detective action, owner and evidence of operation.
Use formulas for derived amounts and preserve source data. Put narrative deliverables in the workbook response area; expand it as needed. Compare amounts within 0.01 of the stated unit and percentages within 0.1 percentage point. No unsupported balancing plugs.
03 / Review your work
Try the assignment before opening the answer.
Open the worked answer and teaching notes
Worked numerical schedule
| Measure | Value | Unit |
|---|---|---|
| A reported profit | 35,000.00 | USD |
| B reported profit | 20,000.00 | USD |
| A corrected profit | 21,000.00 | USD |
| B corrected profit | 22,000.00 | USD |
| Corrected group profit | 43,000.00 | USD |
| Group profit correction | -12,000.00 | USD |
| Allocation share residual | 0.00 | fraction |
| Group correction reconciliation | 0.00 | USD |
Interpretation and recommended actions
Reported profit A $35,000 and B $20,000 becomes A $21,000 and B $22,000. Group profit falls from $55,000 to $43,000 solely from $8,000 cutoff and $4,000 inventory corrections. Allocation shifts $6,000 from A to B. Controls: revenue override approval tied to service evidence, independent count review and reconciliation, and a version-controlled allocation schedule tied to tickets with reviewer approval. These are proposals; do not claim they operated effectively.
Scoring rubric - 100 points
| Dimension | Points | Awarding guidance |
|---|---|---|
| Calculation | 40 | Reported view 8; measurement corrections 12; allocation bridge 12; group result 8. |
| Interpretation | 25 | Correct application of the case rules 10; explain the business decision 10; identify evidence or limitations 5. |
| Controls / audit trail | 20 | Traceable formulas 8; independent reconciliation 8; explicit units and signs 4. |
| Communication | 15 | Decision and numerical headline 5; actions with owners and evidence 5; concise response covering all required deliverables 5. |
Award method credit after an isolated arithmetic error rather than repeatedly deducting for it. Equivalent account labels and well-supported alternative recommendations are acceptable. Numerical tolerance is 0.01 in the stated units; no universal passing score is prescribed.
Common mistakes
Calling allocation changes a group saving; correcting A revenue twice; declaring a control effective from its description alone.
Staged hints
First correct measurement under the old 50/50 allocation. Then change only the key. The second step must net to zero across divisions.
Instructor notes
Prerequisites: Cost allocation and close basics. Suggested use of the estimated 90 minutes: spend roughly 15% on the lesson and smaller example, 55% on the independent task, 20% on comparing approaches and 10% on the decision discussion. Timing is untested. Ask learners to explain why the numerical check is necessary but not sufficient.
For a simpler class, provide the model structure and work through one driver. For an extension, change one operational assumption and require a new reconciliation and recommendation. Verify the new key before distributing any variant. Open files in the intended spreadsheet application before class. Solutions are learning resources, not secure hiring examinations. Expert review remains pending.
Continue this learning path
CON-01 · Which Product Actually Contributes to Profit?
CON-02 · Material and Labour Variances: Find the Operational Cause
AI-assisted synthetic teaching case. Expert review and native Excel / Sheets testing pending.