Reconsider the example illustrating the use of robust optimization that was presented in the lecture note. Wyndor management now feels that there is uncertainty in all of the parameters of the problem the unit profit per door and window (P_D and P_W), the hours of production time used for each door or window produced across the three plants (H_D1,H_W2,H_D3, and H_W3) and the three right-hand-sides representing the hours available at each plant (RHS_1,RHS_2, and RHS_3). The original estimates along with the ranges of uncertainty are shown in the table below. Apply the procedure for robust optimization with independent parameters to find the solution that maximizes profit when the solution also is guaranteed to be feasible. Please include the screenshot of your final spreadsheet model here.

Answer:

Reconsider the example illustrating the use of robust optimization that was presented in the lecture note. Wyndor management now feels that there is uncertainty in all of the parameters of the problem - the unit profit per door and window (PD and PW), the hours of production time used for each door or window produced across the three plants (HD1,HW2,HD3, and HW3) and the three right-hand-sides representing the hours available at each plant (RHS1,RHS2, and RHS3). The original estimates along with the ranges of uncertainty are shown in the table below. Apply the procedure for robust optimization with independent parameters to find the solution that maximizes profit when the solution also is guaranteed to be feasible. - Please include the screenshot of your final spreadsheet model here