Details D Introduction Determine optimal production using LP: The first problem requires solving the problem below using Excel and Solver. Start with a blank Excel spreadsheet and put X1 and X2 in the top row. Below them put zero (0) values which will be changed by solver into the optimum values. Below these put the profit coefficients $5 and $6). Skip two rows and enter the constraint coefficients in the X1 and X2 columns. Directions Complete the Excel sheet using the lecture and PowerPoint procedures as a guide. . Unit 1 Lecture.pptx Unit 1 - PowerPoint Gen Intro + Hot tubs + MakevBuy pptx& MAX Profit $5X, 156X2 Subject to: Labor 6X, + 5X2 5 60 Glass 2X, 1 3X, : 24 Wood 3X, + 6X, : 48 X1 , X2 2 0 The partially filled in Excel sheet gives you a start on this problem. Next >