Assignment details You are required to solve the optimisation problems below. You should produce a typed report of maximum length 4 pages. All questions must be answered in Excel, with the relevant spreadsheet(s) appended to your report as an appendix. Your report does not have to include an abstract, introduction, conclusions section etc. You are required to answer the questions. In answering each question, you should, 1. Formulate the optimisation problem; in other words, define the objective function and any associated constraints drawing on any relevant background theory, 2. Discuss the Excel implementation, 3. Show, discuss and analyse your results using any appropriate figures./nQuestion 2 Consider the following cascade of heat exchangers, 100ºF T. T2 500ºF * Hex 1 300ºF Hex 2 Hex 3 400ºF 600ºF + Ts T Find the minimum total surface area of the three heat exchangers. Data: mcp = 1000 (Btu . h-1 . F-1) (all streams) Exchanger U (Btu . h-1 . ft-2 . F-1) Area (ft2) Duty (Btu . h-1) 1 120 A1 Q1 2 80 A2 02 3 40 A3 Q3 Marking criteria - Formulate the optimisation problem (equations and words, justifying use of equations) - Show spreadsheet implementation - professionally constructed, logical input output structure, results clearly demonstrated. - Discussion and quantification of any uncertainty associated with the result. [25 marks]

Fig: 1

Fig: 2