Vendor Inventory

From UG

Revision as of 16:43, 24 May 2010

Business Requirement

Elizabeth Arden would like to have a vendor Inventory module that they can track shipments that are on hand by vendors, in-transit, on hand by external manufacturer to help the inventory planner to process a shipment plan.

System Requirement

• A portal for vendor to enter/update info for Inventory
• Vendor's visibility
• Inventory Report for Elizabeth Arden Planner

• Filters:
  • Item#
  • Supplier
  • EM(External Manufacturer)
• Result: HTML and xls
  • Item#
  • Item Desc
  • Item type
  • Supplier
  • EM(External Manufacturer)
  • US on hand
  • International on hand
  • In-transit - Land (truck mode)
  • In-transit - Air (Air mode)
  • In-transit - Sea (Ocean mode)
  • EM on hand
  • EA on hand

• Update log for updated information by vendor

• Column heading color code:
  • column is updated in the last 7 days - green
  • column is updated in the last 15 days - yellow
  • column has no updated in the last 30 days - red
• pop-up window for detail updated info
  • Updated by: user profile (vendor)
  • Updated date: dd- mon -yyyy
  • Detail updated: From last transaction to updated transaction information

Steps

Step 1

• Vendor logs on to the Inventory module

• Vendor's visibility ; A vendor can only add, update, and view their specific inventory;
  • For example, vendor A logs on to the system, vendor A can only see inventory that belongs to vendor A.

• Vendor adds:

• Item#
• Item Desc
• Item Type
• Supplier (read only vendor name, mapped from vendor user's profile)
• External Manufacturer (EM)
• Supplier USA on hand
• Supplier International on hand
• NOTE: the combination of Item# and EM are unique

Step 2

• Jaguar operator updates/creates a record to move shipment from supplier to destination (In-transit)

• Shipper (supplier)
• Consignee (EM)
• MOT
• Item#
• Item Desc
• Qty
• NOTE: the combination of Item# and EM are unique
• Qty value will be updated on Vendor Inventory In-transit columns
• Once the shipment is delivered (no longer in-transit) to destination(consignee/EM)
• Number of Qty from in-transit will be deducted and add to the destination (EM/EA) on hand
• US Total on hand: Number of Total USA shipments on hand including Supplier USA on hand will be updated
• ATP next 40 days: Number of Total in-transit shipment including International shipment on hand will be updated as available to promise
• Total pipeline : US Total on hand + ATP next 40 days
• See #Figure 1. Vendor Inventory

Figures

Figure 1. Vendor Inventory