D E Amazon - Introductory Amazon - Regular $1.20 $1.60 2,000 Costco $1.35 Staples $1.50 3 Amazon $120 Costco $50 6,000 Amazon Costco B 1 Input Parameters 2 3 Cost 4 Limit 5 6 7 Subscription Fee 8 9 Notebook Needed 10 11 Decision Variables 12 13 Enrolled? 14 15 16 Amount Purchased 17 18 Objective 19 Total Subscription Fees 20 Total Purchase Cost 21 Total Cost 22 23 Subject to 24 25 Notebook Requirement 26 Effective Capacity Amazon - Introductory 27 Effective Capacity Amazon - Regular 28 Effective Capacity Costco 29 The maximum amount from Staples Amazon - Introductory Amazon - Regular Costco Staples LHS RHS You can download the problem statement and the excel spreadsheet by clicking here Consider the Notebook problem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Costco constraint (Row 28) using dropdowns. Select Select) Select . Select 1 LHS Select Relation Select RHS: Select) D E Amazon - Introductory Amazon - Regular $1.20 $1.60 2,000 Costco $1.35 Staples $1.50 3 Amazon $120 Costco $50 6,000 Amazon Costco B 1 Input Parameters 2 3 Cost 4 Limit 5 6 7 Subscription Fee 8 9 Notebook Needed 10 11 Decision Variables 12 13 Enrolled? 14 15 16 Amount Purchased 17 18 Objective 19 Total Subscription Fees 20 Total Purchase Cost 21 Total Cost 22 23 Subject to 24 25 Notebook Requirement 26 Effective Capacity Amazon - Introductory 27 Effective Capacity Amazon - Regular 28 Effective Capacity Costco 29 The maximum amount from Staples Amazon - Introductory Amazon - Regular Costco Staples LHS RHS You can download the problem statement and the excel spreadsheet by clicking here Consider the Notebook problem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Costco constraint (Row 28) using dropdowns. Select Select) Select . Select 1 LHS Select Relation Select RHS: Select)