PLEASE SHOW ANSWER IN EXCEL SPREADSHEET WITH FORMULAS

The Dorwyn Company has two new products (special kinds of doors and windows) that will compete with the two new products for the Wyndor Glass Co. Using units of hundreds of dollars for the objective function, the linear programming model in algebraic form, formulate to determine the most profitable product mix. Max Profit = 4D + 6W subject to: D + 3W =0 W>=0 Next, because of the strong competition from Wyndor, Dorwyn management now realizes that the company will need to make a strong marketing effort to generate substantial sales of these products. In particular, it is estimated that achieving a production and sales rate of D doors per week will require weekly marketing cost of D3 hundred dollars (so $100 for D = 1, $800 for D = 2, $2,700 for D = 3, etc.). The corresponding marketing costs for windows are estimated to be 2W2 hundred dollars. Thus, the objective function in the model should be: Profit = 4D + 6W - D3 - 2W2 Dorwyn management now would like to use the revised model to determine the most profitable product mix. Adjust the linear problem that you created to make it a nonlinear programming model spreadsheet. Submit your Excel file