[et_pb_section fb_built="1" specialty="on" _builder_version="4.9.3" _module_preset="default" custom_padding="0px|0px|0px|||"][et_pb_column type="3_4" specialty_columns="3" _builder_version="3.25" custom_padding="|||" custom_padding__hover="|||"][et_pb_row_inner _builder_version="4.9.3" _module_preset="default" custom_margin="|||-44px|false|false" custom_margin_tablet="|||0px|false|false" custom_margin_phone="" custom_margin_last_edited="on|tablet" custom_padding="28px|||||"][et_pb_column_inner saved_specialty_column_type="3_4" _builder_version="4.9.3" _module_preset="default"][et_pb_text _builder_version="4.9.3" _module_preset="default" hover_enabled="0" sticky_enabled="0"]
-
- QUESTION
The task is to develop a logistics model with three warehouses and six destinations. It's important that you know how to use the Excel equation =sumproduct(_:_,_:_) for this exercise. If you are not sure how it works search 'sumproduct excel' on your browser.
You can log in to this website https://bookshelf.vitalsource.com The account number is [email protected] The password is Abcde123.The chapter 7 inside is about this assignment
[/et_pb_text][et_pb_text _builder_version="4.9.3" _module_preset="default" width_tablet="" width_phone="100%" width_last_edited="on|phone" max_width="100%"]
| Subject |
Computer Technology |
Pages |
2 |
Style |
APA |
[/et_pb_text][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner module_class="the_answer" _builder_version="4.9.3" _module_preset="default" custom_margin="|||-44px|false|false" custom_margin_tablet="|||0px|false|false" custom_margin_phone="" custom_margin_last_edited="on|tablet"][et_pb_column_inner saved_specialty_column_type="3_4" _builder_version="4.9.3" _module_preset="default"][et_pb_text _builder_version="4.9.3" _module_preset="default" width="100%" custom_margin="||||false|false" custom_margin_tablet="|0px|||false|false" custom_margin_phone="" custom_margin_last_edited="on|desktop"]
Answer
|
COST
|
ROUTE
|
UNITS
|
C1
|
C2
|
C3
|
C4
|
C5
|
C6
|
C7
|
C8
|
C9
|
|
|
|
|
1.60
|
A1
|
0
|
1
|
|
|
|
|
|
1
|
|
|
|
|
|
|
1.80
|
A2
|
0
|
|
1
|
|
|
|
|
1
|
|
|
|
|
|
|
1.10
|
A3
|
200
|
|
|
1
|
|
|
|
1
|
|
|
|
|
|
|
1.50
|
A4
|
150
|
|
|
|
1
|
|
|
1
|
|
|
|
|
|
|
1.70
|
A5
|
450
|
|
|
|
|
1
|
|
1
|
|
|
|
|
|
|
1.00
|
A6
|
100
|
|
|
|
|
|
1
|
1
|
|
|
|
|
|
|
1.40
|
B1
|
0
|
1
|
|
|
|
|
|
|
1
|
|
|
|
|
|
1.20
|
B2
|
300
|
|
1
|
|
|
|
|
|
1
|
|
|
|
|
|
1.30
|
B3
|
0
|
|
|
1
|
|
|
|
|
1
|
|
|
|
|
|
1.10
|
B4
|
200
|
|
|
|
1
|
|
|
|
1
|
|
|
|
|
|
1.90
|
B5
|
0
|
|
|
|
|
1
|
|
|
1
|
|
|
|
|
|
0.80
|
B6
|
0
|
|
|
|
|
|
1
|
|
1
|
|
|
|
|
|
1.30
|
C1
|
300
|
1
|
|
|
|
|
|
|
|
1
|
|
|
|
|
1.50
|
C2
|
100
|
|
1
|
|
|
|
|
|
|
1
|
|
|
|
|
1.70
|
C3
|
0
|
|
|
1
|
|
|
|
|
|
1
|
|
|
|
|
1.80
|
C4
|
0
|
|
|
|
1
|
|
|
|
|
1
|
|
|
|
|
1.90
|
C5
|
0
|
|
|
|
|
1
|
|
|
|
1
|
|
|
|
|
2.00
|
C6
|
0
|
|
|
|
|
|
1
|
|
|
1
|
|
|
|
|
|
2430
|
300
|
400
|
200
|
350
|
450
|
100
|
900
|
500
|
400
|
|
|
|
|
|
|
300
|
400
|
200
|
350
|
450
|
100
|
900
|
500
|
400
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The optimal solution states that 200 units are to be transported from warehouse A to livestock operation 3, 250 units from A to 4, 150 units from A to Operation 4, 450 units from A to 5, 100 units from A to 6, 300 units from B top Opertion 2, 200 units from B to operation 4, 300 units from C to Operation 1, 100 units from C to Operation 2. The total logistical cost of the shipment of feed supplements from warehouses to livestock operation points is 2430.
|
|
|
|
|
|
|
|
|
|
|
|
|
[/et_pb_text][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner _builder_version="4.9.3" _module_preset="default" custom_margin="|||-44px|false|false" custom_margin_tablet="|||0px|false|false" custom_margin_phone="" custom_margin_last_edited="on|desktop" custom_padding="60px||6px|||"][et_pb_column_inner saved_specialty_column_type="3_4" _builder_version="4.9.3" _module_preset="default"][et_pb_text _builder_version="4.9.3" _module_preset="default" min_height="34px" custom_margin="||4px|1px||"]
Related Samples
[/et_pb_text][et_pb_divider color="#E02B20" divider_weight="2px" _builder_version="4.9.3" _module_preset="default" width="10%" module_alignment="center" custom_margin="|||349px||"][/et_pb_divider][/et_pb_column_inner][/et_pb_row_inner][et_pb_row_inner use_custom_gutter="on" _builder_version="4.9.3" _module_preset="default" custom_margin="|||-44px||" custom_margin_tablet="|||0px|false|false" custom_margin_phone="" custom_margin_last_edited="on|tablet" custom_padding="13px||16px|0px|false|false"][et_pb_column_inner saved_specialty_column_type="3_4" _builder_version="4.9.3" _module_preset="default"][et_pb_blog fullwidth="off" post_type="project" posts_number="5" excerpt_length="26" show_more="on" show_pagination="off" _builder_version="4.9.3" _module_preset="default" header_font="|600|||||||" read_more_font="|600|||||||" read_more_text_color="#e02b20" width="100%" custom_padding="|||0px|false|false" border_radii="on|5px|5px|5px|5px" border_width_all="2px" box_shadow_style="preset1"][/et_pb_blog][/et_pb_column_inner][/et_pb_row_inner][/et_pb_column][et_pb_column type="1_4" _builder_version="3.25" custom_padding="|||" custom_padding__hover="|||"][et_pb_sidebar orientation="right" area="sidebar-1" _builder_version="4.9.3" _module_preset="default" custom_margin="|-3px||||"][/et_pb_sidebar][/et_pb_column][/et_pb_section]