A computer implemented system for optimization of sand for the purpose of reducing casting rejections in a foundry, said system comprising: • a first repository configured to store therein data pertaining to a set of primary sand parameters, wherein said parameters is selected from the group consisting of Green Compression Strength, compact-ability index, moisture content, active clay, inert fines content, Loss On Ignition percent, permeability index, wet tensile strength, volatile matter content, grain fineness number (GFN or AFS), oolitics content and pH value of the sand; • a second repository configured to store therein data pertaining to rejection type and rejection quantity; • a third repository configured to store therein pattern generated using the parameter corresponding to the rejections; • an input module cooperating with said first repository, said input module configured to receive at least a value corresponding to the at least one parameter for an instance; • a processor module cooperating with said first repository, said second repository, said third repository and said input module, said processor module configured to correlate the parameter values, the parameters, the rejections, and the rejection type, and provide correlation between the parameter values, the parameters, the rejections, and the rejection type for each of the instance; • a pattern forming engine coupled with the processor module, said pattern forming engine configured to determine at least a pattern based on the correlations of the parameter values, parameters, rejections, and rejection type, the pattern generated being at least a complex equation which takes into account each of the correlated data to form a complex multi-dimensional curve; and • a predictive-prescriptive module cooperating with said pattern forming engine and said processor module, said predictive-prescriptive module configured to receive the input values corresponding to the parameters fed by a user, said predictive-prescriptive module being configured to map the input values into the complex equations and generate at least a predictive/ prescriptive solution including a degree of probability. • a first repository configured to store therein data pertaining to a set of primary sand parameters, wherein said parameters is selected from the group consisting of Green Compression Strength, compact-ability index, moisture content, active clay, inert fines content, Loss On Ignition percent, permeability index, wet tensile strength, volatile matter content, grain fineness number (GFN or AFS), oolitics content and pH value of the sand; • a second repository configured to store therein data pertaining to rejection type and rejection quantity; • a third repository configured to store therein pattern generated using the parameter corresponding to the rejections; • an input module cooperating with said first repository, said input module configured to receive at least a value corresponding to the at least one parameter for an instance; • a processor module cooperating with said first repository, said second repository, said third repository and said input module, said processor module configured to correlate the parameter values, the parameters, the rejections, and the rejection type, and provide correlation between the parameter values, the parameters, the rejections, and the rejection type for each of the instance; • a pattern forming engine coupled with the processor module, said pattern forming engine configured to determine at least a pattern based on the correlations of the parameter values, parameters, rejections, and rejection type, the pattern generated being at least a complex equation which takes into account each of the correlated data to form a complex multi-dimensional curve; and • a predictive-prescriptive module cooperating with said pattern forming engine and said processor module, said predictive-prescriptive module configured to receive the input values corresponding to the parameters fed by a user, said predictive-prescriptive module being configured to map the input values into the complex equations and generate at least a predictive/ prescriptive solution including a degree of probability.