Hands-On: Build a Financial Model on Production Data

"Workshop Description
In this hands-on workshop, you'll build a complete financial model linked to production data from the ProveIt! shared infrastructure. Starting from daily production totals, you'll configure cost assumptions, revenue calculations, and profit analysis—then explore the results through dashboards and AI-powered queries.
This isn't a slideshow about what's possible. You'll leave having built a working model that demonstrates exactly how to turn operational data into financial insights.
What You'll Build
Organizational Structure:
• Enterprise with 3 production sites
• 4 areas per site: Filling, Liquid Processing, Packaging, Palletizing
• Equipment-level detail: filling lines, mix rooms, labeler lines, palletizers
Production Inputs (from conference data):
• OEE metrics: Availability, Performance, Quality
• Throughput: Cola Filler, Orange Filler, Packager (Units/Day)
• Plan metrics: Filler Planned Rate, Product Mix % (Weekly)
Financial Assumptions (you'll configure):
• Cost inputs: 500ml Bottle Cost, Cola Syrup Cost/Litre, Orange Syrup Cost/Litre
• Cost inputs: Packaging Cost, Fixed Cost Estimate, Syrup Mix %
• Revenue inputs: Sale Price Cola Unit, Sale Price Orange Unit, Quantity Discount Rate
Calculated Metrics (formulas you'll create):
• Costs: Bottle Cost, Cola Syrup Cost, Orange Syrup Cost, Packaging Cost, Variable Cost, Fixed Cost
• Revenue: Cola Revenue, Orange Revenue, Total Revenue
• Profit: Total Revenue − Total Cost
• Targets: Filler Throughput Target (Cola/Orange) based on planned rates
Analytics & AI:
• Dashboard: profit by site, cost breakdown, revenue by product
• Drill-down from Enterprise totals → Site → Area → Equipment
• AI chat (beta): Ask natural language questions like ""What's my most profitable site?"" or ""Show me cost per unit by product""
"