please assist using Excel

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 DEPARTMENT PRODUCT WIRING DRILLING ASSEMBLY INSPECTION UNIT PROFIT (S) 9 XJ201 0.5 0.3 0.2 0.5 XM897 1.5 1 4 1 12 TR29 1.5 2 1 0.5 15 BR788 1 3 2 0.5 11 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. Table MA1.2: Production capacity in each department per month, and the minimum monthly production requirement MINIMUM CAPACITY PRODUCTION LEVEL DEPARTMENT (HOURS) PRODUCT 15,000 XJ201 150 Wiring Drilling 17,000 XM897 100 Assembly 26,000 TR29 300 Inspection 12,000 BR788 400 EBORE3A GA 5 Assignment 2022-1 Questions Page 2 of 5 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) (c) State the optimal solution and the value of the objective function. (5) Let: X = number units of XJ201 produced X2 = number units of XM897 produced X3 = number units of TR29 produced X4 = number units of BR788 produced