We use resources to make products. Consider 6 such resources and 5 such products. The various resources that we use might include (e.g.) linen, elastic, plastic, foam, etc. The various products that we make might include (e.g.) soap, sanitiser, washable masks, disposable masks, filters, shields, other personal protection equipment (PPE), etc. (Alternatively, the products might possibly be various graphical processing units - or GPUs - and the various resources might possibly be Solder, Copper wire, Plastic, Aluminium, Bearings, Die size.) We show below the profit of each product, the number of each resource required to make each product, and the total availability of each resource. Product Product 2 Product 3 Product 4 Product 5 $510 $300 $510 $270 $810 Profit of Product Resource Availability 2487 Resource 1 2 10 2 3 6 6 3 6 3 10 3030 2 3 10 6 2 5217 Resource 2 Resource 3 Resource 4 Resource 5 Resource 6 7 6 S 4 3 5 6 3 10 2 4000 4999 2769 10 3 3 4 1a) Formulate a Linear Programming (an LP) model for this problem. 1b) Create a Microsoft Excel spreadsheet model for this problem. 1c) Solve the problem - using Microsoft Excel Solver. Generate the Sensitivity report for the problem and Using the Microsoft Excel Solver sensitivity report (as appropriate), 1d) What is the optimal production plan (X1, X2, X3, X4,X5 ) and the associated profit? Refer to your answers to any of a), b) and/or c) above as appropriate. le) Which constraints, if any, are binding? Refer to your answers to any of the above parts as appropriate and explain your reasoning. 1f) The people running the company are now offered the opportunity of an exchange of goods. The offer is for the company to receive 1 of Resource 2, 10 of Resource 4 and 100 of Resource 5 but for the company to have to relinquish (or surrender or give away. or pay for these resources with) 10 of Resource 1, 5 of Resource 3 and 3 of Resource 6. Should the company accept this offer? Clearly explain with clear calculations (to at least 3 decimal places) how much money the company would gain or lose by agreeing to such an exchange, making it clear whether this would result in a gain or a loss