Hello, Below is the question from Statistic Chapter Linear Programming and the solution is required in the excel format. A sample solution in the excel format of similar type is attached for your ready reference.

On a chicken farm, the poultry is given a healthy diet to gain weight. The chickens must consume a minimum of 25 units of Substance A and another 35 units of Substance B. In the market there are only two classes of compounds: Type X, with a composition of one unit of A to five units of B, and another type, Y, with a composition of five units of A to one of B. The price of Type X is $10 and Type Y, $30. What are the quantities of each type of compound that must be purchased to cover the needs of the diet with a minimal cost?

Solution X Available Stock 30 06 Demand forecast 75 95 min. reqr. prod. 15 Part 1 Decesion Variables [X. Y) X and Y are the numbers of units prod. on machine A and B. x = numer of units of % produced in the current week y = number of units of Y produced in the current week. Objective Function Maximize the the combined sum of the units of X and Y left in the stock by end of week f [ x . y) = X+ Y Maximize (x+30-75) +[y+90-95) = [x+y - 50) Derivable Constraints 1. Machine A proc. 50 x + 24 Y = 45 [ Demand - in Stock = 75 -30 = 45 units) 4. Demand for Y unit y > = 5 abe [ Demand - in Stock = 95 -90 = 45 units) 2 Variables X Y' Coefficients 1 Solutions 45 6.25 51.25 Constraints 1 50 24 2400 Constraints 2 30 33 2100 Constraints 3 0 45 Constraints 4 1 LHS RHS Constraints 1 2400.00 2400 Constraints 2 1556.25 2100 Constraints 3 45.00 45 Constraints 4 Thus, the maximum stock will be achieved when X should produce 45 units and Y produces 6.25 units. Therefore, A combined sum as per objective is 51.25 with a value of objective function being 1.25