ACKNOWLEDGEMENT
I want to acknowledge my deep thanks to our all the Teachers and company Officials who helped me make my final report.
I am deeply indebted and also express my gratitude to my respected teachers atALLAMA IQBAL OPEN UNIVERSITY, ISLAMABAD specially MR. SANA ULLAHfor their
upport. Their guidance and support was always instrumental in setting the track right for preparation of this report.
I am very thankful to Mr.Ahsan Majeed for providing me the opportunity to have an excellent learning experience during my internship at TOYO NASIC TARIQ
GLASS INDUSTRIES LIMITED and to all the experienced staff at for their guidance and ooperation.
Preparation of this report has been an unusually enjoyable and exciting experience
for me. Perhaps the most memorable aspects of the project has been the opportunity o know better a number of people who have provided information for various ortion of the work in the course of the research, I started to collect data from the very first day, when I start working on this report. The person to whom I would like to give my regards is the MIS Manager Mr.Ahsan Majeed of TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED who gave me very useful tips and information. I am sure that my report will prove to be work in advance for the people to study later on. I wish all the successes from the core of my heart to all.
CONTENTS:-
CHAPTER # 1. - INTRODUCTION TO ORGANIZATION 01 - 21
CHAPTER # 2. - INTRODUCTION TO ORGANIZATION’S MIS DEPT 22 - 37
CHAPTER # 3. - SYSTEM DEVELOPMENT PROCESS 38 - 82
CHAPTER # 4. - SWOT ANALYSIS 83 - 89
CHAPTER # 5. - CONCLUSIONS 90 - 90
CHAPTER # 6. - RECOMMENDATIONS 91 - 92
CHAPTER # 7. - BIBLIOGRAPHY 93 - 94
ANNEXURE / APPENDICES
BRIEF CONTENTS
CHAPTER # 1. INTRODUCTION 01 - 21
1.1. MAIN OBJECTIVE OF SELECTING THIS ORGANIZATION. 02
1.2. INTRODUCTION OF ORGANIZATION. 03
1.2.1. PRODUCTION CAPACITY. 05
1.2.2. DECORATING FACILITIES. 05
1.2.3. WAREHOUSING. 06
1.2.4. QUALITY. 07
1.2.5. QUALITY ASSURANCE. 07
1.3. OBJECTIVE OF THE ORGANIZATION. 07
1.4. MISSION OF THE ORGANIZATION. 07
1.5. PRODUCT LINES. 08
1.5.1. PRESSWARE. 08
1.5.2. PRINT RANGE. 13
1.6. BUSINESS VOLUME. 15
1.6.1. PROFIT VOLUME DURING LAST FIVE YEARS. 15
1.6.2. SALES VOLUME DURING LAST FIVE YEARS. 16
1.6.3. PROFIT OF EMPLOYEES. 16
1.7. ORGANIZATIONAL STRUCTURE. 17
1.7.1. ORGANIZATIONAL STRUCTURE CHART. 17
1.7.2. MARKETING DEPARTMENT’S STRUCTURE. 18
1.7.3. PRODUCTION DEPARTMENT’S STRUCTURE. 19
1.7.4. COORDINATION, PR & HR DEPARTMENTS STRUCTURE. 20
1.7.5. MIS DEPARTMENT’S STRUCTURE. 21
CHAPTER # 2. INTRODUCTION TO MIS DEPT 22 - 37
2.1 INTRODUCTION TO MANAGEMENT INFORMATION SYSTEM. 23
2.1.1 MANAGEMENT INFORMATION SYSTEM. 23
2.2 STRUCTURE OF ORGANIZATION’S MIS DEPARTMENT. 24
2.2.1 STRUCTURE OF MIS DEPARTMENT. 24
2.3 MIS EMPLOYEES DETAILS & THEIR JOB TASKS. 24
2.3.1 DIRECTOR MIS. 25
2.3.2 MANAGER MIS. 25
IX
2.3.3 NETWORK ADMINISTRATOR. 26
2.3.4 DATABASE ADMINISTRATOR. 27
2.3.5 SENIOR PROGRAMMER. 28
2.3.6 PROGRAMMER. 29
2.4 FUNCTIONS OF THE MIS DEPARTMENT. 30
2.4.1 MAJOR FUNCTIONS. 30
2.5 MIS OPERATIONS. 31
2.5.1 SALES MODULE. 31
2.5.2 PRODUCTION MODULE. 31
2.5.3 PURCHASING MODULE. 32
2.5.4 FINANCE AND ACCOUNTING MODULE. 32
2.5.5 PLANNING & MARKETING MODULE. 33
2.5.6 PAY ROLL CONSIDERATION MODULE. 33
2.5.6.1 BASIC PAY ROLL PROCESSING. 33
2.5.7 LEAVE DATA. 33
2.5.8 MAINTENANCE MANAGEMENT. 33
2.5.9 OPERATIONS MANAGEMENT. 34
2.5.10 SOFTWARE SECURITY. 34
2.6 MIS SUPPORT TO THE OTHER DEPARTMENTS. 35
2.6.1 MARKETING. 35
2.6.2 ADMINISTRATION. 35
2.6.3 ACCOUNTS. 35
2.6.4 TIME OFFICE & HR DEPARTMENT. 36
2.6.4.1 BASIC PAY ROLL INFORMATION. 36
2.6.5 PRODUCTION DEPARTMENT. 37
CHAPTER # 3. SYSTEM DEVELOPMENT PROCESS 38 - 82
3.1 SYSTEM DEVELOPMENT PROCESS. 39
3.1.1 SYSTEM. 39
3.1.2 INFORMATION SYSTEM. 40
3.2 PRELIMINARY INVESTIGATION & PROBLEM ANALYSIS. 40
3.2.1 OBJECTIVE OF PRELIMINARY INVESTIGATION. 41
3.2.2 SCOPE. 41
3.2.3 CONSTRAINS. 42
3.2.4 EXISTING MIS SETUP. 42
X
3.2.5 CRITICAL ANALYSIS. 43
3.2.5.1 EXISTING SYSTEM. 43
3.2.5.2 PROBLEM STATEMENT. 43
3.2.5.3 STAKEHOLDER AND USER DESCRIPTION. 44
3.2.5.4 PRODUCT OVERVIEW. 44
3.2.5.5 PRODUCT PERSPECTIVE. 44
3.2.6 DFD’S AND RISK ANALYSIS. 45
3.3 REQUIREMENTS ANALYSIS PHASE. 45
3.3.1 PROCESS DIAGRAM. 46
3.3.2 EXISTING SYSTEMS REQUIREMENTS ANALYSIS. 47
3.4 FEASIBILITY STUDY. 48
3.4.1 TECHNICAL FEASIBILITY. 48
3.4.2 OPERATIONAL FEASIBILITY. 48
3.4.3 ECONOMICAL FEASIBILITY. 49
3.4.4 SCHEDULED FEASIBILITY. 50
3.5 SYSTEM DESIGN PHASE. 50
3.5.1 RISK ANALYSIS. 50
3.5.2 SYSTEM DESIGN. 52
3.5.3 GUIDELINES FOR IDEAL MIS SYSTEM DEVELOPMENT. 53
3.5.3.1 DATA SOURCES. 53
3.5.3.2 METRICS. 54
3.5.3.3 ANALYSIS 54
3.5.3.4 PRESENTATION. 54
3.5.3.5 CONTROL. 54
3.5.4 BENEFITS OF THE APPROACH. 55
3.5.5 DFD’S OF SYSTEM DESIGN. 56
3.5.5.1 LOGIN. 56
3.5.5.2 CREATE GRN. 56
3.5.5.3 HANDLE CATEGORY. 57
3.5.5.4 UPDATE ITEM INVENTORY. 57
3.5.5.5 UPDATE PRODUCT INVENTORY. 58
3.5.5.6 HANDLE SUPPLIERS. 58
3.5.5.7 HANDLE TRANSFER OF ITEMS. 59
3.5.5.8 CREATE WAREHOUSE 59
3.5.5.9 CREATE ISSUE VOUCHER 59
3.5.5.10 CHECK REPORTS. 60
XI
3.5.6 DESIGNING SYSTEM OUTPUTS. 60
3.5.6.1 CONTENT 61
3.5.6.2 FORMS. 61
3.5.6.3 VOLUME. 61
3.5.6.4 TIMELINES. 61
3.5.6.5 MEDIA. 62
3.5.6.6 FORMAT. 62
3.5.7 DESIGNING SYSTEM INPUTS. 62
3.5.7.1 CONTENT 62
3.5.7.2 TIMELINES. 63
3.5.7.3 MEDIA. 63
3.5.7.4 FORMAT. 63
3.5.7.5 VOLUME. 63
3.5.8 ENTITY RELATIONSHIP DIAGRAMS. 64
3.5.9 DETERMINING PROCESSING REQUIREMENTS. 65
3.5.9.1 APPLICATION SOFTWARE. 65
3.5.10 DETERMINING STORAGE REQUIREMENTS. 66
3.5.10.1 ACCESS THE ORGANIZATION. 66
3.5.10.2 STORAGE VOLUME. 66
3.5.10.3 MEDIA. 67
3.5.11 DEVELOPING PROCEDURE FOR USING SYSTEM. 67
3.5.11.1 WORK PROCEDURE. 67
3.5.11.2 CONTROL PROCEDURE. 68
3.5.12 DETERMINING PERSONAL REQUIREMENTS. 68
3.5.1.1 WORK DESCRIPTION. 69
3.5.1.2 PERSONAL QUALIFICATION. 69
3.5.1.3 TRAINING. 69
3.6 END USER DEVELOPMENT. 70
3.6.1 FAVORING CIRCUMSTANCES OF PROTOTYPING APPROACH. 70
3.6.2 SYSTEM IMPLEMENTATION. 71
3.6.2.1 SCHEDULING. 71
3.6.2.2 PROGRAM COADING, DEBUGGING & TESTING. 72
3.6.2.3 TRAINING. 73
3.6.2.4 CONVERSION. 74
3.7 SYSTEM EVALUATION. 75
3.7.1 PERIODIC PERFORMANCE REPORTS. 75
XII
3.7.1.1 USER SURVEY. 75
3.7.1.2 SYSTEM PERFORMANCE. 75
3.7.1.3 EARLY WARNING SIGNALS. 75
3.7.1.4 OVERALL EFFECTIVENESS. 75
3.8 USER INTERFACES. 76
3.8.1 LOGIN SCREEN. 76
3.8.2 CHANGE PASSWORD SCREEN. 76
3.8.3 GRN SCREEN. 77
3.8.4 ISSUE VOUCHER SCREEN. 77
3.8.5 DPR SCREEN. 78
3.8.6 CATEGORY. 78
3.8.7 NEW ITEM. 79
3.8.8 NEW UOM. 79
3.8.9 NEW SUPPLIER. 80
3.8.10 TRANSFER OF ITEM. 80
3.8.11 NEW TYPE. 81
3.8.12 NEW UOM. 81
3.8.13 VIEW CATEGORY. 81
3.8.14 VIEW ITEM. 82
3.8.15 WAREHOUSE. 82
3.8.16 WORKSHOP. 82
CHAPTER # 4. SWOT ANALYSIS 83 - 89
4.1 SWOT ANALYSIS. 84
4.1.1 STRENGTHS. 85
4.1.1.1 STRENGTHS OF THE COMPANY. 85
4.1.1.2 STRENGTHS OF THE MIS DEPARTMENTS. 86
4.1.2 WEAKNESSES. 87
4.1.3 OPPORTUNITIES. 88
4.1.4 THREATS. 88
4.2 WEAKNESSES OF THE MIS DEPARTMENT. 89
CHAPTER # 5. CONCLUSIONS 90 - 90
5.1 CONCLUSIONS. 90
XIII
CHAPTER # 6. RECOMMENDATIONS 91 - 92
6.1 RECOMMENDATIONS. 91
CHAPTER # 7. BIBLIOGRAPHY 93 - 94
7.1 REFERENCES & SOURCES USED. 94
7.1.1 FROM ORGANIZATION. 94
7.1.2 WEB PORTALS. 94
7.1.3 BOOKS 94
ANNEXURE / APPENDICES
PRODUCTION FACILITY 05
DECORATING FACILITIES 05
WAREHOUSING 06
QUALITY 06
QUALITY ASSURANCE 07
PRESSWARE PRODUCTS 08
PRINT RANGE PRODUCTS 13
PROFIT VOLUME DURING LAST FIVE YEARS. 15
SALES VOLUME DURING LAST FIVE YEARS. 16
PROFIT OF EMPLOYEES 16
ORGANIZATIONAL STRUCTURE CHART 17
MARKETING DEPARTMENT’S STRUCTURE 18
PRODUCTION DEPARTMENT STRUCTURE 19
COORDINATION, PERSONAL RELATIONS & HR DEPARTMENT’S STRUCTURE
CHART. 21
STRUCTURE OF MIS DEPARTMENT 21
INTRODUCTION TO MANAGEMENT INFORMATION SYSTEM 23
STRUCTURE OF MIS DEPARTMENT 24
INFORMATION SYSTEM 40
ORGANIZATIONAL EXISTING MIS SYSTEM. 42
PROBLEM STATEMENT. 43
DFD’S & RISK ANALYSIS. 45
REQUIREMENTS ANALYSIS 46
PROCESS DIAGRAM 47
XIV
GUIDELINE FOR IDEAL MIS SYSTEM DEVELOPMENT. 53
DFD OF LOGIN. 56
DFD OF CREATE GRN. 56
DFD OF HANDLE CATEGORY. 57
DFD OF UPDATE ITEM INVENTORY. 57
DFD OF UPDATE PRODUCT INVENTORY. 58
DFD OF HANDLE SUPPLIERS. 58
DFD OF HANDLE TRANSFER OF ITEMS. 59
DFD OF CREATE WAREHOUSE 59
DFD OF CREATE ISSUE VOUCHER 59
DFD OF CHECK REPORTS. 60
ENTITY RELATIONSHIP DIAGRAMS. 64
TRADITIONAL DEVELOPMENT APPROACH FOR SYSTEM DESIGN & DEVELOPMENT 69
PROTOTYPING APPROACH FOR SYSTEM DEVELOPMENT. 70
USER INTERFACE LOGIN SCREEN. 76
USER INTERFACE CHANGE PASSWORD SCREEN. 76
USER INTERFACE GRN SCREEN. 77
USER INTERFACE ISSUE VOUCHER SCREEN. 77
USER INTERFACE DPR SCREEN. 78
USER INTERFACE CATEGORY. 78
USER INTERFACE NEW ITEM. 79
USER INTERFACE NEW UOM. 79
USER INTERFACE NEW SUPPLIER. 80
USER INTERFACE TRANSFER OF ITEM. 80
USER INTERFACE NEW TYPE. 81
USER INTERFACE NEW UOM. 81
USER INTERFACE VIEW CATEGORY. 81
USER INTERFACE VIEW ITEM. 82
USER INTERFACE WAREHOUSE. 82
USER INTERFACE WORKSHOP. 82
EXECUTIVE SUMMARY
TARIQ GLASS INDUSTRIES LIMITED is formerly known as NASIR SIDDIQUECORPORATION OF PAKISTAN LIMITED and more properly known as TOYO NASIC is located at 33 kilometer, Lahore Sheikhupura Road Sheikhupura.
The company was established in 1981 as a Public Limited Company. The project
was set up with the Technical Assistance of TOYO NASIC GLASS OFJAPAN is
one of the leading manufacturers of Glass ware in the Pakistan. The entire plant was
designed, erected and commissioned by TOYO NASIC GLASS OF JAPANon
turnkey basis.
Due to great efforts of the management and staff, the TOYO NASIC TARIQGLASS
COMPANY getting its ISO 9001 2000 certification on the MAY 15, 2001,which
reflects the company product quality. Now the management plans to increase its
exports of tableware products to a large number of EUROPEAN COUNTRIES.
Over the last twenty years, TARIQ GLASS INDUSTRIES LTD has excelled in the art of
glass manufacturing. Under the popular brand names of TOYO NASIC, OMROC
and NOVA, TARIQ GLASS INDUSTRIES LTD have become a reliable house hold name
in Pakistan and now the market leader in Pakistan. The backbone of TARIQGLASS
INDUSTRIES LTD.'S is a team of qualified, experienced and dedicated professionals.
TARIQ GLASS INDUSTRIES capture 90% share of the local market in Pakistanand
now exporting its product to other countries. Today TOYO NASIC produces up to
170 TONS of glass per day. The company management hopes to increase its export
of tableware products to number of other EUROPEAN COUNTRIES.
The plant boasts a production capacity of almost 200 METRIC TONS of glass
tableware per day, having a combination of single and double gob press machines
as well as H-28 press and blow machines for light weight product ranges.
TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED is one of the most successful
glass industries in Pakistan I enjoyed my internship period at TOYO NASIC TARIQ
XVI
GLASS INDUSTRIES LIMITED Ferozepur Road Branch. The staff members are very
cooperative and supporting.
MR. AHSAN MAJEED is the Manager MIS and looks after all the functions of the
MIS Department and its activities. Currently a simple database system in Visual
FoxPro is working in the MIS Department of TOYO NASIC TARIQ GLASS
INDUSTRIES, which handle accounts department and store department. I apply the
business intelligence rules on this database by creating a data warehouse for the
existing data. The production department of appliances division is handled
manually and there is computerized database management system for the
department. Therefore, there is problem in handling the data and quality check.
XVII
MY ROLE & PARTICIPATION:
As I know that with the theoretical knowledge, the practical knowledge about the
field also has much more importance that’s why the ALLAMA IQBAL OPENUNIVERSITY, ISLAMABAD has given the project to students in which the practical work is included so that the students can get the knowledge about their relating field beside the bookish knowledge.
This type of research program is basically to broaden the vision of practical
experiences with theoretical knowledge as it increases one’s capabilities to handle
problems at various stages and the ability of decision.
I have chosen TARIQ GLASS INDUSTRIES LIMITED for my final report and emphasis
on one of its factory named TOYO NASIC. I did my level best to analyze theTOYO
NASIC TARIQ GLASS INDUSTRIES LIMITED in order to examine its true position in
the market. I analyzed the various products offered TOYO NASIC TARIQGLASS
INDUSTRIES LIMITED and I got the information about it that it is improving quickly
from its past position.
TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED is one of the most successful
glass industries in Pakistan I enjoyed my internship period at TOYO NASIC TARIQ
GLASS INDUSTRIES LIMITED Ferozepur Road Branch. The staff members are very
cooperative and supporting. I worked in the MIS Department with MR. AHSAN
MAJEED (MANAGER MIS) and assisting him. I chose MIS Department because of
the requirement of my degree. I thoroughly study different departments their
functions and specifically focus on the functionalities of the MIS Department as per
my requirement for this report I thoroughly study their system and proposed a
system for the betterment of their system. As well as implement that system in their
MIS department.
Currently a simple database system in Visual FoxPro is working in the MIS
Department of TOYO NASIC TARIQ GLASS INDUSTRIES, which handle accounts
department and store department. I apply the business intelligence rules on this
XVIII
database by creating a data warehouse for the existing data. The production
department of appliances division is handled manually and there is computerized
database management system for the department. Therefore, there is problem in
handling the data and quality check.
The system will provide services to the higher administration and management of
the departments of the TOYO NASIC TARIQ GLASS INDUSTRIES. The manager or
administrator will put a query and system will automatically execute and display the
reports in more descriptive and comprehensive form. He can also execute the
hidden queries in the queries.
System will facilitate the strategic level management of TOYO NASIC TARIQ
GLASS INDUSTRIES to make decisions, forecasting and better strategies. This system
will also provide the help to the operational level management to entertain queries
generate reporting and maintain stock status.
I had a very learning experience during my internship I had the practical exposure
of the MIS Functions I had been taught at University by the respected teachers &
their guidance and morel support was very helpful for me during all my study
tenure. During my internship I learned a lot about the MIS department and its needs
in the current new era of information technology of the company.
INTRODUCTION
This chapter presents an over view of the organization. The history, nature of
organization, vision, mission and objectives, products/services, business volume,
organizational structure, departments, their functions and activities etc.
1.1. MAIN OBJECTIVE OF SELECTING THISORGANIZATION
In the new era of intranet, extranet and internet in the enterprise and their trading
partners become the primary information technology in fracture of many
organizations. Intranet, extranet and other type of networks enables managers, end
users, teams and work groups to electronically exchange data and information in any
past of the global village. Such technology enables managers for quick decision and
supervises in the new era fast business competition, without such network any
organization cannot survive in the global village.
The main objective of the studying this organization is that how the managers make
daily decision making and handle the organization affairs in routine and how much
theoretical knowledge helps the managers. Practical experience is the first step
towards the attainment.
1.2 INTRODUCTION:-
TARIQ GLASS INDUSTRIES LIMITED is formerly known as NASIRSIDDIQUE
CORPORATION OF PAKISTAN LIMITED and more properly known asTOYO NASIC is
located at 33 kilometer, Lahore Sheikhupura Road Sheikhupura.
The company was established in 1981 as a Public Limited Company with the Prime
objective of producing quality Glass Tableware and Glass Containers (Bottles etc) for
beverages and food industries.( The production facility is spread over and area of 29
acres.) The project was set up with the Technical Assistance of TOYO NASIC
GLASS OF JAPAN is one of the leading manufacturers of Glass ware in the
Pakistan. The entire plant was designed, erected and commissioned byTOYO NASIC
GLASS OF JAPAN on turnkey basis.
Due to great efforts of the management and staff, the TOYO NASIC TARIQGLASS
COMPANY getting its ISO 9001 2000 certification on the MAY 15, 2001,which reflects
the company product quality.
Turning closed down industry around into a viable economic unit is not a small
achievement. Management’s and TARIQ BAIG’S knowledge of glass industry, have
helped TOYO NASIC to come back on its feet and to blossom into the leading glass
manufacturers of the country. Now TOYO NASIC has commenced production of very
high quality thin walled tumblers with this machine and will soon be marketing
stemware products as well.
Now the management plans to further increase its exports of tableware products to a
large number of EUROPEAN COUNTRIES.
Over the last twenty years, TARIQ GLASS INDUSTRIES LTD. has excelled in the art of
glass manufacturing. Under the popular brand names of TOYO NASIC, OMROC and
NOVA, TARIQ GLASS INDUSTRIES LTD. has become a reliable house hold name in
Pakistan. By fulfilling the needs of quality glass tableware and nurturing the basic
ingredients of Quality, Variety, Reliability and above all having a Competitive Edge,
TARIQ GLASS INDUSTRIES LTD. is now the market leader in Pakistan. This success is
now fast spreading to international markets across Europe, Middle East, Africa, Asia
and the Far East. The backbone of TARIQ GLASS INDUSTRIES LTD.'S is a team of
qualified, experienced and dedicated professionals with a proven expertise along with
a staunch backing through technical collaboration with TOYO GLASS OFJAPAN.
TARIQ GLASS INDUSTRIES basically produce two types of line products inPakistan.
1. Tableware Product
2. Container (Beverage and Food Product Jar)
TARIQ GLASS INDUSTRIES capture 90% share of the local market inPakistan and now
exporting its product to other countries. Today TOYO NASIC produces up to 170
TONS of glass per day. TOYO NASIC has commenced production of very high
quality thin walled tumblers with this machine and will soon be marketing stemware
products as well. The company management hopes to increase its export of tableware
products to number of other EUROPEAN COUNTRIES.
1.2.1 PRODUCTION CAPACITY:-
The plant boasts a production capacity of almost 200 METRIC TONS of glass tableware
per day, having a combination of single and double gob press machines as well as H-
28 press and blow machines for light weight product ranges.
1.2.2 DECORATING FACILITIES:-
For the creative and decorative needs of the clients, TARIQ GLASSINDUSTRIES LTD.
has the facility of a fully automated, state-of-the-art printing machine, with the
capability of printing six color simultaneously, including quality gold and silver
banding.
1.2.3 WAREHOUSING:-
To ensure uninterrupted and consistent supply of goods to the valued clientele, an all
weather warehousing facility caters for raw materials, packing goods as well as
finished products storage.
1.2.4 QUALITY:-
TARIQ GLASS INDUSTRIES LTD. stands committed as a team to manufacture quality
glass tableware products through dedication, creativity, experience and technology.
Their focus is striving not only to meet the expectations of their clientele, but also
their imaginations. Their journey continues towards excellence.
1.2.5 QUALITY ASSURANCE:-
At TARIQ GLASS INDUSTRIES LTD. assuring quality starts with a careful selection of
indigenously available raw materials, which are processed through a most modern
and fully automated plant. Quality Assurance at every step is constantly monitored by
their experts through a fully equipped on site laboratory.
1.3 OBJECTIVE OF THE ORGANIZATION:-
The main objective of TOYO NASIC TARIQ GLASS INDUSTRIES LIMITEDis to
produce quality, reliability and variety of Glass products for home users and
industries.
1.4 MISSION OF THE ORGANIZATION:-
TARIQ GLASS INDUSTRIES LTD stands committed as a team to manufacture quality
glass tableware products through dedication, creativity, experience and technology.
Their journey continues towards excellence.
At TARIQ GLASS INDUSTRIES LTD assuring quality starts with a careful selection of
indigenously available raw materials, which are processed through a most modern
and fully automated plant. Quality Assurance at every step is constantly monitored to
achieve the company’s objective.
The main mission of the company is to capture the maximum market share of the
glass industry. Currently TARIQ GLASS INDUSTRIES LTD capture 90% share of the
local market in Pakistan and now exporting its product to other countries. Today
TOYO NASIC produces up to 170 TONS of glass per day. TOYO NASIChas
commenced production of very high quality thin walled tumblers with this machine
and will soon be marketing stemware products as well.
1.5 PRODUCT LINES:-
TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED offers the vast range of the glass
products to full fill the customer needs. Following are the product line:
1.5.1 PRESSWARE
1. Accessories
1.1 Jubilee Candy Box.
2. Ash Trays
2.1 Diamond.
2.2 Dimple.
2.3 Silky.
2.4 Sohni.
2.5 Sparkle.
3. Fruit Sets
3.1 Crown.
3.2 IVY.
3.3 Jasmine.
3.4 Orient.
3.5 Shalimar.
3.6 Thumb.
4. Ice Cream Sets & Cups.
4.1 Crown.
4.2 Jasmine.
4.3 Pansy.
4.4 Silky.
4.5 Simba.
5. Jars.
5.1 Jars
6. Jugs.
6.1 Fancy,
Mehran.
6.2 Flora, Pine.
6.3 Galaxy,
Thumb.
6.4 Petal, Silky.
6.5 Tulip,
Chandani.
7. Mugs.
7.1 IRIS.
7.2 Fine.
7.3 F i e s t a T e a
Mug
7.4 Milano.
7.5 Ocean.
7.6 Orient
Jasmine Tea
Mug.
7.7 Palace.
7.8 Royal.
8. Plates & Bowls.
8.1 Crown Bowl.
8.2 Crown Carry
Bowl Set.
8.3 Crown
Plates.
8.4 L a s e S o u p
Plate.
8.5 Orient Bowl.
8.6 Orient Plates.
8.7 Silky Bowl.
8.8 Silky Curry
Bowl Set.
9. Tea Cups and Saucers.
9.1 Star.
9.2 Daisy,
Omega.
10. Tumblers.
10.1 Alpha.
10.2 Anarkali.
10.3 Aqua.
10.4 Atlantic.
10.5 Chandni.
10.6 Classic.
10.7 Diamond.
10.8 Duke.
11. Water Sets.
11.1 Flora.
1.5.2 PRINT RANGE
1. Custom Prints.
2. Mugs.
2.1 Blue Tulip.
2.2 Daisy.
2.3 Happy
Dolphins.
2.4 Leemun.
3. Tumblers.
IQBAL OPEN UNIVERSITY H 8 ISLAMABAD
3.1 Blue
Flowers.
3.2 Daisy.
3.3 Dots.
3.4 Fresh.
3.5 Fruit.
3.6 Oranges.
3.7 Terrace.
3.8 Tulip.
4. Water Sets.
4.1 Citrus.
4.2 Leaves.
4.3 Lemons.
4.4 Pinki.
4.5 Strawberry.
4.6 Trim.
1.6 BUSINESS VOLUME:-
The project was set up with the technical assistance of TOYO NASIC GLASS OF
JAPAN one of the leading manufacturers of Glassware in the Pakistan. The entire
plant was designed, erected and commissioned by TOYO NASIC GLASS OF JAPAN
on turnkey basis.
In 1993 MR. TARIQ BAIG, Managing Director of TARIQ GLASSINDUSTRIES LTD, not
only rehabilitated the closed project with massive Financial, Technical and Marketing
approach as well as started a balancing modernization and restructuring program. Due
to his great efforts, TOYO NASIC TARIQ GLASS INDUSTRIES got ISO 9001 2000
certification on MAY 15, 2001, which reflects the product quality of the company.
Since 1993, TARIQ GLASS INDUSTRIES has made tremendous growth and increase in
its business volume day by day. In this new era of information technology and
competition TARIQ GLASS INDUSTRIES introduced the quality products. Due to this
matter the net sales volume increases year to year. In 2001 the record profit earned by
TARIQ GLASS INDUSTRIES amounted to 42.468 MILLION and achieving the highest
production capacity level of 87 MILLION TONS per year. The profit in 2006was RS.
96.123 MILLION. TARIQ GLASS INDUSTRIES LTD has captured 90% OF LOCAL MARKET
share in Pakistan. In 2006 the earned profit per share was RS. 6.24.
1.6.1 PROFIT VOLUME DURING LAST FIVE YEARS
YEAR PROFIT
2006 96.123 Million
2005 95.237 Million
2004 91.803 Million
2003 75.220 Million
2002 42.468 Million
1.6.2 SALES VOLUME DURING LAST FIVE YEARS
YEAR PROFIT
2006 Rs. 799,213,506
2005 Rs. 705,112,327
2004 Rs. 632,054,567
2003 Rs. 568,607,309
2002 Rs. 395,290,863
1.6.3 PROFIT OF EMPLOYEES
The profit of employees in the different departments of TOYO NASIC is outlined
below:
FI FII TOTAL
DEPARTMENT SANCTIONED SANCTIONED SANCTIONED
Administrative Division 73 4 77
General Office 12 0 12
Production (I-S) 0 53 53
Production (H-28) 0 34 34
Production (M.D.P) 107 0 107
Workshop (I.S) 28 0 28
Workshop (H-28) 0 16 16
Workshop (M.D.P) 37 0 37
Glass Division 349 254 603
Maintenance Division 66 13 79
Management Information
System 09 06 15
TOTAL 681 380 1061
1.7 ORGANIZATIONAL STRUCTURE:-
Organizational structure of TOYO NASIC TARIQ GLASS INDUSTRIES is being carried
out for making the company more responsive, competitive and capable of facing
global and domestic market challenges.
The main areas focus would be Marketing, Human Resources, Management
Information System and Product Operations. Appropriate changes have also been
brought through in Quality Control department. So that ensure its quality product,
which is now exported to the other countries, Human Resource Management on the
other hand ensures recruitment process and system has been adequately developed by
appropriate new era HR Policies.
Production department of Glass division adopting new era technical advancement, so
that increase the product output, currently new H-28 machine is erected this machine
is only in the Asia which produce the light and thin wall glass products.
Management Information System monitoring the whole organizational department’s
efficiency day by day and report the Managing Director, which facilitate in decision
making.
1.7.1 MARKETING DEPARTMENT’S FUNCTIONS & STRUCTURE:-
The marketing department of TOYO NASIC TARIQ GLASS INDUSTRIES is responsible
for creating, preparing, and establishing marketing strategies and policies for each
product by coordinating the efforts of publicity, promotion, advertising, online and
sales. The marketing department o f TOYO NASIC TARIQ GLASSINDUSTRIES i s
responsible for the following functions:
§ Preparing all sales presentation materials: audio recordings, fact sheet
collation, and promotions
§ Creating and producing additional account-specific presentation materials.
§ Creating pricing strategies.
§ Researching and establishing relations with new markets.
§ Planning and maintaining sales and marketing schedules, including title
launch and planning meetings.
§ Measuring the effectiveness of strategies once completed
1.7.2 PRODUCTION DEPARTMENT’S FUNCTIONS & STRUCTURE:-
The production department of TOYO NASIC TARIQ GLASS INDUSTRIEScoordinates
the production and manufacturing of each product line. Production acts as a liaison
between editorial, managing editorial, design, production, and outside vendors to
create and distribute the final product. Daily activities for the department include:
§ Trafficking of all materials between design and editorial/managing editorial.
§ Following up on late and/or special schedules.
§ Estimating of paper quantities and production costs.
§ Negotiating with suppliers.
§ Assisting on special projects as necessary
1.7.3 COORDINATION. PR & HR DEPARTMENT’SFUNCTIONS &
STRUCTURE:-
The coordination, PR and HR department of TOYO NASIC TARIQ GLASSINDUSTRIES
have different activities. The coordination unit of TOYO NASIC TARIQGLASS
INDUSTRIES has performed the tasks given below:
§ MEDIA RELATIONS (Press, Electronic Media and Liaison with Media
Monitoring, Press and Media visits.)
§ PUBLICATION AND PRODUCTION (1: Advertisements, Notifications.
2: Brochure and Publicity material. 3: Annual Reports etc.)
§ EXHIBITIONS AND TRADE FAIRS ( Participation in Exhibitions, Trade
Fairs, Preparation of Audio Visuals, Documentaries and Photo and Video
graphy.)
§ SEMINARS, CONFERENCES, WORKSHOPS AND OTHER
IMPORTANT EVENTS.
The human resources unit of TOYO NASIC TARIQ GLASS INDUSTRIESworks closely
with all departments to ensure the health and happiness of their employees through
benefits administration, rewards and recognition, facilitation of company-wide
events, and the recruitment of new employees. They also act as a liaison between the
employee and the employer.
The promotions unit of TOYO NASIC TARIQ GLASS INDUSTRIES works as a primary
liaison with marketing and publicity directors, by creating effective campaigns to
encourage the sales force, buyers, and consumers. Promotions departments are
responsible for overseeing the creation of all catalogs, point-of-purchase, and
promotional/sales materials.
The publicity unit of TOYO NASIC TARIQ GLASS INDUSTRIES is responsible for
promoting each title and author in the media without direct payment to the media
communications.
1.7.4 MIS DEPARTMENT’S FUNCTIONS & STRUCTURE:-
The MIS Department of TOYO NASIC TARIQ GLASS INDUSTRIES is responsible for
all the company’s technological services, computers, company web site, networking
and data management as well as the everyday technical support of the company
personnel.
INTRODUCTION TO ORGANIZATIONS MIS DEPT
This chapter presents an over view of the organization’s MIS department. In this
chapter we focus on the introduction to MIS department, what actually the MIS
department is, its structure, functions/activities, staff, staff’s responsibilities, MIS
operations, resources & funds allocation and etc.
2.1 INTRODUCTION TO MANAGEMENTINFORMATION SYSTEM
Management Information System (MIS) has become a serious field of study largely
because of the development of computer and computer related technologies. MIS like
many other computer terms represents an evolving concept.
2.1.1 MANAGEMENT INFORMATION SYSTEM (MIS):-
§ A system to convert data from internal and external sources into information
and to communicate that information, in an appropriate form, to managers at all
levels in all functions to enable them to make timely and effective decisions or
planning, directing and controlling the activates for which they are responsible.
§ A system which may perform routine commercial processing functions, but
which is designed so that such processing will also produce information that
will be presented to that the results will be produced speedily… to enable
management to ascertain the progress of the organization in terms of satisfying
its major objectives.
2.2 STRUCTURE OF ORGANIZATION’S MIS DEPARTMENT:-
Information technology is more important in all organizations in this new era of
information technology and competition. In this new era, managers make fast
decisions, collaborate with other staff to develop the skills of the future. Every
organization demands quick and updated information. Information systems provide
support to its decision and enable to make accurate decision. Director MIS is the head
of Information System in TARIQ GLASS INDUSTRIES, who supervises the whole system.
The director of MIS Department is responsible of all activities of information system in
the organization.
2.3 MIS EMPLOYEES DETAILS & THEIR JOBTASKS:-
The total strength of MIS Department in TOYO NASIC TARIQ GLASSINDUSTRIES is 15
in morning phase, the management personal strength is 09 and in the evening phase the
strength is 06.
2.3.1 DIRECTOR MIS:-
§ Recommends various personnel actions including, but not limited to, hiring,
performance appraisals, promotions, transfers and vacation schedules.
§ Performs liaison duties in coordinating activities with other department’s
regarding user groups, hardware and software problems and solutions, time
scheduling and technical assistance.
§ Assigns, supervises and schedules work load of assigned staff, discusses and
evaluates progress of assignments, problems and changes daily with employees,
recommends employee disciplinary actions to the Board of directors when
necessary.
§ Plans and schedules the long-range work flow to provide the best possible
services, works with other departments to determine their long-range
information systems needs.
§ Attends meetings, conferences and training sessions to keep informed of
changes in hardware and software problems and legislative changes that affect
the operation of the company.
§ Develops overall designs to implement user requests, generates conceptual flow
charts, designs user/operator interface and determines how design can
efficiently make use of existing data base structures.
§ Develops and prepares the annual budget for the department.
2.3.2 MANAGER MIS:-
§ Ensures the analytics and technical team members are focused on the right set
of projects that are approved and prioritized by senior management as necessary
to drive key business decisions.
§ Manages projects and staff to develop strategies, which provide end-users with
an easy-to-use structure containing the strategic information necessary to do
complex analysis, modeling and segmentation.
§ Manages all aspects of development process, including business requirements
gathering, database design, coding, testing, documentation, implementation and
end-user training.
§ Leads resolution of system-related issues with internal technology and system
providers. Drive accountability to ensure appropriate resources are secured to
execute the necessary tasks. Analyze issues and recommend technology
solutions as appropriate.
§ Engage and direct process improvement activities to ensure department is
working at an optimal level. Oversees the development of departmental policies
and procedures. Ensures processes are documented and approved as
appropriate. Ensures areas of concern are addressed and procedures/ controls
are implemented to identify and mitigate future/ current risks.
§ Administers departmental budget, ensure expense/revenue targets are met.
Monitors staffing and volume levels to ensure appropriate resources are
allocated.
2.3.3 NETWORK ADMINISTRATOR:-
§ Full life-cycle management (define, design, develop, deploy) for various
projects relating to the upgrade and ongoing maintenance of the corporate data
network infrastructure.
§ Serve as a liaison with other IS teams and other company departments to define
requirements for and carry out various inter-team projects.
§ Provides r egular management reports to direct supervisor relating to network
health/maintenance/uptime/etc.
§ Directs responsibility for maintaining systems and support service level
agreements for systems uptime and support service levels.
§ Develops options, recommendations and associated cost benefits and
implements cost effective solutions.
§ Works with network engineers, technical staff, and vendors to develop and
implement network projects.
§ Oversees the development and execution of analytical strategies within
Servicing Operations.
2.3.4 DATABASE ADMINISTRATOR:-
§ Develops data model describing data elements and how they are used,
following procedures and using pen, template or computer software.
§ Develops standards and guidelines to guide the use and acquisition of software
and to protect vulnerable information.
§ Plans, coordinates and implements security measures to safeguard information
in computer files against accidental or unauthorized damage, modification or
disclosure.
§ Reviews procedures in database management system manuals for making
changes to database.
§ Reviews workflow charts developed by programmer analyst to understand tasks
computer will perform, such as updating records.
§ Writes and codes logical and physical databases descriptions and specify
identifiers of database to management system or direct others in coding
descriptions.
§ Approves, schedules, plans and supervises the installation and testing of new
products and improvements to computer systems, such as the installation of
new databases.
§ Develops methods for integrating different products so they work properly
together, such as customizing commercial databases to fit specific needs.
§ Identifies and evaluates industry trends in database systems to serve as a source
of information and advices for upper management.
2.3.5 SENIOR PROGRAMMER:-
§ Analyzes designs, supervises and coordinates the development of software
systems to form a basis for the solution of information processing problems
through the use of electronic data processing machines.
§ Designs and develops programming systems making specific determinations
about system performance. Defines functional specifications of the system for
the appropriate hardware.
§ Analyzes total system specifications and translates system requirements to task
specifications for computer programmers. Develops training programs to
promote staff development within departments affected by utilization or
revision of computer systems.
§ Maintains liaison with representatives of other company data processing
operations, professional organizations and equipment manufacturers to ensure
utilization of current principles and techniques.
§ Reviews and analyzes system specifications to determine whether all required
elements have been included. Consults with clients to gather information about
program needs, objectives, functions, features, and input and output
requirements.
§ Analyzes, defines, and documents requirements for data, workflow, logical
processes, hardware and operating system environment, interfaces with other
systems, internal and external checks and controls, and outputs.
§ Advises and works with user departments to resolve specific problems or make
changes in programs, computer applications, capabilities, alternative
programming approaches, limitations, etc.
2.3.6 PROGRAMMER:-
§ Writes programs creating a logical series of instructions the computer can
follow, applying knowledge of computer capabilities, subject matter and
symbolic logic.
§ Code instructions into programming languages and test and debug programs to
get intended results.
§ Converts detailed logical flow charts to language that computers can process.
§ Prepares flow charts and block diagrams and encode resultant equations for
processing.
§ Develops programs from workflow charts or diagrams, considering computer
storage capacity, speed, and intended use of output data.
§ Prepares detailed workflow charts and diagrams from programs to illustrate
sequence of steps to describe input, output, and logical operation.
§ Revises or directs revision of existing programs to increase operating efficiency
or adapt to new requirements.
§ Consults with managerial and engineering and technical personnel to clarify
program intent, identify problems and suggest changes.
§ Writes instructions to guide operating personnel during production runs.
Prepares records and reports.
§ Collaborates with computer manufacturers and other users to develop new
programming methods.
2.4 FUNCTIONS OF THE MIS DEPARTMENT:
MIS department of TOYO NASIC TARIQ GLASS INDUSTRIES LIMITEDplays a
tremendous role in the growth of the firm. MIS department involves a great deal in
expanding or automating the data gathering process. MIS Department processed the
required information demanded by the executive in short time for quick decisions.
2.4.1 MAJOR FUNCTIONS:
Following are the major functions of MIS department of TOYO NASIC TARIQ GLASS
INDUSTRIES LIMITED:
§ Determination of Information needs.
§ Information processing.
§ Information gathering
§ Information utilization.
§ Find out the requirements of the system to enhance the system ability.
§ Ensure new system installed on the required place.
§ Updates the information.
§ Ensures the data cant access by the unauthorized person.
§ Ensures the information flow smoothly.
§ Provide the actual information required by the different departments of the
organization in right time, including monthly, quarterly, annually and by
annually reports.
2.5 MIS OPERATIONS:-
The Management Information System in TOYO NASIC TARIQ GLASSINDUSTRIES has
developed its own application software which consists of different modules i.e. sales,
marketing, production, finance, accounts, planning and marketing time office (basic
payroll consideration), maintenance etc which are briefly described below:
2.5.1 SALES MODULE:-
Module is the part of the application software which performs the unique purpose. It
consists of:
§ Pre-sales activity, planning and availability support for the sales personal.
§ The actual entry of the sales order done by the salesperson at the point of sales.
§ Determining where the most efficient source of the ordered product is in
inventory and shipping it.
§ Delivery.
§ Customer billing.
§ Customer payment.
2.5.2 PRODUCTION MODULE:
§ Sales and operations planning SOP where the sales forecasts are used in a
production-planning model to check feasibility.
§ Master Production Scheduling MPS – The actual plan for the whole production
process.
§ Material Requirements Planning MRP – Where the production plan is actually
converted into raw materials input requirements.
§ Warehouse Control where the actual production takes place and is registered
into the system as finished goods.
2.5.3 PURCHASING MODULE:
§ When the production manager plans to manufacture something, a requisition for
the raw materials is prepared.
§ Purchase order sent.
§ Goods receipt inventory.
§ Payment to vendor.
2.5.4 FINANCE & ACCOUNTING MODULE:
§ Sales events are entered at the proper time in the ledger system.
§ Inventory to match goods shipped.
§ Inventory to match raw materials received.
§ Inventory to move values from raw materials to work in process.
§ Accounts Payable are set up for purchases.
§ Accounts Receivables reflects goods billed but not yet paid for.
§ Time Keeping.
§ Accounts Payable.
§ Revenue Management.
§ Accounts Receivables.
2.5.5 PLANNING AND MARKETING MODULE:
§ Records.
§ Data Collection & Analysis.
§ Customer Information System.
§ Geographic Information System.
2.5.6 PAYROLL CONSIDERATION MODULE:
This is the real overview look at the specifications on the sheets to see the wide range
of available features.
2.5.6.1 BASIC PAYROLL PROCESSING:
§ Get valid time information
§ Get each employee’s information.
§ Get YTD (year to date) information.
§ Calculate pay information.
§ Update employee information and YTD information.
§ Produce payback, pay stub and payroll reports.
2.5.6.2 LEAVES DATA:
§ Accumulated Vacation.
§ Vacation used by each individual.
§ Accumulated sick leave.
§ Individual sick leave used.
§ Accumulated personal time.
§ Individual personal time.
2.5.7 MAINTENANCE MANAGEMENT:
§ Preventative Maintenance.
§ Work Order Processing.
§ Maintenance History.
§ Cost Reporting.
2.5.8 OPERATIONS MANAGEMENT:
§ Production Scheduling.
§ Daily Production.
§ Equipment Utilization.
§ Production Reporting.
2.5.9 SOFTWARE SECURITY:
In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED all the employees of the MIS
Department and other interlinked departments have an identified user name one the
operating system level. Following are the main precautionary measures to secure the
data from the illegal user.
§ Every software module has a different user name defined along with the
password, which can be changed daily. Such precautions make sure that the
authorized person only accesses the data.
§ Secondly one can only takes the data in the database but can’t edit the data. The
MIS manager only edits the data.
§ In each system, antivirus is installed to prevent the virus from the network and
systems.
§ Backup of the database is made to recover the lost data if any occurs.
§ In server room only authorize person can enters.
2.6 MIS SUPPORT TO THE OTHERDEPARTMENTS:
MIS department extends all the departments and provide the updated information to
other departments which support for effective decision-making and helping to establish
effective plans. Now we narrate briefly how the MIS department supports to the other
departments.
2.6.1 MARKETING:
§ MIS Department provides the feed back on the effectiveness of the past
marketing strategies such as product planning, placing planning, promotion of
the product and price of the product.
§ The main function of the Marketing Department is to deal with the customers.
The MIS Department provides the customers data for effective decision
making.
2.6.2 ADMINISTRATION:
§ The main task of the Administration Department is to attain the objectives and
goals. The MIS Department provides the periodic and monthly reports to the
Administration / Top Management appraise the organizational performance and
can easily know strengths and weaknesses.
§ MIS Department provides each employees bio data and their performance and
all the other relevant information about the employees.
§ Provides accurate and current operation performance of the production
department.
§ Provides daily reports of the other departments.
2.6.3 ACCOUNTS:
§ Prepares the financial statements and balance sheets of the organization.
§ MIS Department also helps the Accounts Department in keeping the accounting
of the business transactions.
§ Provides the details of actual receipts and payment transactions to the
Managing Director.
2.6.4 TIME OFFICE & HR DEPARTMENT:
MIS Department provides information about the employee’s attendance and the record
of the each employee which is briefly explained below:
2.6.4.1 BASIC PAYROLL INFORMATION:
a. Personal Data.
b. Employee.
c. Employee Name.
d. Employee Address.
e. Address and Phone.
f. Sex, Birth Date, Marital Status.
g. Date Started Employee.
h. Department Code.
i. Job Codes.
j. Number of Tax Exemptions.
k. Exempt Status (eligibility / non eligibility for overtime).
l. Type of Employee (Salaried, Hourly etc.).
m. Salary or Wages if hourly etc.
n. Overtime Rate.
o. Vacation Accumulation Rate.
p. Sick Leave Accumulation Rate.
q. Leave Data.
r. Accumulates Vacation.
s. Vacation Used This Year.
t. Accumulated Sick Leave Used This Year.
u. Accumulated Personal Time.
v. Personal Time Used This Year.
2.6.5 PRODUCTION DEPARTMENT:
MIS Department facilitates the production department in the following ways:
§ Provides the information of phase of raw material and the date when reach in
the organization.
§ Provides the actual information of the new material in hand.
§ Provides information about the finished products, which pass the quality
standards and take place in the warehouse.
§ Directs the faults of the product occurs during the operation.
§ Provides the machine efficiency and best way to expand its production.
§ Daily report to the operation director about the production efficiency.
SYSTEM DEVELOPMENT PROCESS.
This chapter focuses on the System Development Process. What System Development
Process Means, analysis of the current process which is used in the selected
organization, its problems, techniques, problem analysis, requirements analysis, system
design phase as well as its implementations and evaluations & etc.
3.1 SYSTEM DEVELOPMENT PROCESS:-
System Development Process is a set of activities, methods, best practices and
automated tools that are used to develop and continuously improve information
systems and software.
3.1.1 SYSTEM
§ A system is an orderly grouping of interdependent components linked together
according to a plan to achieve a specific objective. Its main characteristics are
organization, interaction, interdependence, integration and a central objective.
§ It is an entity which consists of interdependent parts so that system theory is
concerned with the attributes and relationships of these interacting parts.
§ A definition which applies to business systems is a collection of men, machines
and methods organized to accomplish a set of specific functions.
§ Any group of components (functions, people, activities, events, and so on) that
interface with and complement one another to achieve one or more predefined
goals.
§ A system is a set of interrelated elements that collectively work together to
achieve some common purpose or goal.
§ The term system is derived form the Greek word systems, which means an
organized relationship among functioning units or components exists because it
is designed to achieve one or more objectives.
§ A regular or orderly arrangement of components or parts in a connected and
interrelated series or whole; a series or group of components necessary to some
operation.
3.1.2 INFORMATION SYSTEM
3.2 PRELIMINARY INVESTIGATION & PROBLEMANALYSIS
In the TOYO NASIC TARIQ GLASS INDUSTRIES Inquiry of limited scope undertaken to
verify whether or not an allegation merits further inquiry as a full investigation.
If we conclude that the idea is interesting, on the basis of the initial material in the
TOYO NASIC TARIQ GLASS INDUSTRIES, we will initiate a more thorough analysis in
order to provide the best basis for a decision about a possible investment. Such
preliminary investigation comprises, among other things:
§ Examination of novelty in patent and scientific literature
§ Technical analysis
§ Marketing analysis
§ Evaluation of development costs
§ Identification of business partners
§ Need for additional expertise
§ Definition of business goals company or sale of rights
§ Preparation of plans and budgets for an initial project, if appropriate.
We discuss the outcome of the preliminary investigation in the TOYO NASIC TARIQ
GLASS INDUSTRIES and decide whether idea has the potential or should be sold to a
third party. If so, we proceed with the so-called initial project within the framework.
3.2.1 OBJECTIVE OF PRELIMINARY INVESTIGATION:
The objective is to develop Loan Management System which will maintain the total
system in computerized way and generate required report that is very essential in every
single manner.
3.2.2 SCOPE:
§ Providing security to the loan information data.
§ Minimizing the large documentation.
§ Making calculations easy.
§ Easy maintains of Data
§ Reducing the extra manpower and overhead work.
3.2.3 CONSTRAINS:
§ As the current system is completely manual, making it automated need lot of
time by realizing the existing system. The time limitation is one of the greatest
problems in this regard.
§ The system will process lots of transaction. So the calculation part must be
reliable as much as possible.
§ In this organization, there are so many senior employee, who are not familiar
with computerized system and they are not interested to develop a
computerized system.
§ Most of the employee does not have good knowledge about computer. That’s
why some of there expectations are unrealistic.
3.2.4 EXISTING MIS SETUP:
The MIS setup which is currently used in TOYO NASIC is summarized in this figure
below:
3.2.5 CRITICAL ANALYSIS:
In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED system development normally
start when a manager and other functional areas personal feel that the current system is
outdated and not meeting the new trends of automation and era specifications.
Preliminary investigation is conducted when manager and other users submit the
request to the MIS department for new system and then such task is assigned to the
analyst to make a preliminary investigation.
3.2.5.1 EXISTING SYSTEM
Currently a simple database system in Visual FoxPro is working in the MIS
Department of TOYO NASIC TARIQ GLASS INDUSTRIES, which handle accounts
department and store department. I apply the business intelligence rules on this
database by creating a data warehouse for the existing data. The production department
of appliances division is handled manually and there is computerized database
management system for the department. Therefore, there is problem in handling the
data and quality check.
3.2.5.2 PROBLEM STATEMENT
The Problem of
Generating reports, static query, database management system,
data structure of simple transaction.
The impact of which
is
Imperfect decisions, inconsistent behavior of the database, slow
processing, duplication, poor strategies, inaccurate reordering,
A successful
solution would be
Enterprise Intelligent System which is based on the OLAP and
Data Warehousing (based on star schema) technique helpful in
decision making, generating reports against dynamic queries,
nested queries and ad hoc queries.
3.2.5.3 STAKEHOLDER AND USER DESCRIPTIONS
The system will provide services to the higher administration and management of the
departments of the TOYO NASIC TARIQ GLASS INDUSTRIES. The manager or
administrator will put a query and system will automatically execute and display the
reports in more descriptive and comprehensive form. He can also execute the hidden
queries in the queries.
3.2.5.4 PRODUCT OVERVIEW
System will facilitate the strategic level management of TOYO NASIC TARIQ GLASS
INDUSTRIES to make decisions, forecasting and better strategies. This system will also
provide the help to the operational level management to entertain queries generate
reporting and maintain stock status.
3.2.5.5 PRODUCT PERSPECTIVE
§ It is a computing environment where users can find strategic information, put
directly in touch with the data they need to make better decisions.
§ It can provide an integrated and total view of the products.
§ It can make the current and historical information easily available for decision
making.
§ It can make decision support transactions possible without hindering
operational system.
§ System can render the organizational information consistent.
§ System can present a flexible and interactive source of strategic information.
TOYONASIC’S Transaction Processing
3.2.6 DFD’S AND RISK ANALYSIS
Enter data
Reports
Fig Context Level DFD
3.3 REQUIREMENT ANALYSIS PHASE:-
The development of a solid foundation is the key to implementing a successful system.
A well-designed system maintains flexibility to accommodate new technologies and
changing user needs over time.
This approach puts significant emphasis of TOYO NASIC TARIQ GLASSINDUSTRIES on
understanding and interpreting the user needs and then carefully managing those needs
with management perspective and budgetary requirements.
Login
Define the system's functional architecture in terms of the operations / events that must
be performed in order to meet the mission goals of the system. This proceeds in a topdown
hierarchical nature and is independent of allocation to hardware, software, or
humans. The goal of the function analysis is to assist in defining and allocating
functions to the human that are best suited to their capabilities and limitations.
3.3.1 PROCESS DIAGRAM
Mission Analysis
Requirements Analysis
Function Analysis
Function Allocation
Design
Verification
3.3.2 EXISTING SYSTEM’S REQUIREMENTS ANALYSIS
Requirements analysis beings when management of the TOYO NASIC TARIQ GLASS
INDUSTRIES LIMITED decides to continue developing the new system on the report of
the analyst. In requirements analysis phase of development of the new proposed
system, traditional approach focusing is on the determining user needs, studying the
application area in depth, assessing the strength and weaknesses of the current system
and work methods and reporting results to the management..
NXTPAGE