aufrattus

Area Operation

Auntie Anne's • Full-time

Jan 2016 - May 2025 • 9 yrs 4 mos

- Automated Inventory & Forecasting Trackers: Built dynamic Excel sheets to predict weekly ingredient orders (e.g., flour, butter, dips) based on historical sales trends, reducing waste by 5%. ​Wastage Analysis Dashboards: Created visual trackers to monitor daily product expiry and scrap, identifying specific shifts or outlets with high variance. ​- Par Level Calculators: Designed automated sheets that calculate minimum stock levels to prevent stockouts across multi-unit operations. Managing multi-unit P&L statements to know exactly what metrics restaurant owners need to see to stay profitable : - ​Interactive P&L Dashboards: Transformed raw financial data into clean, conditional-formatted Excel dashboards visualizing Revenue, COGS, Labor Costs, and Net Profit. ​- Recipe Costing & Menu Engineering Calculators: Developed dynamic calculators where changing a single ingredient price automatically updates the total portion cost and profit margin. ​- Break-Even Analysis Tools: Built Excel models to help multi-unit owners see exactly how many units (or pretzels!) need to be sold to cover fixed and variable overheads.