Solving Flair Furniture's LP problem using Excel's Solver command:

Read the Flair Furniture Company Case, which starts in Chapter $7,$ TABLE $2,$ titled "Flair Furniture Company Data," through the section noted as "Here is a complete mathematical statement of the LP problem"

Skip the section on the "Graphical Solution to an LP Problem."

Pick up reading again starting at section $7\mathrm{.}5$ titled "Using Excel's Solver Command to Solve LP Problems"

Develop a Linear Programming Model for the Flair Furniture Company's Problem: Within a new tab in your Excel Workbook prepare a spreadsheet for Excel Solver. $($IGNORE Use of Excel QM as referenced in the text. This will not apply since you have already installed Solver in Excel$)$

Follow the text reading and program items from below to complete your work.

Program $2$A: Input the Excel Data for the Flair Furniture Example.

Program $2$B: Enter the Formulas for the Flair Furniture Example.

Program $2$C: Create the Excel Spreadsheet for the Flair Furniture Example.

Program $2$D: Begin Solver in Excel $2016.$

Program $2$E: Configure the Solver Parameters in the Solver Parameters Dialog Box.

Program $2$F: Confirm the Solver Parameters in the Solver Parameters Dialog Box.