need help with precise steps and explanations:

A candy manufacturer located at Seattle manufactures five different candy and mixed candy products: Alpha pack, Beta pack, Delta pack, Lambda pack, and Theta pack. Each product, whether individual or mix, comes in a 500g can. The packing requirements and the forecasted demand for the products are as follows:

Alpha Beta Delta Lambda Theta Minimum Requirements (%) Red candy Black candy 100 0 0 100 45 45 30 30 20 20 Demand (cans) 1250 750 1000 500 1500 The production team can manufacture Red candy at a cost of RM0.80 per kilogram, Black candy at a cost of RM0.60 per kilogram, and Yellow candy at a cost of RM0.35 per kilogram. Yellow candy are used to complete each mix, and the production team has an unlimited supply of them. The supply of Red and Black candy is limited. They can be manufactured up to 3000kg of Red candy and 2000kg of Black candy. The management would like to decide the mix that minimizes the cost of fulfilling the demands for all five products. a. Formulate a linear programming model for this problem. b. Use a software package based on the simplex method (e.g. Excel Solver) to solve the problem and then to generate sensitivity report. C. What is the impact on the product mix if only 2000kg of Yellow candy are available? d. What is the impact on the product mix if the Delta pack needs 50% Red candy and 50% Black candy? e. What is the impact on the product mix if demand for the Lambda pack doubles? Alpha Beta Delta Lambda Theta Minimum Requirements (%) Red candy Black candy 100 0 0 100 45 45 30 30 20 20 Demand (cans) 1250 750 1000 500 1500 The production team can manufacture Red candy at a cost of RM0.80 per kilogram, Black candy at a cost of RM0.60 per kilogram, and Yellow candy at a cost of RM0.35 per kilogram. Yellow candy are used to complete each mix, and the production team has an unlimited supply of them. The supply of Red and Black candy is limited. They can be manufactured up to 3000kg of Red candy and 2000kg of Black candy. The management would like to decide the mix that minimizes the cost of fulfilling the demands for all five products. a. Formulate a linear programming model for this problem. b. Use a software package based on the simplex method (e.g. Excel Solver) to solve the problem and then to generate sensitivity report. C. What is the impact on the product mix if only 2000kg of Yellow candy are available? d. What is the impact on the product mix if the Delta pack needs 50% Red candy and 50% Black candy? e. What is the impact on the product mix if demand for the Lambda pack doubles