Tasks 1. (15 points) Calculate the cost matrix for the distribution, modifying capacity and demand unis if necessary, and provide the final transportation tableau. 2. (15 points) Develop the LP model of the problem. Identify decision variables, objective function, and constraints. 3. (10 points) Obtain basic feasible solutions for the transportation model by using North-West corner method. Show the final table, no need to provide the steps. 4. (15 points) Solve the model using EXCEL Solver. Show all the steps. 5. (15 points) Solve the model with LINGO by using LINGO SETS, DATA, and looping functions. 6. (10 points) Based on your optimum solution, what is the number of tires transported between the distribution centers to dealers? Provide your answer as a table. 7. (15 points) Can you model unbalanced transportation problem without adding a dummy sources or destinations? Explain your answer. Report format: Use APA stile and include the following sections o Introduction o Tasks (1-7) O Conclusion References (if needed) Grading Scheme 1. Tasks (1-7) 2. Report format and use of language 95% 5% Tasks 1. (15 points) Calculate the cost matrix for the distribution, modifying capacity and demand unis if necessary, and provide the final transportation tableau. 2. (15 points) Develop the LP model of the problem. Identify decision variables, objective function, and constraints. 3. (10 points) Obtain basic feasible solutions for the transportation model by using North-West corner method. Show the final table, no need to provide the steps. 4. (15 points) Solve the model using EXCEL Solver. Show all the steps. 5. (15 points) Solve the model with LINGO by using LINGO SETS, DATA, and looping functions. 6. (10 points) Based on your optimum solution, what is the number of tires transported between the distribution centers to dealers? Provide your answer as a table. 7. (15 points) Can you model unbalanced transportation problem without adding a dummy sources or destinations? Explain your answer. Report format: Use APA stile and include the following sections o Introduction o Tasks (1-7) O Conclusion References (if needed) Grading Scheme 1. Tasks (1-7) 2. Report format and use of language 95% 5%