The question need to be solved through the linear programming excel solver, conditions mentioned in the sub-parts.

Linear Programming and variant: 2 3 6 Product Product 2 Product 3 | Product Product 5 Profit of Product S510 S300 $510 $270 5810 Resource Availability Resource 1 2 10 2487 Resource 2 3 6 3 10 3030 Resource 3 10 6 5217 Resource 4 7 5 4 3 4000 Resources 5 6 3 10 2 Resource 6 10 3 2769 6 2 3 2 6 4999 3 4 A. the requirement that Product1, Product2 and Product 5 must be produced in equal amounts. Compared to the original Problem with any condition does adding this new requirement make the feasible region larger, stay the same, smaller, or something else? Clearly explain your answer B. Continuing from part A with this newly introduced requirement that Product1, Product2 and Product 5 must be produced in equal amounts, what is the optimal amount to be produced of each of Product1, Product2, Product3, Product4, Products? C. suppose we now introduce the additional requirement that Product1, Product2, Product 3, Product 4 and Product 5 must be produced in integer amounts. Im part 1) What is the optimal amount to be produced of each of Product1, Product2, Product3, Product4, Products? And optimal value of the objective function? D. Continuing on from part C above, assume the same unit profits as before but now with fixed start-up costs as given below. Product Product Product 2 Product 3 Product 4 Product 5 Unit Profit $510 $300 $510 $270 $810 Fixed-cost (Start-up cost) 2000 4000 8000 16000 1000 What is the optimal amount to be produced of each of Product1, Product2, Product3, Product4, Products? And optimal value of the objective function? E. suppose that we introduce the requirement that, if Product 2 is produced, then the amount of Product 2 produced must be one of 102, 103, 105, 107, 111 and we also introduce the further additional requirement that, if Product 4 is produced, then the amount produced of Product4 must be one of 320, 330, 350, 370, 410. 19 part 1) What is the optimal amount to be produced of each of Product1, Product2, Product3, Product4, Products? And optimal value of the objective function