$?$

Operations Management A manufacturer needs to create 3 different types of products: facial cream, body lotion, and hair conditioner, by blending four key natural ingredients: Aloe Vera, Coconut Oil, Argan Oil, and Shea Butter. Each ingredient contributes different levels of essential nutrients necessary for the cosmetic properties of the products. The cosmetics manufacturer must produce 9 tons of facial cream, 5 tons of body lotion, and 7 tons of hair conditioner. The available quantities of ingredients are restricted to 7 tons of Aloe Vera, 12 tons of Coconut Oil, 6 tons of Argan Oil, and 5 tons of Shea Butter. The ingredient costs are $0.18 per kilogram for Aloe Vera, $0.11 for Coconut Oil, $0.25 for Argan Oil, and $0.20 for Shea Butter. Each beauty product has specific nutrient requirements for moisture, lipids, vitamins, and minerals, with precise minimum and maximum values defined for each. The objective is to create a cost-effective production plan that satisfies these nutrient specifications and meets the production volume requirements. Ingredient Aloe Vera Moisture 7 Coconut Oil 6 Argan Oil 5 Shea Butter 4 Lipids 12 5 Vitamins Minerals 6 7 10 5 5 8 6 10 11 7 Table 1: Nutrient content of the ingredients per kilogram Moisture Lipids Vitamins Minerals Product Min Max Min Max Min Max Min Max Facial 6 8 % 5 9 co 3 9 Cream Body 5 80 4 8 7 8 00 3 7 Lotion Hair 4 7 5 8 5 80 3 6 Conditioner Table 2: Min and max vitamin, protein, calcium, and crude fat values for each product per kilogram Solve this problem on excel by using excel solver. Provide formulas and sheet(s)