help please show all works and stpes how do you do it

Question V: 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 per unit of type 2 Extrusion 4 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, 6 hrs 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 $307 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 1 hour at the cost of $6 per hour, and third, increasing the additive mix by 2 lbs at the cost of $2 per lb. Which option should the company choose? Explain. c). Based on the option chosen in part d), how much more profits would the company make after deducting the cost? Original Value Final Value 342 Answer report: Target Cell (Max) Cell Name $D$3 Total profits Adjustable Cells Cell Name $B$3 Amount to be produced Type1 $C$3 Amount to be produced Type 2 Constraints Cell Name $D$5 Extrusion hrs $D$6 Packaging hrs $D$7 Additive mix Original Value Final Value 0 3 0 Cell Value Formula Status Slack 48 SD$5