Reverse Logistics Financial Model

50 %
50 %
Information about Reverse Logistics Financial Model

Published on March 30, 2008

Author: Mehrmann


Create Your Reverse Logistics Financial Model:  Create Your Reverse Logistics Financial Model by John Mehrmann Building a Financial Model:  Building a Financial Model All financial models are not created equal There is no ‘one size fits all’ financial model A personal financial model is determined by Process Product Price Profit People Parts Performance Provisions Percentage Perspective The goal of this material is to give you building blocks for constructing your own financial model. Process:  Process There are different perspectives to the impact of returns Manufacturers may track return ratios by channel, while the channel may track returns by brand and model Product $ MSRP (Retail Price) $ LIC (Cost) $ BOM (Materials) Sales Manufacturer Perspective Credit & Return Ratio $ Direct $ Retail $ VAR Retail Perspective Return Ratio by Brand / Model $ Refund $ Replace Same Brand $ Replace Different Brand $ Time to Return $ RMA & Credit Policies $ Caps on Returns Retail Return Impact View:  Retail Return Impact View Collect Data to compare Brand / Model Performance Manufacturer View:  Manufacturer View Freight and freight related charges How many people touch the product or the process? Are you tracking all of the costs? Product $ MSRP (Retail Price) $ LIC (Cost) $ BOM (Materials) Sales Return Center $ Freight and $ Fuel Surcharges $ Receiving $ Sorting $ Inspection / Validation $ Credit Processing / Finance $ Operations Management $ Warehouse Space $ Ratio Good vs Bad Units $ Return Packaging Trends:  Trends Tracking trends by sales channels and return ratios is an important step to forecast resources, storage, and budget impact for manufacturers. Apply historical trends to forecasted future sales by channel and plan ahead. Where are your Returns Received?:  Where are your Returns Received? Freight and fuel charges are greatly impacted by the geographic location of the Returns Center compared to demographics and carrier (truck, rail, etc) 20% of Returns 80% of Returns Return CenterHidden Costs:  Return Center Hidden Costs Facility Manpower Utilities Fixed Expense Variable Costs Depreciation IT Systems What do you pay for? After it is received . . .:  After it is received . . . Product Sales Return Center Hold – Accumulate Inventory at Full Book Value (Uh Oh) Future Financial Impact Return Product to Vendor for Warranty (ODM/OCM) Refurbish Product, Repair Parts from Vendor or Harvest Sell AS IS or SCRAP $ Freight & Fuel Surcharges $ Inventory position $ Depreciation $ Warehouse Storage $ Operations and Accounting $ Shipping & Receiving $ Packing & Insurance Global Economy:  Global Economy $ Labor Rates $ ODM Part Warranty $ Variable Currency Exchange Rates $ Inventory Position $ Accumulated Shipments $ Import, Export, Duties, Tax $ Shipping, Receiving, Handling $ Depreciation in transit $ Freight Compare Are you getting the most value?:  Are you getting the most value? Cost of Replacement Parts Back-order Spare Parts Status Return Product Refurbish Resale Value Customer Exchanges Harvest Parts for Warranty Harvest Parts for Refurbishing Cost of the sum of Parts compared to Product Value Use Refurbished not NEW units Replace rather than Refund Trend accumulated inventory, depreciation, and price erosion Product Resale Value and Parts Procurement costs change over time and must be updated Accessories:  Accessories How many different ways are the same accessories carried in inventory? Same item with different part numbers and different locations? $ Manuals $ Cables $ Remotes $ AC Adapters $ Batteries $ Ear Buds $ CD’s / Software $ ______________ Replenish? Inventory? Consumer Demand? Debit Missing Accessories? Technology :  Technology Integration and automation Improve tracking, planning, and productivity Automate manual functions Integration between retail dealer, return center, call center, service providers, ODM vendors, claims processing, collectors, recyclers, government, ODM, and OCM vendors Track and trend Failure Rates, Return Ratios, and ROI What is the ROI on your IT Architecture? How is Technology used to plan decisions When to refurbish When to repair When to harvest parts etc e-Waste:  e-Waste Growing awareness, concern, and cost. Expense for collection, recycling, Certificates of Destruction, and related costs for environmental protection are creating new financial burdens by geographic region and product. RoHS & WEEE Directives, Laws being drafted ongoing Create your own model:  Create your own model Map your process Define and measure each step in the process Define movement between steps, movement = expense Assign Metrics to each Step and Movement Frequency Severity or Cost Resources or Manpower Inventory Depreciation or Process Delay Cost Identify Variables Adjustable Seasonal Headcount Warehouse / Storage Currency Exchange Rates, Duties, Fees Find Hidden Costs Examples: Accessories, Boxes and Packing Materials, Utilities, Management, IT, etc Map Your Process:  Map Your Process Wal-Mart Best Buy Circuit City SEARS Other Blanket Return Authorization / On-Line Entry / System Integration Options – RMA Options Logistics / Transportation Costs of Return Freight Consolidation and Receipt Confirmation Electronic / On-Line Alert Report to issue Credit New Refurbish (Not New) Not Economical to Repair TEST REPAIR QUALITY CONTROL Package Warehouse / Inventory Reseller Reseller Reseller Quality Control Engineering Lab ISO9001/2000 Technical Data Failure Reports A B Time to Repair MFFR Parts ODM Parts Source Parts Repair Parts In-House Repair Stock Balance Consolidate Freight To/From Source Asset Recovery Revenue Share (SCRAP) Slide17:  Compare Cost to Return on Investment Simple Example Look for ways to Simplify:  Look for ways to Simplify Measure the cost for each step in the process. Look for ways to Simplify:  Look for ways to Simplify Measure the cost for each step in the process. Then review options and calculate savings to reduce cost. Measure the impact of your changes. Can you think of some additional Cost Concerns that were not included in this overview?Share your experience.:  Can you think of some additional Cost Concerns that were not included in this overview? Share your experience. Thank You:  Thank You

Add a comment

Related presentations

Related pages

Reverse Logistics Magazine: Reverse Logistics Financial ...

Reverse Logistics Financial Model by John Mehrmann, DEX Reverse Logistics Magazine, Jan/Feb 2008. It has been said that a boat is a hole in the water in ...
Read more

Closing the Supply Chain Loop: Reverse Logistics and the ...

Closing the Supply Chain Loop: Reverse Logistics and ... SCOR model ( ... estimated financial value to returned goods. Reverse logistics ...
Read more

Reverse logistics - Wikipedia, the free encyclopedia

Reverse logistics is for all operations related to the reuse ... The product would travel in reverse through the supply chain network in order to retain ...
Read more

Reverse Logistics - UPS Supply Chain Solutions

4 Improving reverse logistics operations As is often the case in complex business systems, the starting point for reverse logistics operations ...
Read more

Inventory Models in Reverse Logistics -

Corvinus University Budapest Faculty of Business Administration Inventory Models in Reverse Logistics PhD Dissertation by Dobos Imre November, 2006.
Read more

Reverse Logistics Magazine - What is Reverse Logistics ...

What is Reverse Logistics? — The process of planning, implementing, and controlling the efficient, cost effective flow of raw materials, in-process ...
Read more

Model of reverse logistics by means of a logistics ...

This study describes a reverse logistics model that can ... Model of reverse logistics by ... As far as the financial benefits go, the logistics ...
Read more

Reverse Logistics - Customer Returns

Reverse Logistics can be defined as activities associated with a product after a point of sale. This article examines the elements of reverse logistics.
Read more

The hidden value in Reverse Logistics Point of view

The hidden value in Reverse Logistics. 3. In today’s business context, companies can not longer afford to neglect reverse logistics as an integral part
Read more

Why Reverse Logistics Needs to Become a Core Competency ...

Why Reverse Logistics Needs to Become a Core Competency Inside Your Supply ... Reverse Logistics: ... there are the financial drivers that come into play.
Read more