I will build an excel inventory forecast and reorder point tracker

5.0
5.0

Vietnam

I speak English, Vietnamese

11 orders completed

Vietnam sourcing agent and supply chain support

I'm Phuc - 9+ years in manufacturing supply chains, based in Ho Chi Minh City. Six years in production planning, three as Deputy Purchasing Manager for a US-owned factory in Vietnam. I've sat on both ...

Level 1

Has met certain performance criteria and shows strong potential in the marketplace.

About this Gig

Stop guessing when to reorder.


I build the inventory forecast that product brands actually run their purchasing on. The same system I built for an Australian skincare distributor managing five brands out of Xero.


WHAT IT DOES

  • Reads your sales export (Xero, Shopify, QuickBooks or plain CSV)
  • - Monthly sales history and daily sales rate per SKU
  • - Minimum stock and reorder point based on your real lead times
  • - Suggested order quantity per SKU, updated when you paste new data
  • - Days until PO arrives and stock gap columns with colour flags
  • - One dashboard tab across all your brands or categories

WHY ME

9+ years in manufacturing supply chains, six of them in production planning. I have built these for real purchasing teams, not as a spreadsheet exercise. Lean Six Sigma Green Belt, SAP and Epicor.


WHAT I NEED

A sample export, your SKU list, supplier lead times, and how much cover you want to hold.


You get the working file with formulas left open. No macros, no lock-in. Not sure which package fits? Send me your SKU count first.

Platform:

Excel

•

Google Sheets

Development technology:

Excel

•

VLOOKUP

Expertise:

Formatting

•

Forms

•

Pivot tables

•

Formulas

•

Dashboard

My Portfolio

Reviews

2 reviews for this Gig
5.0

(2)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Quality of delivery
    5
  • Value of delivery
    5
Sort By
Most relevant
  • M

    manthony1955

    US

    United States

    5

    Phuc was very cooperative and accommodated my requests for edits and changes in a very attentive manner. She is a pleasure to work with as she pays attention to detail and responds in a very timely manner. Thanks, Phuc!

    $100-$200

    Price

    8 days

    Duration

    Helpful?
    Yes
    No
  • C

    cossol

    AU

    Australia

    Ongoing collaboration
    5

    Phuc was so easy to work with. She understood the brief entirely and delivered more than I asked. Would recommend highly.

    $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No
Reviews

2 reviews for this Gig
5.0

(2)
(0)
(0)
(0)
(0)
Rating Breakdown
  • Seller communication level
    5
  • Quality of delivery
    5
  • Value of delivery
    5
Sort By
Most relevant
  • M

    manthony1955

    US

    United States

    5

    Phuc was very cooperative and accommodated my requests for edits and changes in a very attentive manner. She is a pleasure to work with as she pays attention to detail and responds in a very timely manner. Thanks, Phuc!

    $100-$200

    Price

    8 days

    Duration

    Helpful?
    Yes
    No
  • C

    cossol

    AU

    Australia

    Ongoing collaboration
    5

    Phuc was so easy to work with. She understood the brief entirely and delivered more than I asked. Would recommend highly.

    $50

    Price

    1 day

    Duration

    Helpful?
    Yes
    No