How to create conditional formula for costs with categorical ingredients
Jul 27, 2015 9:32 AM(5532 views)
I have attached an example mixture design with one categorical factor for one of the ingredients. How would I create a formula to compute the total cost of the formula when it depends on which type of ingredient is used?
If X1 is type A, the total cost is $1/kg x % X1 + $0.50/kg x % X2 + $0.75/kg x X3
If X2 is type B, the total cost is $2/kg x % X1 + $0.50/kg x % X2 + $0.75/kg x X3
If X3 is type C, the total cost is $3/kg x % X1 + $0.50/kg x % X2 + $0.75/kg x X3
Then I would be able to use the prediction formula for targeted costs.