570 quantitative business analysis, homework 5 wk 6

all in excel please.

Please submit your Homework Assignment as one Word file for your written answers and one Excel workbook containing self-explanatory worksheets to organize your quantitative work. Failing to comply with this policy or submitting unorganized documents will result in a score of zero.

Answer the following:

Chapter 8: 8-2 (solve using Excel’s Solver functionality), 8-6 (solve using Excel’s Solver functionality)

Chapter 9: 9-7 (solve using Excel’s Solver functionality)