Retail campaign reporting workshop / 7 MIN READ
Reconcile the inventory cost basis before comparing campaign profit
Replace the flattering stamp-set headline with a reconciled explanation before the campaign deck is presented.
AI-assisted research and analysis for the SNS Creative Fieldbook
Sources checked 2026-11-07
Resolve why the worksheets disagree before using either to support a campaign story.
What you will leave with: A corrected reporting headline attached to a complete, consistently described comparison.
Use this when
- Two worksheets describe the same retail exercise but support conflicting presentation headlines.
- A campaign deck has selected a favorable money total before its reporting basis is clear.
Not an accounting-policy election, journal-entry procedure or tax recommendation.
Stop the headline before it becomes the campaign story
A fictional stationery retailer is preparing a campaign review for its stamp sets. The campaign manager has two slides describing the same trading exercise, but their profit totals differ. One slide looks more favorable and has already been placed beside a celebratory photograph of the counter display. Before choosing it for the presentation, the editor asks what changed between the calculations. The task is to resolve comparability, not to reward the slide that best supports the preferred story.
Keep the two original slides available and give them neutral labels. Do not call one correct and the other mistaken before reconstructing their basis. Ask the report owner for the underlying purchase and sale record, the period covered and the definition used for each total. Keep missing evidence unresolved rather than filling it from memory.
The commercial question must also be clear. The team wants to describe what the campaign achieved, not merely explain why two worksheets disagree. Those are separate tasks. A reconciled worksheet can remove one reporting error, but it cannot by itself establish that a display, message or offer caused customer behavior. Keep the proposed campaign conclusion visible so that the eventual correction addresses the claim people were about to repeat.
Reconstruct the complete teaching record
Periodic teaching comparison; costs in fictional currency units. Opening inventory is zero. Receive 10 units at 4 each, then 10 at 6; afterward sell 12 at 10. Available cost = 40 + 60 = 100; revenue = 120; 8 units remain. FIFO allocates earliest costs first: sold cost = 10 × 4 + 2 × 6 = 52; ending cost = 8 × 6 = 48. Weighted average = 100 / 20 = 5: sold cost = 12 × 5 = 60; ending cost = 8 × 5 = 40. Both allocations total 100. Gross profit, revenue minus sold cost, is 68 versus 60, not cash or net profit. No other costs or events are modeled; no universal perpetual-system behavior is asserted.
The supplied calculations were executed with exact rational arithmetic and independently checked against an expanded list of the purchased units. No accounting record was posted or amended. The example deliberately contains only the stated events; it is not a template for deciding an organization’s accounting policy or applying a tax treatment.
Place the complete comparison beside the proposed headline rather than on a remote appendix slide. The audience should be able to see what question the exercise answers before encountering the celebratory photograph. The photograph may honestly document the campaign presentation, but it should not be used to suggest that an unexplained worksheet difference is evidence of commercial success.
Replace the flattering comparison with an accurate explanation
The revised heading is “Same sales, different cost bases.”
Keep the marketing narrative separate from that explanatory heading. The campaign may still have an interesting creative execution, useful customer feedback or a well-documented operational outcome. Present those on their own evidence. Do not abandon every positive observation merely because the original money headline was unsuitable, and do not use those observations to rescue the unsuitable headline.
For the actual report, ask the accountable finance owner which approved basis belongs in the comparison being presented. The marketing editor should then apply that supplied definition consistently across the relevant report or clearly mark why two views are shown. This is a request for the correct reporting input, not an invitation to select a policy that produces the preferred result.
If the report owner cannot establish the basis before the presentation, remove the comparative profit claim from the draft. Explain the unresolved reporting question plainly and retain any independently supported campaign facts. A postponed headline is better than a precise number whose interpretation changes according to which worksheet the presenter opens. Do not quietly substitute revenue and keep the old profit label.
Preserve the original slides in the review record with the corrected explanation. That makes it possible to answer a later question about why the presentation changed without accusing the preparer of inventing a result. The difference may have arisen from an understandable worksheet choice. The editorial responsibility is to prevent that choice from becoming an unsupported comparison in front of an audience.
Give the next report a consistent question
Write a short reporting note that identifies the measure, period, approved basis and responsible owner. Link it to the underlying record rather than relying on a slide title alone. When the campaign deck is copied for another audience, keep that note available to the person rewriting the headline. Preserve the definition with the number.
Before the final presentation, ask a colleague to explain the claim in ordinary language. If they say the campaign created extra money merely because one of the two totals is larger, the correction has not been made clear enough. Revise the heading or the explanation rather than adding more decorative charts. The purpose of the bridge is understanding, not the appearance of financial sophistication.
For a later campaign comparison, start with a common reporting question and obtain the relevant figures on that basis. Do not carry this toy exercise forward as a standing instruction about how inventory should be valued. Actual policies and adjustments belong to the finance process. The marketing task is to preserve their meaning when assembling a commercial story.
The finished artifact is a corrected headline, a complete comparison and a clear boundary around what the evidence establishes. It resolves the worksheet disagreement without choosing a policy, posting entries or advising on tax. The campaign team can then discuss supported outcomes without allowing a difference in report construction to stand in for performance.
Make the reasoning concrete.
The campaign deck pairs the more favorable worksheet with a celebratory counter-display photograph.
Keep the strongest-looking total
Opening: Present the existing slide without explaining the disagreement.
Hypothesis: The campaign story appears simple and positive.
Risk: The audience may infer a commercial improvement the comparison does not establish.
Correct the comparison first
Opening: Use the supplied bridge and obtain the report’s approved basis before choosing a headline.
Hypothesis: The audience can understand what the numbers actually describe.
Risk: The comparative claim may need to be removed until the basis is resolved.
Choose the second approach while retaining separately supported campaign observations.
Take the questions into your next brief.
Use these prompts in your own notes. Nothing is submitted from this page.
Claim
What did the original headline invite the audience to believe?
Record
Which source record belongs to both worksheets?
Basis
Who supplies the approved definition for this report?
Correction
What should be removed if the reporting question remains unresolved?
Reuse
Will the definition remain available when the slide is reused?
Watch for the wrong conclusion.
- Choosing a worksheet because it best supports the planned narrative.
- Replacing a measure without correcting its headline.
- Treating the campaign photograph as evidence for an unexplained financial comparison.
Your next action
Rewrite the fictional headline and attach the comparison before selecting the commercial claims for the deck.
Sources & scope
The transactions and campaign are invented. Local calculations were executed; no financial record, policy or commitment was changed.
- 10.2 Calculate the Cost of Goods Sold and Ending Inventory Using the Periodic Method →Primary instructional textbook · Supports: Periodic allocations.