Inventory and Demand Planning Specialist Needed

$15-25 USD / hour

Closed

Posted 7 days ago

$15-25 USD / hour

Hi, I’m looking for an experienced demand and inventory planning specialist to help me take over an existing Excel demand plan for a footwear and accessories company. I need hands-on help reviewing and correcting the workbook, updating it with current data, and teaching me how to maintain it independently. The work includes: * Reviewing existing formulas, data sources, and forecasting assumptions. * Reconciling sales history, available inventory across warehouses and Amazon, backorders, and open purchase orders with arrival dates. * Forecasting demand by SKU, including individual sizes and colors, while accounting for seasonality and periods when products were out of stock. * Showing projected shortages, weeks of inventory remaining, and recommended order quantities and timing based on lead times. * Creating a clear weekly update process and walking me through the calculations. My priority is getting the existing workbook accurate and usable quickly. The deliverable should be an updated Excel plan, a list of corrections and unresolved data questions, and simple instructions for maintaining it. Have you worked with a similar business involving multiple warehouses, Shopify, Amazon, and a large number of size variations? Are you comfortable troubleshooting someone else’s Excel workbook? Can we start with a paid two-hour screen-sharing session to assess the file and work through the first updates together? Please let me know your earliest availability, hourly rate, and whether you can work this weekend. After reviewing the file, I’d like an estimate for completing the remaining work. Thank you, Stacy

Project ID: 40720310

About the project

32 proposals

Remote project

Active 6 days ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

32 freelancers are bidding on average $23 USD/hour for this job

@ayazakhtar75

Hi Stacy, Yes, I’m comfortable taking over and troubleshooting an existing Excel planning model rather than rebuilding everything unnecessarily. I can review the formulas and assumptions, reconcile Shopify/Amazon sales, warehouse inventory, backorders and open POs, then work through SKU-level forecasting for sizes/colors, seasonality and stockout periods. I’ll also make shortages, weeks of cover and reorder timing much easier to follow. Starting with a paid two-hour screen-share makes sense. We can use it to diagnose the workbook, fix the highest-priority issues together, and then I can give you a realistic estimate for the remaining work. I can work this weekend. Please send the workbook/sample data and your preferred session time. Best regards, Ayaz Akhtar

$25 USD in 40 days

5.0

(131 reviews)

6.8

@ZohaibRoy

⭐⭐⭐⭐⭐ Expert Demand & Inventory Planning for Footwear and Accessories ❇️ Hi My Friend, I hope you are doing well. I just reviewed your project requirements and see you are looking for a demand and inventory planning specialist. You have no need to look any further as Zohaib is here to help you! My team has completed over 50 similar projects for demand planning. I will review your existing Excel workbook, correct it, and teach you how to maintain it independently, ensuring accuracy and usability. ➡️ Why Me? I can easily handle your demand and inventory planning needs as I have 5 years of experience in Excel data management, forecasting, and inventory reconciliation. My expertise includes data analysis, sales forecasting, and inventory tracking. Additionally, I have a strong grip on Excel functions, data visualization, and reporting tools, ensuring a comprehensive approach to your project. ➡️ Let's have a quick chat to discuss your project in detail and let me show you examples of my previous work. I'm looking forward to discussing this with you! ➡️ Skills & Experience: ✅ Excel Data Management ✅ Demand Forecasting ✅ Inventory Reconciliation ✅ Sales Analysis ✅ Data Visualization ✅ Formula Review ✅ SKU Management ✅ Seasonal Planning ✅ Order Quantity Calculation ✅ Reporting Tools ✅ Troubleshooting Excel ✅ Process Documentation Waiting for your response! Best Regards, Zohaib

$17 USD in 40 days

5.0

(23 reviews)

6.2

@jinufeb14

As an experienced software engineer, I am well-versed in handling complex tasks involving Excel, data analysis, and problem-solving which makes me the perfect fit for your demand and inventory planning project. I've successfully averted stockouts, reduced carrying costs by optimizing stock levels and increased overall efficiency for my previous clients. Your requirement for reconciling sales history across multiple warehouses, platforms like Shopify and Amazon, existing stock levels, backorders, open purchase orders and more aligns perfectly with my skills and expertise. I’ve previously handled analogous challenges in large-scale e-commerce businesses and gained considerable experience in demand forecasting. By using advanced Excel formulas and a mechanical approach to checks and double-checks, I ensure an accurate plan tailored for your business. Furthermore, my client-centric approach ensures that I equip you with the knowledge to confidently maintain the revamped workbook yourself after completion of my work. This would be accompanied by a documented process walkthrough as requested. Hence, let me alleviate your concerns, guaranteeing a quicker turnaround time on your project while providing uncompromised accuracy-oriented deliverables.I assure you my hourly rate is competitive and I'm available to start immediately

$20 USD in 40 days