These assignments Must be completed using Excel (please show formulas too – cant just have the values showing)

I should be able to download 2 Separate excel files – as there are 2 separate assignments due  

Linear Programming assignments

(Do these questions #1-3 on one excel workbook) 

1. Page 513 # 26 (A product-Mix model): 

2. Page 554-555 # 6: 24 hours scheduling problem.

3. Page 516 # 37 (Transportation Model)

Model with Binary Variables

(do these questions #1-4 on a SEPARATE excel workbook file) 

1. Project Selection Model (page 533 – 535)

2. Supply Chain Distribution

3. Multiperiod financial management

4. Fixed Charge Model