Math 407

USING EXCEL

A tutorial for installing the Solver add-in in Excel can be found here.

• The Furniture Problem Model (new) (Solved)
• The Alloy Blending Model 4 (Solved)
• The Summer Job Model 8 (Practise)
• The Pig Farming Model 2 (Practise)
• The Cargo Packing Model 11 (Excel file only)

  In the Cargo Packing Model 11 the workload balance constraint has not yet been added. The task is to use Excel tricks to efficiently add it to the model.

It is possible to check your answers using MatLab or R.