All drop downs included thanks

there are 3 questions and all drop downs are shown it is clear

U A local personal finance company is interested in reducing the purchase cost of notebooks in a year. The company uses 6,000 notebooks in a year. The company considers shopping at Amazon, Costco, and Staples. Amazon sells initial 2000 notebooks at $1.20. After the introductory 2,000 notebooks, Amazon charges $1.60 for each notebook. The annual subscription fee for Amazon is $120. Costco sells notebooks at $1.40 (no introductory rate, and it has an annual subscription fee of $50. Finally, Staples does not have any subscription fee and sells notebooks at $1.50 (no introductory rate.) How should the company purchase notebooks? D E F Amazon - Introductory Amazon - Regular $1.20 $1.60 2,000 Costco $1.35 Staples $1.50 Amazon $120 Costco $50 6,000 Amazon Costco A 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 RHS 19 Total Subscription Fees 20 Total Purchase Cost 21 Total Cost 22 23 Subject to 24 LHS 25 Notebook Requirement 26 Effective Capacity Amazon - Introductory 27 Effective Capacity Amazon - Regular 28 Effective Capacity Costco 29 The maximum amount from Staples You can download the problem statement and the excel spreadsheet by clicking hers Consider the Notebook problem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Amazon Introductory constraint (Row 26) using dropdowns. # Select . Select . Select LHS Select) Select 1 Relation Select) RHS: Select . LHS RHS 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 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 Amazon Introductory" constraint (Row 26) using dropdowns. Select) Select Select [Sele LH Select D7 C7 D13 0 E16 Rel. C16 C13 F16 C4 C9 RH 016 25 26 27 28 29 Notebook Requirement Effective Capacity Amazon - Introductory Effective Capacity Amazon - Regular Effective Capacity Costco The maximum amount from Staples 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 Amazon - Introductory" constraint (Row 26) using dropdowns. LHS Select) 4 [Select) [ Select Select 1 Relation: Select) RHS: Select] Amazon - Introductory pacity Amazon - Regular ffective Capacity Costco um amount from Staples blem statement and the excel spreadsheet by clicking here @. roblem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Amazon (Row 26) using dropdowns. Select [Select ] [Select Select 4 Select C4 C16 07 D7 F16 E16 C13 D13 C9 D16 0 Select Notebook Requirement city Amazon - Introductory Capacity Amazon - Regular Effective Capacity Costco mum amount from Staples problem statement and the excel spreadsheet by clicking here. problem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Amazon nt (Row 26) using dropdowns. Select) Select Select] [ Select Select 1 [Select Total Subscription Fees Total Purchase Cost Total Cost LHS RHS Notebook Requirement opacity Amazon - Introductory tive Capacity Amazon - Regular Effective Capacity Costco maximum amount from Staples the problem statement and the excel spreadsheet by clicking here book problem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Amazon straint Row 26) using dropdowns . Select Select Select : Select C13 E16 0 F16 013 010 C16 Select . Select LHS RHS 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 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 Amazon - Introductory constraint (Row 26) using dropdowns - LHS Select) Select Select Select 1 Select Relation Select RHS: Total Cost 21 22 LHS RHS 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 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 Amazon - Introductory" constraint (Row 26) using dropdowns. LHS Select) Select) Select Select Relation: [ Select] RHS: Select] C4 D7 09 C7 0 Amazon Costco Amazon - Introductory Amazon - Regular Costco Staples 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 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 Amazon - Regular" constraint (Row 27) using dropdowns. Select Select Select 1 LHS Select) Select Relation Select 1 RHS 20 Total Purchase Cost 21 Total Cost 22 23 Subject to 24 LHS 25 Notebook Requirement 26 Effective Capacity Amazon - Introductory 27 Effective Capacity Amazon - Regular 28 Effective Capacity Costco 29 The maximum amount from Staples You can download the problem statement and the excel spreadsheet by clicking here 10 Consider the Notebook problem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Amazon - Regular constraint (Row 27) using dropdowns. 1 Select) LHS Select) 4 Select) Select Select) Relation Select) RHS: Select) Total Cost LHS RHS Notebook Requirement Capacity Amazon - Introductory ctive Capacity Amazon - Regular Effective Capacity Costco maximum amount from Staples the problem statement and the excel spreadsheet by clicking here @. ebook problem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Amazon aint (Row 27) using dropdowns. Select) 4 [Select] [Select) Select Select C7 0 F16 C4 E16 D16 C13 C9 D7 C16 D13 Select 8 pts ct to LHS RHS Notebook Requirement Fective Capacity Amazon - Introductory Effective Capacity Amazon - Regular Effective Capacity Costco The maximum amount from Staples wnload the problem statement and the excel spreadsheet by clicking here. the Notebook problem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Amazon constraint (Row 27) using dropdowns. lect Select 1 Select Select) [Select Select I Select st st LHS RHS ent Ory lar tco bles e excel spreadsheet by clicking here i he excel spreadsheet screenshot above Construct "Effective Capacity Amazon Select) [Select [Select] E16 D13 F16 D16 C16 0 C13 LHS RHS 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 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 Amazon - Regular" constraint (Row 27) using dropdowns. LHS Select) Select] Select Select Relation: [Select) RHS: 29 The maximum amount from Staples 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 Amazon - Regular" constraint (Row 27) using dropdowns. LHS Select [Select) Select Select Relation: [Select) RHS: Select D7 C4 C2 0 Amazon Costco 11 Decision Variables 12 13 Enrolled? 14 Costco Staples 15 Amazon - Introductory Amazon - Regular 16 Amount Purchased 17 18 Objective 19 Total Subscription Fees 20 Total Purchase Cost 21 Total Cost 22 23 Subject to 24 LHS 25 Notebook Requirement 26 Effective Capacity Amazon - Introductory 27 Effective Capacity Amazon - Regular 28 Effective Capacity Costco 29 The maximum amount from Staples You can download the problem statement and the excel spreadsheet by clicking hece RHS Consider the Notebook problem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Costco constraint (Row 28) using dropdowns Select Select) LHS Select Select Select Relation: Select 1/ 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 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. LHI Select) Select Select Rel. (Select C9 C4 D7 F16 C16 o D16 C7 D13 C13 E16 2 RH Total Cost ubject to LHS RHS Notebook Requirement Effective Capacity Amazon - Introductory Effective Capacity Amazon - Regular Effective Capacity Costco The maximum amount from Staples an download the problem statement and the excel spreadsheet by clicking here - der the Notebook problem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Costco" craint (Row 28) using dropdowns. [Select v Select) Select) Select Select 1 tion: Select) S: Select Total Subscription Fees Total Purchase Cost Total Cost to LHS RHS Notebook Requirement tive Capacity Amazon - Introductory Effective Capacity Amazon - Regular Effective Capacity Costco The maximum amount from Staples wnload the problem statement and the excel spreadsheet by clicking here Notebook problem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Costco Row 28) using dropdowns. ct Select 1 Select 1 [Select [ Select v Select D13 F16 C7 C4 C16 E16 0 D16 C13 D7 Select) Amount Purchased tal Subscription Fees Total Purchase Cost Total Cost LHS RHS otebook Requirement mazon - Introductory city Amazon - Regular ective Capacity Costco amount from Staples m statement and the excel spreadsheet by clicking here Hem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Costco" opdowns. Select Select) Select) [Select lect) lect Amount Purchased Total Subscription Fees Total Purchase Cost Total Cost LHS RHS Notebook Requirement y Amazon - Introductory apacity Amazon - Regular Effective Capacity Costco um amount from Staples blem statement and the excel spreadsheet by clicking here oblem statement and the excel spreadsheet screenshot above. Construct "Effective Capacity Costco" dropdowns. Select Select) Select Select) C16 C13 F16 013 0 016 E16 Select Solart! 27 28 29 Effective Capacity Effective Capacity Costco The maximum amount from Staples 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 LHS Select Select) Relation Select) W RHS 28 29 Effective capacity Costco The maximum amount from Staples 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. LHS Select) Select) Select Select Relation Select RHS: [Select 07 D7 CO C4 0