Design and Implementation of Supermarket
CHAPTER ONE
Objective
- To study the functions of Supermarket management system.
- To explore the challenges being faced by the manual system.
- To make a software fast in processing, with good user interface.
- To ensure accurate statistics of product item.
- For Easy record of goods in store and proper identification.
CHAPTER TWO
LITERATURE REVIEW
Introduction to Supermarket
A supermarket is a large form of the traditional grocery store, it is a self-service shop offering a wide variety of food and household products, organized into aisles. It is larger in size and has a wider selection than a traditional grocery store, but is smaller and more limited in the range of merchandise than a hypermarket or big-box market.
The concept of an inexpensive food market relying on large economies of scale was developed by Vincent Astor. He founded the Astor Market in 1915, investing $750,000 of his fortune into a 165 by 125 corner of in the famous 95 Manhattan avenue, creating in effect, an open air mini-mall that sold meat, fruit, produce and flowers. The expectation was that customers would come from great distances (“miles around”), but in the end even attracting people from ten blocks away was difficult, and the market folded in 1917. The concept of a super market was developed by entrepreneur Clarence Saunders and his Piggly Wigglystores. His first store opened in 1916. Saunders was awarded a number of patents for the ideas he incorporated into his stores. The stores were a financial success and Saunders began to offer franchises. The Great Atlantic & Pacific Tea Company, which was established in 1859, was another successful early grocery store chain in Canada and the United States, and became common in North American cities in the 1920s. The general trend in retail since then has been to stock shelves at night so that customers, the following day, can obtain their own goods and bring them to the front of the store to pay for them. Although there is a higher risk of shoplifting, the costs of appropriate security measures ideally will be outweighed by reduced labor cost.
Historically, there was debate about the origin of the supermarket, with King Kullen and Ralphs of California having strong claims. Other contenders included Weingarten’s Big Food Markets and Henke & Pillot. To end the debate, the Food Marketing Institute in conjunction with the Smithsonian Institution and with funding from H.J. Heinz, researched the issue. It defined the attributes of a supermarket as “self-service, separate product departments, discount pricing, marketing and volume selling.”
CHAPTER THREE
SYSTEM ANALYSIS AND DESIGN
Analysis of the Existing System
The current system operates manual supermarket management system, from stocks, products, ordering and purchases etc. recorded in a book. This is faced with errors, incompleteness, and insufficient data for analysis. Information regarding stocks, products, sales and purchases are still in black and white which is not properly organized and managed. From the wholesalers to retailer bills, tickets, vouchers, receipts of products are recorded in a book but further operations are not being properly handled. As a result it is difficult in processing, updating and managing.
The factors for these difficulties are:
Labor-Intensive: A manual Super Market management systems is that they can be highly labor-intensive to operate. They require continuous monitoring to ensure that each transaction is accounted for and that products are maintained at the appropriate stocking levels. It is also more difficult to share inventory information throughout the business, because the lack of computerization makes accessing inventory records a more cumbersome process. The time spent monitoring inventory levels could be used on more productive activities for the business.
CHAPTER FOUR
SYSTEM IMPLEMENTATION AND DOCUMENTATION
System Implementation
This chapter is the part that puts a planned system into action and examine in details the analysis and design of the Skillmid supermarket system. The present chapter discusses the implementation of the system, highlighting the testing exercise and describing some of the main components of the system’s Graphical User Interface. It will give an output from programming language and other tools used to develop our system. According to this plan, the activities are to be carried out, discussions made regarding the equipment and resources and the additional equipment has to be acquired to implement the new system.
CHAPTER FIVE
Conclusion and Recommendation
Conclusion
In conclusion, Supermarket Management System has to do with making appropriate effort to stop the rising problem to all manual supermarket operation in order to enhance the operation of such supermarket. In this project, the software or system that can be used to aid all supermarkets that is still operating manually have been successfully developed. The software can be implementing in all types of supermarket as mentioned in the second chapter. The software has a large memory of storing all the goods in the supermarket and also keeping record it is highly effective and accurate.
Recommendation
In the development of this supermarket management system, I will recommend that if there is going to be any modification the new writer should endeavor to improve on the limitations such as inclusion of the billing and printing to further increase the system architecture and to satisfy users need more for writing of the source code, visual studio 2012 should be used and Microsoft access for the database. There are some limitations during the development of this supermarket management system that will require improvement as stated in previous chapter writer should put them in mind and face it as a challenge and not a problem.
Problem Encountered
A lot of challenges surfaced during the development of this incredible application though it tried stopping this project but the doggedness and consistency of the writer was in match with the challenge
The following are some of the problems or challenges encountered.
- Expensive internet facility.
- Understanding the M.S ADODC (Active X Data Object Data Control).
- Inadequacy of power supply and many more.
- Time factor on research to get a way of packaging the application successively.
Further research
In the future, the following components can be added to the system in order to improve the effectiveness and efficiency of the system, which includes:
- An advanced password system that will be embedded into all login pages to increase the security of the system.
- A good Printing module should be included.
- A good internet backup should be automated after everyday sales.
- Internet Transactions should be allowed.
REFERENCES
- Ballou, R.H. (1999). Business Logistics Management: Planning, Organizing and Controlling the Supply Chain, 4th ed., Prentice-Hall International, London.
- Billington, C., Callioni, G., Crane, B., and Ruark, J.D., et al, (2004) “Accelerating the Profitability of HewlettPackard’s”
- Supply Chains”. Interfaces. Linthicum Breugelmans, E., Campob, and K., Gijsbrechts (2006).
- “Opportunities for active stock-out management in computerized stores: The impact of the stock-out policy on computerized stock-out reactions © 2006 New York University. Published by Elsevier Inc.
- Bucklin, L.P. (1965). “Postponement, speculation, and the structure of distribution channels”, Journal of Marketing Research, Vol. 2 No. 1.
- Bowersox, C. (2009). “Inventory Speculation: Cause and Effect”, Ohio, United States 89511
