Info

# sorting of products based on requirement

1 view (last 30 days)
sampath kumar punna on 10 Oct 2019
Closed: MATLAB Answer Bot on 20 Aug 2021
i have two set of objectives
actvites resources duration
mode 1 mode 2 mode 1 mode 2
A 5 4 10 6
B 7 3 7 9
C 3 7 5 11
D 8 8 4 7
E 9 6 9 4
if we choose a set randomly A from mode1, B from mode 2, C & D from mode 1 and E from mode 2.
total resources = 5*10+3*9+3*5+8*4+6*4 = 148,
like wise we have to choose a set R where total resource utilization from two modes in decendeing order
set D ( decereasing order of duaration)
how to write program for this in matlab
##### 2 CommentsShowHide 1 older comment
sampath kumar punna on 10 Oct 2019
i have to form a set of activites A-E, where i can choose any mode for each activty,
for suppose i have choosed a set as
A mode 1
B mode 2
C mode 1
D mode 2
E mode 2
average distribution = 5*10+3*9+3*5+8*7+6*4 = 172/35 = 4.91.
if i want to choose a set where it utilises less resources
A mode 2 4 6
B mode 2 3 9
C mode 1 3 5
D mode 2 or 1 8 4
E mode 2 6 4
average distribution of resources in each day = 4*6+3*9+3*5+8*4+6*4 = 122/28 = 4.35.
if i want to choose a set with least duration
A mode 2 4 6
B mode 1 7 7
C mode 1 3 5
D mode 1 8 4
E mode 2 6 4
average distribution of resources in each day = 4*6+ 7*7+ 3*5+ 8*4+ 6*4 = 144/26 = 5.53.
like the same way i need a set R( where the total resources utilized is arranged in decending order )
like the same way i need a set D( where the total duration utilized is arranged in decending order )

Ganesh Regoti on 5 Nov 2019
Hi,
I presume that you need to pick the activities in descending order of duration and resources (first being the highest)
activity = 'ABCDE'; %The order of activities given
%Matrax of form NX4 where each column represents as follows:
%Resources,Duration,Mode,Activity Index
Activities = [5 10 1 1;
4 6 2 1;
7 7 1 2
3 9 2 2
3 5 1 3
7 11 2 3
8 4 1 4
8 7 2 4
9 9 1 5
6 4 2 5];
%Sorting based on Duration
[~,inx]=sort(Activities(:,2)); % Change the column number to 1 to get the values in sorted order of resources
out = Activities(inx,:);
num = 0;
den = 0;
str = '';
modes = [];
for i = 10:-1:1 %As we need descending, we need to start from end
if ~contains(str,activity(Activities(i,4)))
num = num + Activities(i,1)*Activities(i,2); % Sum of distribution
den = den + Activities(i,2);% Sum of duration
str = [str activity(Activities(i,4))]; % Final order of activities
modes = [modes, Activities(i,4)]; % Final order modes to respective activities
end
end
average = num/den; % This is average on descending order of duration