ITDOCU - ON SemiConductor

A Final Academic Project Proposal Presented to The Faculty of De La Salle University – College of St. Benilde

In Partial Fulfillment of the Requirements for the Degree of Bachelor of Science in Information Systems Prepared and Submitted By: Buluran, Joseph Rannie M. Empino, Romir Gian O. Malabanan, Jinno Rafael R.

3

rd

Trimester, SY 2008-2009

_____________________________ Ebenzer Uy IT-DOCU Professor

PANEL OF EXAMINERS

________________________ Panel Chair

_______________________ Panel Member

1

_____________________ Panel Member

Table of Contents

Page

I. Executive Summary

3

II. Introduction

5

III. Analysis of the Existing System

11

IV. Design of the Proposed System

22

V. IT Infrastructure

40

VI. Implementation Plan

43

VII. Reference

55

VIII. Appendices

56

2

I. Executive Summary The group decides to focus our study on the semiconductor industry because it has a wider market segment and we look for probabilities in enhancing their existing systems. So, our group picked ON Semiconductor as our subject of interest for our study. Fortunately, one of our group mates has a relative working in ON Semiconductor. So, we ask for her permission to help us in conducting our study regarding on their existing systems. Our source gives us a couple of possible systems that needs to be improve or change. We chose the existing recording system on their production area as our target due to some vital elements are not automated. Those vital elements are the sub processes such as baking, molding and welding of IC’s, evaluation of machines, equipments and operators in-charge. So, our group planned on how we will approach the company and the appropriate actions on conducting our study. We ask for resources with some cautions in handling the data due to its confidentiality, ask for facts about the existing system and browsing the available data in their web page. The data is present and ready to be digested, so we perform brain storming and then summarize the facts in finalizing our proposal. Our main proposal is to enhance the existing recording system on their production side including the mentioned vital elements that must be included in the automation. The group also approves the implementation of new features in the web site of the company where the clients can view the products and shipment status. We will only use the existing database of the company in order to lessen the proposal implementation cost.

The beginning of the project will be on December 1, 2008 and expected to be finished on March 1, 2009. It will be done in the office of ON Semiconductor Company in Carmona, Cavite to utilize the equipments available in the company and to lessen the hassle in connecting to their existing servers as the group creates and tries the upgraded software. The group reviews the existing languages and server types used in order to prepare the group in planning what type of approach the group will do. After the review of the language and server type, the group will start in coding of the proposed system. It will take at least one in doing the codes because the group will assure that the new updates are compatible in the existing system. Then after 1 month of coding, it will be tested on the database of the company to ensure it will work and check for errors and will take 3 weeks in performing the testing. The remaining time period will be reserve for the revisions purposes, fixing of errors, testing and for evaluation of top management.

The factors that motivate us in completing the whole project are; to race against the rising global crisis in the economy in which ON Semiconductor is one of those companies that are affected by the global recession and pressure in completing the project.

The value of the proposed system to the business are; the company will give their clients the ability to track their product and order status which can be viewed as the access they web page of the company, the top management will be able to view the full report and conduct reviews or assessment based on the productions performance and it will be easy for them to perform failure and follow up analysis in case of recalls and need of past information are to take place.

3

The benefits of the system will reduce the time of delay in case of failure analysis and relationship with the clients will be strong due to the openness of the company. In the presence of the company’s presence of intranet all through accessible in the premise of the company, therefore a lot of major benefits shall also realized because the information can be brought into reality or shall the group say into action in a much faster pace. Delegation of task for the Top Management may also be affected positively because if in some cases a short notice of letter were about to be announce to the company, therefore all of the employees can now be aware regarding it and can do something about.

By improving system, the group will not focus to integrate a new system for the company at all. All that the group wants is the reinforcement and to compete over its competitors, in terms of the systems that deal with the processes and sub processes of the company in the long run. Much competitive advantage also shall be exposed if changes are to be made with the system of the company. Most especially, with the improvement of the system meaning from the Top Management, and other employees and workers are to expect that they are now elevated in a way by making their system improved. An overview now shall be provided for their mindsets for a new and innovative way and tool of attaining the vision mission, goals and objectives of the company will take place.

4

II. Company Introduction A. Company Profile With its global logistics network and strong product portfolio, ON Semiconductor (Nasdaq: ONNN) is a preferred supplier of efficient power solutions to customers in the power supply, automotive, communication, computer, digital and consumer, medical, industrial, and military/aerospace markets. The company’s broad portfolio includes power, analog, DSP, mixed-signal, advance logic, clock management and standard component devices.

Global corporate headquarters are located in Phoenix, Arizona. The company operates a network of manufacturing facilities, sales offices and design centers in key markets throughout North America, Europe, and the Asia Pacific regions.

• • • • • • •

Pro Forma 2007 revenues of $2.2 billion Leader in analog and mixed signal technology and design Industry leader in efficient power management Automotive products leader Leading custom products in Medical, Mil/Aero and Industrial end markets World class, high volume, cost effective manufacturing Leading standard products in Automotive, Computing, Consumer and Communications end markets

Main Headquarters 5005 East McDowell Road Phoenix, AZ 85008 USA Telephone: 1 602 244 6600 Customer Inquiries: 1 888 743 7826

B. Company History ON Semiconductor Company started when it spins off from Motorola in 1999. As it enters the year 2000, it acquires the Cherry Semiconductor in East Greenwich, Rhode Island. The company also named Keith Jackson as their President and Chief Executive Officer. As the company enters year 2005, they had refinanced 12% high yield debt with convertible bonds less than 2%. On the year 2006, they had introduced the “Green Point” which is a power efficient reference design. In the 2nd quarter of the year, they have been awarded KEN SHARMA EXCELLENCE AWARD for Supply chain Management by AMR and i2 and as they enter 2007, they had buys back 45 million shares of ONNN stock. In the middle of 2007, they acquire the rights in Analog Devices Computing Division Limerick, Ireland, San Jose, California, Longmont, Colorado and finally, in 2008, they acquire AMIS and generate 2.2 Billion dollars.

5

See company timeline: Appendices

B.1. Vision Statement ON Semiconductor is dedicated to becoming the premier supplier of high performance energy efficient silicon solutions worldwide.

B.2. Mission Statement To provide our customers with high quality, cost effective solutions to solve the demanding power and signal management design challenges.

B.3. Products and Services The main product and service offered by the ON Semiconductor is efficient power solutions to the power supply, automotive, communication, computer, and digital and consumer, medical, industrial, and military/aerospace markets.

(Note: The Market segments will be attached on the appendices.)

6

B.4. Organizational Chart Corporate Organization

7

Sample Manufacturing Site Organization Corporate Functions Reg. FA & Rel. Reliability Eng’g

President and General Manager

Quality - External Mfg & Direct Mtl’s External Mfg Operations

Executive Asst

Assembly Operations

Product & Test Engineering (Carmona)

Test Operations (Carmona)

Product & Test Engineering (Calamba)

Test Operations (Calamba)

IE / Planning / Procurement / Logistics PC Wan

Facilities, Environmental, Health & Safety

Program Mgt & LSS

Philippines Mfg Quality

Manila Global Dist. Center Asia Mfg HR Regional Dev. Center Data & Doc Config Mgmt Asia Region SOX Finance Shared Services Regional EHS

Human Resources

8

Finance Controller

Information Technology

New Package Development

C. System Overview The team proposes full automation of shop floor recording system for ON Semiconductor Philippines, Carmona, where it will give real time status of the lots in process including traceability to what customers a particular product was shipped. This proposed system will provide a management tool to know what is the status of a certain lot, in what process it is being processed, were there are failures or is it within specified requirements. It will also provide the cycle time per process or the total cycle time for its completion. Depending on the company’s agreement with its customers, some even grant access to its customers to provide them real time status that will guide them in their manufacturing planning or order acceptance. The status of a product will come up to the reports of the operators in charge or it can be viewed online by the top management and the buyers which are the main customers of the company as well. The group will use the existing intranet and extranet of the company to lessen the implementation cost.

The group focuses on this business process for a semiconductor company, in this business, manufacturing cycle time is leverage for customers preference.

This is a fast pace industry, delays in delivery will entail cost on the part of the company. Real time status along the manufacturing process will provide management a tool to reschedule commitment or a proactive basis for corrective action in case there is a problem encountered. Failure in the field of delivered products will also cost much on the part of the company as they will have to pay for the assembled parts or even product recall costs.

D. System Goals and Objectives The proposed system will provide a solution where machine status, process monitors is linked to the proposed shop floor recording system. Even equipment and operator’s qualification and certification are controlled, i.e. unqualified equipment which is not yet enrolled in the system can not be transacted or an uncertified operator can not transact in the system. Process monitors are timely encoded or equipment, depending on its capability, can be linked to the system for real time data. The system will also provide online traceability where a particular product//lot was shipped. This will provide easy containment/recall in case a problem is discovered.

9

E. Assumption, Scopes and Limitations Assumption Our group assumes that the existing system is not yet automated and close linked with other sub processes. Though, may also give us the difficulty in studying the whole recording system as there might be proprietary and confidential information, but this may be addressed through understanding their specifications, language used and review the documentation in order for us to know our plan of approach. Our group also assumes that the communication between us and the company will be quite difficult because of operations schedule and the company has decided to temporarily reschedule entertaining outsider for study purposes.

Scopes The scope of our project is the whole recording of manufacturing processes of ON Semiconductor Carmona, Philippines. It will contain the records of the main and sub processes, evaluation and qualification equipment and subsequent preventive maintenance records, and process monitors which will be linked to process control and affected lot disposition, in case there will be off-centered processes. This will also include the status of the product in process and the shipment status if it is ready for shipment or not. Our group has also decided to integrate the some records on the existing intranet of the company for real time analysis, with controls on the access and manipulation by authorized associate functions.

Limitation The limitation of the project will simply concentrate on the stated scope of the project. So in short, the proposed shop floor recording system will only be applicable to the manufacturing shop floor control integrated with interdependent equipment and operator qualifications, equipment performance, process monitors and subsequent holding of lots, if necessary, and disposition. In addition, process capability can also be computed and analyzed from this automated and integrated manufacturing shop floor controls. Other departments, which may have existing online processes, are not included in the proposed system.

10

III. Analysis of the Existing System Use Case Diagram and Narrative

Check Main Process

Check Sub Process Update Database <<includes>>

<<includes>>

CHECK PROCESS

Review Hard/Soft Copies

Supervisor <<includes>>

Check Operatorâ&#x20AC;&#x2122;s Status

11

<<includes>>

Check Machine Status

Top Management

Use Case Narrative Identification summary Title: Existing Shop Floor Recording System Summary: The existing system does not include the recording of the Operator and Machine Status in their database. The Order and Product status are also not included in the automation process.

Actors: â&#x20AC;˘ Supervisor â&#x20AC;˘ Top Management Person in Charge: Supervisor Flow of Events Preconditions: 1. Piling up of hard and soft copies for recording purposes.

2. Only vital processes are automated.

3. Clients are not allowed to view their order and product status online.

Main Success Scenario: 1. The operators will record their main reports on the database through while the other reports are through hard and soft copy.

2. A Supervisor will check the system through reports given by his/her operators based on the scheduled checking.

3. He/She will check the Machine or equipment to know if it is in good condition and suitable for production.

4. The operator can evaluate the production levels to know if they meet the specify requirements for each level.

5. After checking, the supervisor will only update the reports about the main and sub processes. â&#x20AC;&#x153;Alternative Sequences: A1: Skipped process evaluation The operator has the probability of forgetting a vital process evaluation which is included on the whole report.

A2: Unreliable operator report There is a tendency that operators might skip or forge a certain report due to some bad personal behaviors.

A3: Checking is delayed Delays on releasing of overall report might happen due to inconsistent scheduling of checking or other personal reasons which it will result to not updated database where as it is vital for weekly Top Management reviews.

Error Sequences E1: Delayed Record Checking

12

Delay in checking might result in unscheduled updating of records.

E2: Not updated records There will be a vacant slot in the recording system so, the top management will ask for an immediate action.

E3: Top Management will conduct immediate response If the problem is not addressed immediately, there is a possibility of conducting meetings that as much as possible, it must be avoided due to it will cost time, money and productivity level of the company.

PostConditons: 1. The database is only updated with main and sub process reports.

2. Top management can view the reports.

13

Activity Diagram â&#x20AC;&#x201C; Module 1: Check Main Process Shop Floor Recording System

Supervisor

Main Process

Database

Check Process Report

Evaluate Process [Approved]

Finalize Report

[Disapproved]

Notify Production Unit

A

14

Supervisor

Main Process

Database

A

Update Database

15

Activity Diagram â&#x20AC;&#x201C; Module 2: Check Sub Process Shop Floor Recording System

Supervisor

Sub Process

Database

Check Process Report

Evaluate Sub Process [Approved]

Finalize Report

[Disapproved]

Notify Production Unit

B

16

Supervisor

Sub Process

Database

B

Update Database

17

Activity Diagram – Module 3: Check Operator’s Performance Shop Floor Recording System

File Cabinet

Operator’s Performance

Supervisor

Review Operator’s Performance

Observe Operator

Interview Operator

Conduct Examination

Evaluate Operator [Certification Ready]

Certify Operator

[Certification on Hold]

Hold Operator’s Certification

C 18

Supervisor

Operatorâ&#x20AC;&#x2122;s Performance

File Cabinet

C

Compile Report

19

Activity Diagram â&#x20AC;&#x201C; Module 4: Check Machine Status Shop Floor Recording System

Supervisor

Machine

File Cabinet

Review Machine Report

Conduct Machine Test

Gather Feedback

Evaluate Machine [Approved]

Approved Machine

[Disapproved]

Conduct Machine Maintenance

D 20

Supervisor

Machine

File Cabinet

D

Compile Report

21

Problems and Recommendations PROBLEMS P.1. Equipment and Operator status is not automated.

P.2 Skipping of other processes is not inevitable.

P.3 Only the main and sub processes are reviewed thoroughly.

Recommendations R. 1. Equipment and Operator status must be encoded for reviewing and evaluation purposes R. 2 There are instances that an operator might skip or forgot a vital process that might lead to delays or even whole process failure.

R.3 Because other specs are not recorded into a database like equipment and operator status, there is a possibility that the top management lacks on information which is being used in reviewing purposes.

IV. Design of the Proposed System System Features and Functionalities FUNCTIONALITIES FEATURES A.1 Customers can view the status of A.2 Order Status Viewer their product.

B.1 The Company can detect any B.2 Process Control and inefficient process on a certain Monitoring stage.

C.1 Certification of Equipment and Operator.

C.2 Operator and Equipment Status Viewer

D.1 Top management can view the D.2 Shop Floor Recording System whole production processes and its related functions

22

Use Case Diagram and Narrative Use Case Diagram

Check Order Status <<includes>>

Evaluate Operator <<includes>>

Top Management Update Database Online

Check System <<includes>>

Supervisor

Check Machine Status

23

<<includes>>

<<extendss>>

Evaluate Process Stage

Log In Clients

B. Use Case Narrative Identification summary Title: Shop Floor Recording System Summary: The proposed system will allow the company to record the processes and its related components as well as the order and process status of a product into a database where in it can be viewed by the management through their intra and extranet while the clients, through the net.

Actors: • Supervisor • Clients • Top Management Creation Date: December 1, 2008 Date of Update: April 1, 2009 Version: V.1 Person in Charge: Supervisor Flow of Events Preconditions: 4. The Intranet and the Extranet must be active.

5. The Database is error and log free.

6. Records are ready for recording.

7. The web sit is not under construction.

8. The software is error and log free.

Main Success Scenario: 6. The operators will record their respective reports or data on the database through the software.

7. A Supervisor will check the system through reports given by his/her operators based on the scheduled checking.

8. He/She will check the Machine or equipment to know if it is in good condition and suitable for production.

9. He/She can also evaluate the operators that are in charge of operating the machines.

10. The operator can evaluate the production levels to know if they meet the specify requirements for each level.

11. He/she can also know or track the order status of a product through looking the product’s status and time in each process.

“Alternative Sequences: A1: Skipped process evaluation The operator has the probability of forgetting a vital process evaluation which is included on the whole report.

A2: Unreliable operator report

24

There is a tendency that operators might skip or forge a certain report due to some bad personal behaviors.

A3: Checking is delayed Delays on releasing of overall report might happen due to inconsistent scheduling of checking or other personal reasons which it will result to not updated database where as it is vital for weekly Top Management reviews.

Error Sequences E1: Delayed Record Checking Delay in checking might result in unscheduled updating of records.

E2: Not updated records There will be a vacant slot in the recording system so, the top management will ask for an immediate action.

E3: Top Management will conduct immediate response If the problem is not addressed immediately, there is a possibility of conducting meetings that as much as possible, it must be avoided due to it will cost time, money and productivity level of the company.

PostConditons: 1. The database is updated and available for reviews or evaluation 2. Customers can view their productâ&#x20AC;&#x2122;s order and process status.

25

Activity Diagram Activity Diagram â&#x20AC;&#x201C; Module 1: Evaluate Stage Process Shop Floor Recording System

Supervisor

Main Process

Database

Check Process Report

Evaluate Process [Approved]

Finalize Report

[Disapproved]

Notify Production Unit

A

26

Supervisor

Main Process

Database

A

Update Database

27

Activity Diagram â&#x20AC;&#x201C; Module 2: Check Order Status Shop Floor Recording System

Supervisor

Order Status

Database

Check Order Status

Evaluate Order Status [Approved]

Finalize Order Status

[Disapproved]

Notify Production Unit

B

28

Supervisor

Order Status

Database

B

Update Database

29

Activity Diagram – Module 3: Check Operator’s Performance Shop Floor Recording System

Supervisor

Operator’s Performance

Database

Review Operator’s Performance

Observe Operator

Interview Operator

Conduct Examination

Evaluate Operator [Certification Ready]

Certify Operator

[Certification on Hold]

Hold Operator’s Certification

C 30

Supervisor

Operatorâ&#x20AC;&#x2122;s Performance

Database

C

Compile Report

31

Activity Diagram â&#x20AC;&#x201C; Module 4: Check Machine Status Shop Floor Recording System

Supervisor

Machine

Database

Review Machine Report

Conduct Machine Test

Gather Feedback

Evaluate Machine [Approved]

Approved Machine

[Disapproved]

Conduct Machine Maintenance

D 32

Supervisor

Machine

Database

D

Compile Report

33

ON Semiconductor Web site

HOME

Products

Design Support

Semiconductor & Integrated Circuit Services

Featured New Products

Technical Documentation

Company News

Master Selection Guide

Design resources

Product Catalog

Technical Support

Articles in the Press

Product Services

Applications

Consumer & Portable

Quality System

Automotive

Quality Services

Circuit Protection

Networking & Telecom.

Computing and Peripherals Industrial & Medical Power Supply

Sitemap

34

Quality

LED Lighting

Environmental Programs Corporate Awards

My ON: Sign in & Register

Product Status

Shop Floor

Order Status

Database Schema / Entity-Relationship Diagram (ERD)

35

Data Dictionary Shop Floor System (ShopFloorSystem) Field Name

Data Type

Field Title

Field Size 50 50

ShopFloorNo ShopFloorDate

Integer smalltimedate

Shop Floor No Shop Floor date

OperatorID MachineID

Integer Integer

Operator ID Machine ID

50 50

ProcessMONID

Integer

50

OrderStatusID

Integer

Process Monitoring ID Order status ID

50

SupervisorID

integer

Supervisor ID

50

Field Description Number of the Shop Floor Date of Shop floor updated Number of the Operator Identification number of machine A number assigned to the process monitoring.

Number of order which is set to delivered.

ID of the supervisor in charge of checking.

Primary Key YES NO

Foreign Key NO NO

YES YES

NO NO

YES

NO

YES

NO

YES

NO

Primary Key NO

Foreign Key YES

NO NO

NO NO

NO

NO

Reference Table

Supervisor (Supervisor) Field Name

Data Type

Field Title

Field Size

Field Description

SupervisorID SupervisorName SupervisorContact No. SupervisorDept.

36

NVarchar(MAX) Integer

Shop Floor date Operator ID

MAX 50

NVarchar(MAX)

Machine ID

MAX

Name of the supervisor Contact info of the supervisor Supervisorâ&#x20AC;&#x2122;s dept.

Reference Table ShopFloorSy stem

Process Monitors (ProcessMonitors) Field Name

Data Type

Field Title

Field Size

Field Description

Primary Key NO

Foreign Key YES

50

The ID of the main process for each level Name of the process

NO

NO

NO

NO

The level where the main process is.

Description of the main process.

The sub processâ&#x20AC;&#x2122;s ID Remarks regarding the main process.

NO

NO

NO

NO

YES NO

NO NO

Primary Key NO

Foreign Key YES

NO NO

NO NO

NO

NO

ProcessMONID MainProcessID

Integer

Main process ID

MainProcessName

NVarchar(MAX)

MainProcessLevel

NVarchar(MAX)

MainProcessDesc

NVarchar(MAX)

SubprocessID MainRemarks

Integer NVarchar(MAX)

Main process Name Main process Level Main process Description Subprocess ID Main Remarks

MAX MAX MAX 50 MAX

Reference Table ShopFloorSy stem

Order Status (OrderStatus) Field Name

Data Type

Field Title

Field Size

Field Description

OrderStatusID OrderStatusID SendTo

Integer NVarchar(MAX)

Order Status ID Send To

SendDate

smalltimedate

Send Date

37

50 MAX 50

ID of the OrderStatus Location of the product receiver The date of delivery.

Reference Table ShopFloorSy stem

Operator (Operation) Field Name

Data Type

Field Title

Field Size

Field Description

Primary Key NO

Foreign Key YES

Name of the operator Name of the Department where the operator is part of.

The specific job of the operator.

Remarks on the operatorâ&#x20AC;&#x2122;s performance.

NO NO

NO NO

NO

NO

NO

NO

Field Description

Primary Key NO

Foreign Key YES

NO NO

NO NO

NO

NO

NO

NO

OperatorID OperatorName OperatorDept

NVarchar(MAX) NVarchar(MAX)

Operator Name Operator Department

MAX MAX

OperatorIJob

NVarchar(MAX)

Operator Job

MAX

OperatorRemarks

NVarchar(MAX)

Operator Remarks

MAX

Reference Table ShopFloorSy stem

Machine (Machine) Field Name

Data Type

Field Title

Field Size

MachineNo. MachineName MachineDesc

NVarchar(MAX) NVarchar(MAX)

Machine ID Machine Description

MAX MAX

MachineIDate

NVarchar(MAX)

Machine Date

MAX

MachineRemarks

NVarchar(MAX)

Machine Remarks

MAX

38

Machine name or brand Description of the machine base on its functionality The date of checking of the machine Remarks on the machine

Reference Table ShopFloorSy stem

Sub process (Subprocess) Field Name

Data Type

Field Title

Field Size

Field Description

Primary Key NO

Foreign Key YES

SubprocessName

NVarchar(MAX)

MAX

SubprocessArea

NVarchar(MAX)

Sub process Name Sub process Area

The Sub process name

NO

NO

MAX

Affected area by the sub process The description of Sub process Remarks on the Sub process

NO

NO

SubprocessDesc

NVarchar(MAX)

MAX

Subprocess Remarks

NVarchar(MAX)

Sub process Description Sub process remarks

NO

NO

NO

NO

SubprocessID

39

MAX

Reference Table ProcessMoni tors

V. IT Infrastructure Network Diagram Diagrams are placed in the appendices area of the paper.

Software Requirements A. Microsoft Vista The Operating System that will be used in the 3 computers that will be place in the production area for recording activities is Microsoft Vista. Although Microsoft XP is still used in ON Semiconductor Philippines, we will no longer used it due to the termination of its production this late 2008 and updates are will be no longer available next year.

B. SQL Server 2005 Our group had decided that we will use MySql Server 2005 as our database due to its flexibility in usage and it is easy to operate.

C. Microsoft Office 2007 It provides document creation, power point presentations, and other office related works.

D. Microsoft Visual C# Express Edition 2005 Our group will use Microsoft Visual C# as our programming language to create programs like Machine recording system and linked it to MySql 2005 for data storage.

Hardware Requirements A. Lenovo Idea Centre K200 • • • • • • • • • •

40

Processor(CPU Speed) Up to Intel® Core™2 Duo 4500 (2.2 GHz) Operating system Genuine Windows Vista® Home Premium Video graphics Up to ATI Radeon HD 2400 Pro 128MB Discrete Hard drive Up to 500GB SATA II 7200rpm Memory 2GB DDR2 (2 x 1GB) 667MHz (Max Upgradeable 4GB) Optical drive Dual Layer CD/DVD Recordable Web Cam USB Connection (640x480) Sound 5.1 Surround Sound Ready Integrated communications 10/100, 56K Modem Weight

• •

9.75Kg System Only Dimensions (System) 380mm x 180mm x 432mm Warranty 1 year system /1 year battery

B. Linksys WRT5462 Wireless-G Broadband • Brand :Linksys • Use : Home and Business • Functionality : Wireless Access Point • Connectivity : Wireless/Wired C. Epson Stylus Photo915 Injet Printer Main Specifications • • • • • • • •

• • • • • • • • • •

41

Product Description: Epson Stylus Photo 915 - printer - colour - ink-jet Printer Type: Photo printer - ink-jet - colour Dimensions (WxDxH): 46.7 cm x 25.6 cm x 21.2 cm Weight: 5.3 kg Localization: English / United Kingdom Max Media Size (Standard): Legal, A4 Max Media Size (Custom): 216 mm x 356 mm Print Speed: Up to 1.2 ppm - photo best - 101.6 x 152.4 mm ¦ Up to 0.54 ppm photo best - 203 x 254 mm ¦ Up to 7.8 ppm - black draft - A4 (210 x 297 mm) ¦ Up to 7.6 ppm - colour draft - A4 (210 x 297 mm) Max Resolution ( B&W ): 1440 dpi x 720 dpi Max Resolution ( Colour ): 1440 dpi x 720 dpi Image Enhancement Technology: EPSON Photo RPM Interface: USB RAM Installed ( Max ): 32 KB - integrated Media Type: Envelopes, transparencies, plain paper, photo paper, semi-gloss photo paper, glossy photo paper, heavy-weight matte paper Total Media Capacity: 100 pages System Requirements: Apple MacOS 8.1 or later, Microsoft Windows XP, Microsoft Windows 98/ME/2000 Environmental Standards: EPA Energy Star Manufacturer Warranty: 1 year warranty

System Costing / Cost-Benefit Analysis Company Name: ON Semiconductor Philippines, Carmona Cost-Benefit Analysis Period of <1 week> COST Software Microsoft Windows VistaPhp 14,697.55/ unit (3 units) SQL Server 2005Php 29,351.00 / unit (I unit) Microsoft Office 2007Php 24,497.55 /unit (3 units) Microsoft Visual Studio 2005PHP 64,750.00/unit(1 unit) Total Software cost Hardware Lenovo Idea Centre K200- PHP 39,984.00/ unit (3 units) Linksys WRT5462 Wireless-G Broadband PHP 2,588.00/unit Epson Stylus Photo915 Injet Printer - PHP 4,995.00/unit (2 units) Total Hardware cost Total Cost

Benefits Tangible Increased revenue Decrease daily failure analysis Intangible Centralized record keeping Fast decision making by The top management Records are always present in the Intranet and extranet.

Total Benefit *For benefits, the basis is 1 week.

42

Amount (Php) Php 44,092.65 PHP 29,351.00 PHP

73,492.65

PHP 64,750.00 PHP 211,686.30 PHP119, 952.00 PHP 2,588.00 PHP 9,990.00 PHP 132,530.00 PHP 344,216.00

Amount (PHP) PHP 1,000,000.00 PHP 200,000.00

PHP 1, 200,000.00

Return on Investment (ROI) Ratio: â&#x20AC;˘ Total Benefits - Total Costs / Total Costs (PHP 1, 200, 000.00 - PHP 344,216.00) / PHP 344,216.00 = 2. 49 % VI. Implementation Plan Project Development Timetable The Development Timetable is in the Appendices area.

Transition and Training Plan Transition Plan System Name: Shop floor recording system Goals: To integrate the records of the main and sub processes, evaluation and qualification equipment and subsequent preventive maintenance records, and process monitors, status of the product in process and the shipment status into a one recording system.

Assumptions: Orientation of operators will be not so difficult because the proposed system is linked to the existing system specifications and language.

Risks: Implementing the transition plan will cost the productivity level to decrease and will cause delays as the operators undergo training.

Transition Team Transition Role Team Leader and

Who Project Joseph Rannie Buluran

Transition Manager Business and Technical Project Leader Transition Specialist Production Support Manager Configuration Manager Training Coordinator Configuration Manager Project Team Database Administrator Systems and Networking Production Support

43

Romir Gian Empino Harvey Charles Chua JR Galang Timothy CO Jinno Rafael Malabanan

-------------------------

Desktop Support Help Desk OPS Platform Support Project Development

-----------------------------------------

Transition Process Task Task transition planning meeting Distribute project Initiation Plan or Project Plan Attend transition planning meeting Review development project schedule Review deliverables list to determine requirements Develop matrix of required resources/skills Conduct skill gap analysis against all IS staff Identify project activities to be completed before transition can start Determine timeline Establish transition milestones Assign support staff to the application Determine actual training needed, based on gap analysis Determine roles and responsibilities (such as collect, review, accept deliverables, resolve variances, etc.)

Assign evaluator for each transition deliverable Establish support expectations for IS Obtain access/privileges Acquire software license agreements for production support Develop training plans • Identify necessary training courses • Schedule classes • Identify necessary knowledge transfer activities • Determine measurable tasks to validate that knowledge transfer

44

Responsible Empino, Buluran Buluran

Due time April 1 – 7 April 7 - 14

Empino, Chua Empino, Chua Empino, Chua

April 14 April 15 April 15 -17

Empino

April 17 – 19

Malabanan, Galang

April 20 – 25

Empino, Chua

April 25

Empino, Chua Empino, Chua Galang

April 26 – 27 April 26- 27 April 28 – 29

Empino, Galang, April 28 – 30 Malabanan Empino, Chua April 30 – 31

Chua Empino, Buluran Empino Empino, Co

April 31 Chua, May 1

Malabanan, Empino, Galang

May 2 May 2 -3 May 3 – 9

is acceptable May 9 Notify business area(s) of production support procedures Notify C&C units of transition to production status Establish new on-call lists Move development documentation and code to production repository Transfer user group/steering committee leadership to production support

Galang Galang or Empino

May 11

Galang Empino, Co

May 12 May 12 – 15

Buluran, Empino

Galang, May 16

Training Plan Skill

Level of Expertise Has a background Moderate on SQL Server 03 C# Expert Expert Knows how to use Moderate Microsoft Office 07 Knows how to use Moderate Vista

Availability Required IS,

Degree of Applicability 5

IS, IS, User Area

5 4

IS, User Area

4

*Degree of Applicability: 1- lowest and 5- highest Training Needs • • •

SQL Server 2005 – Operators will undergo SQL Server crash course sessions with the supervision of the company.

C# Expert – IT personnel in-charge of creating software will only take a C# training sessions if only new updates will be released.

Microsoft Vista – The company will encourage their employees to attend seminars regarding in using Microsoft Vista.

Training Plan Training Plan Layout Training Details Unit of Competence Course Employer Employer Address Employer contact name Employer role Employer phone number Trainee name

45

Recording production related data MySql 03, C#, Vista, Microsoft Office 07 ON Semiconductor Philippines, Carmona Golden Mile Business Park, Special Economic Zone, Governor’s Drive, Carmona, Cavite Confidential IT Section Head Confidential -----------

Trainee commencement date Anticipated period of training Arrangements of formal training Arrangements of informal training

Location of training

March 1, 2009 5 weeks Training manager will schedule the training hours for each operators and employees Supervisors nominated in the trainee logbook will identify opportunities for informal training that will contribute to the trainee gaining the knowledge and skills set out in the scope of training as provided below.

Company’s training area where computers are present.

Evidence methods Training assessments will be recorded for future evaluations.

Supervision arrangements Experts for each language will teach the trainees.

Assessment arrangements Trainees will complete the needed specifications of the company in order to operate the new system.

Equipment available • Lenovo Idea Centre K200 • Linksys WRT5462 Wireless-G • Epson Stylus Photo915 Injet Literacy and numeracy reports The training manager will assess the literacy and numeracy needs of the trainee twice a week.

Nominal hours of formal training 30 hours Nominal hours of informal training 30 hours Monitoring arrangements for The training manager will monitor the progress of delivery training each trainee and record the stats for reviewing an evaluation purposes.

46

Risk Management Plan Risk Register

Reference Number: Version Number: 1.0

System Name: Shop Floor Recording System Risk

Title

Cost Impact

Probabil

Risk

(Php)

ity (%)

Exposure

ID

Rank

(Php) 1

System down

P3,800.00

10

P380.00

2

2

Hardware malfunctions

P3, 200.00

9

P288.00

3

3

Database failure

P6, 000.00

9

P540.00

4

4

Security Breach

P5,000.00

19

P950.00

1

5

Power restoration

P3, 400.00

13

P442.00

5

6

Force majeure

Total

Except

Except

Except

P21,400.00

60

P2,600.00

Except

1. System down (Technical Support) 1-3 Years Experienced Employee: Salary = P19, 000.00 Salary / No. of working Days = 19,000.00 / 5 days = P3,800.00/visit Risk Exposure: Cost Impact * Probability (%) 3,800.00 * .1 = P380.00

2. Hardware Malfunctions (Technical Support) 1-4 Years Experienced Employee: Salary = P16, 000.00 Salary / No. of working Days = 16,000.00 / 5 days = P3, 200.00/visit Risk Exposure: Cost Impact * Probability (%) 3,200.00 * .09 = P288.00

3. Database Failure (Programmer) 3 Years & Up Experienced Employee: Salary = P30, 000.00

47

Salary / No. of working Days = 30,000.00 / 5 days = P6, 000.00/visit Risk Exposure: Cost Impact * Probability (%) 6,000.00* .09 = P540.00

4. Security Breach (Database Administrator) 1-5 Years Experienced Employee: Salary = P25, 000.00 Salary / No. of working Days = 25,000.00 / 5 days = P5,000.00/visit Risk Exposure: Cost Impact * Probability (%) 5,000.00 * .19 = P950.00

5. Power restoration (Technical Support) 2 Years Experienced Employee: Salary = P17, 000.00 Salary / No. of working Days = 17,000.00 / 5 days = P3, 400.00/visit Risk Exposure: Cost Impact * Probability (%) 3,400.00 * .13 = P442.00

6. Force Majeure (Database Administrator) - EXCEPT

48

Risk Management Risk Register

Reference Number: Version Number: 1.0

System Name: Shop Floor Recording System Title

ID 2th

1 System Down

% 10

Rank

Exposure P380.00

Description System down is caused by irregularities in software and database in the shop floor recording system.

Mitigation Plan Regular maintenance check of software and database components.

Contingency Plan Company data must be backed up.

Performance Impact Production processes will be delay and accumulation of cost.

49

Risk Register

Reference Number: Version Number: 1.0

System Name: Shop Floor Recording System Title

ID 3rd

2 Hardware malfunctions

Rank

% 9

Exposure P288.00

Description Hardware irregularities will stop the functions of software in which is also a factor in causing System down.

Mitigation Plan Daily check up and evaluation for hardware performance.

Contingency Plan A technician is always present and there are hardware reserves available.

Performance Impact Some affected areas will stop or perhaps the whole system will stop if the hardware contributes on the main process of the production.

50

Risk Register

Reference Number: Version Number: 1.0

System Name: Shop Floor Recording System Title

ID 4th

3 Database Failure

Rank

% 9

Exposure P540.00

Description The Database has been corrupt or crashed due to insufficient requirements.

Mitigation Plan Weekly maintenance for possible factors that might result to database failure.

Contingency Plan A team are on stand by in case of database restoration or repair.

Performance Impact Records are temporarily inaccessible for evaluation. Data input and acquisition are also stopped.

51

Risk Register

Reference Number: Version Number: 1.0

System Name: Shop Floor Recording System Title

ID 1st

4 Security Breach

% 19

Rank

Exposure P950.00

Description Breach on the security wall imposed by the company on their database and other confidential data.

Mitigation Plan Strong Firewall or Database Security.

Contingency Plan Expert anti-hacking teams are on stand by and ready in case of security breaching by outsiders.

Performance Impact Companyâ&#x20AC;&#x2122;s credibility in keeping their confidential information is low in which it might give hackers the idea to infiltrate their system.

52

Risk Register

Reference Number: Version Number: 1.0

System Name: Shop Floor Recording System Title

ID 5

Power restoration

5 %

13

Rank th

Exposure P442.00

Description The company is ready in shifting their power supply from electrical outlets to generator set in case of calamities and brown outs. .

Mitigation Plan Daily check up on their generator sets.

Contingency Plan Back up generators are ready in case of main generators malfunctions and downs.

Performance Impact It will help the company to continue their operations although experiencing calamities and electrical failures.

53

Risk Register

Reference Number: Version Number: 1.0

System Name: Shop Floor Recording System Title

ID

Rank

%

Exposure

6 Force Majeure

Description Nature driven factor that might stop or cripple the operations of the company such as earthquakes, war and storms.

Mitigation Plan A business continuity plan is ready on addressing the needs before the calamities.

Contingency Plan A Disaster recovery plan is ready after the calamity.

Performance Impact Calamities may stop or cripple the operation of the company if there are no appropriate plans that are ready on unwanted events..

54

IV. References Epson Stylus Photo 915 Inkjet Printer. November 30, 2008, Web site: http://www.amazon.co.uk/Epson-Stylus-Photo-Inkjet-Printer/dp/techdata/B0000C7A22/ref=de_a_smtd/278-4509223-8959914 Linksys Wireless-G Broad band router. November 30, 2008. Web site: http://cgi.ebay.com/Linksys-Wireless-G-Broad-band-routermodel%23wrt5462_W0QQitemZ300276708398QQcmdZViewItemQQimsxZ20081128?IMSfp =TL081128105003r35666 Lenovo Idea Centre K200. November 30, 2008. Web site: http://www-07.ibm.com/lenovoinfo/au/ideas/kseries/k200.html Transition Plan Template. December 1, 2008. Web site: http://www.ops.org/DOCS/OPS_2005_TRANSITION_PLAN_SECURED.pdf Training Plan Template. December 1, 2008. Web site: http://www.deir.qld.gov.au/pdf/whs/trainingplan.pdf Systems Development Life Cycle. December 2, 2008. Web site: http://en.wikipedia.org/wiki/Systems_Development_Life_Cycle ON Semiconductor. Whole 2nd term. Web site: http://www.onsemi.com

55

VII. Appendices II. B Company History

II. B.3 Products AC-DC Controllers & Regulators (353) • Off-Line Controllers (203) • Off-Line Regulators (108) • Power Factor Controllers (33) • Secondary Side Post Regulation Controllers (9) DC-DC Controllers, Converters, & Regulators (1849) • Battery Charge Controllers (15) • Charge Pumps (5) • Controllers (104) • Converters (262) • Hot Swap Controllers (4) • Linear Voltage Regulators (1459) Voltage Controllers, References, & Supervisors (484) • Battery Protection Controllers (30) • Voltage References (119)

56

•

Voltage Supervisors (335)

Thermal Managers (115) • Remote Thermal Sensors (63) • Remote Thermal Sensors with Fan Control (43) • System Monitors (9) Drivers (167) • Display / LED Drivers (40) • Load / Relay Drivers (33) • MOSFET / IGBT Drivers (56) • Motor Drivers (38) DSP Systems (5) • Audio DSP Systems (5) Memory (52) • EEPROM Memory, Parallel • EEPROM Memory, Serial • Flash Memory • NVRAM Memory • SRAM Memory, Parallel (44) • SRAM Memory, Serial (8) Bipolar Transistors (1541) • Audio Transistors (120) • Bias Resistor Transistors (BRTs) (225) • Composite Transistors (5) • Darlington Transistors (208) • General Purpose Transistors (881) • Insulated Gate Bipolar Transistors (IGBTs) (18) • Low VCE(Sat) Transistors (69) • RF Transistors (up to 2 GHz) (15) FETs (621) • JFETs (21) • MOSFETs (575) • Protected MOSFETs (25) Amplifiers & Comparators (604) • Audio Amplifiers (19) • Compandors (23) • Comparators (110) • Operational Amplifiers (426) • Transconductance Amplifiers (9) • Video Amplifiers (17) Analog Switches (255)

57

• • • •

Audio Switches (34) Data Switches (16) General Purpose Switches (199) Video Switches (6)

EMI / RFI Filters (48) • Audio Filters (5) • Data Filters (43) Diodes (2099) • ESD Protection Diodes & Arrays (122) • Schottky Diodes & Rectifiers (363) • Small Signal Switching Diodes (182) • Transient Voltage Suppressors (TVS) (580) • Tuning Diodes (9) • Zener Diodes (843) Rectifiers (228) • Standard and Fast Recovery Rectifiers (55) • UltraFast Rectifiers (166) • UltraSoft Rectifiers (7) Thyristors (446) • Programmable Unijunction Transistors (PUTs) (13) • SIDACs (10) • Silicon Controlled Rectifiers (SCRs) (177) • Thyristor Surge Protection Devices (TSPDs) (64) • Triacs (182) Interfaces (159) • Data Transmitters (99) • Modulators / Demodulators (16) • Sensor Interfaces (4) • Smart and SIM Card Interfaces (11) • Timers (29) Clock Managers (453) • Clock Distributors (235) • Clock Modules (21) • Clock Synthesizers (49) • Phase / Frequency Detectors (PLL) (18) • Skew Managers (32) • VCO (PLL) (48) • Zero Delay Buffers (50) Differential Logic (ECL) (1399) • Arithmetic Functions (192)

58

• • • • • • • • •

Buffers (40) Crosspoint Switches (18) Flip-Flops (178) Logic Gates (219) Latches & Registers (61) Multiplexers (161) Receivers / Drivers (232) Serial / Parallel Converters (21) Translators (277)

Standard Logic (2280) Standard Logic Family View • Arithmetic Functions (160) • Buffers (419) • Flip-Flops (213) • Logic Gates (555) • Inverters (324) • Latches & Registers (224) • Multiplexers (223) • Multivibrators (29) • Transceivers (94) • Translators (39)

59

II.B. Company Profile: History

- 60 -

V. Network Diagram

- 61 -

- 62 -