For Sherwin Williams Production Facilities College of Business

Document Sample
For Sherwin Williams Production Facilities College of Business Powered By Docstoc
					        IT Architecture Analysis
For Sherwin Williams Production Facilities
Administrative Applications Portfolio:

      Applications: There are two major applications at Sherwin Williams’s production

      facilities are CSS and Cullinet.

             Cullinet is a manufacture-based application that is setup to make

             production more efficient. Cullinet was developed in 1980, and was last

             updated in 1998. The processes involved are:

                        Receiving
                        Inventory Adjustments
                        MRP
                        Bill of Material
                        Manufacturing Ordering
                        Batch Ticketing
                        Accounts Payable
                        Formulas

             Cullinet is an application in which orders are placed for products to be

             manufactured to the production facilities from headquarters. When the

             orders drop the Production Planer plans them by priority and availability.

             At this point two processes start; first the Raw Materials Buyer puts in

             orders for the materials needed to produce the batch. Raw materials are

             ordered on a modified JIT system. Meaning that most materials are only

             order when they are called for by a batch based on the lead time for the

             order and the planned date for the batch, and the heavily used materials are

             kept in stock with reorder points and safety stock requirements factored in.
With over 800 different Raw Materials needed for the wide variety of

Sherwin Williams’s products the planning and coordination of raw

material procurement is imperative. Next a batch sheet is printed with the

batch date and formula on it and is placed in the Production Manager’s

office for production of the product. Cullinet assigns a job number to each

batch; this indicates the size of each batch, the size of the finished goods

(five-gallon pail, gallons, pints, half pints, or drums), the distributions of

the finished goods, and the label type for the batch. Upon completion of

the batch Cullinet then charges the accounts payable for the cost of the

raw materials and labor that is involved with each batch. Cullinet has low

process automation, but it is very helpful in the planning and production in

the production facilities insuring high coordination and prioritization of

the manufacturing of finished goods and raw material inventories.

CSS is an order entry application that is used in every facility in the

Sherwin Williams network from store ordering to customer service order

entry to DSC (Distribution Service Center) order fulfillment to DSC

reorder points to production facility production. CSS was implemented in

1975 and was last updated in 1999. Finished goods enter this system

when they are shipped from a production facility and are billed to the

DSC. The production facilities use CSS to bill the DSC and move the

batch to accounts receivable. CSS is more of a billing application as far as

production facilities are concerned but this step is imperative for the
            application to work for the rest of the network, which uses CSS

            extensively for coordination, inventory levels, and order fulfillment.

     The production facilities are presently working on implementing two more

     applications that will tie all of the present production facility systems together.

     These systems are Batch Tracking and Bar Code Shipping. These applications

     are intended to tie Cullinet and CSS together and automate the entire system.

     Batch Tracking will hook Cullinet to CSS by following each job number through

     each process of manufacturing and place it CSS to be billed on completion of the

     finished goods. Bar Code Shipping will automate the shipping and billing of the

     finished goods to each DSC in coordination with CSS.

Technical Platform:

     Sherwin Williams still has its original mainframe computing system at its

     corporate headquarters in Cleveland, Ohio. The mainframe has been updated

     continuously to stay on pace with advancing technology. It runs all of Sherwin

     Williams’s applications and also houses the companies data warehouse. From

     this mainframe a Wide Area Network is ran to every Sherwin Williams’s facility

     in the United States. At the corporate headquarters a Local Area Network is ran

     off of the WAN. LANs are also connected to the WAN at each production

     facility and each DSC. The LANs run desktop units that have each of the

     applications that are run at each specific facility. Also each Sherwin Williams’s
    company store has a desktop terminal that is connected directly to the mainframe

    in Cleveland.

IT Organizational Structure:

    Sherwin Williams’s IT structure is centralized at the corporate headquarters in

    Cleveland, Ohio. The IT group is responsible for every aspect of Sherwin

    Williams’s IT structure. The departments include:


                    Corporate         Mainframe
                    Headquarters      (Data Warehouse)
                                                          LAN (CSS, Cullinet, AWCS)




      LAN                                                                         LAN
                    Enterprise & Strategic Planning
                    Finance & Procurement
                    Year 2000 Project
                    Application Development
                    Infrastructure
                    Customer Service/Operations

In addition to the corporate IT group each production facility and DSC has an IT

administrator that facilitates technical support, application introduction, customer

service, and platform maintenance.

Sherwin Williams does all IT work internally development, installation, customer

service, and trouble shooting. This is a tremendous strength for the organization

because IT problems and applications are tended to with expedience and the

specialization needed for Sherwin Williams business. The weakness of having

this type of internal organization is the ability to hire and keep qualified IT