Question 1 A

The SAVE-IT COMPANY operates a reclamation center that collects four types of solid waste materials and treats them so that they can be amalgamated into a salable product. (Treating and amalgamating are separate processes.) Three different grades of this product can be made (see the first column of Table 1), depending upon the mix of the materials used. Although there is some flexibility in the mix for each grade, quality standards may specify the minimum or maximum amount allowed for the proportion of a material in the product grade. (This proportion is the weight of the material expressed as a percentage of the total weight for the product grade.) For each of the two higher grades, a fixed percentage

Table 1

\fTable 2 Pounds per Treatment Cost Material Week Available per Pound (S) Addltlonal Restrictions 3,000 . 1. For each material, at least half of the 2,000 . pounds per week available should be 4,000 collected and treated. 1,000 2. $30,000 per week should be used to treat these materials. AWN Microsoft Excel 15.0 Answer Report Worksheet: [Assignment 1 s1 2022-23 solution.xlsx]Q2 Report Created: 10/14/2022 9:25:10 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.063 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $E$4 profit 0 16200 Variable Cells Cell Name Original Value Final Value Integer $B$3 number of units Rockin chair 0 0 Contin $C$3 number of units Dining table 10 Contin OO $D$3 number of units Armoire 15 Contin Constraints Cell Name Cell Value Formula Status Slack $E$6 Assembly (minutes LHS 3600 $E$6