-
Step 1: Define the decision you need to make
What to do: Set a specific scope, such as a product cost review for one outlet, a supplier comparison, or a margin investigation for a group of items. Decide the period and the question before collecting data.
Success looks like: You can state which items, outlets, dates, and decision the analysis covers.
Common mistake to avoid: Combining different outlets or time periods without checking whether their costs and sales are comparable.
-
Step 2: Gather source records across outlets
What to do: Collect supplier invoices, delivery notes, relevant POS or sales records, bank activity, and any handwritten documents needed for the chosen period. A shared workflow can make it easier to bring records from multiple outlets together.
Success looks like: Each document has an identifiable source, date, supplier, and outlet where those details are available.
Common mistake to avoid: Assuming a missing delivery note or invoice can be safely replaced by an account total.
-
Step 3: Extract and standardize item details
What to do: Capture the product or SKU, quantity, unit price, and tax fields when they appear in the document. Normalize naming differences carefully so that variations in spelling or packaging are not mistaken for different products—or incorrectly merged.
Success looks like: The extracted items can be matched to the appropriate products and their source documents.
Common mistake to avoid: Treating automated extraction as verified when handwriting, language, units, or document quality could create errors.
-
Step 4: Code and reconcile transactions
What to do: Assign costs to the correct accounts and outlets, then reconcile transactions against available bank activity and supporting records. Bank reconciliation workflow and document checks help surface mismatches before they distort the analysis.
Success looks like: Material transactions have a consistent classification, and unresolved exceptions are visible for review.
Common mistake to avoid: Hiding an unmatched or uncertain transaction inside a broad expense category without follow-up.
-
Step 5: Compare costs using consistent assumptions
What to do: Compare relevant product costs and, where reliable sales and recipe data exist, examine contribution margin. Account for units, package sizes, discounts, and time period so the comparison uses like-for-like inputs.
Success looks like: Each comparison has a clear basis and can be traced to the records and assumptions used.
Common mistake to avoid: Calling an item profitable or unprofitable based on purchase price alone when other relevant costs are missing.
-
Step 6: Review supplier and outlet differences
What to do: Examine cost patterns by supplier and outlet where the data supports those dimensions. Investigate differences with the relevant manager or finance reviewer before treating a variation as a performance issue.
Success looks like: The team can explain material differences or has a specific exception to investigate.
Common mistake to avoid: Comparing outlets with different menus, purchasing arrangements, or recording practices as if their conditions were identical.
-
Step 7: Make a measured change and monitor it
What to do: Use verified findings to inform a menu, purchasing, portion, or pricing decision. Record what changed and review comparable cost and sales information afterward; the analysis informs decisions but does not make them automatically.
Success looks like: The decision has a documented rationale, a responsible reviewer, and a suitable follow-up period.
Common mistake to avoid: Attributing a later sales or margin change to one menu adjustment without considering other operational changes.