Oak Products Project - Worksheets   

  Back (page 7) Oak Products (first page) Excel Review Home

 

Views of the Oak Products project worksheets, in stages

Stage 1: Shows the data copied from the Word document into an Excel spreadsheet. Because Unit Profit values are key in this model, I've moved them from the bottom of the Word table to a row directly beneath chair type in this spreadsheet. I've added documentation and slightly changed a couple of labels to make them more clear.

Return to Top

 

Stage 2: Shows decision variables added. The decision variables have the label "Qty Produced" and are inserted between "Product" and "Profit/Unit".

Return to Top

 

Stage 3: Shows objectives and constrained quantities added to the worksheet.

Return to Top

 

Stage 4: Our worksheet with formulas displayed so most of the SUMPRODUCT calculations are visible. (The SUMPRODUCT formula in Cell J6 contains =SUMPRODUCT(C4:H4,C6:H6)).

Return to Top

 

Stage 5: The final version of the worksheet, with the "Qty Produced" and "Total Profit" values Solver suggests.

Return to Top  Oak Products (first page)  Excel Review Home