please include excel

FIGURE 5.18 Solver options and settings for the recycling problem Solver Settings: Objective: H21 (Mini Variable cells: A6 A19 Constraints 16.114 >=M6:M14 A5:19 >=0 Solver Options: Standard LP/Quadratic Engine (Simplex LP 5.5.3 ANALYZING THE SOLUTION The Solver parameters used to solve this problem are shown in Figure 5.18 and the optimal solution is shown in Figure 5.19. In this solution, 43.4 tons of newspaper, 50 tons of mixed paper, and 30 tons of white office paper are assigned to recycling process 1 (i.e., Xis = 43.4, X25 = 50, X35 = 30). This recycling process then yields a total of 107.6 tons of pulp (i.e., 0.9 x 43.4 + 0.8 x 50 +0.95 x 30 = 107.6) of which 63.2 tons are allocated to the FIGURE 5.18 Solver options and settings for the recycling problem Solver Settings: Objective: H21 (Mini Variable cells: A6 A19 Constraints 16.114 >=M6:M14 A5:19 >=0 Solver Options: Standard LP/Quadratic Engine (Simplex LP 5.5.3 ANALYZING THE SOLUTION The Solver parameters used to solve this problem are shown in Figure 5.18 and the optimal solution is shown in Figure 5.19. In this solution, 43.4 tons of newspaper, 50 tons of mixed paper, and 30 tons of white office paper are assigned to recycling process 1 (i.e., Xis = 43.4, X25 = 50, X35 = 30). This recycling process then yields a total of 107.6 tons of pulp (i.e., 0.9 x 43.4 + 0.8 x 50 +0.95 x 30 = 107.6) of which 63.2 tons are allocated to the