Date of Award

8-2023

Document Type

Project

Degree Name

Master of Science in Computer Science

Department

School of Computer Science and Engineering

First Reader/Committee Chair

Quingquan Sun

Abstract

ABSTRACT

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.

Share

COinS