Thursday, January 13, 2011

Requirement Analysis an Inventory System Problem

Hospital Muar provides medicines to patients and there are also 10 Klink Desa in Muar that receive supplies from Hospital Muar. XY Pharmacy supplies the medicine and delivers it to Hospital Muar and to the 10 Klinik Desa.

When ordering , Klinik Desa has to order through Hospital Muar for authority processes. The supplier will deliver the supplies directly to Klinik Desa but they often has the problem of receiving less than they ordered through Hospital Muar.




The procedure involved in the process is Klinik Desa will order from XY Pharmacy but it have to go through Hospital Muar for authorization. But , Hospital Muar can order straight from the supplier that is XY Pharmacy. In the process of ordering , Klinik Desa will send purchasing order form to Hospital Muar and the hospital will check the form and approve the purchasing order. After the purchasing order have been approved , the purchasing order form will be send to the supplier which is XY Pharmacy.

Then XY Pharmacy will send the invoice to Hospital Muar and Klinik Desa. XY Pharmacy then will send delivery note to both Klinik Desa and Hospital Muar. After a right amount of time , the supplies will be send to both Klinik Desa and Hospital Muar and the receipt will be given upon receiving the suppplies.

The technology and solution that we will be using is to develop the procedures using online systems. Compared to the old systems that using forms as a media to communicate that is to order , get authorization , delivery note and receipt , the new systems will also be using the form but the form is in the online based. For example if Klinik Desa want to order supplies they just have to login to XY Pharmacy page and key in what supplies they need but first they have to get confirmation from Hospital Muar and to get confirmation they have to go to Hospital Muar page and write down the supplies they need and the hospital will send confirmation to them. After that they can continue to order from XY Pharmacy and the cycle is repeated if they want to order new supplies.

To order medicine from the supplier, which is XY Pharmacy Klinik Desa and Hospital Muar can just using an order form that can be obtained at XY Pharmacy website. For Hospital Muar they can just order the supplies of medicine they need but Klinik Desa have to get confirmation from Hospital Muar first before they can proceed to order the medicine supplies. Both of this customer can just simply go to XY Pharmacy website and order the medicine supplies they need without going to XY Pharmacy to order. This will save both the customer and supplier time that they can use to do or concentrate on other things.

To keep track of the inventory, all of the entities such as Hospital Muar, Klinik Desa and XY Pharmacy will have to use or develop a software that can save, record , delete and update every supplies of medicine and other things that being ordered or sent. This software will record and save every log or every details about what is going on and what will be happen from time to time. By doing this alot of problems can be avoided such as tracing back missing item, retracing back what is the problem, and also can make the inventory system more neat and tidy and also can avoid errors or mistakes.

The database that we used to record the information is Microsoft Access.

The methodology that being used is prototyping methodology. This because the system is using a web based development and by using this methodology we can test the system for a while and if there is an error occured , we can throw away the previous design and start with a new and better design and functions.
By using this methodology we can also save a considerable amount of time by reducing re-work as the users see the product for the first time.

User Interface Draft 



This is a login form for our system and this form is used by all 3 entities that is XY Pharmacy , Hospital Muar and Klinik Desa.

 

This is an order form for our system that is used to order the supplies of medicine. This form is used by Klinik Desa and Hospital Muar.


This is an supply form that being used in our system and this form is used by supplier that is XY Pharmacy.



This is the database for Hospital Muar that being used to store imformation of the medicine , the description of the medicine, the date of the medicine arrived in the hospital and the quantity of stock.




This is the database for Klinik Desa and is used to store information about the medicine, the description of the medicine, and the quantity of stock.




This is the database for XY Pharmacy and is used to store medicine information, description of medicine and quantity of medicine stock.

Gantt Chart


This is the gannt chart of our project from that will take approximately about 80 days to complete and consist of several steps such as discussing the topic, creating the blog, following the project flow, analyzing the problem, designing the application interface, building interface and database, linking the coding with database and completing the coding, submitting the final report and lastly the final presentation.

Thursday, January 6, 2011

Project Overview

Our project consist or our main focus of this project is to develop an inventory system of a small organization of our choice and our group choose a car accessories company as the organization and we will be studying their inventory system. We will try to understand more of what their company sell or supplies to their customer and we will try to improve or upgrade their system so it will be better and efficient. By combining our group main focus and the group name we named our project as Pioneer Car Accessories.

The mission of our project is to build a system where the supply of goods and the stock management will run properly and smoothly.


The objective of this project is to improve the quality of goods that being sold in the shops. Furthermore we also try to reduce the difficulties in handling any stock in the shop. Lastly we also want to increase the use of computers in business management.


The scope of our project is intended to be carried out regularly to conduct business using a system built so that work can be carried out with ease. Our approach to inventory is one of the examples of industry operations management. This system consists of suppliers, warehouses and customers.

Group Members Introduction

Our group name is Pioneer.

The group leader is Nurul Shazani Binti Sahidan from Gurun, Kedah. She have finish her diploma in Computer Science (Information Technology) at UTMKL. She have various of programming skills such as Java, C++, C, Visual Basic, and HTML.

The other group member is Mohamad Izzuddin Bin Mohd Rezmi from Petaling Jaya, Selangor. He also have finish his diploma in Computer Science (Information Technology) at UTMKL. His programming skills included  Java, C++, C, Visual Basic, PHP, and HTML.

The last member of our group is Mohd Syafiq Bin Sulaiman from Johor Bahru, Johor. He also have finish his diploma in Computer Science (Information Technology) at UTMKL. His programming skills included Java, C++, C, Visual Basic, and HTML.