1 / 18

Dow Chemical

Dow Chemical. Presented By: Chris williams Sugi Terbish Carl smith. Business Background. Dow Chemical is a world-wide leading supplier of plastic resins and material science innovations As of 2008 Annual sales $57.4 billion 46,000 employees worldwide 150 manufacturing sites in

alec-travis
Download Presentation

Dow Chemical

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Dow Chemical Presented By: Chris williams SugiTerbish Carl smith

  2. Business Background Dow Chemical is a world-wide leading supplier of plastic resins and material science innovations As of 2008 • Annual sales $57.4 billion • 46,000 employees worldwide • 150 manufacturing sites in 35 countries • Produce 3,300 different products

  3. Business Background • Dow Houston Operations located in Deer Park, TX • Complex covers 139 acres • Produces and sells more than 500 million pounds of product annually • Products are shipped via rail, truck, and pipeline • Employs more that 375 employees and contractors.

  4. Business Need • Provide a business database to keep better track of incoming and outgoing shipments of raw materials and product • Keep track of the raw materials used in production of Dow’s products: • what vendors the product was purchased from • how it was delivered to the company (via truck, train, or pipeline) • how it was delivered to the buyer (via truck, train, or pipeline) • Determine the ROP based on flow of inventory per quarter

  5. Context Diagram

  6. EVENT HANDLING PROCESSING

  7. LEVEL 0 DFD

  8. LEVEL 1 DFD FOR PROCESS 1

  9. LEVEL 1 DFD FOR PROCESS 2

  10. LEVEL 1 DFD FOR PROCESS 4

  11. SYSTEM COMPONENT

  12. STRUCTURE CHART

  13. ER DIAGRAM

  14. PHYSICAL DESIGN • CUSTOMER (Cust_ID, Cust_Fname, Cust_Lname,Cust_Address, Cust_City, Cust_State, Cust_Zipcode, Cust_Phone, Cust_PrimaryContact) • ORDER(Order_ID, Cust_ID*, Order_Quantity, Order_Shipmethod) • INVENTORY(Inv_ID, Inv_Category, Inv_Quantity, Inv_Price, WH_ID*, Order_ID*, Inv_ROP, Inv_Target, Inv_Discontinued)

  15. PHYSICAL DESIGN cont’d • VENDOR(Vendor_ID, Vendor_Prod,Vendor_Fname, Vendor_Lname, Vendor_Address, Vendor_City, Vendor_State, Vendor_Zipcode, Vendor_Primarycontact , Inv_ID*) • INVOICE (Invoice_No, Order_ID*, Dow_Address, Dow_City, Dow_State, Dow_Zipcode, Dow_Phone) • WAREHOUSE(WH_ID, WH_State)

  16. IVENTORY DETAILS FORM

  17. INVENTORY DETAILS REPORT

  18. Questions???

More Related