sconley1789
01-19-2008, 10:37 PM
I am trying to create a model for a simulation that will forecast production based upon customer specifications and demand. I think I have created a good model for optimizing product specifications in order to maximize sales. The issue I am running into is the ability to constrain predicted sales by the product lines capacity or output. I am able to constrain the the predicted sales cell (B34 thru B38) using the IF function. But the model does not redistribute the remaining product to the products that are still available.
I have attached the model spreadsheet. At the bottom of the regression page is the model. Predicted sales is derived as a % of market share based up the variance of the product characteristics and the products target characteristics. The %of market share is than summed and adjusted by dividing the predicted sales.
Any help would be appreciated,
SC
I have attached the model spreadsheet. At the bottom of the regression page is the model. Predicted sales is derived as a % of market share based up the variance of the product characteristics and the products target characteristics. The %of market share is than summed and adjusted by dividing the predicted sales.
Any help would be appreciated,
SC