they would like us to solve on solver so please solve through excel and submit

Assessment 2b-Using Solver for Linear Programming For these cases be sure to provide your solver solutions showing the parametrs of solver. Case 1. In a product-mix-problem, X1,X2,X3, and X4 indicate the units of products 1,2,3, and 4 , respectively. The linear programming model is: MAXZ=551+572+583456X4 Subject to- 1) 31+22+43+34600 Machine A hours 2) 41+12+23+645700 Machine B hours 3) 2X1+3X2+1X3+2X4800 Machine C hours Input the data into an Excel file and using Solver, solve the