CASE PROBLEM 1: Exquisite Confectionary Limited makes three types of confectionary i. Crunchy Bars, Coconut Delights and Chocolate Exquisites.

CASE PROBLEM 1:Exquisite Confectionary Limited makes three types of confectionary i.e. Crunchy Bars, Coconut Delights and Chocolate Exquisites. The three confectionaries are made by mixing different percentages of 6 types of ingredients. To prepare a batch of the confectionaries, the following ingredients have been purchased at the costs per kilogram shown:Ingredient Cost ($/Kg) Quantity Purchased (Kg) Milk chocolate 0.41 1,500 Strawberry jelly 0.32 300 Peanuts 0.83 600 Coconut 0.3D 300 Milk solids 0.34 200 Dried fruit 1.25 400Exquisite wants to determine the minimum cost mixture for an order of 1,000 kilograms of Crunchy Bars, 800 kilograms of Coconut Delights and 500 kilograms of Chocolate Exquisites.In Crunchy Bars: the weight of chocolate must be at least 40 percent the total weight; there should be no strawberry jelly; ESGC 6322 Operations Research Methods Sem. 1, 2011/20122 the weight of peanuts must be at least 25 percent the total weight; the weight coconut must be no more than 10 percent the total weight; the weight milk solids must be no more than 15 percent the total weight; and the weight dried fruit must be at least 10 percent the total weight.In Coconut Delights: the weight of chocolate must be at least 40 percent the total weight; the weight of strawberry must be at least 25 percent the total weight; there should be no peanuts; the weight coconut must be at least 10 percent the total weight; the weight milk solids must be no more than 10 percent the total weight; and there should be no dried fruit.In Chocolate Exquisites: the weight of chocolate must be at least 50 percent the total weight; the weight of strawberry must be no more than 15 percent the total weight; the weight of peanuts must be at least 5 percent the total weight; the weight coconut must be at least 5 percent the total weight; the weight milk solids must be no more than 10 percent the total weight; and the weight dried fruit must be at least 10 percent the total weight.Formulate the linear-programming problem. (There are 18 variables). Solve it using Excel. Produce a report concerning the model and the results, including the following1. optimal product mix and the associated cost,2. the values of the slack and surplus variables,3. Recommendations how the total cost can be reduced if the weight of the ingredients can be decreased in each of the three types of confectionary.4. A recommendation as to whether an additional 200 kg of coconut should be purchased for $10 from a supplier who overbought5. Recommendations on how the cost can be decreased (if at all) if the existing orders are not satisfied.