Date of Award


Document Type


Degree Name

Master of Science in Computer Science


School of Computer Science and Engineering

First Reader/Committee Chair

Quingquan Sun



Grocery stores using Excel for managing sales and stock management could involve maintaining separate sheets for sales and stock data, with revenue/cost. This system could provide a basic level of tracking and analysis, allowing the grocery store to monitor sales trends and stock levels. However, using Excel for this purpose is not without its challenges. For example, the manual nature of data entry in excel can result in errors and inconsistencies, particularly if multiple people are involved in maintaining the sheets. Additionally, as the volume of sales and stock data grows, the Excel spreadsheet can become unwieldy and slow, making it difficult to extract meaningful insights. Furthermore, Excel does not offer real-time updates or integration with other systems, such as point-of-sale (POS) systems, which can lead to inaccuracies and inefficiencies in the sales and stock management process. These limitations highlight the need for a more robust and integrated solution for sales and stock management in a grocery store.