Twill Brain

#271 Create dashboard for ice cream franchise

1 min read

#271 — Create dashboard for ice cream franchise

Repo: Twill-AI/twill-llm-engine State: closed | Status: done Assignee: meliascosta, Ahmad1809

Created: 2025-03-19 · Updated: 2025-03-24

Description

Based on data availabiity these are the plots generated

  • KPI labor costs
  • KPI total income
  • Piechart expenses on ice-cream supplies
  • Linegraph expenses on top 5 expense accounts
  • Linegraph monthly expenses on Liquid Nitrogen
  • Linegraph monthly expenses on rent as percentage of income
  • Linegraph Monthly cost of sales as percentage of income
  • Stacked bar plot monthly expenses on payroll related accounts
  • Barplot Top5 expenses accounts for 2024
  • Linegraph of those 5 accounts in time for 2024
  • Linegraph of P&L main variables
  • Pie cart of top vendors

Original Ask:

  • Revenue Breakdown
  • COGS (Also as a percentage of revenue, targeting 20%)
  • Labor Costs (Also as a percentage of revenue, targeting 30%)
  • Nitrogen Costs (Also as a percentage of revenue, targeting 10%)
  • Rent Expenses (Also as a percentage of revenue, targeting 20%)
  • Miscellaneous Costs (mainly utilities)
  • Sales Revenue (daily, weekly, monthly, rolling 3-month, YoY)
  • Net Profit (after costs above)
  • Revenue by Product/Flavor (best sellers)

Notes

Add implementation notes, blockers, and context here

Add wikilinks to related people, meetings, or other tickets

Graph View