Monthly Bill Summary

Per-meal rate calculation and individual dues for the selected month

Billing period

Total Meals

280

All 4 members combined

Grocery Expense

₹10,170

Total from daily entries

Per Meal Cost

₹36.32

Grocery ÷ Total Meals

Total Fixed Costs

₹6,460

Rent ₹6,000 + Electricity ₹460

Room Expenses

These are split equally among all 4 members and are not counted in meal cost

Room Rent (₹)

₹

Per person: ₹1,500

Electricity Bill (₹)

₹

Per person: ₹115

Calculation Formula

Per Meal Cost

₹10,170 ÷ 280 meals

= ₹36.32 / meal

Each Member's Meal Bill

Member's Meals × ₹36.32

Fixed Cost Per Person

(₹6,000 + ₹460) ÷ 4

= ₹1,615

Total Due Per Member

Meal Bill + Fixed Cost

Individual Bill Breakdown

1 of 4 members settled

Grand Total

₹16,630

Member	Meals	Grocery Paid	Meal Bill	Rent Share	Elec. Share	Total Due
AD Abhijit Das Pending	72	₹3,740	₹2,615	₹1,500	₹115	₹4,230
AM Abhi Maji Pending	69	₹2,490	₹2,506	₹1,500	₹115	₹4,121
SD Surajit Das Pending	69	₹2,180	₹2,506	₹1,500	₹115	₹4,121
PN Prasanta Nayak Settled	70	₹1,760	₹2,543	₹1,500	₹115	₹4,158
Total	280	₹10,170	₹10,170	₹6,000	₹460	₹16,630

Abhijit Das

72 meals

Total Due

₹4,230

Meal Bill

₹2,615

Rent

₹1,500

Electricity

₹115

Abhi Maji

69 meals

Total Due

₹4,121

Meal Bill

₹2,506

Rent

₹1,500

Electricity

₹115

Surajit Das

69 meals

Total Due

₹4,121

Meal Bill

₹2,506

Rent

₹1,500

Electricity

₹115

Prasanta Nayak

70 meals

Total Due

₹4,158

Meal Bill

₹2,543

Rent

₹1,500

Electricity

₹115