🍽️ Food Supporting

Comprehensive Excel-based corporate food management system with vendor management, daily consumption tracking, menu-based pricing, attendance integration, and professional dashboards for multi-company meal planning and billing.

📋 What This Does

Solves the problem: How to track corporate food consumption across multiple companies, manage multiple vendors with different menu items, integrate daily attendance with meal counts, automate billing, and maintain vendor performance records with detailed remarks.

Key Benefits:

• Dynamic menu-based pricing system
• Multi-vendor food supply management
• Company & order type selection
• Weekend/holiday automatic marking
• Attendance-integrated meal tracking
• Daily consumption analysis
• Vendor performance tracking
• Monthly billing automation
• Per-employee cost calculation
• Detailed vendor remark tracking

📸 View the File

Access Food Supporting Template

Password: 123 Note: Dashboard auto-updates based on selections

---

📸 System Screenshots

Professional Food Consumption Dashboard

Professional dashboard with Company (FinEdge Advisory), Vendor (RoyalPlatter Hospitality), Order Type (System Order), daily rates (₹95/pizza, ₹105.5/pizza-with-box), and automatic weekend holiday marking.

Vendor Remarks & Performance Sheet

Comprehensive vendor tracking with month, vendor name, unique code, and detailed remarks documenting vendor performance, special occasions, menu changes, and issues throughout the year.

---

✨ Main Features

1. Professional Dashboard

• Company Selection: Dropdown to select company
• Vendor Selection: Automatic vendor assignment based on the company
• Order Type Selection: System Order vs External Order
• Rate Display:
  • Per Pizza: ₹95 (varies by vendor)
  • Per Pizza With Box: ₹105.50 (varies by vendor)
• Daily Tracking Table:
  • Days with date
  • Automatic weekend/holiday marking (Sunday, Saturday)
  • Variable rates by day (weekday: ₹95, Friday non-veg: different rate)
  • Dinner/Lunch tracking
  • Total count per meal
  • Total amount calculation
  • Employee count
  • Per-employee cost
• Monthly Summary:
  • Dinner count: 10
  • Lunch count: 50
  • Total count: 60
  • Total amount: ₹5,700
  • Employee count: 294
  • Per-employee cost: ₹19.39
• Day-Wise Consumption Chart: Visual trend analysis
• Ctrl+P Print Ready: Professional bill generation

2. Dynamic Menu Pricing

• Different rates for different days:
  • Weekdays: Base rate
  • Non-veg days (e.g., Wednesday, Friday): Higher rate
  • Weekends: Holiday (no service)
• Pizza vs Pizza-with-Box options
• Vendor-specific pricing: Each vendor has own rates
• Order type variation: System Order vs External Order pricing

3. Company Management

• FinEdge Advisory LLP
• Sai Gourmet Catering Solutions LLP
• Datta Food Services Pvt Ltd
• RoyalPlatter Hospitality LLP
• RoyalPlatter Express Catering LLP
• Kings Restaurants LLP
• And multiple others

4. Vendor Management

• Sai Gourmet Catering Solutions LLP
• Datta Food Services Pvt Ltd
• RoyalPlatter Hospitality LLP
• RoyalPlatter Express Catering
• NextGen Catering Solutions
• Each vendor has unique code
• Custom pricing per vendor
• Rate configuration per company assignment

5. Raw Data Sheet

• Direct data input from software
• Daily meal count entries
• Vendor-wise tracking
• Date & company reference
• Easy data consolidation
• Auto-calculation from entries

6. Attendance Integration

• Monthly employee count tracking
• Daily attendance data
• Links to meal consumption
• Per-employee cost calculation
• Scaling of food based on attendance
• Attendance-based billing validation

7. Remark Data Sheet

• Month-wise vendor tracking
• Vendor unique code reference
• Detailed remarks section:
  • Timing changes (Dinner/Lunch hours)
  • Menu modifications
  • Special occasions
  • Issues & complaints
  • Employee count changes
  • Special services
  • Location/shift changes
• Historical vendor performance documentation

8. Holiday & Working Day Management

• Automatic Sunday marking (holiday)
• Automatic Saturday marking (holiday)
• Configurable holiday list
• Working day tracking
• Holiday exemptions
• Rate adjustments for holidays

9. Per Employee Cost Tracking

• Daily per-employee cost
• Monthly average per-employee cost
• Employee count variation handling
• Cost optimization visibility
• Fair allocation basis

10. Monthly Billing

• Automated invoice calculation
• Dinner charges totaling
• Lunch charges totaling
• Total billing amount
• Average per-employee billing
• Multiple month tracking (Oct-24 onwards)

🚀 How to Use

Step 1: Open Dashboard

1. Download file from link above
2. Open in Excel
3. Go to "Dashboard" sheet
4. Ready to configure

Step 2: Select Company

1. Dashboard → Company Name dropdown
2. Choose company (e.g., FinEdge Advisory LLP)
3. Vendor auto-populates
4. Rates auto-update

Step 3: Select Vendor

1. If company has multiple vendors, choose preferred vendor
2. Rates adjust to vendor's pricing
3. Past data loads if available
4. Remark history displays

Step 4: Select Order Type

1. Choose "System Order" (internal kitchen)
2. Or "External Order" (catered service)
3. Rates adjust based on order type
4. Dashboard recalculates

Step 5: Input Daily Data

1. Go to "RAW DATA" sheet
2. Enter daily meal counts:
   • Date
   • Company
   • Vendor
   • Dinner count
   • Lunch count
3. Dashboard auto-calculates
4. Costs populate

Step 6: Track Attendance

1. Go to "Attendance Data" sheet
2. Enter monthly employee count:
   • Month
   • Company
   • Daily attendance
3. Used for per-employee cost
4. Scaling meals accordingly

Step 7: Add Vendor Remarks

1. Go to "Remark Data" sheet
2. Add monthly notes:
   • Month & vendor
   • Unique code
   • Details about:
     • Timing changes
     • Menu modifications
     • Special occasions
     • Issues
     • Employee changes
3. Visible in dashboard remarks

Step 8: Generate Bills

1. Configure dashboard completely
2. Press Ctrl+P
3. Print professional bill
4. Include with payment
5. Easy for finance team

📊 Real-World Usage

Multi-Vendor Corporate Catering:

Company: FinEdge Advisory LLP
Vendor: RoyalPlatter Hospitality LLP
Order Type: By System Order
Rate Per Pizza: ₹95
Rate With Box: ₹105.50
Month: Jun-25
Dinner Orders: 10
Lunch Orders: 50
Total: 60 meals
Total Amount: ₹5,700
Employee Count: 294
Per Employee Cost: ₹19.39

Attendance-Based Scaling:

May-25: 22 working days, ₹5,700 total
Jun-25: 25 working days, ₹6,500 total
July-25: 22 working days, ₹5,500 total
(Scaled based on employee attendance)

Vendor Performance Tracking:

Oct-24: "Dinner timing changed, 26 days"
Nov-24: "Lunch timing modified, 27 days increase"
Dec-24: "Days decreased to 21, employee shift change"
Jan-25: "Employee count increased, special menu ₹80"

💡 Key Benefits

✅ Dynamic Menu Pricing: Different rates for different days
✅ Multi-Vendor Support: Manage multiple food suppliers
✅ Attendance Integration: Scale meals to employee count
✅ Holiday Management: Auto-mark weekends as holidays
✅ Performance Tracking: Detailed vendor remarks history
✅ Daily Automation: Rates auto-calculate from selections
✅ Professional Dashboards: Company-wise analysis
✅ Per-Employee Costing: Fair cost allocation
✅ Monthly Billing: Automated invoice generation
✅ Printable Bills: Ctrl+P ready-to-print format

🔧 Customization

Add New Company:

1. "Validation" sheet → Add company name
2. Assign default vendor
3. Configure vendor relationship
4. Auto-available in dashboard dropdown

Add New Vendor:

1. "Validation" sheet → Add vendor name
2. Set unique code
3. Configure rates (pizza, pizza-with-box)
4. Add to company assignments

Change Daily Rates:

1. "Validation" sheet → Update rate table
2. Specify day & vendor
3. Configure rate per item
4. Dashboard auto-applies

Add Holiday:

1. "Validation" sheet → Holiday list
2. Add date as holiday
3. Dashboard excludes from working days
4. No meal count that day

Update Vendor Remarks:

1. "Remark Data" sheet → New row
2. Month, vendor, unique code
3. Add detailed remarks
4. Visible in dashboard selection

📞 Contact

• GitHub
• Email: suubhamghadge@gmail.com
• LinkedIn

📄 License

MIT License - Free to use and modify

---

🌟 Project Stats

---

🍽️ Track Food Consumption - Manage Vendors - Automate Billing - Optimize Costs

⭐ If this helps manage your corporate food service, please star this repository!

Password: 123 | Multi-Vendor | Invoice Ready