SOLVE IT USING EXCEL DATA SOLVER LINEAR PROGRAMMING AND WRITE DOWN CONSTRAINTS

Problem 2 Fat Chicken Farm is a producer of frying chickens. In order to produce the best fryers possible, the regular chicken feed is supplemented by four vitamins. The minimum amount of each vitamin required per 100 grams of feed is: vitamin 1, 40 units; vitamin 2, 50 units; vitamin 3, 50 units; vitamin 4, 60 units. Two supplements are available: Supplement I costs 0.07 per gram and contains 45 units of vitamin 1 per gram, 45 units of vitamin 2 per gram, 35 units of vitamin 3 per gram, and 15 units of vitamin 4 per gram. Supplement II costs 0.02 per gram and contains 45 units of vitamin 1 per gram, 10 units of vitamin 2 per gram, 45 units of vitamin 3 per gram, and 40 units of vitamin 4 per gram. What is the minimum cost of supplements which have to be added to each 100 gram of feed to ensure the desired ammounts of vitamins