Internship Report for MBA Information Technology (IT) AIOU

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 ULLAH for 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 ORGANIZATIONS 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 DEPARTMENTS STRUCTURE. 18

1.7.3. PRODUCTION DEPARTMENTS STRUCTURE. 19

1.7.4. COORDINATION, PR & HR DEPARTMENTS STRUCTURE. 20

1.7.5. MIS DEPARTMENTS 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 ORGANIZATIONS 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 DEPARTMENTS STRUCTURE 18

PRODUCTION DEPARTMENT STRUCTURE 19

COORDINATION, PERSONAL RELATIONS & HR DEPARTMENTS 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 SIDDIQUE CORPORATION 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 OF JAPAN 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 JAPAN on

turnkey basis.

Due to great efforts of the management and staff, the TOYO NASIC TARIQ GLASS

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 TARIQ GLASS

INDUSTRIES LTD.'S is a team of qualified, experienced and dedicated professionals.

TARIQ GLASS INDUSTRIES 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. 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 OPEN UNIVERSITY, 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 the TOYO

NASIC TARIQ GLASS INDUSTRIES LIMITED in order to examine its true position in

the market. I analyzed the various products offered TOYO NASIC TARIQ GLASS

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 THIS ORGANIZATION

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 NASIR SIDDIQUE

CORPORATION 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 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 by TOYO NASIC

GLASS OF JAPAN on turnkey basis.

Due to great efforts of the management and staff, the TOYO NASIC TARIQ GLASS

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 BAIGS 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 OF JAPAN.

TARIQ GLASS INDUSTRIES basically produce two types of line products in Pakistan.

1. Tableware Product

2. Container (Beverage and Food Product Jar)

TARIQ GLASS INDUSTRIES 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 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 GLASS INDUSTRIES 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 LIMITED is 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 NASIC has

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 GLASS INDUSTRIES 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 2006 was 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 DEPARTMENTS 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 GLASS INDUSTRIES 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 DEPARTMENTS FUNCTIONS & STRUCTURE:-

The production department of TOYO NASIC TARIQ GLASS INDUSTRIES coordinates

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 DEPARTMENTS FUNCTIONS &

STRUCTURE:-

The coordination, PR and HR department of TOYO NASIC TARIQ GLASS INDUSTRIES

have different activities. The coordination unit of TOYO NASIC TARIQ GLASS

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 INDUSTRIES works 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 DEPARTMENTS 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 MANAGEMENT INFORMATION 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 ORGANIZATIONS 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 JOB TASKS:-

The total strength of MIS Department in TOYO NASIC TARIQ GLASS INDUSTRIES 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 LIMITED plays 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 GLASS INDUSTRIES 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 OTHER DEPARTMENTS:

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 & PROBLEM ANALYSIS

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 GLASS INDUSTRIES 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 SYSTEMS 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.

3.4 FEASIBILITY STUDY:

3.4.1 TECHNICAL FEASIBILITY

In this report, I shall provide the solution to the running system of the organization

named as TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED. This system uses the data

warehousing techniques and models.

A periodic reporting system on the basis of previous data to higher management will

also be a part of the system, which will helpful to them in strategic decision-making. I

have the basic knowledge of Dot NET framework but advance technologies of database

i.e. OLAP, Data warehousing, Data mining and BI are explored and worked on during

the internship progress.

3.4.2 OPERATIONAL FEASIBILITY

In the project all the database technologies regarding Business intelligence and frontend

development will explore and implemented:

STEP 1: OLTP

§ Analysis of Store department

§ Design of Store department

§ Implementation of Store department

STEP 2: OLAP & DATA WAREHOUSING

§ Analysis of Store department

§ Design of Store department

§ Implementation of Store department

STEP 3: BUSINESS INTELLIGENCE (USING .NET)

§ Analysis of Store department

§ Design of Store department

§ Implementation of Store department

§ Testing and deployment of BI system

3.4.3 ECONOMICAL FEASIBILITY

The main concern here is on the system of the MIS Department of TOYO NASIC

TARIQ GLASS INDUSTRIES LIMITED. B y going computerized, TOYO NASIC can

achieve more reliability and accuracy.

A. MAINTAINABILITY

Since I am using .Net Technology therefore it is easy to maintain the whole system

whenever required.

B. COST BENEFIT ANALYSIS

Economic feasibility has been defined as a cost benefit analysis. How do you estimate

the costs and benefits? And how do you compare those costs and benefits to determine

economic feasibility?

C. COSTS FOR DEVELOPING THE SYSTEM

The cost for developing the information system can be classified according to the

phase in which they occur. Systesm development costs are usually applied once.

D. COSTS FOR OPERATING THE SYSTEM

These costs may be fixed (after regular interval but have relatively fixed rates or one

time costs & variable costs occur in proportion to some usage).

3.4.4 SCHEDULED FEASIBILITY

However the scope is flexible and can be extended. Because it is an industrial project

and TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED is such a large company, which

has many departments where we can also implement Business Systems. But we will

meet all the basic requirements of BS in store and production from which a further

useful work is continuing able.

3.5 SYSTEM DESIGN PHASE:-

System design represents how a proposed information system will meet the

information needs of the users, including logical and physical design activities, user

interface, data and process design activities that produce system specifications satisfy

the customer requirements in the system analysis stage.

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED designing phase begins, the

analyst and system development team determines how manual software & hardware

components will perform at logical and physical levels in each of the following areas:

§ Output Requirements.

§ Input requirements.

§ Processing Requirements.

§ Storage Requirements.

§ Procedure Requirements.

§ Personnel Requirements.

3.5.1 RISK ANALYSIS

In developing new projects it is common that risks or uncertainties always exist,

especially in the development of industrial type projects. Our mission is to minimize

the risks up to a possible limit in TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED.

Principal sources of risks include random variations in components and subsystem

performance, inaccurate or inadequate data, wrong information about work flow of

organization, integrity rules, problems in schemas and the inability to forecast things

about project development due to lack of prior experience.

3.5.2 SYSTEM DESIGN:-

Organizations may develop a system in many ways. One single ideal system

methodology is not working properly in all situations. Because some approaches are

better suite for developing small systems then large ones. During my internship in

TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED the prototyping approach was used.

Basically TOYO NASIC INFORMATION SYSTEM is small in nature due to the expansion

of its business plant, now they needs medium sized Information System which will

develop soon. The MIS Director of TOYO NASIC says, because the company is not in

such a position to develop a system at once so they use Prototyping approach and the

required modifications are made when required. The main benefit of Prototyping

Approach is that you can develop appropriate system in short time without bear heavy

expense. However the main motive of all good approaches is that,

§ High level of interaction with user’s involvement throughout the development

process.

§ Conscientious attempts to minimize development time and costs.

§ A loyal concern for improving system quality.

§ The use of rigorous and disciplined approach to system development.

§ Production of complete and perfect design specification and documentation.

§ Implementation of system that satisfies the user requirements and is easy to

maintain.

If any one keep in such issues for the development or modification of system ensure

that it reach in its goals.

3.5.3 GUIDELINES FOR IDEAL MIS SYSTEM DEVELOPMENT:-

The main and basic purpose of the Management Information System is to collate,

summarize and present data / information accurately that enables the managers to the

company to control its operations efficiently.

In the perspective of data gathering the ideal Management Information System has five

layers.

3.5.3.1 DATA SOURCES:

Data sources provide the three main sets of data to be considered.

A. OPERATIONAL:

This provides the actual values of the metrics that you measure to determine the

success of your business.

B. BUDGETS:

Represents short term estimates of the future values of the metrics.

C. FORECASTS:

Represents short term estimates of the future values of the metrics.

3.5.3.2 METRICS.

Define the things that you will measure to monitor the performance of your company.

The values you collect for operations, budget and forecasts provide the raw metric for

the analysis layer of your MIS.

3.5.3.3 ANALYSIS.

Defines how you will transform the raw metric data before presenting it to your

company’s employees. Employees at the lower levels of management in your company

are likely to need access to small subsets of the raw metric data that pertain to their

specific duties. As you move up through the management levels you will need to

summarize a wider range of metric data.

3.5.3.4 PRESENTATION.

Defines how you will present the transformed data to your company’s employees. Most

employees will need a simple dashboard that reflects the scope of their duties. The

dashboard should provide an easy to read display of the values of the key performance

indicators (KPI) for that person. It should be possible for the person to drill down

through any KPI to see the underlying data that determined the displayed value.

3.5.3.5 CONTROL.

Control provides the mechanism by which the employees of the company attempt to

manage the values of the KPLs.

Metric analysis component that provides templates and wizards to help you with the

following:

METRICS:

§ Defining the metrics that will help you measure the operational performance of

your company.

§ Collecting raw metric data (including operational budgets and forecasts.)

CONTROLS:

§ Defining management controls on the values of the metrics.

§ Providing workflow automation mechanism for managing metric values.

We can also build pilot management information system to meet your company’s

needs as part of a comprehensive business management solution. Constructing such a

system would include:

§ Automation of links to your operational data sources to gather raw metric data.

§ Automation of links to your budgets and forecasts data sourced to gather raw

metric data.

§ Creating a tailored analysis suite for your metrics.

§ Creating a tailored presentation suite including employee dashboards.

3.5.4 BENEFITS OF THE APPROACH:-

§ Helps you focus management attention on those things that affect the success of

your company and are subject to your control.

§ Helps you focus the attention of management on appropriate key performance

indicators across the company sending a message to all of your company’s

employees – it tells them what is important and what is expected!

3.5.5 DFD’S OF SYSTEM DESIGN:-

UC 1: LOGIN

Fig 5.1 Login Use Case

UC 2: CREATE GRN

Manager Login

Identification

<>

Database

Server

(From Use Cases)

<>

Manager Handle Category

Enter Category

Database Server

(from Use Cases) <>

<>

UC 3: HANDLE CATEGORY

UC 4: UPDATE ITEM INVENTORY

View Item

Manager Handle Inventory

Edit Item Enter Category Enter Item

Enter UOM

Edit UOM

<> <>

<> <>

<>

UC 5: UPDATE PRODUCT INVENTORY

View Product

Enter Model Edit Product

Enter Color

Enter Product

Enter Type

<> <>

<> <>

<> <>

Manager Handle Product

UC 6: HANDLE SUPPLIER

NewClass3 Handle Supplier

Enter Supplier

Database Server

<>

<>

UC 7: HANDLE TRANSFER OF ITEMS

Update Inventory

Database Server <>

Manager Handle Transfer of Items

<>

UC 8: CREATE WAREHOUSE

Manager Handle Warehouse

Enter New Warehouse

Database Server

<>

<>

UC 9: CREATING ISSUE VOUCHER

Manager Check Reports Director

Manager Handling Issue Voucher

Enter Item

<>

Enter Warehouse

<>

Database Server

(from Use Cases)

<> <>

UC 10: CHECK REPORTS

3.5.6 DESIGNING SYSTEM OUTPUTS:-

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED six important factors are

considered in Designing System Output.

§ Content.

§ Form.

§ Timelines

§ Media.

§ Format.

3.5.6.1 CONTENT:

Content refers to the actual pieces of data included among outputs provided to users.

System designers generally put too much content into managerial reports instead of too

little. Too much content can waste a lot of time of the managers by making then isolate

from the information that they need, it also diminishes the impact of truly important

information.

3.5.6.2 FORM:

Form refers to the way that content is presented to the users. Content can be presented

in various forms “quantitative” and “non-quantitative”, text, graphics, audio and video.

The reason behind is that managers prefer to the summary and detailed information in

relative rather than absolute form or in charts from such as pie charts, pie lines or bar

charts.

3.5.6.3 VOLUME:

The term volume is commonly used in technology t measure the amount of activity

taking place at a given time. The amount of data output required at any one time is

known as output volume. Heavy volume often suggest a fast frequently used output

device such as a high speed printer or a rapid retrieval display unit.

3.5.6.4 TIMELINES:

Timelines refers to when users needs outputs. Some outputs are required on regular,

periodic basis (weekly, monthly, quarterly or annually). Manager requires the out put

& get it when they need.

3.5.6.5 MEDIA:

Input output media refers to the physical substance or device used for:

§ Inputs.

§ Storage.

§ Outputs.

Output media choices include Paper, Video, Microfilms, Tape, Disk and Voice.

3.5.6.6 FORMAT:

The method or manner in which data are physically arranged is called a format. Such

arrangements are called output format when referring to data output on printed report

or on a display screen.

3.5.7 DESIGNING SYSTEM INPUTS:-

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED five important factors are

considered in Designing System input.

§ Content.

§ Timelines

§ Media.

§ Format.

§ Volume

3.5.7.1 CONTENT:

Firstly the analyst considers the types of data that need to be gathered to generate user

inputs. This is a complicated process because new proposed system means the new

information and the new information often requires new source of data, which can be

expensive. Sometimes the data needed for new proposed system are not available

within the organization but a close substitute might be.

3.5.7.2 TIMELINES:

Exactly when inputs are entered the system is critical because outputs cannot be

produced until certain inputs are available. So a plan is established regarding different

types of inputs entering the system. Timing logistics are usually most complex in

transaction processing and information reporting system.

3.5.7.3 MEDIA:

Another most important input consideration includes the choices of input media and

subsequently, the device on which to enter the data. Such user input alternatives

includes:

§ Workstations.

§ Magnetic Disks.

§ Keyboards.

§ Pen Based Computers.

§ And Voice.

3.5.7.4 FORMAT:

After the data content and the media requirements are determined, input formats are

considered. When specifying record formats the type and length of each data field, as

well as any other special characteristics are defined and avoid any error.

3.5.7.5 VOLUME:

Input volume refers to the amount of data that is entered in the computer system at any

time. And it is also considered important to determine the size of the input volume such

as light or heavy.

3.5.8 ENTITY RELATION DIAGRAMS

ER Model consists of 31 tables. Here 14 tables are shown in figure below

Here other 12 tables shown from the ER Model

Last 4 tables of ER Model are viewing in this figure

3.5.9 DETERMINING PROCESSING REQUIREMENTS:-

In this phase the project team decides which types of application software products are

needed and consequently which of the degree of processing the system needs to be

handled. This leads the system developers to decision regarding the system software

and computer hardware that most effectively get output for users.

3.5.9.1 APPLICATION SOFTWARE:

Application software’s are the programs that specify the information processing

activities required for the completion of specific tasks of computer users. The analyst

of the output and input usually suggests numerous processing requirements for

application software. These requirements normally address such issues as the basic

functions and capabilities that the software must possess. In TOYO NASIC TARIQ

GLASS INDUSTRIES LIMITED application software’s are developed according to the

organizations transaction activities, mostly the medium size information system is

developed.

3.5.10 DETERMINING STORAGE REQUIREMENTS:-

In the specification of storage requirements, accessing and organizing data are

considered. We also discuss need storage capacity and physical storage media options

which are identified.

§ Access the Organization.

§ Storage Volume.

§ Media.

3.5.10.1 ACCESS THE ORGANIZATION:

In this phase TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED project team

determines in what way the users will need access stored data sequentially, directly or

both. User access requirements then help determine appropriate data and file

organization methods. In some cases online order or billing require only sequential

access. Mostly business data are organized logically into records. However physical

data placement both file oriented and data processing methods are also organized

sequentially.

3.5.10.2 STORAGE VOLUME:

Storage volume relates t the aggregate of the:

§ Number of Data.

§ Records.

§ Strengths.

§ Sets.

§ Or all such matters are accessible to the users at any time.

Generally system developers determine the total bytes required for the number of

records expected to be stored that byte requirement is double or triple to arrive at total

secondary storage requirements.

3.5.10.3 MEDIA:

Finally the system developers determine the storage media according to the size of

transaction which are as follows:

§ Diskette.

§ Hard Drive.

§ Tape.

§ Optical Disk / USB etc.

Normally for huge volume data storage the media optical disk is more feasible for ruse.

But in TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED the hard drive is used for the

data storage.

3.5.11 DEVELOPING PROCEDURE FOR USING SYSTEM:-

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED the system design is incomplete

until the procedures for using the system are finished. We define the procedure in this

way “A procedure is set of rules” procedure fall into two major categories:

§ Work Procedure.

§ Control Procedure.

3.5.11.1 WORK PROCEDURE:

This complies several procedures / ways under which it is inducted as the work should

be performed. These are call work procedures.

3.5.11.2 CONTROL PROCEDURE:

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED control procedure indicates how

work should be controlled. In computerized information system several controls must

be implemented to ensure the secrecy and security and accuracy of the data.

§ SECURITY CONTROL:-

Security control ensuring to eliminate the risk of unauthorized access of data, for

eliminating such risk we use the password, protection, mechanism etc.

§ ACCURACY CONTROL:-

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED computer information system

used the audit trail for the accuracy of the data so that accurate complete information is

stored. Audit is used to certify both the correctness of account balances and adherence

to a set of procedures or standards. Audit trails are used to trace the computer system

outputs back to original source documents.

§ PRIVACY CONTROL:-

Regarding technology, privacy control ensures the protection of people’s rights

regarding how information about them is suppressed or used.

3.5.12 DETERMINE PERSONAL REQUIREMENTS:-

In this phase we discuss personal specification for the personnel involve:

§ Work Description.

§ Personal Qualification.

§ Training.

3.5.12.1 WORK DESCRIPTION:

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED the most critical personal related

specification involves the work that people perform during their job. Total business

operations are divided into well defined goals and then those tasks are combined into

job. Each job must be feasible from the organization point of view as well as

responsible in accordance with the individual’s capabilities.

3.5.12.2 QUALIFICATIONS:

When jobs are defined qualification is another taster for individual who fill those jobs.

For example, for the post of data entry operator the keyboard skill is necessary, etc.

3.5.12.3 TRAINING:

Training of the personnel is a major ongoing cost that is considered when the system is

being designed. For the new system software and hardware the training of the personal

is done for the purpose of getting desired results from the software.

TRADITIONAL DEVELOPMENT APPROACH FOR SYSTEM DESIGN &

IMPLEMENTATION:-

PROTOTYPING APPROACH FOR SYSTEM DEVELOPMENT:-

3.6 END USER DEVELOPMENT:-

With the increase availability of low cost technology, end user end user development

on of them. In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED the end user

development, it is the end user not the computer professional who is responsible for

systems development. The number and nature of systems development activities

followed by the end user often differ from those found in more formal approaches.

Three way in which end user development might be implemented, “Traditional

Approach”, “Prototyping” and an intuitive approach”.

3.6.1 FAVORING CIRCUMSTANCES OF PROTOTYPE APPROACH:

A system under development is local rather than enterprise wide.

§ The system under development is inexpensive.

§ A suitable environment of end user development tools and professional

expertise is available.

§ Standards exist to maximize divergent efforts by the end users and other danger

to the organization.

§ High levels of security are not necessary for the system being developed.

§ The system under development involves numerous customized queries and

reports.

§ The system under development can easily be built and supported by the end

user.

§ The system under development does not involve high volume transaction

processing.

§ The development time is short and cannot be accommodated by the MIS

department.

§ The user must be heavily involved in the development process.

3.6.2 SYSTEM IMPLEMENTATION:

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED after data gathering and choosing

the hardware, software and services necessary to operate the system, the system

implementation phase of development begins. Implementation phase consists of the

following activities:

§ Scheduling.

§ Program Coding, Debugging and Testing.

§ Training.

§ Conversion.

3.6.2.1 SCHEDULING:-

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED to ensure that the system will

work by a certain date the analyst must prepare an implementation timetable. In this

time table, all the activities are desirable as how the implementation must start and

finished.

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED a detailed implementation

timetable is often essential to develop management confidence in the installation plan

and to ensure uninterrupted operations during the implementation period.

3.6.2.2 PROGRAM CODING, DEBUGGING AND TESTING:-

PROGRAM CODING. Coding is the process of writing that can run the computer

Hardware.

CODING & DESIGN TOOLS. Three coding and design tools are widely recognized as

potentially making programmers more productive are:

I. Structure Programming Techniques.

II. Software Prototype.

III. Object Oriented Programming.

I. STRUCTURE PROGRAMMING TECHNIQUES.

“A set of program design and coding tools developed throughout in 1970 which

provide programmers with a well defined and familiar set of structure.”

Using structure techniques, programs can be written in a systematic, standard style,

thereby reducing development time and errors plus making programs more

maintainable.

II. SOFTWARE PROTOTYPE.

The quickly coded 4GL program is called prototype software. The 4Gl product that

facilitates creation of software prototypes is an application generator. Application

generators and software prototypes are useful when users are not exactly sure what

they want and what time is a limiting factor in software development.

III. OBJECT ORIENTED PROGRAMMING.

An object oriented programming used to developed programs that create and use

objects to perform information processing tasks.

PROGRAM DEBUGGING. Debugging is a methodical process of finding and reducing the

number of bugs, or defects, in a computer program or a piece of electronic hardware

thus making it behave as expected. Debugging tends to be harder when various

subsystems are tightly coupled, as changes in one may cause bugs to emerge in

another.

PROGRAM TESTING. Testing (sometimes called compliance testing) is that part of an

internal control review which assesses whether actual practice follows, or complies

with, prescribed policies and procedures. The assessment is made by interviewing or

observing staff, following a transaction through the process, or sampling

documentation of transactions to determine if required steps are executed.

3.6.2.3 TRAINING:

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED meteorology, training is when a

successive series of showers or thunderstorms moves repeatedly over the same area,

usually causing some form of flooding, especially flash floods. Often, this happens

when a line of rain or storms forms along a stationary front, and moves down the

length of the front, while the front is stalled. It is named so because this is similar to the

way train cars move down a track in a line, over and over the same point, without the

track moving.

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED with the burst of activity in end

user computing and the appearance of new tools for computer professional, training is

becoming a major component of implementation sector.

The main object of training is that the users are well known to operate the program

according to the specification.

3.6.2.4 CONVERSION:

The initial operation of a new computer based system can be a difficult task. Such

operation is usually a conversion process in which the Hardware, Software, People,

Network and data Resources of an old information system must be converted to the

requirements of a new information system. This usually involves a Parallel, Phased,

Pilot or Plunge conversion process from the old to new system. Four major forms of

conversion are as follows:

I. Parallel Conversion.

II. Phased Conversion.

III. Pilot Conversion.

IV. Plunge or Direct Cutover.

I. PARALLEL CONVERSION.

Conversion can be done on a Parallel basis, whereby the old and new system are

operated until the project development team and end user management agree to switch

completely over to the new system. During this time the operation and result of both

systems are compared and evaluated. Errors can be identified and corrected and the

operating problems can be solved before the old system is abandoned.

II. PHASED CONVERSION.

The phase conversion can be allows a gradual implementation processes to take place

with an organization.

III. PILOT CONVERSION.

In pilot conversion where one department or other serves as test site. A new system can

be tried out at this site until developers feel it can be implemented throughout the

organization.

IV. PLUNGE OR DIRECT CONVERSION.

The installation of the new system can be accomplishes by a direct cutover plunge to

the new developed system.

3.7 SYSTEM EVALUATION:-

In TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED the performance and worth of the

MIS department is assessed in the following ways:

3.7.1 PERIODIC PERFORMANCE REPORTS:

Periodic reports describes how much the MIS department performed with respect to staying

within planned spending limits.

3.7.1.1 USER SURVEY:

The user surveys such as questioner and interviews indicate about the performance of the MIS

department. So in this way head of the department knows about the feed back of the system.

And if any problem is found he tries to resolve it.

3.7.1.2 SYSTEM PERFORMANCE:

The main object of the system performance is that is the workstation working properly or not?

Is the system performing task or not? If not, then remedial action is taken to victory.

3.7.1.3 EARLY WARNING SIGNALS:

Early warning signals means that some thing is seriously wrong. In this way the MIS staff

evaluates the system & removes the miss-happening / errors on the spot.

3.7.1.4 OVERALL EFFECTIVENESS:

If MIS is performing in commensurate plan it means the system is running effectively.

SWOT ANALYSIS.

In this chapter the System Design, SWOT (Strengths, Weaknesses, opportunities and

Threats) Analysis of TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED.

4.1 SWOT ANALYSIS:-

TOYO NASIC TARIQ GLASS INDUSTRIES LTD is the leading organization of Glass

products in PAKISTAN. TARIQ GLASS INDUSTRIES is the only organization in ASIA

which has H-28 latest glass manufacturing machine which produces thin wall light

tableware products.

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 OF JAPAN.

Now if we have a critical look on all the situation and circumstances then we came to

know that this industry has a Monopoly in the Pakistani glass market. No other

company is there who can be able to become a challenge for TOYO NASIC TARIQ

GLASS INDUSTRIES LTD in the market. According to this we can say that TOYO NASIC

TARIQ GLASS INDUSTRIES LTD just has opportunities and strengths in the glass market

of Pakistan and to some extent have the weaknesses & threats as well. But most of

times these type of industries that have the monopoly in the market create hurdles for

upcoming related industries. In this context we can say that TOYO NASIC TARIQ

GLASS INDUSTRIES LTD currently have no fear of loosing the market share in its current

position in the market.

4.1.1 STRENGTHS:-

TOYO NASIC TARIQ GLASS INDUSTRIES LTD is financially strong and it owns largest

assets in Pakistan as compared to others and has earned 96.123 MILLION of profit last

year.

The service of transferring products either with in the country or outside the country is

the fastest as compared to others. Almost 15000 employees are working in the

organization.

4.1.1.1 STRENGTHS OF THE COMPANY:-

§ TOYO NASIC TARIQ GLASS INDUSTRIES LTD is captures 90% OF LOCAL GLASS

MARKET share in the Pakistani market.

§ TOYO NASIC TARIQ GLASS INDUSTRIES got ISO 9001 2000 certification on

MAY 15, 2001,

§ Since 1993, TARIQ GLASS INDUSTRIES has made tremendous growth and

increase in its business volume day by day.

§ Only TOYO NASIC TARIQ GLASS INDUSTRIES LTD is captures H-28 machine is

erected this machine is only in the Asia which produce the light and thin wall

glass products.

§ Three main glass production company’s of Pakistani market are running under

the name of TARIQ GLASS INDUSTRIES LTD.

§ Now the management of TARIQ GLASS INDUSTRIES plans to further increase its

exports of tableware products to a large number of EUROPEAN COUNTRIES.

§ Now days TOYO NASIC TARIQ GLASS INDUSTRIES LTD produces up to 170

TONS of glass per day.

§ The plant of TOYO NASIC TARIQ GLASS INDUSTRIES LTD boasts a production

capacity of almost 200 METRIC TONS of glass tableware per day.

§ TOYO NASIC TARIQ GLASS INDUSTRIES LTD is the only industry which

produces the world class level glass in the Asian countries and have capture the

maximum share in the Asian market.

4.1.1.2 STRENGTHS OF THE MIS DEPARTMENT:-

§ MIS Department of TOYO NASIC TARIQ GLASS INDUSTRIES LTD has the

Extensive network and large database, allows the departments as well as the

staff to access to a stable and low cost database.

§ The ongoing up graduation of technological infrastructure is expected to

enhance the efficiency of information system, there by strengthening,

monitoring procedures and expediting decision-making. Further automation of

front-end activities will enable the TOYO NASIC TARIQ GLASS INDUSTRIES

LTD to improve customer service.

§ Given the scope of the TOYO NASIC TARIQ GLASS INDUSTRIES LTD activities

and the existing level of impairment in assets, capital base of the company

requires further strengthening.

§ A good system of communication flow is a great advantage to TOYO NASIC

TARIQ GLASS INDUSTRIES LTD.

§ The department of MIS is handling all kind of software’s as per the TOYO

NASIC TARIQ GLASS INDUSTRIES LTD departmental requirements.

§ Major staff of the TOYO NASIC TARIQ GLASS INDUSTRIES LTD is experienced.

§ TOYO NASIC TARIQ GLASS INDUSTRIES LTD extensive network and large

customer base allows the access to a stable and low cost product base.

4.1.2 WEAKNESSES:-

§ Over burden on staff.

§ Not highly qualified staff.

§ Unionism, centralization of authority, favoritism and nepotism has worked in

and few employees are gaining undo advantage that tarnish the image of TOYO

NASIC TARIQ GLASS INDUSTRIES LTD.

§ Employee’s turnover is higher.

§ There is lack of proper advertising like sponsoring of any festival or any event

like sports etc.

§ The role of personal and relationship managers may increase its market share.

§ Lack of resources.

§ Lack of volunteers.

§ TOYO NASIC TARIQ GLASS INDUSTRIES LTD has third class infrastructure like

furniture fixture etc.

§ There is no customer relation officer in TOYO NASIC TARIQ GLASS

INDUSTRIES LTD.

§ There is lack of coordination among different departments in TOYO NASIC

TARIQ GLASS INDUSTRIES LTD.

§ There is a lack of discipline in each department and employee of TOYO NASIC

TARIQ GLASS INDUSTRIES LTD.

§ A bad system of communication flow is a lowest advantage to TOYO NASIC

TARIQ GLASS INDUSTRIES LTD.

4.1.3 OPPORTUNITIES:-

“The Future belongs to those who see the possibilities before they become obvious”

§ With renewed focus towards expanding the portfolio, efforts have been directed

towards consumer.

§ Both these areas particularly consumer financing remains largely unexplored

territories for the local sector and require a high level of risk surveillance.

§ High skilled labors force should be employed.

§ Online order placement facilities should be enhanced.

§ Employees having professional thinking and attitude toward their work as well

as having good industry experience should be hired by giving them special

salaries.

§ TOYO NASIC TARIQ GLASS INDUSTRIES LTD should try to increase their

branches in foreign countries.

4.1.4 THREATS:-

§ The main threat which TOYO NASIC TARIQ GLASS INDUSTRIES LTD has to

face now days that is the products of china. China has a much enhanced

industry and growing day by day. Chinas capture all the markets of the world

due to the low cost and high quality. Now in these days the major competitor of

TOYO NASIC TARIQ GLASS INDUSTRIES LTD is China which provides the high

quality products in a very low price as compare to the market.

4.2 WEAKNESSES OF THE MIS DEPARTMENT:-

Although MIS department of TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED is

trying to perform good job and supporting other departments yet there are some short

falls which I observe during my internship program and described them below:

§ The main short fall is that the information system processed the information

very slowly due to overloading.

§ The information system is based on COBOL so it’s very difficult to end users

to retrieve the required data easily as they are not receiving proper training.

§ Delay between transaction and output.

§ Information gathering will always be out of date.

§ Information from master file is not easily available.

§ Lack of speeding printer such as laser jet currently the organization uses the

Dot matrix printers.

§ Complaint about the trouble shooting is rectifying slowly.

§ Duplication of the data occurring in information system.

§ Lack of training facility.

§ Poor quality of computer such as Pentium I & II.

§ MIS department is facing overload of work.

§ Insufficient coordination of information among the departments.

§ The trouble shooting complaints are increased day by day.

CONCLUSION

TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED is the monopolistic organization of

Glass products in Pakistan launches versatile glass products in local market and export

to the other countries and now exports its glass products to European countries. TOYO

NASIC TARIQ GLASS INDUSTRIES LIMITED launches the aggressive market strategies to

increase its sales volume.

TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED has still some short falls in its

system. The Managing Director of the firm is determined to overcome such short

comes and develop the organization as MODEL ORGANIZATION. Employees

believe that management takes action in span time for job satisfaction. The channel of

the communication and other information are not followed properly by different

departments which is the main cause of reducing the end user’s productivity.

RECOMMENDATIONS

Following are the suggestions to further enhance and update the quality of the MIS

department of TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED.

§ The immediate need is to modify or develop the new system as per demand of

the time so that further requirements are met accordingly.

§ Made the system easy and end user friendly.

§ Provide high quality services and system documentation for all end users.

§ Improve the user interface and user training program in order to enhance end

user productivity.

§ Improve the sharing of data among the departments.

§ Close down plug-in the communication gaps between different departments.

§ Increase the latest Pc’s on the job.

§ Recruit new and trained employees to decrease the work load on current

employees.

§ Proper maintenance of the system.

§ Use the high speed technology which is basic need of a good information

system.

§ The staff must be properly trained and skilled. Secondly, the right person

should be put to the right job so that the customer may be satisfied with the

conduct and performance of the staff.

§ Appointment on key post should not be made on political basis because people

appointed in this way are not only capricious minded but they also cast bad

reflection upon the reputation of the organization.

§ Maximum incentive in the form of profit and counter services should be offered

to the customers. Consequently, such incentives would bring more and more

business in return.

§ Customer satisfied with the counter service proves an asset to the organization.

Therefore, utmost care should be taken while dealing with the customers at the

counter. The staff at the counter must be highly skilled and trained according to

the changing trends of the world.

§ Fair appraisal system must be introduced. Equality appeals to everyone while

injustice discourages every qualified, hardworking and conscientious employee.

§ Every eligible employee should be rewarded according to his merit. All the

above suggestions will earn a good reputation and goodwill for the

organization.

BIBLIOGRAPHY.

In this chapter all sources are mentioned through which all the data for the preparation

of this internship report is gathered for the MIS department of TOYO NASIC TARIQ

GLASS INDUSTRIES LIMITED. All of the sources, web sites, books are mentioned.

.

7.1 REFERENCES & SOURCES USED:-

All of the references and sources from where the data gathered for this report are

mentioned herewith for your kind concern.

7.1.1 ORGANIZATION

§ Annual Reports of TOYO NASIC TARIQ GLASS INDUSTRIES LIMITED.

§ www.tariqglass.com

§ Management of the Organization.