Please solve for (a), (b) and (c) 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 UNIT PRODUCT WIRING DRILLING ASSEMBLY INSPECTION PROFIT ($) XJ201 0.5 0.3 0.2 0.5 9 XM897 1.5 1 4 1 12 TR29 1.5 2 0.5 15 BR788 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 CAPACITY MINIMUM PRODUCTION LEVEL DEPARTMENT (HOURS) PRODUCT Wiring 15,000 XJ201 150 Drilling 17,000 XM897 100 Assembly 26,000 TR29 300 Inspection 12,000 BR788 400 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 X = number units of XM897 produced X3 = number units of TR29 produced X = number units of BR788 produced