- Review the attached document.
- Recreate the spreadsheet shown in the attached document.
- Change the X2 lower constraint value (cell F12) from 200 units to 100 units.
- Use the Excel add-in Solver to determine the optimal production of products to maximize total profit.
- Return the spreadsheet showing the optimal solution.
You will find the answer to this puzzling question inside.