BUS-660 Module 7 Optimization Modeling Applications - Problems 8-3, 8-4, & 8-6.

Quantitative Methods – Optimization Modeling Applications     

Grand Canyon University            

Text book: Quantitative Analysis for Management (12th Edition)

Complete Problem 8-3. Add this additional constraint: Total Number of Workers to Start the Shifts must be less than or equal to 31.        - FAMOUS Y.S CHANG RESTAURANT

Complete Problem 8-4. - BATTERY PARK STABLE

Complete Problem 8-6. - EDDIE KELLY RE-ELECTION ADVERTISEMENT

Use Excel's Solver to complete the problems.    

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