Question: show how to do in solver which to select fro sum product and the constraints. show the selectedvariables for sum product. (0) Sika case: Develop
show how to do in solver which to select fro sum product and the constraints. show the selectedvariables for sum product. (0) Sika case: Develop an optimization template that resolves the supply chain for the current 30-day lead time. show each step and how to do it in excel solver Landed Cost (= Production + Transport + Import Tax) per Ton Production/Market Country 1 Country 2 Country 3 Country 4 Country 5 Country 6 Country 7 Country 8 Country 1 $4,840 $4,900 $5,484 $5,501 $5,182 $5,050 $5,152 $5,172 Country 2 $5,250 $5,180 $5,838 $5,872 $5,415 $5,350 $5,509 $5,519 Country 3 $5,030 $5,508 $4,880 $5,626 $5,236 $5,080 $5,030 $5,314 Country 4 $5,020 $5,504 $5,594 $4,940 $5,198 $5,140 $5,020 $5,297 Country 5 $5,191 $5,708 $5,788 $5,830 $5,071 $5,311 $5,211 $5,425 Country 6 $5,423 $5,655 $5,775 $5,776 $5,463 $5,050 $5,170 $5,493 Lead Time Matrix (Order Processing & Transportation) Days Production/Market Country 1 Country 2 Country 3 Country 4 Country 5 Country 6 Country 7 Country 8 Country 1 7 18 24 14 31 31 14 39 Country 2 12 7 15 12 25 20 12 25 Country 3 16 15 7 16 27 25 16 29 Country 4 18 20 27 7 31 21 21 33 Country 5 31 38 38 38 7 38 38 24 Country 6 36 40 33 32 44 7 40 49. show the information in excel and show the values selected that are calcullated by sum porduct to get the min cost. show step by step
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
