arun trikha 4706 10 mis hotel management project
TRANSCRIPT
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
1/27
Hotel Management InformationSystem A Study
Arun Trikha4706/10
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
2/27
Agenda
Introduction Hotel Ramee GuestLine
Questions on Hotel MIS system
Organization Hierarchy
Flow of MIS
Work Flow
MIS Project Details
POS system
Screens Layout
MIS Reports
Conclusion
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
3/27
Ramee Guestline Hotel - Juhu is a delightful boutiquehotel conveniently located in the heart of Mumbai'sfamous Juhu beach area, a short drive from both theairports and the railway station. Just 100 meters fromJuhu beach and within easy reach of Mumbai's new
commercial and entertainment centre.
Ramee Guestline Hotel - Juhu Maintains the traditionsof hospitality and service for which Ramee Hotels arerenowned the world over. The commercial and financialhub of India and a shopper's paradise, Mumbai is home
to a fascinating mix of traditions with an endless rangeof attractions from the ancient and modern world. The person which we interact was Mr. Milind (EDP
Manager for Juhu).
Introduction on Ramee Guestline Hotel
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
4/27
The following were the questions consider while gettinginformation
What is the hierarchy system of your company and the flow ofinformation?
what is the medium of coordination between inter department? What are the software used in the process? How does the MIS help the system ? How are able to calculate growth and profits in a certain period? Is there any updates done in the recent period to enhance the
MIS system? has it affected the organization? Is there any checks on the MIS system? Which are the levels of decisions taken at? Are there any back up plans? BCP ? securities?
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
5/27
Restaurant Manager
Main Chef Stores Manager
Accounts
Bar Manager
Disc Manager
Restaurant Manager
Restaurant TeamDisc TeamBar Team
EDP Manager
EDP Team
Organization HierarchyHierarchy
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
6/27
Flow of M.I.SFlow
StoresDept
FinanceDept
KitchenDept
I TDept
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
7/27
Restaurant Basic Work Flow Flow
Customer
RestaurantStaff
KOT
Order Interface
Kitchen Interface
Inventory Requirement
KitchenStaff
KitchenStaff
RestaurantStaff
Stores
Staff
Store Interface
Order against KOT
Bill
Requirement Send
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
8/27
MIS Project
The MIS-Project plays a major role
Maintenance of a master file (Details of Inventory)
Maintenance of databases
Maintenance of the Inventory records
Co-ordination between Staff to improvements in the workCycle
Co-ordination with the Finance to purchase or cash transaction
Sending periodic process based reports (Daily/Weekly/Monthly )
Showing Graphical trends of Growth, Volume( KOTwise/Inventory wise/Hotel wise)
Shows the revenue generated per day/week/month by Hotel
Shows difference between the potential revenue and the actualrevenue generated by the process
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
9/27
POS system from Fiesta Corp. Microsoft Windows operating system
Basic System which Can be used as Centralized Server LAN Network Client Server Application Routes/Switches Reports send to Head office as Excel file (System generated
reports on Crystal reports, which can be transfer in Excel file)
MIS Project (Technology & software used)
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
10/27
I.T. Manager
I.T. Executive 1 I.T. Executive 2 I.T. Executive 3 I.T. Executive 4
Roles :MaintenanceUpgradesI.T. Administration
DecisionsInstallationsSecurities
Permissions
I.T. ManagersProgram managersTeam managersM.I.S. Team
EDP Department
Software Windows 2000 server
Microsoft Outlook Cisco Routing Microsoft Office
I.T. Dept
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
11/27
KOT Kitchen Order Taken Layout
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
12/27
Define Menu, Outlets where they are sold, Selling Price at differenttimes.
Define Happy Hours.
Define Waiters, Order Cancellation Reasons, Cooking Instructions,
Selling Price Types, KOT Printing Locations, Types of Discounts,Check cancellation Reasons.
It allows the user to create and print KOTs at remote locations.Integration with core modules enables two-way communicationgiving access to billing instructions and online posting of checks toGuest Ledger. Integration with Inventory, Recipe Costing & F & B
Control modules provides management information for reordering,costing and variance monitoring.
Point of Sales
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
13/27
Define Time Limit For Hours (KOT)
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
14/27
Generate Bill (KOT)
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
15/27
KOT Recipe Details
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
16/27
Item Master (Inventory)
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
17/27
Stock transfer (Inventory)
k l l ( )
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
18/27
Stock Details on Outlets (Inventory)
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
19/27
Accounting MIS - I
Account Balances (Accounts)
L d D il (A )
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
20/27
Ledger Details (Accounts)
P h V h (A t )
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
21/27
Purchase Voucher (Accounts)
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
22/27
Consumption by product and by category Inventory value by product and by category Consumption compared to sales by category Combined inventory value of locations and stockroom
Product list by sequence
Purchase orders by Supplier Stock Receipt reports for each Purchase Order Request and Issues reports for activity between Storerooms and Sales
Centers. Product list by cost price Product list by sales price Full/empty bottle weight list
Discontinued product list Value on hand for combined product locations Consumption compared to sales by category
Products below PAR by supplier
MIS Report
R (MIS)
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
23/27
Revenue summary (MIS)
A dit T il R t (MIS)
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
24/27
Audit Trail Report (MIS)
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
25/27
Conclusion
Flow of MIS/Data is a continuous chain Flow of information varies at various levels Prime decisions are done at top level management Smaller level decisions are done at every supervisory level There are several rooms for improvements for co
ordination to minimize the turn around time for tasks More innovations/ideas will certainly improve standards
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
26/27
Suggested Report (MIS)
Date
Mode KOT BAR Guest System Liquor Disc
Debit 1452 87546 2555 54866 4445
Master Card 215668 2121 21216 45424 474
Visa Card 1212157 3256 242 44 545
Cash 45656 445 548254 242 5454
Credit 240 0 0 0 0
Total 1475173 93368 572267 100576 10918
Suspended Amount 5000 484 700 0 0
Staff used 250 100 0 400 0
Total revenue for Day 1469923 92784 571567 100176 10918
Daily Collection report
-
7/28/2019 Arun Trikha 4706 10 MIS Hotel Management Project
27/27
Thank you