Dear sir, I want a mess expense sheet format in excel. So that I can find out how much our day and month cost per person/dish calculate
From India, Rajkot
Acknowledge(0)
Amend(0)
1From India, Rajkot
Acknowledge(0)Amend(0)
Dear HR-Rajkot,
Have you outsourced the running of the operations of the employee mess (staff cafe), or is your company handling the operations in-house?
The calculation of the expenses for the staff cafe is not that difficult. You will have the operating expenses on the following counts:
a) Employee cost (which includes staff salary, uniform, statutory payments, etc.)
b) Food cost
c) Energy cost (which includes electricity and LPG cylinder)
d) Maintenance cost (cleaning the burners of the gas stove and chimneys, sharpening the kitchen tools, etc.)
e) Housekeeping and pest control expenses
f) Water charges
g) Payments for the statutory licenses
h) Medical expenses (to conduct periodical medical tests of the staff employed; however, it can be merged with the employee cost as well)
i) Administration expenses (like rent of the premises, maintaining the food store, painting, etc.)
j) Transportation cost (this is applicable if you have a cargo vehicle to bring the grocery items. It is not recommended to merge it into the admin expenses)
You can record the expenses on the counts above and find out the monthly expenses. Find out how many people dined per month, and you can find out the expense per day.
However, the bifurcation of the expenses into breakfast and lunch will be a little difficult. If your company provides dinner, then trifurcation of the expenses will also be difficult.
If you wish to go beyond the bifurcation or trifurcation of the expenses and find out even the cost per dish, then you may hire the services of the "cost controller." I recommend you do so because the apportionment of the various costs like food cost, energy cost, etc., will require a lot of experiments. A novice cannot handle this task.
In most of the star hotels, cost controllers are employed, and their job is to calculate the cost of each food item served in the hotel. However, while calculating the cost per food item, you just cannot take into account the operating expenses mentioned above but should consider the inventory carrying cost of the inventory stored in the store also. This will further complicate the job of the cost calculation.
If your staff cafe is big where hundreds of people dine every day, then you may hire the services of a "Cost Accountant" whose qualification is CMA. Their primary job is to do the costing, and they will be able to do the costing methodically.
Thanks,
Dinesh Divekar
From India, Bangalore
Acknowledge(0)Amend(0)
Have you outsourced the running of the operations of the employee mess (staff cafe), or is your company handling the operations in-house?
The calculation of the expenses for the staff cafe is not that difficult. You will have the operating expenses on the following counts:
a) Employee cost (which includes staff salary, uniform, statutory payments, etc.)
b) Food cost
c) Energy cost (which includes electricity and LPG cylinder)
d) Maintenance cost (cleaning the burners of the gas stove and chimneys, sharpening the kitchen tools, etc.)
e) Housekeeping and pest control expenses
f) Water charges
g) Payments for the statutory licenses
h) Medical expenses (to conduct periodical medical tests of the staff employed; however, it can be merged with the employee cost as well)
i) Administration expenses (like rent of the premises, maintaining the food store, painting, etc.)
j) Transportation cost (this is applicable if you have a cargo vehicle to bring the grocery items. It is not recommended to merge it into the admin expenses)
You can record the expenses on the counts above and find out the monthly expenses. Find out how many people dined per month, and you can find out the expense per day.
However, the bifurcation of the expenses into breakfast and lunch will be a little difficult. If your company provides dinner, then trifurcation of the expenses will also be difficult.
If you wish to go beyond the bifurcation or trifurcation of the expenses and find out even the cost per dish, then you may hire the services of the "cost controller." I recommend you do so because the apportionment of the various costs like food cost, energy cost, etc., will require a lot of experiments. A novice cannot handle this task.
In most of the star hotels, cost controllers are employed, and their job is to calculate the cost of each food item served in the hotel. However, while calculating the cost per food item, you just cannot take into account the operating expenses mentioned above but should consider the inventory carrying cost of the inventory stored in the store also. This will further complicate the job of the cost calculation.
If your staff cafe is big where hundreds of people dine every day, then you may hire the services of a "Cost Accountant" whose qualification is CMA. Their primary job is to do the costing, and they will be able to do the costing methodically.
Thanks,
Dinesh Divekar
From India, Bangalore
Acknowledge(0)Amend(0)Gathering data for an AI comment.... Sending emails to relevant members...
Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
SAMPLE Employee Attrition Calculation sheet for FY 09-10 .xls