Interactive Sales Tracking Dashboard

Real-time tracking of branch performance and promotional offers

Last Updated

Monthly Performance Summary

Key Metrics

3,628
Total Orders
12%
$175,414
Total Revenue
8%
$48
Avg Order Value
3%
90%
Delivery Rate
2%
Calculation Formulas:
Total Orders = Σ(Delivery Orders + Takeaway Orders)
Total Revenue = Σ(Total Value per Branch)
Avg Order Value = Total Revenue ÷ Total Orders
Delivery Rate = (Total Delivery Orders ÷ Total Orders) × 100

Monthly Performance Comparison

Month-over-Month Comparison
Add Monthly Comparison Data

Monthly Performance Comparison

Branch January February March April May June July August September October November December Monthly Avg Yearly Total Actions

Branch Monthly Data

Branch Monthly Data
Add Monthly Data
Change Calculations:
Revenue Change (%) = ((Actual Revenue - Last Year Revenue) ÷ Last Year Revenue) × 100
Count Change (%) = ((Actual Count - Last Year Count) ÷ Last Year Count) × 100
Branch Month Actual Revenue Actual Count Last Year Revenue Last Year Count Revenue Change Count Change Actions

Delivery Report

Delivery Performance
Total Delivery Orders
3,267
12% from last month
Formula: Σ(Delivery Orders per Branch)
Overall Delivery Rate
90%
2% from last month
Formula: (Total Delivery Orders ÷ Total Orders) × 100
Estimated Delivery Revenue
$157,873
8% from last month
Formula: Total Revenue × (Total Delivery Orders ÷ Total Orders)
Delivery Performance by Branch
Delivery Rate Calculation per Branch:
For each branch: (Delivery Orders ÷ (Delivery Orders + Takeaway Orders)) × 100
Delivery Orders Distribution
Update Delivery Data

Branch Performance

Branch Performance
Performance Indicators:
• High Performance: Delivery Rate ≥ 85%
• Medium Performance: 75% ≤ Delivery Rate < 85%
• Low Performance: Delivery Rate < 75%
Update Branch Data

Promotional Offers Performance

Promotional Offers Performance
Selected Offer
Fried Chicken (12 pieces)
Total Offer Orders
1,452
Formula: Σ(Orders per Day)
Total Offer Revenue
$64,580
Formula: Σ(Revenue per Day)
Update Offers Data