Course Description:
This module is designed to train students in managing hotel inventory — from stock receiving to consumption tracking — using a digital Inventory Management System (IMS). By the end of 8 weeks, students should be able to handle inventory workflows confidently.
Week 1: Introduction to IMS & System Navigation
Objective: Familiarize students with the IMS dashboard, categories, and item master setup.
Workflow Focus: System Orientation & Item Setup
Hands-on Exercise 1:
Log into the IMS using student credentials.
Explore the Dashboard and identify key metrics (e.g., Low Stock Items, Total Inventory Value).
Navigate to Item Master and create 3 inventory items: Bath Soap, Mineral Water (500ml), and Coffee Sachet.
Assign each item to the correct category (Housekeeping Supplies, F&B, etc.) and set a reorder level.
Week 2: Stock Receiving & Purchase Orders
Objective: Learn how to create purchase orders and receive deliveries into the system.
Workflow Focus: Procurement & Receiving
Hands-on Exercise 2:
Create a Purchase Order (PO) for 200 units of Bath Soap and 500 units of Mineral Water from a supplier.
Simulate the delivery by posting a Goods Receipt against the PO.
Verify that the inventory count updated correctly after receiving.
Generate a Receiving Report and review the supplier details.
Week 3: Stock Issuance & Departmental Requests
Objective: Process stock issuance to different hotel departments.
Workflow Focus: Stock Issuance
Hands-on Exercise 3:
Create a Stock Issuance Request from the Housekeeping department for 50 units of Bath Soap.
Approve and process the request. Verify the inventory decreased accordingly.
Issue 30 units of Coffee Sachet to the F&B Department.
Generate a Daily Issuance Summary Report.
Week 4: Stock Adjustment & Physical Count
Objective: Understand inventory adjustments for variances found during physical counting.
Workflow Focus: Physical Inventory & Adjustments
Hands-on Exercise 4:
Conduct a simulated physical count of all items in one storage room.
Identify 2 items with variances (e.g., 5 units short of Bath Soap due to breakage).
Post a Stock Adjustment entry with the appropriate reason code (e.g., Damaged/Loss).
Verify the adjusted quantities in the inventory report.
Week 5: Low Stock Alerts & Reordering
Objective: Monitor inventory levels and generate reorder suggestions.
Workflow Focus: Stock Monitoring & Alerts
Hands-on Exercise 5:
Set a reorder level (minimum quantity) for all 3 items created in Week 1.
Simulate stock consumption until one item falls below the reorder point.
Review the Low Stock Alert list on the dashboard.
Create a new Purchase Order based on the system's reorder suggestion.
Week 6: Inter-Department Transfers
Objective: Process stock transfers between storage locations or departments.
Workflow Focus: Stock Transfer
Hands-on Exercise 6:
Transfer 20 units of Mineral Water from the Main Storeroom to the Restaurant Storeroom.
Confirm the transfer in the receiving department and verify both locations updated correctly.
Generate a Transfer Report for the transaction.
Week 7: Inventory Reports & Analytics
Objective: Generate and interpret key inventory reports for management decision-making.
Workflow Focus: Reporting & Analytics
Hands-on Exercise 7:
Generate a Stock Ledger Report for Bath Soap showing all transactions for the month.
Generate a Slow-Moving Items Report and identify items with no movement for 30+ days.
Compute total inventory value and present a summary to the class.
Objective: Apply all weekly learnings in a continuous real-world inventory scenario.
Workflow Focus: End-to-End Inventory Operations
Hands-on Exercise 8 (Simulation Scenario):
The Scenario: You are the Storeroom Supervisor. A new delivery has arrived, departments are requesting supplies, and you need to close the month with an accurate inventory count.
Receive a delivery of 3 different items via a new PO.
Process 2 departmental issuance requests.
Conduct a physical count and post any necessary adjustments.