thank you :)

The above Linear Program from the above problem is solved using MS-Excel. Refer to the enclosed "Answer and Sensitivity" reports below and answer the below questions (Hint: All questions below can be answered from the Answer and Sensitivity reports. Do not waste time in solving for new Linear Programs to obtain Answers). a) Which decision variables are basic, and which decision variables are non-basic? Which constraints are binding, which constraints are non-binding? What is the optimal solution and what is the total profit? b) How much would the total profits increase if the profit per unit of type 1 pipe is increased to $42? How much would the total profits increase if the profit per unit of type 2 pipe is increased to $42? c) How much would the total profits increase if the profit per unit of type 1 pipe is decreased to $30? How much would the total profits increase if the profit per unit of type 2 pipe is decreased to $30? d) If the company has three options: first, increasing the extrusion hours availability by 5 hours at the cost of $5 per hour; second, increasing the packaging hours availability by I hour at the cost of $6 per hour; and third, increasing the additive mix by 2 Ibs at the cost of $2 per lb. Which option should the company choose? Explain. e). Based on the option chosen in part d), how much more profits would the company make after deducting the cost?Louis Payton Company produces two basic types of plastic pipe. Three resources are crucial to the production: extrusion hours, packaging hours, and a special additive to the plastic raw material. The following data represent next week's situation. Resource Resource Resource Resource requirements requirements availability per unit of type 1 Extrusion hrs per unit of type 2 6 hrs 48 hrs Packaging 2 hrs 2 hrs 18 hrs Additive mix 2 lbs 1 lb 16 lbs The profit per unit for Type 1 and Type 2 Plastic are $34/unit and $40/unit. The company wants to determine how much of each type of pipe should be produced to maximize the total profits. The linear programming formulation for the above problem is given below