solution is required ising leaner programming simplex method by Excel Solver
As a company manager you need to know the following year plan of concrete manufacturing. The company concrete manufacturing plants could choose from 3 sources of sand, 4 sources of cement and 3 sources of gravel to produce three types of concrete A, B, and C knowing that each source of the given components has a different transportation and price cost will be given in the following table. Also, each type of concrete will consume different amounts of sand, cement and gravel as will be given in the following tables. It is required to supply 4 construction sites of the company and also to sell the rest of production to other 5 sites knowing that each site transportation cost or price will be given in the following tables. Find the optimum quantities that should be produce from each type, also find the transported amounts to even own sites or other sites that gives the company the optimum revenue. Sand Cement Gravel LE/m LE/tonLE/m 50800 90 Suppliers Sand m' for each concrete m! Suppliers Gravel m' for each concrete m' Source Source Source 0.9 08 0.7 supplier 0.4 0.5 0.35 100 supplier 0.3 0.4 0.45 120 supplier 0.5 0.3 0.4 100 Source OS 0.7 0.9 150 0.9 09 0.8 0.7 0.8 160 Available Available Transportation cost for company's own sites /m! Needs Suppliers Cement kg for each concrete mi 1 2 3 Source Source Source Source 150 140 180 170 170 155 160 150 160 150 140 180 Available 100000 150000 170000 160000 sitel Site 2 85 150 120 70 75 80 95 7085 90 Sites Sited 140 0 C Available 0.35 100 0.45 120 0.4 100 0.9 150 0. 80 . 8 160 140 .7 170 Available Needs (m') Transportation cost for company's own sites/m ABC Sitel 70 75 85 Site2 80 95 75 Site3 7 0 85 90 Site4 90 C 150 120 130 140 80 Suppliers Cement kg for each concrete m 1 200 3rd 4th Source Source Source Source 150 140 180 170 170 155 160 150 1 60 150 140 180 Available 100000 150000 170000 160000 Other sites Buying price /m B Sitel 1200 1300 1800 Site2 1800 1000 1700 Site3 1900 1400 1600 Site4 1500 1500 1700 Sites 1600 1350 1800 Other sites Transportation cost/m Needs m 120 130 180 1.70 Sitel Site2 Site3 Site4 Site5 200 140 130 160 150 170 120 160 135 180 170 As a company manager you need to know the following year plan of concrete manufacturing. The company concrete manufacturing plants could choose from 3 sources of sand, 4 sources of cement and 3 sources of gravel to produce three types of concrete A, B, and C knowing that each source of the given components has a different transportation and price cost will be given in the following table. Also, each type of concrete will consume different amounts of sand, cement and gravel as will be given in the following tables. It is required to supply 4 construction sites of the company and also to sell the rest of production to other 5 sites knowing that each site transportation cost or price will be given in the following tables. Find the optimum quantities that should be produce from each type, also find the transported amounts to even own sites or other sites that gives the company the optimum revenue. Sand Cement Gravel LE/m LE/tonLE/m 50800 90 Suppliers Sand m' for each concrete m! Suppliers Gravel m' for each concrete m' Source Source Source 0.9 08 0.7 supplier 0.4 0.5 0.35 100 supplier 0.3 0.4 0.45 120 supplier 0.5 0.3 0.4 100 Source OS 0.7 0.9 150 0.9 09 0.8 0.7 0.8 160 Available Available Transportation cost for company's own sites /m! Needs Suppliers Cement kg for each concrete mi 1 2 3 Source Source Source Source 150 140 180 170 170 155 160 150 160 150 140 180 Available 100000 150000 170000 160000 sitel Site 2 85 150 120 70 75 80 95 7085 90 Sites Sited 140 0 C Available 0.35 100 0.45 120 0.4 100 0.9 150 0. 80 . 8 160 140 .7 170 Available Needs (m') Transportation cost for company's own sites/m ABC Sitel 70 75 85 Site2 80 95 75 Site3 7 0 85 90 Site4 90 C 150 120 130 140 80 Suppliers Cement kg for each concrete m 1 200 3rd 4th Source Source Source Source 150 140 180 170 170 155 160 150 1 60 150 140 180 Available 100000 150000 170000 160000 Other sites Buying price /m B Sitel 1200 1300 1800 Site2 1800 1000 1700 Site3 1900 1400 1600 Site4 1500 1500 1700 Sites 1600 1350 1800 Other sites Transportation cost/m Needs m 120 130 180 1.70 Sitel Site2 Site3 Site4 Site5 200 140 130 160 150 170 120 160 135 180 170
