Replenishment system forecasting model and formulas in Microsoft Excel - repost

CLOSED
Bids
18
Avg Bid (USD)
$21 / hr
Project Budget (USD)
$15 - $25 / hr

Project Description:
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.

Hours of work: 15 Project Duration: 1 - 4 semanas Skills required:
Data Mining, Excel, Inventory Management, Logistics & Shipping, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$20 / hr
Hours: 20 hr/ week
$22 / hr
Hours: 15 hr/ week
$20 / hr
Hours: 40 hr/ week
Hire Aldo21
$15 / hr
Hours: 10 hr/ week
$24 / hr
Hours: 15 hr/ week
Hire saktulgasaktulga
$16 / hr
Hours: 15 hr/ week
Hire gaer88
$22 / hr
Hours: 15 hr/ week
Hire sisdel
$22 / hr
Hours: 15 hr/ week
$15 / hr
Hours: 15 hr/ week
Hire PriyankPiyush1
$15 / hr
Hours: 20 hr/ week