Part A: The "SuperPaper Company" has two separate problems. First, they need to transport enough wood from forests to produce paper in their paper mills. They use 5 different forests (F1, F2, ..., F5) to feed their 3 paper mills (P1, P2 and P3). Each of the first two paper mills (P1 and P2) needs to receive 1200 tonnes of wood every week to produce 300 tonnes of paper each (Please note that, every ton of wood received by any paper mill is converted into 0.25 tons of paper). The third paper mill produces the remaining required paper by receiving enough wood. Then the paper produced is sent to 5 five distribution centres (D1, D2, ..., D5). The paper is distributed to seven markets (M1, M2, ..., M7) through the distribution centres. The capacities of each distribution centre and forest, the demand of each market, and the unit transportation cost per ton of paper are given below. Market M1 M2 M3 M4 M5 M6 M7 Demand 40 60 110 120 140 130 150 Distribution Centres D1 D2 D3 D4 D5 Forests F 1 F2 F3 F4 F5 Handling Capacity 200 250 220 210 300 Wood Quantity 600 700 1000 800 900 Table 1: Capacities and demand (tons of paper/week and tons of wood/week) P1 P2 P3 D1 D2 D3 D4 D5 M1 M2 M3 M4 M5 M6 M7 -1 54 78 70 P1 52 79 68 70 87 D1 93 78 59 57 72 67 65 F2 57 53 90 P2 71 76 68 65 80 D2 95 70 58 53 70 79 70 F3 92 90 65 P3 53 88 55 52 79 D3 79 71 55 59 86 81 54 F4 40 50 60 D4 91 79 82 7 80 64 61 F5 38 60 D5 87 97 94 76 51 70 62 Table 2: Transportation cost of wood and paper (f/ton) The company wants to meet the demand at a minimum cost. Write the two mathematical models: 1. For the transport planning between the forests and paper mills 2. For the transport planning between paper mills and markets through distribution centres. Solve both of the problems using a software (Excel Solver, Classic Lindo or Lingo). Calculate the cost associated with your solution and present your solution in tabular form