Question: Develop a Model-Oriented Decision Support System for the problem described below. Steps: 1- Open a blank Excel worksheet and save it as a macro-enabled workbook.

Develop a Model-Oriented Decision Support System for the problem described below.
Steps: 

1- Open a blank Excel worksheet and save it as a macro-enabled workbook.

2- Develop a Solver Macro for the backpack problem given below and click the button associate it.

3- For changing product numbers, the button and macro find the best solution of the model. please provide. The button should work correctly when the data is changed and the model is correct should give the solution.

Below is a mathematical model of a single constrained backpack problem. 

Develop a Model-Oriented Decision Support System

Screen output and problem data should be as follows.

Develop a Model-Oriented Decision Support System

wxi K(W) 1=1 ( wi: Weight of i (1 fi is put in the bag Xi = 0 otherwise n The biggest 7 = = Pi: Value of i I=1 O P w N LO 10 000 N 00 UA00w 00 8 KE O 0 0 0 B E G H K M N 1 Decision support system for truck loading 2 3 Item 1 2 3 4 5 6 7 8 9 11 12 13 14 4 Weight 43 40 38 88 46 38 46 97 46 43 40 38 88 46 5 Volume 23 21 8 14 8 8 6 19 24 23 21 8 14 8 6_Value 178 111 105 115 142 158 132 130 129 178 111 105 115 142 7 Decision 1 0 1 0 0 1 0 0 0 1 0 1 0 0 8 9 Left side Right side Utilization 10 WeCap 200

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!