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: WAN Corporate Mainframe Headquarters (Data Warehouse) LAN (CSS, Cullinet, AWCS) Production Facility DSC CSS AWCS CSS Cullinet CSS LAN LAN Stores 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 professionals.