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 Excels 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).
