They introduce themselves as a leading producer of top quality poultry feed in Pakistan. The company emerged under the name of Asia Poultry Feeds as a private limited concern in 1993. Since then it has proved itself as a market leader in quality by applying the latest scientific concepts in poultry nutrition and is enjoying a very high reputation as an efficient and a fast growing company.
The company started its production with a small plant… only producing 7,200 tons feed per year and just with in 7 years period they are producing more than 48,000 tons feed per year. Now they have equipped themselves with a new state of the art pelleting plant along with its infrastructure capable of producing 60 tons poultry feeds per hour. The plant has been installed by M/s Buhler AG, Switzerland. Buhler is a globally acknowledged engineering company known to be a big name in supplying feed plant throughout the world. This plant is the biggest and latest plant in the subcontinent.
They produce nutritionally balanced feed and for this purpose their poultry nutritionist are well in touch with the latest nutritionally concepts which are being applied all over the world. All these ideas are being put into practice along with the local adjustments to fulfill the specific nutritional requirements.
Strict quality control is maintained during all stages i.e. from the purchase of raw material to the final product. They produce constant quality round the year. A very well equipped in house laboratory is maintained for this purpose.
They use following ingredients in their poultry feed:
- Maize
- wheat
- Rice / Paddy
- Sorghum
- Rice Polish
- Fish Meal
- Guar Meal
- Soybean Meal
- Sunflower Meal
- Canola Meal
- Rapeseed Meal
- Cottonseed Meal
- Corn Gluten Meal
- Di Calcium Phosphorus
- Marble Chips
- Sugarcane Molasses
- Sodium Bi Carbonate
- Salt
- Cooking Oil
- Vitamin Mineral Premix
Poultry Feed Brands
1. Chick Starter Mash
2. Grower Mash
3. Layer Mash
4. Broiler Starter Mash
5. Broiler Finisher Mash
6. Breeder Starter Mash
7. Breeder Grower Mash
8. Breeder Mash
9. Layer Chick Crumbs
10. Grower Crumbs
11. Layer Crumbs
12. Broiler Starter Crumbs
13. Broiler Finisher Crumbs
14. Breeder Starter Crumbs
15. Breeder Grower Crumbs
16. Breeder Crumbs
17. Pre Breeder Crumbs (6-17 Weeks)
Packing
Net weight 50 Kg (At the time of packing) in new Poly Propylene Bag.
Cattle Feed Brand
1. Milky Vanda
2. Fattening Vanda
Packing
Net weight 40 Kg (At the time of packing) in new Poly Propylene Bag.
Current system
The current system of Asia Feeds is manual. When order of customer is placed, it is completed in a following process.
Ø Order is received through phone, fax or mail.
Ø Clerk checks the order. Order includes customer name, quantity, and destination.
Ø GM checks the previous record of customer.
Ø Sometimes MD is also involved in this process, if previous record of company is not good.
Ø Order is singed by GM.
Ø Order is sent to the delivery officer (D.O)
Ø D.O sends three copies of orders to 1. Assistant sales officer, 2. Factory, 3. Accounts Dept.
Ø Assistant sales officer arrange the vehicle, and he also calls the factory that includes vehicle number, brand name and quantity.
Ø Required amount of feed is then sent to the customer.
Ø Quantity is sent through FOB destination.
Current system
Problems of current System
There are some problems in the current system. They are using traditional tools for maintaining their system. They are facing the following problems.
Ø Data Redundancy
Ø Costly System
Ø Unaccuracy
Ø Finding Errors is difficult
Ø Data Redundancy
More than one person is involved in maintaining the same data.
Ø Costly System
Existing system is very expensive in terms of time and cost.
Ø Unaccuracy
Existing system is also unaccurate.
Ø Finding Errors is difficult
If there is an error in the system then it is very difficult to find the error where it has been taken place.
Scope of problem
Data Redundancy is the main problem faced in this existing system. They have to maintain the same type of data at many places. This Data Redundancy creates problems. One problem is that it increases time and cost. Data Redundancy also makes it difficult to fetch an error. When an error occurs. It becomes very difficult to fetch the error. They do not know where the error has been occurred.
Alternatives for Problems Solving
For the solution of the problems mentioned above, we propose the following two alternatives:
1. LAN ( Local Area Networking )
2. WAN ( Wide Area Networking )
1. LAN ( Local Area Networking )
They can solve their problems by connecting their offices through Local Area Networking.
Local Area Networking is privately owned communication network. That serves user with in the confined geographical area. The range is usually with in a mile perhaps one office, one building or groups of building closed together.
3. WAN ( Wide Area Networking )
They can work more efficiently by using WAN. By using WAN they can connect their head office directly to their factory.
Wide Area Network is a communication network that covers a wide geographical area such as state, city or country.
The best use of WAN is in the shape of MAN (Metropolitan Area Network). It is a communication network covering area the size of the city.
Pros and cons of the alternatives
The advantage of networks is that they can use the same information and can also use the same software.
Advantages of LAN:
Ø By connecting their system through LAN their efficiency will be increased.
Ø Data Redundancy problem will also be solved by Local Area Network.
Ø It will also reduces the time spend on the same work alone by different people.
Ø LAN is also less costly as compared to the WAN.
Disadvantages of LAN:
Ø But the cost of introducing LAN will be more as compared to their current system.
Ø LAN is not covering as much area as covered by WAN.
Ø Through LAN they cannot connect their system to their factory directly.
Advantages of WAN:
Ø They can directly line their factory to their head office by using Wide Area Network.
Ø Customer can access the database from any where in the world.
Disadvantages of WAN:
Ø The cost of WAN is very high. It is also very complex.
Ø They have to hire a technical person for the implementation of WAN.
Selecting the Best Alternatives
We are using Local Area Network (LAN) technique for computerization. The type of LAN we are using is STAR Network.
A Star Network is one in which all microcomputers and other communication devices are connected to central server. The advantage of Star Network is that hub prevents collisions between messages.
If connection is broken between any communication device and hub, the rest of the devices on the Network will continue operation.
Cost and Benefit Analysis
In this step we will prove that our proposed system is beneficial for the firm.
We will prove it in two ways:
1. In term of qualitative factor
2. In term of quantitative factor
1. Qualitative Factor
Our proposed system will increase the efficiency of the firm’s processes in terms of time and cost, and it will also decrease the redundancy. The very little redundancy is due to the fact that we are using LAN and not WAN, because WAN is expensive and complex with respect to the firm’s resources.
It will decrease the manual work that means chances of error will very less.
2. Quantitative Factor
Now we will see the cost (quantitative factor) of the proposed system.
Five computers are required for firm according to their office’s location. The expenditures of computers and other network tools are following:
Detail in terms of cost
1-Server Pentium (III)
Intel (800) processor……..8000 Rs.
Intel mother board ……….7500 Rs.
Ram (256) mb……………...2100 Rs.
CD-Rom 52x(LG)………….2100Rs.
Hard-Disk 40 gb……………5700Rs.
Casing Atx………………….1200Rs.
Speaker(Zoltrix 60w)……..800Rs.
Fax-Modam(Matrola)……..1100Rs.
Keyboard-Mouse…………1000Rs.
Printer-Laser(Epson)…….18,550Rs.
Scaner(Acer)………………5000Rs.
Total…………………………53,050Rs.
Clients Detail
4 pc required.
P(II) 850 Mhz intel Celeron processor….3700Rs Each.
Mother Board intel 810e………………….4000Rs Each.
Ram 128 Mb………………………………..1050 Rs Each.
Casing Atx………………………………….1100 Rs Each.
Hard-Disk 10 Gb…………………………..3000 Rs Each
Total………………………………………..51,400 Rs
Other Details.
Hub (8 ports)…………. 2200 Rs.
Connector …………… 7 Rs Each.
« Two connectors are required for one computer.
Net work card ……….. 650 Rs Each.
Installation charges ………. 1000 Rs.
Grand Total…………………..106985 Rs .
The total cost of computerized system = Rs107,000 approx.
By adopting the following system, the organization will gain the following advantages:
« Increase in efficiency
« Increase in customer satisfaction
« Reduce the redundancy
« Reduce the cost
« Reduce the time
General designing of the solution
Logical data flow diagram
Form Designing
Main Form
| NO | DESCRIPTION | QTY. BAGS | RATsE | AMOUNT RS. |
| 1 | CHICK STAR MASH | |||
| 2 | GROWER MASH | |||
| 3 | LAYER MASH | |||
| 4 | BROILER FINISHER MASH | 185 | 567 | 104,895 |
| 5 | BREEDER STARTER MASH | |||
| 6 | BREEDER MASH | |||
| 7 | LAYER CRUMBS | |||
| 8 | GROWER CRUMBS | |||
| 9 | BROILER STARTER CRUMBS | |||
| 10 | BROILER FINISHER CRUMBS | 35 | 567 | 19845 |
| 11 | OTHERS | |||
| LESS: | 124740 | |||
| DISCOUNT: 11227 | ||||
| FREIGHT: 4200 | ||||
| UNLOADING CHARGES 5300 | ||||
| DESTINATION CHARGES 1100 | ||||
| OTHERS: | ||||
| TOTAL Ded. 16527 | 16527 | |||
| TOTAL | 220 | 108213 |
|
|
|
|
CUSTOMER INFORMATION
Codification
Create Table Customer (
Cust. _ id Number (4),
Cust. _ name Varchar2 (20). Not Null,
Phone _ No. Number (10),
Terms _ conditions Varchar2 (20). Not Null,
Bonus Number (10),
Opening Balance Number (10). Not Null,
Constraint Cust._cust.id_pk Primary key (Cust._id))
Create Table Product (
Product_id Varchar2 (20),
Product_Desc. Varchar2 (40),
Rate per Bag Number (10),
Constraint Product_ Product_ id_ pk Primary key (prod._id),
Constraint product_Rate per Bag_ck Check Rate per Bag > 150);
Create table sale (
Cust._id Number (4),
Delivery Order NO. Number (10),
Quantity Number (10),Not Null,
Amount Number (12), Not Null,
Sale_ Date Date, Not Null,
Freight Varchar2 (20), Not Null,
Constraint Sale_cust.id_ Fk Foreing key (cust._id)
References Customer (cust._id),
Constraint Sale_ Delivery Order No._Fk Foreing key (delivery order NO.) References Invoice Detail Detail (Delivery order No.) );
Create Table Invoice Detail (
Delivery Order No. Number (10),
Prod._id varchar2 (20),
No. of Bags Number (3),
Constraint Invoice Detail_Delivery Order No._Pk primary key (Delivery Order No.),
Constraint Invoice Detail_prod._id_Fk Foreign Key (Prod._id)
References Product (Prod._id) );
Create Table Receipts (
Record_No. Number (4),
RDate Date , Not Null,
Cust._id Number (4),
Amount Number (10), Not Null,
Mode of Payment Varchar2 (20),
Constraint Receipts_ Record No_Pk Primary key (Record No),
Constraint Receipts_cust._id_Fk Foreign Key (Cust._id)
References Customer (Cust._id) );
Database Designing
Data Dictionary
The data dictionary contains the information about data and procedures of the firm. The four data dictionary categories are:
Ø Data Flows
Ø Data Structure
Ø Data Elements
Ø Data Stores
Ø Data Flows
Data flows contain the following information:
« Customer ID
« Customer Name
« General description
« The source of data flow
« The destination of the data flow
« The type of data flow
« Volume time
« An area for comments
Ø Data Structures
The data structure of the Asia Feeds can be such as:
Customer Order = Customer ID +
Customer Name +
Customer Address +
Order Date +
{Available Order Item}+
(Tax)+
Shipping and Handling +
Order Total +
(Expiration Date).
Customer Name= First Name +
Last Name.
Customer Address= Street +
City +
(country).
Available Order Item= Quantity Order +
Item Number +
Item Description +
Size +
Price +
Item Total.
Method of Payment= [Check, Money Order]
Ø Data Elements
The characteristics commonly included on the element description form are:
« Element ID
« Element Name
« Element Description
« Length of Element
« The type of Data
« Input Format
« Out Put Format
« Validation Criteria
« Default Value
Ø Data Store
Characteristics included on the data store are:
« Data Store ID
« Data Store Name
« Description of Data Store
« Record Size
« Maximum Number of Record Size
« Primary Key
« Secondary Key
« Commands
Implementation
Implementation will contain the general categories of the activities and with in each of those a detailed list of tasks that need to be performed. General categories are as follows:
« Training
« Equipment Installation
« File conversion
« Procedure conversion
« System conversion
« Evaluation
The training staffs will probably the analyst alone, although training by vendor is another possibility. To help trainees learn by doing the trainer can give demonstrations and assign excuses.
