Quantitative Methods Homework: Optimization Modeling Application

I have attached screen shots of 3 questins and the data.

1) Complete: Chapter 8, p. 332 – Complete Problem 8-3.

a) Add this additional constraint: Total Number of Workers to Start the Shifts must be less than or equal to 31.

Chapter 8, p. 332 – Complete Problem 8-4.

Chapter 8, pp. 333 – Complete Problem 8-6.

2) Use Excel’s Solver to complete the problems.

3) Use one Excel spreadsheet file for the calculations and explanations, with one worksheet per problem. Use the problem number for each worksheet name. Cells should contain the formulas (i.e., if a formula was used to calculate the entry in that cell).