MIS Report in Excel | How to prepare MIS Report | How To Make Housekeeping Consumption Report ?
Вставка
- Опубліковано 5 лис 2024
- In this Video You will understand how to prepare MIS Report. Consumption report kaise banayi Jati hai. Kaise aap cost per room nikal sakte hai.
Minibar PnL Report Kaise Banate hai.
excel mai kaise formula lagake calculation ki jati hai. Per linen washing cost kaise nikali jati hai.
what Is HLP and How to calculate it.
I think first time on UA-cam anyone explained this way..
Thanks bhai for your lovely feedback।
Very much elaborated....thanks...it is a must watch... knowledgefull too...
You are most welcome ji
great knowledge sir
Thanks so much ajay bhai..
Great Mr Vijay
Thanks So much..
Sir, It's a very interesting and great work u have done. appreciate you.
Thanks yadav ji
Great job dear sir very rarely people make videos related house keeping ... keep it up... We always look for more HK information videos...
Thanks Geeta ji for your valuable comments.
I have uploaded more videos for Housekeeping.
Hope to hear more from you soon.
Stay in tuned
Really fabulous video and easy excel formatting ....simple to understand ...keep going sir....🤘🙏🙏
Thanks varun.
It can be more easier but thanks that u understand and love the format.
Keep it up sir many things to learn
Thanks so much bhai....
Hi Mr Vijay
Your video is very valuable for whoever's working in housekeeping. They can learn lots from your video.
Mostly EHK not teaching. They scare and don't want someone growth.
Thanks so much for your valuable feedback.
Keep learning and keep growing.
God bless u
Excellent work brother brother
Thanks bheem bro
Is CPR also take other expenses like laundry, HLP & eatable s
Yes.
I wil upload a brief video on CPR shortly
Excellent video 👌👌
Thanks sunil ji
Kindly send me the format ..raman.awasthi1@gmail.com
Fantastic video Mr joshi, keep it up waiting for new knowledgeable videos.
Thanks ji.
Coming soon with some interesting topic
Sir your very good I’m as a room attendant
Thanks so much for supporting Rakesh Ji..
Keep supporring..
Superb video
Thanks sir ji
Sir it very interesting video and i have some doubt but it clear now because of your video only Thank you so much sir
If u have any doubt u may reach me at 7561866642.
Thanks
Thanks for the information
Welcome naresh ji
Wonderful and extremely knowledgeable video.. please keep it up sir !!!
Thanks so much bhai ji।।।
Pleasure sir🙏🙏🙏
Thanks bhai ji.....
Bhai aap isi tarah ki video banate raho please
Thanks so much bhai.
Mai bnaunga
Pls support
Is very grateful
Thanks bhai
Good
Keep supporting
Thank you sir.
Welcome Mithlesh ji.
Keep learning
Thank you boss
Welcome boss
Actually from housekeeping department also it should be maintained the MIS because is is very easy to find exact position of department as well as closing stock of department on monthly basis.
Very well Said Karan bhai.
Keep it up..
I am watching all your videos so that I can gain much knowledge to appear interview and you are a motivation for me I watched your video how you became h.k executive in 5 years being a certificate holder not degree holder . Now Sir please if you know someone who can provide me a chance to showcase my skill and honesty then pls share with me I am desperate now it's been 2 years I am, not working there is too much pressure of my parents now . Please Sir reply me
Dear Bhadana ji,
I understand your problems
Pls be in touch with me through my insta ID Vicky Joshi Vlogs
Well explained vijay keep it up keep going
Thanks so much sir ji
U r grt
Thanks ji
U people made me unique
Do you consider hk labour cost, electricity,linen washing in CPR ?
Thanks for this concern Ranjeet ji,
HK Labour Cost never be added in CPR.
Yes i consider Linen washing Cost and electricity Cost in overall CPR.
@@SuccessinHousekeepingByVijay Thanks.. How do you calculate HLP per room ? Can you share me your contact details..
@@SinghOfChrist 7561866642
Very nice sir. Please make a vedio about budget.
Thanks arun ji for your lovely comments.
As you requested i am coming with topic on budget asap.
Stay in touch.
Dear Arun Ji,
As u have said i uploaded my topic on How to prepare budget.
Kindly go through the video.
Thanks
@@SuccessinHousekeepingByVijay thank you so much sir. I saw it
Welcome arun ji.
House keeping will prepare mis to show room cost which is very important .. hskp have various heads of expenses related to room cost
Very good Priyajit ji. Right answer.
Minibar PNL me last me PNL k bad ye konsa Consumption ka column hai?
Noted Ji,
Mai apko brief mai batata hu
Thanks!!!
Welcome dear
Nice
Thanks bhai
Should I go to MBA after completing Marriott voyger
Dear Kamal,
Higher studies have no limitation.
You may proceed for MBA.
How to work on monthly, daily, weekly report in MIS? Plse explain with example..
Well Noted.
Coming with Video Shortly.
@@SuccessinHousekeepingByVijay thank you
Can u tell me how to calculate about staff requirements
It can be calculated by having below mentioned figures.
1) No. Of Rooms
2) Occupancy percentage.
3) Layout of hotels i.e.down town, Resort,Retreats etc.
4) No. Of outlet
5) Frequency of service etc.
Sir your videos is amazing sir, I just want to know that how to figure out Per Room Cost ?
Thanks so much bro for supporting.
Per room cost can be figure out by :- Total room expenditure / No. Of rooms occupied
With the help of Mis we can easily find cost of each room and can control
Well said Ankesh.
@@SuccessinHousekeepingByVijay thanku sir
Welcome dear.
Tanx sir
Welcome shishank ji
🤩
Thanks Tripathi ji
Bhai agar 1 omr cost price hai per kg ka aur double bed sheet ka wait 1kg hai to chemical cost kiya hoga
Bhai bahut acha question apne pucha hai.
Iske liye apko actual calculation karna hoga kuki washing keval ek hi chemical se nahi hoti.
Mai apko process bata deta hu.
Washer mai doublebedsheet wash karne ko dalo and phir usme prewash and mainwash k liye chemical dalo.
For example prewash mai 20 gram mai 20 gram, 10 gram aur main wash mai 30 gram and 10 gram chemical laga.
Chemical ki cost nikalke no of bedsheet washed se divide karo
Bhai mera chemical cost 1 omr 10 gram ka aya hai ch 1omr+hlp 6.66=7.66
Sir greetings of the day , I need your suggestions on my lyf I did my bsc hotel management course in 2015 . I got placement from clg in marketing for raheja developers that's why I left that bcz I wanted to work in hotels . Later I worked as computer operator for 2 years then I worked as room attendant for pullman hotel and resort Kuala Lumpur Malaysia. I came back from there in 2018 i thought to leave hotel industry bcz I got so much back pain during my working in Malaysia. This why I decide to go in PvR as entertainment service provider i worked untill 2019 june but there i got less salary now I am trying to go back in hotel either as h.k supervisor or either room attendant but I am not getting any calls bcz it's been 2 years I haven't worked and I don't have experience in same fields I have different fields experience. What to do now it's been 5 years from my clg and I am not able to find a Good job . Pls suggest, me Sir what can I do now . I would be waiting for your reply ,.. pls Sir your response ,means a lot I am a gold ,medallist from my HM batch but I don't know what to do now
Pls contact me through my instagram
Vicky Joshi Vlogs
Mai apko apna number instagram mai share karunga
Sir pls make a video for annual budget
Noted Shishank ji.
Dear shishank ji,
Annual budget video is uploaded.
Pls go through this and leave your valuable feedback...
Thanks
Any difference occupied per room cost or cost per room
First up all I would like to thanks You Abhay ji for your first Comment.
As u asked there is no difference in both terms ( Occupied per room cost or cost per room) but somewhere people used to say in diffrent Terms.
Thank u for such a informative video and very well explained 👏👏. Kindly make a video regarding Making of Annual Housekeeping Budget and steps to remember while making a Budget.
Thanks so much for your valuable feedback.
Sortly i will be coming with this content
Can you explain how to take out electricity and water cost per room when we have a common meter for Guest rooms, public spaces and back areas??
Dear Sudip,
Let me come back to u with a answer but as of now i have seen that we are calculating it individually, every floor having electrical pannel through which engeneering staff are accessing the light control.
Electricity cost it's depends in rooms on the electrical equipment like gyzer, A.C and other light equipment.
Water cost is depends upon the flow of the water pressure.
Sir while calculating hlp 300kaha send aya kindly thoda bateyenge
HLP Cost apko apni Unit Consumption k according Nikalni hogi Maintenance & Laundry team ki help se
Can you learn to housekeeping IDS knowledge sir please 🙏🙏🙏🙏
Noted bro i will uplaod video soon
Through MIS we can control our cost
Thanks sir ji.
Appreciated your effort.
Samch nhi aya yeah video thoda or clear kr k bnao ye video sir Bhut important h ye sab lekin Es mai thik se samchaya nhi CPR or Par room cost
Noted ma'am,
Mai apko samjhta hu format k through.
Mis is to give manager feedback it is show actual data parformance and result
Great Mohit bhai.
Excellent.
Keep it up
@@SuccessinHousekeepingByVijay thank you sir ...
Keep it up bhai
God bless u
Pls watch other videos and share your feedback and pls share it with ur al friends
Sir can you make one more video About it. Because we are freshers ... If you explain broadly it will helpful for us... Please small request for my side...
I hope you will help us .
Thank you sir.
Noted Aarif Ji,
I will upload soon..
I am waiting for that video
To control cost of operations
Okay bhai
Sir bht tej bta rahe hein per topic video bnao with atleast 5exmple
Ji jarut bhai..
Sir How to work out room cost
Room Cost :- Total expenses / No. Of room sold
Amit verma
Thanks Amit ji..
Can we get soft copy of excel sheet
Sorry bro, this sheet I prepared in my official laptop and I left that job.
Let me connect with my team and if anything comes across I will let you know.
Thankyou
Hello sir I am hemlata Yadav Hk excitive I have to emprove my skills and knowledge can you halp me
Noted Ji..
can I get this all excel sheets my Email. kindly let me know.
Ansari ji,
The format i have deleated after uploading video.
Lets sew if i make again then i will share it with u
Housekeeping course karna hai bhaiya sasta i h m college
Apna number dijiye pls
Food cost 28%
So Room cost kitana % Hona chahiye
Room Cost ARR ka 5-7% hona chahiye,
But you said in video 6% to 8%
And now saying 5% To 7%
So which cost is standard cost?
can you share this video file link
Bro, Its just a sample format which i have used to explain. you can ask me it through Google Drive.
MIs Ka full form kya h sir
Monthly Inventory & Stock
sir. yi. report. Likhkar. samjao
Ji bilkul
Housekeeping makes MIS for record and Housekeeping matching MIS with Account end of the month. Sometimes not matching. That's why housekeeping also makes MIS as I know.🙏
Thanks Mr. Ashok for your valuable feedback.
My motto behind creating this channel is to build up confidence level among Housekeeping and make HK Department as recognisable like other departments in Hotels.
Pls do share videos to maximum HK staff so that they can learn.
Yes you are right we make MIS in Housekeeping to know the actual consumption of supplies and Amenities and have it record for future reference.
Thanks
Thanks
Hello sir aapk nubmer mila sakte hai kya sir mujhe aapk helap chahiye
7561866642
Nice sir ji
Tq so much ji
Contact number sir
7561866642
sir pls share ur email I'd
Vijayjoshi827@gmail.com
thanks sir