Other ODS

Enterprise Info Systems

A table of enterprise information systems regarding the sales and marketing department, and the application.
Department Application
Sales and Marketing
  • Lead generation
  • Lead tracking
  • Customer management
  • Sales forecasting
  • Product and brand management
A sales database with a snowflake schema. Several tables are joined and displayed

 

A table of enterprise information systems regarding the sales and marketing department, operations, and manufacturing.
Department Application
Sales and Marketing
  • Lead generation
  • Lead tracking
  • Customer management
  • Sales forecasting
  • Product and brand management
Operations
  • Order entry
  • Order management
  • Finished-goods inventory management
Manufacturing
  • Inventory (raw materials, goods-in-process)
  • Planning
  • Scheduling
  • Operations

 

Manufacturing Process versus Project

Project based manufacturing views each product as a discrete unit.  This allows cost to be aggregated uniquely for that project.  Think of a company that build office buildings.  each project has a budget and costs are managed for each project/building.  some other examples might be movies, homes.  Generally these are larger items that are not mass produced.  Consulting projects might be another example in your field.

Process manufacturing occurs when there are many identical units produced.  Cost are accumulated for a large group or lot of products and then apportioned to each using a formula.  You can think about them as a group that is mass produced.  A factory may be set up to make a run of Nike shoes all of the same model.  Cost of the materials going in would be divided across all of the shoes produced that day to get a cost.

Consider also the speed of the production cycles.  The projects usually take longer than the mass produced process manufacturing jobs, and often generate unique data about the project as it progresses through steps (status.)  Henry Ford was famous for taking a project based manufacturing process and turning it into a process one.

  • Process
    • Jell-O Plant
    • Brawny Paper Towels
    • Toothpaste

 

  • Project
    • Construction – Home, Commercial, Solar
    • Movie
    • Medical Procedure

 

A table of enterprise information systems regarding the sales and marketing department, operations, and manufacturing. However this instance of the replicated table highlight finished-goods inventory management in the operations department, and inventory (raw materials, goods-in-person) in the manufacturing department.
Department Application
Sales and Marketing
  • Lead generation
  • Lead tracking
  • Customer management
  • Sales forecasting
  • Product and brand management
Operations
  • Order entry
  • Order management
  • Finished-goods inventory management
Manufacturing
  • Inventory (raw materials, goods-in-process)
  • Planning
  • Scheduling
  • Operations

 

Lets take a look at some the supply chain and inventory.  We may hold data about two type of inventory here.  raw materials and finished goods.  Both may be in the same warehouse.  The inventory system generally tells us which is what is stored where and when items need replenishing.  Warehouse  automation is an interesting field on its own.  Basically you are keeping track of what you have and when you need more. and when more comes in, or orders need to be filled the inventory system tells you where to put it away or to pick it for an order.  You would expect the functions of the inventory system to be closely tied to purchasing and sales orders.

What are some of the components or entities?

Purchasing / Inventory

Entities

  • Vendor Master
  • Item Master
  • Inventory
  • Purchase Requisition
  • Purchase Order
  • Work Order

Purchasing

  • Vendor Master
    •   Vendor #
    •   Vendor Info (address, etc)
    •   Vendor Contacts
    •   Vendor Tax Info (payable, Tax area code, Tax Id, VAT)
    •   Terms Prepayment, net 10, etc
    •   1099 Eligibility
    •   Federal ID
    •   Our Account #
    •   Location Code (where vendor ships to)
    •   Shipping Agent(s)
    •   Lead Times (shipping)
    •   Pricing/Discounts
  • Product Information
    • SKU
    • UM or UoM (Unit of Measure)
    • Pricing Tiers
    • MOQ (Minimum Order Quantity)
    • EOQ (Economic Order Quantity)
    • Min (Minimum Stock Level)
    • Max (Maximum Stock Level)
    • Lead Times
  • Other
    • Requisition
    • Purchase Order *
    • Work Order
    • Receipt
    • Invoice

 

Inventory Processes

Fulfill Order

A flowchart illustrating the inventory process to fullfill an order. (sale to sales order to inventory to book to customer)

Replenish

A flowchart illustrating the inventory process to replenish goods.

Vendor Relationship

Purchasing Warehouse elements: items, vendor, purchase orders, inventory (locations), orders filied, purchase history, purchhase discounts / pricing
Vendor Relationship Elements: Purchase History, Purchase Discounts / Pricing, Purchase Orders, Vendors.

Sample Entity-Relationship Diagrams

An Entity-Relationship (E-R) Diagram helps us to explain, diagrammatically, the overall high-level structure of a database as concluded by Silberschatz (1997). Elmasri & Navathe (1999) state an E-R diagram can be used as a reference to ensure all users’ requirements are met and that no conflicting requirements occur. As the model does not include technical details it was also presented to Carpet World to demonstrate how the system would be implemented. The graphical notation used in the E-R diagram (below) is based on the representation that Rock-Evans (1989) favors and shows the logical structure of the Carpet World database.

A simplified diagram of thhe Carpet World Database. The following tables are shown: Customer, Sales Order, Stock, Sales Order History, Product, Purchase Order, Supplier, Purchase Order History, Category.

 

A more in depth diagram of the same Carpet World Database. The tables that were listed prior, have been expanded on by displaying the names of the fields in the tables.
The actual Carpet World database Schema, complete with all of the fields that are in each table, as well as displaying the foreign / primary keys interconnecting the database tables .

 

Vendor Master

A Vendor table within a database. There are several fields present in this table and shown in the image.A continuation of the many fields present in the vendor table.

Item Master

Item master table. Several fields are present in this table and shown in the image.

Warehouse

  • Inventory
    • Total Quantity on hand
    • Quantity allocated
    • Bin #
    • On Order (open PO’s)
    • Kits
    • PO
    • Batch Pick
    • Pick to Order

License

Share This Book