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