Charley's Ice Cream Charley's Ice Cream (CIC) specializes in small-batch homemade ice cream. The first step in making ice cream is to select and blend the ingredients. CIC wants to create 50-pound batches, which meets pre-specified requirements based on the seven constituents. The possible ingredients that CIC can use in a batch of ice cream are shown in Table 1 along with each ingredient's cost per pound. The pre-specified requirements for each constituent for a 50-pound batch of ice cream are shown in Table 2. Notice that these requirements are shown in terms of percentages of a 50-pound batch. Table 1: Ingredient cost per pound Cond Skim Sugared 10% 23% Plastic Butter 4% Skim Milk Liquid Frozen Powdered Cream Cream Butter Cream Oil Milk Milk Powder Sugar Egg Yolk Egg Yolk Stabilizer Emulsifier Water $1.19 $0.70 $2.32 $2.30 $2.87 50.25 $0.35 50.65 50.25 $1.75 $4.45 $2.45 $1.65 50.01 Table 2: Minimum and Maximum Requirements by Constituent Constituent Minimum Maximum Fat 15.00% 17.00% Serum Solid: 7.00% 9.00% Sugar Solids 15.50% 16.50% Egg Solids 0.30% 0.40% Stabilizer 0.20% 0.30% Emulsifier 0.10% 0.20% Water 58.00% 59.50% Each ingredient used contributes to the constituent requirements differently. For example, there are many sources of fat and water. The input/output matrix of the 7 constituents and 14 potential ingredients is shown in Table 3. For example, one pound of 40% cream adds 0.4 pound of fat, 0.1 pound of serum solids and 0.5 pounds of water to the mix. In addition, one pound of skim milk powder adds one pound of serum solids. Table 3: Input/output ratios for 14 ingredients by 7 constituents Con Skim sugared 40% 23% Plastic Butter 4% Skim Milk Liquid Frozen Powdered Cream Cream Butter Cream Oil Milk Milk Powder Sugar Egg Yolk Egg Yolk Stabilizer Emulsifier | Water Fat 0.4 0.2 0.8 0.8 0.9 0.1 0.5 0.5Serum Solids Sugar Solids Egg Solids Stabilizer Emulsifier Water Develop a Solver based model in order to determine the minimum cost for a 50-pound batch of ice cream that meets the stated requirements. HINT: Any value that is missing from Table 3 is considered a 0