Replenishment system forecasting model and formulas in Microsoft Excel - repost

Closed

I am working on a forecasting model for a re-order point/max replenishment system for a manufacturing company in the US.

The sales trends have many components, including seasonality factors (influenced strongly by weather) and individual store or regional growth/decline by product type which has some correlation with the housing market growth, etc.

My model needs to account for less than 5% stockouts on the premise of a weekly to bimonthly store replenishment cycle.

Additionally, the volume of product on hand needs to cover an estimated baseline demand.

The upper bound constraint of inventory is that annualized inventory turns must be 6 or higher. Additionally, geographical regions have a target inventory supply based on predicted sales in a monthly time frame.

I can provide examples of product types and sales trends along with average lead times for shipment to store locations.

Typical formulas that have been used are weighted moving averages, in conjunction with growth trends and seasonality. A regression model would be useful, but I do not have sufficient market and correlational data to build a regression model at this point.

Skills: Data Mining, Excel, Inventory Management, Logistics & Shipping, SQL

See more: replenishment forecasting excel, excel model inventory replenishment, inventory replenishment excel formulas, inventory forecasting model, order point system microsoft excel, supply and demand data, sql inventory system, microsoft excel formulas, demand and supply data, upper sql, sql less than, less than excel, excel less than, regression model, excel to my sql, EXCEL MODEL, excel inventory, data forecasting, correlation, Baseline, sql forecasting inventory, microsoft excel account, data trends excel, build excel model, excel regional

Project ID: #4985728

18 freelancers are bidding on average $21/hour for this job

pkcyber

Hi, I can develop the application for your which will help you. See the sample application below. Idea is, this automated application will take the input files/data we will discussed on it and give u forecastings More

$20 USD / hour
(23 Reviews)
5.4
dpune

Hi, I am expert in this kind of work and I have already completed more than 200 projects. Please look at my feedback to know more about me. Thanks and waiting for your positive reply.

$22 USD / hour
(21 Reviews)
4.9
qualifiedcoders

hi hope you are doing fine. We have read your requirements and have 10 experts in our company who have very good experience as Excel programmers and can do any sort of administrative tasks. They have Very good kn More

$20 USD / hour
(1 Review)
4.6
Aldo21

Simulation expert here, worked with many statistical models. aldo -.----------------------------------------------.--------------------------------------------

$15 USD / hour
(5 Reviews)
2.4
bandana89

Hi, MBA in Operations Management. Will start working developing model right away. Please provide with more data as product types, company location, sales trends, lead times, also provide all the data you have , so that More

$24 USD / hour
(0 Reviews)
0.0
saktulgasaktulga

Hello, I am an excel expert who can do this in 3 days. I would like to get sample files to start with. You will be pleased with the job done. Regards.

$16 USD / hour
(0 Reviews)
0.0
gaer88

Hi there! I like maths and I am an engineer. I did my thesis with excel in my final year at college.

$22 USD / hour
(0 Reviews)
0.0
sisdel

For the last few years, I am managing the planning department of a huge factory, producing parts for the automotive industry. My team had to create a planning model for about 10 000 articles, set up reorder point (b More

$22 USD / hour
(0 Reviews)
0.0
sureshtolani

HI, Though i am new to this portal, but my live field role is all about the domain you are currently working on. I take care of 10 hyper retail stores replenishment for grocery and 90% availability is one of my KRAs. H More

$15 USD / hour
(0 Reviews)
0.0
PriyankPiyush1

I am a MBA grad I did a similar Modelling for Mahindra Reva ( Electric Cars ). Please let me know when Can I start. My Main objective is to gain good review Money is secondry. Hope it helps.

$15 USD / hour
(0 Reviews)
0.0
opie71

Dear Sir / Madam, I have extensive experience in developing Inventory Management related reporitng and dashboards - I have been working for last 2 years for UPS Supply Chain Solutions - Contract Logistics in Inventory More

$27 USD / hour
(0 Reviews)
0.0
mehakgupta25

I have worked with Infosys for 2 years, and I am quite open to SQl. microsoft excel which is required for your project.

$22 USD / hour
(0 Reviews)
0.0
malikha1969

God willing, with the experience and skills that I have, I am able to complete the work that you entrusted to me.

$25 USD / hour
(0 Reviews)
0.0
abhisheknitj08

Sir, I am a student of MBA-operations management and making these kind of models is what we learn. we can provide you the service required. kindly consider us. regards, abhishek

$20 USD / hour
(0 Reviews)
0.0
bluerain05

Hi there, I'm actively in logistics business for 8 years now and I'm an AFIT Supply Chain and Logistics Master's Program Graduate(2012). We've studied inventory management problems in great detail and experienced appli More

$33 USD / hour
(0 Reviews)
0.0
sheiksadak

Hi, I have been working with store replenishment , which i have worked in manufacturing and Retail Warehouses in my experience.

$16 USD / hour
(0 Reviews)
0.0
vipulkotkar

Hi , I am vipul kotkar from India. Educational Portfolio - MBA (Supply chain Management) Bachelor of Engineering (Instrumentation) ASQ certified quality process analyst. I have More

$22 USD / hour
(0 Reviews)
0.0
bfolkestad1

I am detailed oriented and am very focused. I understand the important of integrity in the database or spreadsheet. I am a gap locator with a high rate of accuracy.

$24 USD / hour
(0 Reviews)
0.0