17853826 fj de kock tut4 facility location template
Post on 07-Jul-2018
216 Views
Preview:
TRANSCRIPT
-
8/18/2019 17853826 FJ de KOCK Tut4 Facility Location Template
1/5
Question 1
Inputs - Costs, Capacities, Demands
Fixed Low Fixed High
Supply Region Gauteng Free state KZN Western Cape Cost (R) Capacity Cost (R) Capacity
Johannesburg 2,080 2,290 2,370 2,970 5,550,000 2000 9,250,000 4000
Boe!"onte#n 2,290 2,090 2,270 2,770 5,500,000 2000 9,200,000 4000
$urban 2,350 2,270 2,%20 2,&70 5,500,000 2000 9,200,000 4000
Cape 'o(n 2,9&0 2,770 2,&70 2,220 5,500,000 2000 9,200,000 4000
Demand %&00 900 800 %000
Decision Variables
Demand Region - Production Allocation (Units) )o( Cap *ants
Supply Region Gauteng Free state KZN Western Cape +%open- +%open-
Johannesburg %&00 900 800 0 0 %
Boe!"onte#n 0 0 0 0 0 0
$urban 0 0 0 0 0 0
Cape 'o(n 0 0 0 %000 % 0
Constraints
Supply Region Excess Capacity
Johannesburg 700
Boe!"onte#n 0
$urban 0
Cape 'o(n %000
Gauteng Free state KZN Western CapeUnmet Demand 0 0 0 0
Objective Function
Cost = . 24,255,000
Demand RegionProduction and Transportation Cost per Unit
/#gh Cap*ants
-
8/18/2019 17853826 FJ de KOCK Tut4 Facility Location Template
2/5
Question 2a
Input Data
Variable Production and Shipping Cost (R / unit) Annual Fixed Cost (R) Tax Rate
German Great !ritain Spain "tal France
!erlin #$$% #&%% #&$% #$'% #'%% R ##%%%%%%% '%%%% &*
Fran+,urt #$%% #-%% #&%% #'%% .%%% R #'%%%%%%% #%%%% &*
"tal #&%% #&%% #&$% #$%% #$% R #$%%%%%%% #%%%% .$*
Spain .%%% .%%% #$$% #-$% #-%% R #$%%%%%%% #%%%% .*
%%% 0$%%% 0$%%% .-%%% '#%%%
Sale price 1 R 0$%%2%% R 0$%%2%% 333 333 333
Decision Variables and Constraints
4uantit Shipped
German Great !ritain Spain "tal France 5pen (#) / Shut (%) Cost Re6enue
!erlin % 0$%%% % .-%%% % # 800000 . 224,&&0,000 . 324,000,00
Fran+,urt %%% % % % % # 3%00000 . 328,500,000 . 445,500,00
"tal % % % % % % 000 . 0 .
Spain % % 0$%%% % '#%%% # 400000 . 357,450,000 . 5&7,000,00
% % % % % #
'ota Cost . 9%0,&%0,000 . %,33&,500,00
Suppl7ocations
Capa1#t +un#tsper ear-
8emand (units /ear)
CapacitConstraint
8emandconstraint
-
8/18/2019 17853826 FJ de KOCK Tut4 Facility Location Template
3/5
Question 2a
Input Data
Variable Production and Shipping Cost (R / unit) Annual Fixed Cost (R) Tax Rate
German Great !ritain Spain "tal France
!erlin #$$% #&%% #&$% #$'% #'%% R ##%%%%%%% '%%%% &*
Fran+,urt #$%% #-%% #&%% #'%% .%%% R #'%%%%%%% #%%%% &*
"tal #&%% #&%% #&$% #$%% #$% R #$%%%%%%% #%%%% .$*
Spain .%%% .%%% #$$% #-$% #-%% R #$%%%%%%% #%%%% .*
%%% 0$%%% 0$%%% .-%%% '#%%%
Sale price 1 R 0$%%2%% R 0$%%2%% 333 333 333
Decision Variables and Constraints
4uantit Shipped
German Great !ritain Spain "tal France 5pen (#) / Shut (%) Cost Re6enue
!erlin % % % % '%%%% # 000 . 254,000,000 . 3&0,000,000
Fran+,urt '-%%% % % % % # 4300000 . 3%0,500,000 . 39%,500,000
"tal #.%%% 0$%%% 0$%%% .-%%% #%%% # 000 . 357,900,000 . 585,000,000
Spain % % % % % % 000 . 0 . 0
% % % % % #
'ota Cost . 922,400,000
Suppl7ocations
Capa1#t +un#tsper ear-
8emand (units /ear)
CapacitConstraint
8emandconstraint
-
8/18/2019 17853826 FJ de KOCK Tut4 Facility Location Template
4/5
Question 2a
Input Data
Variable Production and Shipping Cost (R / unit) Annual Fixed Cost (R) Tax Rate
German Great !ritain Spain "tal France
!erlin #$$% #&%% #&$% #$'% #'%% R ##%%%%%%% '%%%% &*
Fran+,urt #$%% #-%% #&%% #'%% .%%% R #.%%%%%%% #%%%% &*
"tal #&%% #&%% #&$% #$%% #$% R #$%%%%%%% #%%%% .$*
Spain .%%% .%%% #$$% #-$% #-%% R #$%%%%%%% #%%%% .*
%%% 0$%%% 0$%%% .-%%% '#%%%
Sale price 1 R 0-%%2%% 0#%% #%% %% 4,500
Decision Variables and Constraints
4uantit Shipped
German Great !ritain Spain "tal France 5pen (#) / Shut (%) Cost Re6enue
!erlin % % % % % % 000 . 0 . 0
Fran+,urt %%% % '%%% % .%%% # 000 . 327,300,000 . 593,&00,000
"tal % 0$%%% % .-%%% $'%%% # 000 . 375,&00,000 . 550,800,000
Spain % % % % % % 000 . 0 . 0
% % -%%% % % #
'ota Cost . 702,900,000 . %,%44,400,000
Suppl7ocations
Capa1#t +un#tsper ear-
8emand (units /ear)
CapacitConstraint
8emandconstraint
-
8/18/2019 17853826 FJ de KOCK Tut4 Facility Location Template
5/5
tota
%
2a
2b
3
top related