Inventory Tracking

Challenge

This hospitality business were having trouble with time consuming manual tracking of stock & maintenance activities across 300 rooms. Including regular items like soaps, coffee and tea, and materials required to fix issues like a leaking tap or broken light.

The existing process was managed on paper with job sheets & stock lists updated as each room was refreshed with stock each day. The administration team then reconciled the stock to purchase orders & manually wrote invoices for rooms owned by investor.

Solution

Automation of this process was the solution. A central excel workbook was created to store all stock used by the cleaning staff to record used items per room to be replaced.

The stock details including the price and supplier were recorded into the spreadsheet from which reports were run to generate purchase orders for replacement of any items that were running low on stock.

Benefits

Time saved per month by the administration team. No more manual paper based reconciliation needed

Improved cashflow due to the automated generation of invoices for the investors.

Improved level of service for guests with the ability to maintain stock levels for all rooms consumables, cleaning and room maintenance.

Gallery

1/4

Video Demo