Formulation the problem as an integer Linear Programming

5. Homework 6 A firm has developed the following supply, demand, cost and inventory data. Assume that the holding cost (carrying cost) is applied to the end of each period and suppose that backorders are not permitted. What is the optimal allocation of the production capacity to meet demand at a minimum cost? Open the Excel file Homework 6.xlsx. Three methods will be applied to solve this problem. Method 1: Formulating the problem as a Transportation Model, then applying Excel Solver, as presented in Worksheet 1 . Method 2: Applied directly Excel Solver to the data (without using Transportation format), as presented in Worksheet 2. Method 3: Formulation the problem as an integer Linear Programming, then applying Lingo Software to get the solution (See Lab Operations Research 1 and watch the Video Tutorial 7 Help for LP formulation in Aggregate Planning) 5. Homework 6 A firm has developed the following supply, demand, cost and inventory data. Assume that the holding cost (carrying cost) is applied to the end of each period and suppose that backorders are not permitted. What is the optimal allocation of the production capacity to meet demand at a minimum cost? Open the Excel file Homework 6.xlsx. Three methods will be applied to solve this problem. Method 1: Formulating the problem as a Transportation Model, then applying Excel Solver, as presented in Worksheet 1 . Method 2: Applied directly Excel Solver to the data (without using Transportation format), as presented in Worksheet 2. Method 3: Formulation the problem as an integer Linear Programming, then applying Lingo Software to get the solution (See Lab Operations Research 1 and watch the Video Tutorial 7 Help for LP formulation in Aggregate Planning)