master inventory replenishment: the fba sellers guide to inventory management

• Excess Inventory

• Stock-outs

• Replenishing Inventory

• Forecasting Best Practices

• New Product Orders

Sections

3 Days vs. 1 Day Per Month

Month 1

Month 2

Month 3

Month 4

Month 5

Month 6

Month 7

Month 8

Month 9

Month 10

Month 11

Month 12$0

$10,000

$20,000

$30,000

$40,000

$50,000

$60,000

$70,000

$80,000

3 Days/Month 1 Day/Month

3 Days / Month 1 Day / MonthProfit / Day $200 $200

Missed Profit / Month $600 $200

Total Profit* $64,800 $69,600

$4,800

*Assumes 30 days per month

Stock-Out Example

http://bit.ly/prosper-forecasting

Simple Example

• Safety Stock• Reorder Point

• RP = Safety Stock + (Lead Time * Velocity)• Days Until Reorder

• DUR = (Current Inventory – Reorder Point) / Velocity• Number of Units

• Units = ((# of Days + Lead Time) * Velocity) + Safety – Current – Inbound

bit.ly/jungle-forecastingEXCEL TEMPLATE

bit.ly/jungle-forecastingEXCEL TEMPLATE

Excel Replenishment Tool

• Options• Differences

• Time is money!• Real-time Data

• Velocity• Profit• Inventory Quantities – Fulfillable/Reserved/Inbound

• Typos (one number can throw everything off)• Safety Stock• Stock-out Days• Promotional Order Exclusions• FBM Data Incorporated (i.e. Shopify)• History (Graphs)

Amazon/Excel vs. Software Tool

Initial Order Excel Tool

bit.ly/jungle-forecastingEXCEL TEMPLATE

Jeremy Bironweb: www.forecastly.comemail: support@forecastly.com

Questions & Contact Info