Process
- Finding a particular item is in stock or not – the person has to go through a lot of items to confirm whether the item is obtainable or not. This can be a long process and the customer will be left waiting. The employees will have to find a particular item manually. This is a long and strenuous procedure. Finally, stock controlling is carried out manually as well. They get part-time workers to count all the stock and double check it.
- Calculate each item cost =cost * quantity
- Calculate subtotal ?? show formulae
- Calculate tax ?? show formulae
- Add delivery charge ?? show formulae
- To calculate the receipt total – sometimes the cashier can get it wrong, therefore overcharging or undercharging the customer.
Output
- The re-order list – this has all the items that are needed to be restocked from the suppliers. To produce this it takes a long time, thus the proprietor has to count the items in the stock room.
- The receipt – the cashier has to write the item name and the price of the item, which is dated and given to the customer. This is time consuming as it is paper-based.
What about other reports such as total monthly sales etc – can be mentioned in evaluation
Storage
- All customer details, stock details and sales details are kept in a paper file which is then kept in a filing cabinet.
- Locating details in the filing cabinet requires the searcher looking through loads of files to find the appropriate information. As it is paper based it can be damaged very easily – it is very fragile.
Why computerisation will benefit the business?
As it is a busy grocery, the jobs are needed to be done quickly. The data needs to be better organized making is appropriate and efficient. Computerised invoices for goods or services provided better and quicker. A business needs to be computerised so it can be more successful in day to day trade. It will provide enhanced presentation of the organisation. Where there is better information so that decisions can be made easily. Plumbers are self reliant and would be easier and cost less in the long term if they stick to computerised systems.
New system
Input
- Stock Details
- Supplier Details
- Inputting all the customer details; items bought, the price they paid and when it was bought – this would be efficient and very fast. The person inputting would be much happier than writing on paper. This will have fewer errors, making it convenient. The data will be entered in directly by keyboard. The person can choose from a list of orders to restrict any errors. Initially, the system will need to be set-up only once. If there are changes (for example, Product Name or Product Code) they will be entered.
- Data Validation
The data in the system is going to be validated. This makes the system very efficient, therefore leading to fewer errors. These validation points are the end-user. One of its user requirements was to reduce stress by not knowing what to do. This will eventually reduce stress, because it will ensure there are no mistakes and will tell where they are going wrong.
Reproduce the tables above adding Validation column that specifies which validation can be applied to which field.
- Processing
- Finding a particular customer would be much easier in this method.
- Finding all male customers between the age of 16-19 years old – this would be very fast and would be accurate.
The input data will need to be processed into the required output. There will be various calculations carried out at this stage. The individual price of product will be added together to give the total price, plus the value added tax. Also, the money given by the customer will be deducted from the total price. Finally, the change will calculate.
When entering customer details it will made very easy. There will various menus and selections to choose from making it easy to navigate. The customer’s details will be entered in by keyboard (for example – First Name, Surname, Address etc). When this process is complete the system will save the information. There will be a similar sort of process for entering stock information of new or current stock. Furthermore, when in search of particular customer, there will be a search system which enables the user to find particular customer. The customers will have a unique identifier which will make even easier. The system will perform a search of the entire systems customer database. Then it produces a report of what it has retrieved. This can be saved or printed if the user desires.
- Output
-
The listing of all the items - Output Stock Report
- Item code
- Item name
- Item description
- Quantity
- Price
- Amount of stock left in the stock list
- Receipt
- Item Code
- Item Name
- Price of individual item
- Total Price of all items
- Cash given by customer
- Change given back by cashier
- Cashier Name
- Date and Time of purchase
- Storage
- The storage of all the customer information will be stored on a customer sheet. As it is a computer based system – this would be safer for storage. This is because it can’t be damaged, if it is, and then there will be a back up with no cost at all.
Sheet Name
Process Skill
Below is a list of skills that I will learn and going to have to learn during the project.
Spreadsheet Application
- the ‘IF’ statement
- lookup tables
- sorting data out
- general sorting
- linking worksheets
- produce graphs and formulas
- naming of cells
- Validation
- The use of macros
- Similarities/Differences in Old and Proposed Systems
The major similarity is that they have the same data to be inputted. The shop has the same stock and items that they sell. They will be on different formats, where it is proposed in the new system.
- Same Input Data
- Same figures
- Items
- Prices of Stock
- The data will be stored digitally
- The information can be encrypted
- Up-to-date stock listing
-
Instant cash turnover by sales reporting
- General System Objectives
- The new system should user friendly, easy to use interface. Making inputting easy by touch-screen, but can have optional keyboard.
- The proposed system should be automated as possible, without any intrusion.
- The should not crash and be reliable for its purpose
- Finally, the system should secure, not to have unauthorised access to gain personal details and other information.
- To Have 100% accuracy in calculations
7.1 Quantitative Indicator
- The system should keep over 40 items and 3 suppliers.
- The level of stock available or needed should be identified immediately, upon request.
- ?????
- ????
7.2 Qualitative Indicator
- The proposed system should calculate current stock levels, after sales.
- The system should be clear and easy to view.
- The new system should have accurate figures, regarding cash registers.
- End User requirements – User Specifications
Bullet points of end user requirements
Such as
- the user wants a menu driven system
- etc
- etc
The end user wants the system to save them time and money overall.
Also making the whole of the business much more efficient and smoother in its running.
They want to improve the customer service they give currently – faster and accurate survives. They will want to reduce the amount of stress caused by work. Finally the end user wants the proposed system to be simple and user friendly, so they don’t have to spend valuable time in learning how the new system works. Also it can be costly to send staff on a course as staff turnover is too much.
-
Performance indicators when the application runs
- The system should calculate total stock list with 100% accuracy.
- The system should be able to store at least 40 items of stock.
- The system should allow the user to input details of customer in 2 minutes maximum, (it currently takes 5 minutes in the paper based system).
- The system should be able to cope with 46 customer details.
10. Hardware requirements for the new system
The hardware required for the business, for the proposed system is the following:
- Touch Screen Monitor
- Electronic Tablet
- Network Cable
- Hardrive – 80GB
- Printer – print quality (black and white), landscape orientation, cartridges cost £40
- Scanner
The Business at this current time does not have sufficient hardware or software.
11. Software Requirements
The business will need to have a computer system, which is a reasonable price. It should have all the standard peripherals and generic software packages installed.
The following software that might be used:
- A spreadsheet application
- This has different functions which enable efficient use
- Calculations can be done easily
Cost
There will be an initial cost of setting up the proposed system, but in the long run it the solution will be reduction of the costs of the business itself. The end-user will want to save money as they will want make as much profit as possible. The user will want to cut down time consuming, so this system will perfect as it will quicker an much efficient than a secretary maintaining a filing cabinet full of records.
Menu Hierarchy
Designs
Main Menu Sheet
Customer Purchase Sheet
Receipt
Customer Records
Stock Management Sheet
Data security and Integrity
The system will have a range of security features which will prevent any unauthorised access. The system as a whole will have a password. This will be needed in order to start the program. The worksheets are protected; therefore modifying the software will be restricted.
There are going to be cells which can be modified but will need a separate password which is (modify). Once it is entered, then the user can change anything. The password will come back to action when the system is saved and closed. The system will have very good integrity as you will not be able to move copy or delete cells which are inappropriate. Furthermore, there are cells which are locked and cannot be used at all.
System development commentary
Main Menu
Customer Purchase
Receipt
Customer Records
Testing
Main Menu
Customer Purchase
Test Evidence
E10
E17
Evaluation
To evaluate the whole system was a success, with some problem which I overcome. The objective I stated before earlier in the project will need to address.
General System Objectives
-
The new system should user friendly, easy to use interface. Making inputting easy by touch-screen, but can have optional keyboard. – the system is very user friendly with arrange of buttons
-
The system should secure, not to have unauthorised access to gain personal details and other information. – The system has number of features as stated before. It is password protected and cannot be modified by unauthorised personnel.
-
To Have 100% accuracy in calculations – the calculation are automated and are accurate
Quantitative Indicator
-
The system should keep over 40 items and 3 suppliers. – The system can store up to 46 items and has at least suppliers.
-
The level of stock available or needed should be identified immediately, upon request. - The amount of stock each item has can found easily on the stock management sheet.
Qualitative Indicator
-
The proposed system should calculate current stock levels, after sales. – Unfortunately the system was going to be very complex and as I’m not an experienced and professional programmer, the macro coding. This has been scraped and does not work.
-
The system should be clear and easy to view. – The system is very clear and has a brilliant colour scheme that does not strain the eyes.
-
The new system should have accurate figures, regarding cash registers. – The receipts that the customers receive are very accurate and achievable.
End User requirements
The end user wants the system to save them time and money overall. Also making the whole of the business much more efficient and smoother in its running. They want to improve the customer service they give currently – faster and accurate survives. They will want to reduce the amount of stress caused by work. Finally the end user wants the proposed system to be simple and user friendly, so they don’t have to spend valuable time in learning how the new system works. Also it can be costly to send staff on a course as staff turnover is too much. – Overall I think a business that has no system will benefit from my system. It will defiantly make their business much more efficient and professional looking. It will provide fast and easier transactions.
Performance indicators
-
The system should be able to store at least 40 items of stock. – The system does store more than 40 items.
-
The system should allow the user to input details of customer in 2 minutes maximum, (it currently takes 5 minutes in the paper based system). – The system allows the first time user to enter customer details less than 1 minute. This is better than the previous set indicators set earlier in the project.
-
The system should be able to cope with 46 customer details. - The system deals with at least 46 customers and it has been very successful.
User Documentation
CONTENTS
- Before you install
- Getting Started
- General Features
- Navigation
-
How to do Transactions (Step-by-Step Instructions)
1.
This section displays the hardware requirements when using the program. The faster the processor and/or extra memory may increase the performance.
2.
- In order to use the program you will need the MS office package, more specifically MS Excel. Once the package is installed on your computer, you can access the program.
- Click on the icon ASTMS
- It will load and start on the Main Menu.
3.
This package is excellent for making your business much more profession and makes you more money, quicker. This is the complete package from stock management to printing a receipt for a customer. It is very user friendly. This will carry out all the account in the business.
4.
5. Step-by-Step Instructions
5. Continued