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

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!