The Need of an Upgraded System for Kudler Fine Foods
Kudler fine Foods are in dire need of an upgraded system as well as a better constructed database. It is recognized that there are three stores involved, and downtime is unacceptable. This document will outline the requirements needed from different section, such as Marketing, Human Resources, and Management to name a few. Currently, there is a collection of information, but many of the systems are not automated. We will outline areas that we feel need improvement. Information storage is perhaps one of the most critical aspects of a business. So, it is imperative that the business have a well organized and reliable database so each section can extract the proper information when needed.
Marketing and Purchasing
The marketing department has been encouraging the purchasing department to try to reduce costs of ordering food as well as incorporation a zero out-of-stock policy. Purchasing has made small steps by implementing a supplier relations program, but this could go further. Using the point of sale system that updates the items on-hand as sales happen in real time, and also establishing quantities at which orders can automatically sent to purchasing will further ensure that the stores will not run out of any particular items.
Marketing’s new initiative is tracking the purchase habits of the individual customers. This will help the stores offer the most wanted products, which is one of Kudler market areas. Instead of offering discounts Kudler has teamed with other stores and businesses such as airlines, gift shops, etc…offering points to its customers that can be redeemed at said stores. The database will need to uniquely track individual customer purchases so the points will accumulate on the correct customer account. Information from the purchases will also be extracted by purchasing, and marketing to more effectively place ordering, keeping costs down, and marketing to better provide the customer with the specialty products they demand.
Human resources currently uses Excel spreadsheets, and for some instances a paper trail that is under lock and key. Using the same database with security privileges set so only authorized personnel will be able to access this portion of the database. Information that will be kept in this area will be results of job analyses, salary surveys, and individual compensations. The Human resources assistant will be able to use the database to store files that are currently tracked by paper, which is not a bad idea as a back-up. The data collected can be queried in many ways making the information more useful. The assistant will be keeping information about complaints and grievances as well as other sensitive type data. Again, this area of the database will have limited access for the personnel that require retrieving such information. Keeping this type of information in a database which can be easily queried will be able to...