Where Does a Snack Shop Actually Make Its Money? A Business Report in Google Sheets

Snack Attack Shack is a fictional snack retailer from the Masterschool orientation challenge. The official submission was a group project, but my place in the Data Analytics track rode on my orientation results, so I also built a complete version of my own: the report I would want to read if the shop were mine, covering where the money actually comes from, which customers are drifting away, and what’s quietly rotting in the warehouse.

The answers were concentrated ones. Twenty-five customers, 28% of the base, generate 69.6% of revenue; the top 25 products carry 68.2%. Regular customers drive 96.8% of everything, which makes the dormant segment a reactivation opportunity rather than a write-off. On the operations side: several products sat flagged for urgent reorder while discontinued items still held excess stock, and the carrier comparison split cleanly into a fastest option (Speedy Express, 8.6 days average) and a cheapest one (United Package, €8.76 average), which is a choice, not a problem.

Everything runs in Google Sheets, from cleaning through loyalty segmentation (new, non-returning, dormant, regular) to AI-assisted demand and profitability forecasting. Two logs in the repository document the work end to end: every transformation from raw data to final numbers, and exactly where AI assisted, because analysis you can’t retrace is just opinion with charts.

Read the full report (PDF), or explore the live analysis workbook in Google Sheets.