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.

КОМЕНТАРІ • 173

  • @arindamsarkar3599
    @arindamsarkar3599 4 роки тому +3

    I think first time on UA-cam anyone explained this way..

  • @getwithavi
    @getwithavi Рік тому +1

    Very much elaborated....thanks...it is a must watch... knowledgefull too...

  • @mylifeajaykumar6016
    @mylifeajaykumar6016 3 роки тому +1

    great knowledge sir

  • @kirankanchan6718
    @kirankanchan6718 2 роки тому +1

    Great Mr Vijay

  • @prabinyadav6343
    @prabinyadav6343 4 роки тому +4

    Sir, It's a very interesting and great work u have done. appreciate you.

  • @geetgallery7483
    @geetgallery7483 4 роки тому +4

    Great job dear sir very rarely people make videos related house keeping ... keep it up... We always look for more HK information videos...

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  4 роки тому +1

      Thanks Geeta ji for your valuable comments.
      I have uploaded more videos for Housekeeping.
      Hope to hear more from you soon.
      Stay in tuned

  • @varunsharma3181
    @varunsharma3181 4 роки тому +1

    Really fabulous video and easy excel formatting ....simple to understand ...keep going sir....🤘🙏🙏

  • @Training-junction1
    @Training-junction1 3 роки тому +1

    Keep it up sir many things to learn

  • @ashokkumar-qg8my
    @ashokkumar-qg8my 4 роки тому +4

    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.

  • @bheemsen8722
    @bheemsen8722 4 роки тому +1

    Excellent work brother brother

  • @sarabjitsingh29
    @sarabjitsingh29 2 роки тому +2

    Is CPR also take other expenses like laundry, HLP & eatable s

  • @sonu20061
    @sonu20061 4 роки тому +1

    Excellent video 👌👌

  • @digambarsikarwar4470
    @digambarsikarwar4470 4 роки тому +1

    Fantastic video Mr joshi, keep it up waiting for new knowledgeable videos.

  • @rakeshmarathe1875
    @rakeshmarathe1875 3 роки тому +1

    Sir your very good I’m as a room attendant

  • @hasmuddinsaifi9758
    @hasmuddinsaifi9758 4 роки тому +1

    Superb video

  • @marycheetri680
    @marycheetri680 3 роки тому +1

    Sir it very interesting video and i have some doubt but it clear now because of your video only Thank you so much sir

  • @nareshbeladbont9839
    @nareshbeladbont9839 2 роки тому +1

    Thanks for the information

  • @arindamsarkar3599
    @arindamsarkar3599 4 роки тому +1

    Wonderful and extremely knowledgeable video.. please keep it up sir !!!

  • @blackfungus1674
    @blackfungus1674 3 роки тому

    Bhai aap isi tarah ki video banate raho please

  • @ansariaman8055
    @ansariaman8055 3 роки тому +1

    Is very grateful

  • @Yashpal-fz1eh
    @Yashpal-fz1eh Рік тому +1

    Good

  • @mithleshkumar4060
    @mithleshkumar4060 3 роки тому +1

    Thank you sir.

  • @amitkamboj2142
    @amitkamboj2142 3 місяці тому +1

    Thank you boss

  • @karanpatil354
    @karanpatil354 3 роки тому +2

    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.

  • @bhadanarv4687
    @bhadanarv4687 3 роки тому +1

    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

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  3 роки тому

      Dear Bhadana ji,
      I understand your problems
      Pls be in touch with me through my insta ID Vicky Joshi Vlogs

  • @shivashaktijobs
    @shivashaktijobs 4 роки тому +1

    Well explained vijay keep it up keep going

  • @alokjoshi1604
    @alokjoshi1604 3 роки тому +1

    U r grt

  • @SinghOfChrist
    @SinghOfChrist 3 роки тому +1

    Do you consider hk labour cost, electricity,linen washing in CPR ?

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  3 роки тому

      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.

    • @SinghOfChrist
      @SinghOfChrist 3 роки тому +1

      @@SuccessinHousekeepingByVijay Thanks.. How do you calculate HLP per room ? Can you share me your contact details..

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  3 роки тому

      @@SinghOfChrist 7561866642

  • @arunlalsingh9968
    @arunlalsingh9968 4 роки тому +1

    Very nice sir. Please make a vedio about budget.

  • @priyajitdas8712
    @priyajitdas8712 4 роки тому +1

    House keeping will prepare mis to show room cost which is very important .. hskp have various heads of expenses related to room cost

  • @ajaysaha9044
    @ajaysaha9044 2 роки тому +1

    Minibar PNL me last me PNL k bad ye konsa Consumption ka column hai?

  • @sanjitsahani1305
    @sanjitsahani1305 3 роки тому +1

    Thanks!!!

  • @ajayjoc223
    @ajayjoc223 4 роки тому +2

    Nice

  • @kamalsharma9018
    @kamalsharma9018 3 роки тому +1

    Should I go to MBA after completing Marriott voyger

  • @archanaaa2514
    @archanaaa2514 2 роки тому +1

    How to work on monthly, daily, weekly report in MIS? Plse explain with example..

  • @bimaldey1077
    @bimaldey1077 2 роки тому +1

    Can u tell me how to calculate about staff requirements

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  2 роки тому

      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.

  • @devendrarajgupta4764
    @devendrarajgupta4764 3 роки тому +1

    Sir your videos is amazing sir, I just want to know that how to figure out Per Room Cost ?

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  3 роки тому

      Thanks so much bro for supporting.
      Per room cost can be figure out by :- Total room expenditure / No. Of rooms occupied

  • @ankeshsharma8569
    @ankeshsharma8569 4 роки тому +1

    With the help of Mis we can easily find cost of each room and can control

  • @shishank-vu7jr
    @shishank-vu7jr 4 роки тому +1

    Tanx sir

  • @tripathiji9448
    @tripathiji9448 4 роки тому +1

    🤩

  • @indiandance6018
    @indiandance6018 3 роки тому +1

    Bhai agar 1 omr cost price hai per kg ka aur double bed sheet ka wait 1kg hai to chemical cost kiya hoga

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  3 роки тому

      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

    • @indiandance6018
      @indiandance6018 3 роки тому +1

      Bhai mera chemical cost 1 omr 10 gram ka aya hai ch 1omr+hlp 6.66=7.66

  • @bhadanarv4687
    @bhadanarv4687 3 роки тому +1

    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

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  3 роки тому

      Pls contact me through my instagram
      Vicky Joshi Vlogs
      Mai apko apna number instagram mai share karunga

  • @shishank-vu7jr
    @shishank-vu7jr 4 роки тому +1

    Sir pls make a video for annual budget

  • @abhayrathore1063
    @abhayrathore1063 4 роки тому +1

    Any difference occupied per room cost or cost per room

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  4 роки тому

      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.

  • @sudipghorai1872
    @sudipghorai1872 4 роки тому +1

    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.

  • @sudipghorai1872
    @sudipghorai1872 4 роки тому +1

    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??

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  4 роки тому +2

      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.

  • @bimaldey2517
    @bimaldey2517 4 роки тому +1

    Sir while calculating hlp 300kaha send aya kindly thoda bateyenge

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  3 роки тому

      HLP Cost apko apni Unit Consumption k according Nikalni hogi Maintenance & Laundry team ki help se

  • @lovelybadi2166
    @lovelybadi2166 3 роки тому +1

    Can you learn to housekeeping IDS knowledge sir please 🙏🙏🙏🙏

  • @hasmuddinsaifi9758
    @hasmuddinsaifi9758 4 роки тому +1

    Through MIS we can control our cost

  • @hemlatayadav4937
    @hemlatayadav4937 2 роки тому +1

    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

  • @mohitgaur5751
    @mohitgaur5751 4 роки тому +1

    Mis is to give manager feedback it is show actual data parformance and result

  • @aarifahmad206
    @aarifahmad206 3 роки тому

    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.

  • @nishkarshpatel3425
    @nishkarshpatel3425 Рік тому +1

    To control cost of operations

  • @nishkarshpatel3425
    @nishkarshpatel3425 Рік тому +1

    Sir bht tej bta rahe hein per topic video bnao with atleast 5exmple

  • @aminmahananda5254
    @aminmahananda5254 Рік тому +1

    Sir How to work out room cost

  • @amitverma-rs6ww
    @amitverma-rs6ww 4 роки тому +1

    Amit verma

  • @randhirkumar4180
    @randhirkumar4180 3 місяці тому +1

    Can we get soft copy of excel sheet

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  3 місяці тому

      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

  • @hemlatayadav4937
    @hemlatayadav4937 3 роки тому +1

    Hello sir I am hemlata Yadav Hk excitive I have to emprove my skills and knowledge can you halp me

  • @ansariaman8055
    @ansariaman8055 3 роки тому +1

    can I get this all excel sheets my Email. kindly let me know.

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  3 роки тому +1

      Ansari ji,
      The format i have deleated after uploading video.
      Lets sew if i make again then i will share it with u

  • @shaikhrehan2844
    @shaikhrehan2844 Рік тому +1

    Housekeeping course karna hai bhaiya sasta i h m college

  • @kedarmande4195
    @kedarmande4195 Рік тому +1

    Food cost 28%
    So Room cost kitana % Hona chahiye

  • @sureshsharma6016
    @sureshsharma6016 3 роки тому +1

    can you share this video file link

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  3 роки тому

      Bro, Its just a sample format which i have used to explain. you can ask me it through Google Drive.

  • @happiness6011
    @happiness6011 2 роки тому +1

    MIs Ka full form kya h sir

  • @Technicalparichalan666
    @Technicalparichalan666 2 роки тому +1

    sir. yi. report. Likhkar. samjao

  • @ashokkumar-qg8my
    @ashokkumar-qg8my 4 роки тому +2

    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.🙏

    • @SuccessinHousekeepingByVijay
      @SuccessinHousekeepingByVijay  4 роки тому +2

      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

  • @chandravijaysuryavanshi6971
    @chandravijaysuryavanshi6971 3 роки тому +1

    Hello sir aapk nubmer mila sakte hai kya sir mujhe aapk helap chahiye

  • @successinhousekeepingbymon8470
    @successinhousekeepingbymon8470 2 роки тому +1

    Nice sir ji

  • @AVINS1000
    @AVINS1000 4 місяці тому +1

    Contact number sir

  • @ektayadav8648
    @ektayadav8648 Рік тому +1

    sir pls share ur email I'd