Assignment for Linear Programming
\nOrder Description
\nAssignment about Linear Programming, and need to use Excel Sover in Microsoft Excel.
\nCalculating allocation costs with UNKNOWN allocation<\/p>\n
Connection Cost matrix
\nDepot 1 Depot 2 Depot 3 Depot 4 Depot 5 Allocation Cost Allocation of stores to depots
\nStore 1 2,563.81 2,141.20 5,421.17 2,092.17 4,990.89 2,092.17 4
\nStore 2 5,480.25 4,649.93 8,410.58 4,928.55 8,042.24 4,649.93 2
\nStore 3 10,881.55 22,563.23 16,413.29 17,629.59 14,408.26 10,881.55 1
\nStore 4 12,729.57 8,525.28 28,673.08 11,309.96 26,327.61 8,525.28 2
\nStore 5 249.59 630.79 599.35 476.78 517.82 249.59 1
\nStore 6 1,560.68 3,967.30 5,791.40 3,015.08 5,056.33 1,560.68 1
\nStore 7 8,039.42 10,100.48 15,085.34 7,876.65 13,752.20 7,876.65 4
\nStore 8 8,581.71 11,343.20 4,548.07 9,898.75 4,947.47 4,548.07 3
\nStore 9 5,626.82 9,498.46 4,180.36 7,746.54 3,857.04 3,857.04 5
\nStore 10 9,696.95 10,817.35 11,513.28 9,832.64 11,185.24 9,696.95 1
\nTotal connection cost 53,937.91<\/p>\n
Assignment of jobs to machines<\/p>\n
Times to perform jobs on various machines Range names used:
\nJob Assignments =Model!$C$15:$F$19
\n1 2 3 4 Jobs_on_machine =Model!$G$15:$G$19
\nMachine 1 14 5 8 7 Machine_capacity =Model!$I$15:$I$19
\n2 2 12 6 5 Machines_on_job =Model!$C$20:$F$20
\n3 7 8 3 9 Total_time =Model!$B$25
\n4 2 4 6 10
\n5 5 5 4 8<\/p>\n
Assignments, and constraints on machine capacities and job completion requirements
\nJob
\n1 2 3 4 Jobs on machine Machine capacity
\nMachine 1 0 0 0 0 0 <= 1
\n2 0 0 0 1 1 <= 2
\n3 0 0 1 0 1 <= 1
\n4 1 1 0 0 2 <= 2
\n5 0 0 0 0 0 <= 1
\nMachines on job 1 1 1 1
\n= = = =
\nRequired 1 1 1 1<\/p>\n
Objective to minimize
\nTotal time 14<\/p>\n","protected":false},"excerpt":{"rendered":"
Assignment for Linear Programming Order Description Assignment about Linear Programming, and need to use Excel Sover in Microsoft Excel. Calculating allocation costs with UNKNOWN allocation Connection Cost matrix Depot 1 Depot 2 Depot 3 Depot 4 Depot 5 Allocation Cost Read More …<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-95060","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/95060","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=95060"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/95060\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=95060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=95060"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=95060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}