Descripción: Tugas Kuliah Logistics and Supply Chain Management. Topik: Logistics Network and Distribution
Descrição completa
PPT gives a summary of the developments in Supply Chain of Benetton. This PPT was prepared by us while studying at IIM AhmedabadFull description
Project Supply Chain ManagementFull description
Full description
theoryFull description
TRABAJO FINAL ENEB SUPPLY CHAIN MANAGEMENT - CASO DE CERAMICOSADescripción completa
scm rapport
Uploaded from Google Docs
Full description
Full description
Questions and answers for supply chainFull description
spcmFull description
Supply Chain ManagementFull description
Supply Chain Management RSFull description
supply chain management system is vital in any major production companyFull description
Oracle’s Pre-built Financial, Order Management & Supply Chain Analytics Star Schemas Principal Sales Consultant Oracle BI & Analytics
Oracle Financial Analytics Star Schemas
Oracle Financial Analytics Star Schemas
Oracle Financial Analytics • • • • •
AR Overview AR Balance AR Invoice Aging rans ransac actt on ons s AP Overview
• AP Invoice Aging • AP Transactions
• • • • • • • •
GL Activity Activity – Balance Balance Sheet Sheet u ge an xpenses GL Activi Activity ty – Cash Cash Flow GL Detail Transactions Company Profitability Customer Profitability Revenue Analysis
Oracle Financial Analytics Accounts Pa ables A in Company/
Business
Legal Entity
Area
Date
Example Metrics
Purchasing
(Snapshot/Due
Org
/Invoice..)
AP Aging Profit
Ledger
Supplier
EAI
AP Line ETL
Supplier
Item Details
Account
• AP Aging 1-30 Amount • AP A in 31-60 Amount • AP Aging 61-90 Amount • AP Aging 90+ Amount • AP Due 1-30 Amount • AP Due 31-60 Amount • AP Due 61-90 Amount • AP Due 90+ Amount • AP Overdue Amount to Total % • AP Avg Invoice Days Overdue • AP Av Invoice Da s Until Due • AP Count Overdue Transaction
Features
. Provides drill down from Aging Metrics to under lying receivables line item details.
Provides ability to analyze transactions at all levels
• AP Avg Invoice Amount • • AP Avg CR Memo Amount • AP Avg DR Memo Amount • AP Avg Supplier Payment Days • AP Overdue Items to Total % • AP Payment Amt to Invoice % • AP Times Paid After Due mes a e ore ue • • AP Total Payment Amount • AP Total Payment Days • AP Wei hted Da s in Pa ments
Oracle Financial Analytics Accounts Payable Activity Example Metrics
Company/ Legal Entity
Date
Business
(Balance Dk..)
Area AP Activity
Supplier
GL
Account
Account
Ledger
• Closing Group Amount • Opening Group Amount • Closing Local Amount • Opening Local Amount • Days Payables Outstanding • AP Turnover
Supplier
Features
Provides ability to do analyze h istorical and current AP Balances
Oracle Financial Analytics Accounts Receivables A in Company/
Business
Legal Entity
Area
Example Metrics
Date
Sales
(Snapshot/Due
Org
/Invoice..)
Customer
AR Aging
Sales Region
Account
Ledger
EAI
AR Line ETL Details
Sales Rep
• AR Aging 1-30 Amount • AR Aging 31-60 Amount • AR Aging 61-90 Amount • AR Aging 90+ Amount • AR Due 1-30 Amount • AR Due 31-60 Amount • AR Due 61-90 Amount • AR Due 90+ Amount • AR Overdue Amount to Total % • AR Avg Invoice Days Overdue • AR Avg Invoice Days Until Due • AR Count Overdue Transaction
Features
Provides drill down from Aging Metrics to under lying receivables line item details
• AR Avg CR Memo Amount • AR Avg Customer Payment Days • AR Avg DR Memo Amount • AR Avg Invoice Amount • AR Overdue Items to Total % • AR Times Paid After Due • AR Times Paid Before Due • AR Total Payment Amount • AR Unapplied Payment Amount • AR Weighted Days in Payments • AR Credit Memo Count • AR Debit Memo Count
Features
. Provides ability to analyze transactions at all levels – Summary and Details
Oracle Financial Analytics Accounts Receivable Activity Example Metrics
Company/ Legal Entity
Date
Business
(Balance DK..)
Area AR Activity
Customer
GL
Account
Account
Ledger
• Closing Group Amount • Opening Group Amount • Closing Local Amount • Opening Local Amount • Days Sales Outstanding • AR Turnover • Credit Limit Used % • Credit Limit Amount
Customer
Features
Provides ability to analyze historical and curren t AR Balances by above dimen sions
• Operating Cycle • Cash C cle • Working Capital Turnover • LT Assets Turnover • Total Assets Turnover • Days Cash in Hand • Times Interest Earned • Debt to Equity • Quick Ratio • Capex Ratio • NWC To Assets • Closing Group Amount
Features
Ability to publish a complete Balance Sh eet including trial balance analysis
Oracle Financial Analytics GL Activity – Cash Flow Example Metrics
Ledger
Date
Business
(Balance Dk..)
Area GL Activity
Company/
GL
Legal Entity
Account
• Operating Cash Flow • Investing Cash Flow • Financing Cash Flow • Operating Cash Flow to CL • Cash to Current Liabilities • Operating Cash Flow to LT Debt • Cash Gross Margin • Cash Gross Margin % • Net Cash Flow
Features
Ability to publish a complete Cash Flow Statement on a pe riodic basis.
Oracle Financial Analytics GL Budget Example Metrics
Ledger
• Budget Document Amount • Budget Local Amount • Budget Group Amount
Date
Cost
(Posted/
Centers
/Budget..)
GL Budget Budget ers ons
ypes
GL Account
Features
Flexible to add dimensions for budget comparisons across many other dimensions
Oracle Financial Analytics GL Activity – Company Profitability Example Metrics Ledger
Date
Business
(Balance Dk..)
Area GL Activity
Company/
GL
Legal Entity
Account
• ROA (EBIT Basis) • ROCE (EBIT Basis) • ROCE (Pre Interest) • ROE • Gross Margin % • EBIT Margin % • EBT Margin % • Net Income Margin % • Gross Profit YTD • Gross Profit • Cost of Goods Sold • Sales & Marketing Expenses
Features
Ability to publish a complete P/L including all key profitability ratios – Margins and Returns
• Sales Cycle Lines • History • Accounts Receivables
• Sales Backlog History • • Sales Invoice Lines
• Inventory Transaction • Inventory Bill of Material
Oracle Supply Chain and Order Management Analytics Sales Order Lines Sales Order Details
Example Metrics
Cust. Location Sold to / Ship to / Bill to
Employee
Sales Channel
Customers
Products
Sales Order Lines
Mfg / Sales / Supplier
Locations a es
an g Ship / Storage
rgs
EAI
Payment ETL Terms
nc u es
og ca
mens ons an
• • • • • •
Date
Features
• • • • • • • • •
ou o
e ox me r cs
Provides ability to do detailed analysis of sales order lines
# of Cancelled Order Lines # of Customers # of First Customers # of Order Lines # of Orders # of Products # of Returned Order Lines % Or er D scount Average # of Products per Order Average Order Size Cancelled Amt / t Orders to Booking Close Rate Outstanding Booking Amt / Qty Total Ordered Amt / Qty
Oracle Supply Chain and Order Management Analytics Sales Booking Lines Sales Order
Cust Location
Details
Sold to / Ship to / Bill to
Example Metrics • # of Order Lines • # of Returned Lines
Employee
Sales Channel
• Adjustment Amount • Booked COGS • Booked List Amount
Customers
Sales Booking Lines
Products
• Discount Booked Amount
Mfg / Sales / Supplier
• Number of Adjustments • RMA Value Rate
a es
Locations
rgs
Plant / Ship / Storage
• Total Booked Amount • Total Booked Quantity
EAI
Payment ETL Terms
Date
• Total Return Amount
Features
Provides ability to do analysis of book ings and insight for optimally handling booking / RMA issues
Oracle Supply Chain and Order Management Analytics Sales Schedule Lines Example Metrics Date
• Confirmed Scheduled Base Quantity
Sales Order Details
Sales Channel
• Confirmed Scheduled Quantity • Issued Early Quantity
Customers
Products
Sales Schedule Lines
Mfg / Sales / Supplier
• Issued On time Quantity • Number of On Time Scheduled Items
Provides ability to do detailed analysis of the sales scheduling process
Oracle Supply Chain and Order Management Analytics Sales Backlog Lines Sales Order Details
Cust Location Sold to / Ship to / Bill to
Employee
Sales Channel
Customers
Products
a es
Sales Backlog Lines
Mfg / Sales / Supplier
Locations
rgs
Mfg / Plan t / Ship / Storage
EAI
BacklogETL Status
Date Txn. / Promised / Booked
Example Metrics
• • • • •
Hold Value Rate Hold Volume Rate Blocked Backlog Amt / Qty Delinquent Backlog Amt / Qty
• • Unscheduled Backlog Amt / Qty • Operational Backlog Amount • O erational Backlo Quantit • Total Open Credit Memo Request Value • Total Open Debit Memo Request Value • o a pen a ue
Features
Provides ability to do analysis of backlog and insight for optimally handling backlog issues
Oracle Supply Chain and Order Management Analytics Sales Backlog History Sales Order Details
• Total O en Credit Memo Re uest Value • Total Open Debit Memo Request Value
Date Txn. / Promised / Booked
• Total Open RMA Value
Features
Provides ability to do analysis of backlog trends based on historical snapshots of sales backlogs
Oracle Supply Chain and Order Management Analytics Sales Pick Lines Example Metrics
Date
• Actual Picked Quantity • Number of On Time Picks
Employee
Sales Channel
• On Time Pick Rate • On Time Picked Quantity • On Time
Customers
Sales Pick Lines
Products
• Picked COGS
Mfg / Sales / Supplier
• Planned Pick Quantity • Shipped COGS
a es
Locations
rgs
Plant / Ship / Storage
Sales Pick Detai s
• Total Shipped Amount
Cust Location o
o p o Bill to
Features
nc u es
og ca
mens ons an
ou o
e ox me r cs
Provides ability to do detailed analysis of the sales pick process
Oracle Supply Chain and Order Management Analytics Sales Invoice Lines Sales Order Details
Cust Location Sold to / Ship to / Bill to
Employee
Sales Invoice Details
Customers
a es
Products
Sales Invoice Lines
Mfg / Sales / Supplier
Locations
rgs
Plant / Mfg Ship / Storage
EAI
Payment ETL Terms
Date
Features
nc u es
og ca
mens ons an
ou o
e ox me r cs
Provides ability to do detailed analysis of sales invoices
Example Metrics • Average Discount Paid • Average Invoice Value • ance e m y • CR / DR Memo Amount • Gross Profit • Invoice to List Price Rate • nvo ce • Invoiced Discount Amount • Invoiced Freight Amount • Invoiced List Amount • nvo ce a es ax moun • Net Invoiced Amount • Number of Invoice Lines • Number of Invoices •
Oracle Supply Chain and Order Management Analytics Sales Cycle Lines Sales Order Details
Cust Location Sold to / Ship to / Bill to
Employee
Sales Cycle Details
Customers
a es
Products
Sales Cycle Lines
Mfg / Sales / Supplier
Locations
rgs
Plant / Ship / Storage
EAI
Payment ETL Terms
Date Order / Book / Pick / Ship / Invc.
Example Metrics • # of Orders • Cancelled Quantity • nvo ce moun • Order To Invoice Days Lag • Order to Pick Days Lag • Order To Ship Days Lag • r ere uan y • Sales Quantity • Ship Early Amt / Qty • Ship Late Amt / Qty • p n me m y • Shipment Amount • Total Invoiced Quantity • Total Pick Quantity •
Features
nc u es
og ca
mens ons an
ou o
e ox me r cs
Provides ability to do analysis of sales cycle times and ensur e process efficiencies
Oracle Supply Chain and Order Management Analytics Sales Customer Status History Cust Location
Example Metrics
Sold to / Ship to
• # Active Customers • # Dormant Customers • # Existing Customers • # Inactive Customers • # Lost Customers
Customers
• # New Customers
Sales Customer Status History
• # Recent Customers • # Total Customers •
EAI
us omer nac v y a o
ETLDate
Features
nc u es
og ca
mens ons an
ou o
e ox me r cs
Provides ability to do analysis of customer status and insight into leading indicators of churn
Oracle Supply Chain and Order Management Analytics Accounts Receivables Company
Example Metrics • Closing Group Amount • Opening Group Amount • Closing Local Amount • Opening Local Amount • Credit Limit Used % • Total AR Overdue Amount
Date (Balance DK..)
Receivables
• AR Overdue Amount to Total % • Total AR Due and Overdue Amt • AR Overdue Items to Total % • Da s Sales Outstandin • AR Turnover
Customer
Features
Provides ability to analyze historical and curren t AR Balances by above dimen sions
Oracle Supply Chain and Order Management Analytics Inventory Balance Example Metrics • Opening Quantity • Available uantit Product