Browse categories
Explore
Fiverr Pro
English
$
USD
I will improve your inventory spreadsheet
Inventory Management for Supply Chain in Excel or Google Sheet
Hi, my name is Pedro and am glad to share my Excel skills through my experience as Demand & Supply Planner in Inventory Management System for small and medium business. I'm willing to customize any Ex...
Level 2
Has met high performance criteria and has a proven track record for meeting client expectations.
Highly Responsive
Known for exceptionally quick replies
About this Gig
This Inventory Management system get following features for your business:
- Is fully automatic with protected sheets
- Easy handle with userforms and dependent lists
- Include 4 modules: Master Data / Replanisment / Sales Ordering / Forecasting
- Dashboards and dynamic charts updated and saved on every run macro
- Stock warnings by SKU's visible on dashboards
- Stock coverage is controled by automatic replanisment calculation
- You can create, edit and send Purchase Orders and Invoices to PDF
- You can create and edit your Master Data (Suppliers, Customers, and Products) and data is protected with password
- Inventory is updated on every Goods Receive or Delivery Order
- Replanisment calculation based on ABC clasification, Minimum Order Quantity, and Sales Forecast
- You can update and release you Demand Forecast anytime you like with Time Series Method (Exponencial Smoothing) in Forecasting Module
- You can load Budget and Sales History quantities to get better Forecast. Back-orders are quantitated
- You can check charts for Planning Scenarios for any product category or SKU's in 24 month planning horizon
- This systems will support up to 200 SKU's and support replanishment and forecast till Dec-2021
Platform:
Excel
•
Google Sheets
•
OpenOffice
Development technology:
VBA
•
Google Apps Script
•
Excel
Expertise:
Formatting
•
Fixing
•
Forms
•
Pivot tables
•
Formulas
Reviews
3 reviews for this Gig
| (3) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
Most relevant
W wavell_aps
Germany
great work again!
$200-$400
Price
8 days
Duration
Helpful?D duncanzahra
United States
Pedro truly exceeded expectations with his professionalism and attention to detail in data processing, delivering outstanding work that amazed me! His deep understanding and quick responsiveness made collaboration effortless, with timely delivery. VERY GOOD WORK, HE TOOK THE TIME TO GO OVER EVERYTHING STEP BY STEP - WILL DEFINITELY USE AGAIN! 🙌
$100-$200
Price
3 days
Duration
Helpful?L 
luisrueda779
Mexico
Great Service! the solution works perfectly and he delivers very fast
Up to $50
Price
6 days
Duration
Helpful?
Reviews
3 reviews for this Gig
| (3) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
Most relevant
W wavell_aps
Germany
great work again!
$200-$400
Price
8 days
Duration
Helpful?D duncanzahra
United States
Pedro truly exceeded expectations with his professionalism and attention to detail in data processing, delivering outstanding work that amazed me! His deep understanding and quick responsiveness made collaboration effortless, with timely delivery. VERY GOOD WORK, HE TOOK THE TIME TO GO OVER EVERYTHING STEP BY STEP - WILL DEFINITELY USE AGAIN! 🙌
$100-$200
Price
3 days
Duration
Helpful?L luisrueda779
Mexico
Great Service! the solution works perfectly and he delivers very fast
Up to $50
Price
6 days
Duration
Helpful?
