I need to be able to forecast the demand for 3 month worth of stock with a 6 week lead time based on a bell curve.
I have the calculations for the weekly demand and the lead time but I need someone to create a smooth bell curve with an X & y axis and return the physical value back to my data sheet so I can use that figure to calculate the weekly demand/requirement.
The sku has four key elements, it has a stock range, so 1.5, 1.59, 1.61, 1.67, 1.74, then each stock range has coatings, UC, HC, IXT, Hydro+, BSIXT, then they have a sphere and cyl value (they do have colour but I am ignoring that for the demand planning).
I need a smooth bell curve graph per stock range/coating which can be used to calculate the stock ordering demand to allow us to hold 3 months stock.
I feel I have it close to the end product but I need help this morning to get it over the link.
Please note, I need to complete this by 12 noon GMT today, please don't bid if you can't meet that time.
if you can give me good budget i can doing sir within your deadline. I am PhD in computer science and statistics having seven years of experience in Excel development.