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.
Workbook structure
The student workbook intentionally leaves the analysis structure open. Build the schedules required above, retain the source inputs, and add formula-based checks. You may add worksheets. The worked solution is one acceptable structure, not the only correct layout.
03 / Review your work
Try the assignment before opening the answer.
Open the worked answer and 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. The total duration of 90 minutes is a planning estimate, not a tested completion time. Allocate class time according to prior knowledge and reserve time for discussion of the decision and evidence.
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.
Decision
Correct cutoff and inventory before comparing divisions, then approve a consistent allocation basis.
Evidence and reasoning
Cutoff and inventory errors change group profit; reallocating a shared cost changes divisional profit but not the group total. These are different management decisions.
What would change the conclusion
Service evidence, independent counts or support-ticket data could change adjustments and allocation weights. Proposed controls are not evidence of effective operation.
Related learning
Version 1.1. Synthetic teaching case. Completion time is an estimate.