Bottle Royale The current project is developed to tackle the problem presented by GateGroup global food and hospitality company about "Alcohol Bottle Handling" during the HackMTY 2025.
Problem Introduction Provided by GateGroup:
Current Description Alcohol bottle handling rules change among different client rules and agreements established on their contract.
The possibilities to handle a specific bottle depend on:
Client Policies (might or not be limited to a specific fill level) Fill level (0-100%) Seal status (Sealed / Opened) Label Status (Intact / Slighly Damaged / Heavily Damaged) Bottle Condition (Poor / Acceptable / Excelent) Cleanliness Score (Poor / Fair / Good / Excelent)
Due to this confusion, the employees responsible for handling the alcohol bottles after the catering event has ended (E.The plane arrived to its destination) are confused and many times take decision based on judgement without a set standard even though the rules are shown to them; leading to irregular results and unconsistencies.
Challenge Design a software approach that can help automate these decisions so employees certainly know the right action to take based on the client guidelines. Securing efficiency and compliance with chosen rules in benefit of GateGroup and its clients.
Development Assumptions Based on the information collected from the multiple interactions, questions and talks with the representatives of GateGroup at the HackMTY2025 the following assumptions have been taken:
GateGroup company has a database of Employees and keep record of their information and the facility they work at. * GateGroup is responsible for setting an account for the employee to use at the presented application, reason why a Sign In is not implemented in the Log In page. GateGroup company has a database or has access to a database that keeps an updated record of the multiple flights of que associated airlines. * The greatest problem to tackle is the reduction of the human inconsistencies among the desicion taking processes. There are only two processes available to perform with an opened alcohol bottle for GateGroup: discard or keep, based on determined ranges. Beer, wine and small alcohol bottles are always discarted. At no moment any kind of licor of any brand is combined in order to save space into the same bottle. Instead, each kind of licor is maintained within each its original container only adding several bottles in order to meet client licor requirements, each on its individual container.
- = Provitional Database has been created for testing purposes.
Solution Approach Through a progressive web application we present a product for the employees handling the alcohol bottles after events.
Based on the client, by registering each alcohol bottle to manage through:
Interactive Forms Strategic recolection of data that is filtered thanks to the selection of Airline and Flight Entities, to obtain specific rules that determine the final decision of a determined alcohol bottle.
Additional registration of the bottle size, licor type, brand, and upload of photography (analyzed through an object classification to determine fill level) leads to the decision making process which has been defined taking into priority regulations in the following level:
National Regulations Airline Regulations Or any of which is the strictest regulation.
PyTorch Machine Learning to make an object categorization. Model of Machine Learning developed in PyTorch trained with an approximate total of 100 images classified in four clusters that divide alcohol bottles into four main categories of fill level (0%-25%, 25%-50%, 50%-75% and 75%-100%) in order to determine a fill level for an image taken by the user eliminating the human approximation from the interaction.
The system determinates and shows the proper action to be taken on screen based on client policies, and registers each handling performed by the employee based on the bottles of a specific event.
Log in or sign up for Devpost to join the conversation.