Specification Documents

Specification Documents for my coursework 

Scope of the System: The system will be used an a daily basis, logging all sales and reorders so it can keep track of stock levels for each product so the user will know when they need to reorder. However, when the data is added to the system it will not yet go as far as automatically sending messages to the suppliers to reorder stock. This would have to be done separate. It would also automatically update stock levels, financial figures such as profit/loss and it would automatically print receipt templates that the user can fill out and give to the customer when a sale is made. However it will not go as far as automatically generating custom receipts for each sale that would not have to be filled out by the user. 

Objectives: 

• Automatically update stock levels
• Store all sales and orders made
• Store customer details
• Automatic financial figure reports produced 

In order for this to be successful and meet the objectives I would need to make sure each part of the business is made meeting the time constraints to ensure i am able to complete all objectives in time. I will also need to test each aspect of the system in order to be successful, making sure each objective is met. 

Timing: Time constraints should be implemented within the project to ensure that the project is met and completed in time., It will also provide motivation to get sections completed quickly in order to meet the deadline. A Gantt chart should be used to set the time constraints. 

Constraints: There is no budget for this task and the workforce contains one person. Therefore the project cannot cost to make and may take a longer period of time. 

Inputs: 

• Sales tables/forms to input sales information 
• Order tables/forms to input order information 
• customer information tables/forms to input customer information 

Output: 

• Financial figure reports
• Receipts 

Design Specification 

Purpose: Designed to track stock levels of each product automatically. 

Screen Layout and Templates: Each screen within the system follows the house style of the business: Norfolk Cricket Bat Co. using the colour scheme of black and white.

Data Structures: The data will be stored in structured tables each on separate worksheets, separating information.  

Inputs: Data will be input using set user forms with drop-down boxes and buttons to easily input information. 

Outputs: Printed receipts, digital financial reports including graphs

Validation: Validation would be implemented within the system to ensure errors do not occur. For example validation checks would occur when entering customer information to check whether phone numbers have the correct number of digits and email addresses have the '@' symbol in.