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 Allocation of stores to depots
Store 1 2,563.81 2,141.20 5,421.17 2,092.17 4,990.89 2,092.17 4
Store 2 5,480.25 4,649.93 8,410.58 4,928.55 8,042.24 4,649.93 2
Store 3 10,881.55 22,563.23 16,413.29 17,629.59 14,408.26 10,881.55 1
Store 4 12,729.57 8,525.28 28,673.08 11,309.96 26,327.61 8,525.28 2
Store 5 249.59 630.79 599.35 476.78 517.82 249.59 1
Store 6 1,560.68 3,967.30 5,791.40 3,015.08 5,056.33 1,560.68 1
Store 7 8,039.42 10,100.48 15,085.34 7,876.65 13,752.20 7,876.65 4
Store 8 8,581.71 11,343.20 4,548.07 9,898.75 4,947.47 4,548.07 3
Store 9 5,626.82 9,498.46 4,180.36 7,746.54 3,857.04 3,857.04 5
Store 10 9,696.95 10,817.35 11,513.28 9,832.64 11,185.24 9,696.95 1
Total connection cost 53,937.91

Assignment of jobs to machines

Times to perform jobs on various machines Range names used:
Job Assignments =Model!$C$15:$F$19
1 2 3 4 Jobs_on_machine =Model!$G$15:$G$19
Machine 1 14 5 8 7 Machine_capacity =Model!$I$15:$I$19
2 2 12 6 5 Machines_on_job =Model!$C$20:$F$20
3 7 8 3 9 Total_time =Model!$B$25
4 2 4 6 10
5 5 5 4 8

Assignments, and constraints on machine capacities and job completion requirements
Job
1 2 3 4 Jobs on machine Machine capacity
Machine 1 0 0 0 0 0 <= 1
2 0 0 0 1 1 <= 2
3 0 0 1 0 1 <= 1
4 1 1 0 0 2 <= 2
5 0 0 0 0 0 <= 1
Machines on job 1 1 1 1
= = = =
Required 1 1 1 1

Objective to minimize
Total time 14