I need help answering D.) and E.) please and thank you!

7-40 from end of the chapter. a. Formulate a linear programming model for this problem. b. Solve the linear programming model using Excel Solver. What is the maximum profit? c. How many of each product should be produced? d. Which resources should Weinberger Corporation invest to increase profit? Why? e. If it costs $20,000 to increase inspection hours from 12,000 to 14,000 , would it be worth the investment? Why? Use LP Template as demonstrated in videos. I will delete your decision variables in your Excel submission and re-solve your problem. There is no credit for the problem if your Excel submission doesn't solve. 40 The Weinberger Electronics Corporation manufactures four highly technical products that it supplies to aerospace firms that hold NASA contracts. Each of the products must pass through the following departments before being shipped: wiring, drilling, assembly, and inspection. The time requirement in hours for each unit produced and its corresponding profit value are summarized in the following table: The production manager has the responsibility of specifying production levels for each product for the coming month. Help him by formulating (that is, setting up the constraints and objective function) Weinberger's problem using LP. x)=amsint of kiso1 Xm= ambunt of xmat Trummount of Tez': amount of Beres Qbjestive functigr Nolmize Freht 52xj+512Km+5127%+5116r a see b actirefunction ahorve b. Max fvofite5232.700 if