please help with questions 2

Manufacturing Applications 1 Excel Solver Project The Eastern Digital Electronics Corporation manufactures four highly technical products that it supplies to aerospace firms with SpaceX contracts. Each of the products must be routed through the following departments before they are shipped: wiring, drilling. assembly, and inspection. The time requirement in hours for each unit produced and its corresponding profit value are summarised in Table MA1.1 below. Table MA1.1: Time requirement in hours for each unit produced and its corresponding profit PRODUCT WIRING DRILLING ASSEMBLY INSPECTION XI20 0.5 0.3 0.2 0.5 M 15 1 1.5 2 3 XM897 TR29 DEPARTMENT BR788 4 1 1 0.5 0.5 Wiring Drilling Assembly Inspection UNIT PROFIT (S) The production capacity available in each department per month, and the minimum monthly production requirement to fulfill contracts, are as shown in Table MA1.2 below. CAPACITY DEPARTMENT (HOURS) 15,000 17,000 26,000 12,000 12 15 11 Table MA1.2: Production capacity in each department per month, and the minimum monthly production requirement PRODUCT X201 XM897 TR29 BR788 MINIMUM PRODUCTION LEVEL 150 100 300 The production manager has the responsibility of specifying production levels for each product for the coming month. (a) You are the production manager and must formulate (that is, setting up the constraints and objective function) Eastern Digital's problem using LP. (23) (b) Use your formulation in part (a) to form a Microsoft Excel Solver spreadsheet to solve the LP problem. (68) (5) (c) State the optimal solution and the value of the objective function