this system will limit the need for human management.
The user needs to have basic knowledge of using Microsoft Access and basic
knowledge or running a computer. I will include a general instruction manual to
allow the users to link their knowledge; it will be basic and not too advanced.
The security and data protection will have a password protection system that
only the employees working at the shop can obtain.
The input of the system will be the stock previously ordered, this would be
stored data. With the process calculating the stock and the output will be the
available stock left in the shop.
OBJECTIVES
Ø The new system should be user friendly.
Ø Stock level should be automatically updated when processed.
Ø An order of stock should not take more then a minute to process.
Ø User interface will need to be spontaneous as the end users may not be
advanced users of ICT or the databases involved.
PREPARATION
I have found an organisation and have based my project on them and have
discussed it with them in detail and have reached an agreement.
I outlined the project and the critical problem to the organisation in an
informal discussion and obtained consent from both my teacher and the
organisation to carry out my new system and project. Both have agreed that my
project has suitable depth to obtain a competent mark.
FOOD ORDERING SYSTEM
The business is located in Kingsbury, London has around 10 or so employees that
do a specified task on a daily basis. For Example, a few employees prepare the
food and a few handle the financial side to the organisation. On average around
100-120 customers per night depending on reservations or not. The business uses
invoices as a form of information and uses receipts for take away customers.
The problem the business is having is a stock check every week, which is
occasionally inaccurate and very time consuming and could lead to human error. I
intend to solve this by creating a system which will be used for eating in and
take away orders it will be a food ordering system and it will keep stock of how
much food is available in the restaurant and when it goes below a certain level
the system will re-order stock automatically.
The main problem I will tackle is convenience for the staff, as my system will
repeatedly order stock after a certain level of monitoring.
My overall aim in this project is to create an automated food re-ordering
system, which will verify the level of availability of stock for the restaurant.
The business I am following uses large amounts of data as there are endless
stock to monitor and order. I will process this information to make it easier
for the business as well. I will carry out research on how the business also
deals with the stock and how it functions manually.
The completed IT solution must be able to process the routine needs of the
organisation:
Ø Store information about the available stock.
Ø It will keep records of transaction and invoices for the business so it can
refer to the available stock.
HARDWARE
There will be many limitations in this business as the available hardware at the
organisation location is very tedious as the computer is not very swift and not
up to date and this may jeopardise the efficacy of my new modern system.
Also the software they have is not up to date and my system requires the latest
version of Microsoft Access to fully utilize the potential of my system.
Therefore I will urge the organisation to purchase a copy of the software and
this will help my system and erase any problem internally and externally in the
business.
INPUT, PROCESSING AND OUTPUT (not finished)
The input will include how much stock was ordered on previous checks, it would
include the customer’s invoices and receipts, number of customers, etc. The
processing will use the customer’s invoices and receipts to check how much stock
was consumed. Output will be the data that I will be able to interpret and will
show me the amount of stock left in availability so I can create a system that
will allow me to order stock when it is required for re-order.
INTERVIEWS
I will arrange an interview with one member of the staff who will be the end
user and be the tester for my new system and check if it is a success. I will
arrange the interview on a weekend and it will take place in the organisation
itself.
I will ask the following questions to my end-user:
What current problems do your old system on stock have?
How do u re-order stock? Do you have any schedule for re-ordering or do you just
re-order when there isn’t any stock available? Explain how you order your stock?
Do you feel your system is proficient or can there be improvements?
What do you feel about my new automated system?
How do you think my new system will help this organisation?
What advantages and disadvantages do you think my new automated system will have
over you old manual system?
QUESTIONNAIRE
I will also carry out a questionnaire for the employees of the workplace so I
can get their opinions on my new system and how it will benefit the
organisation.
Do you agree that making the old system automated will help the business?
YES NO
What system would you prefer to work with?
OLD MANUAL NEW AUTOMATED
What skill level do you think you have on information technology?
BASIC INTERMEDIATE ADVANCED
