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.