Question

com/hm.tpx ae 0 l and find the to help SP develop a distribution plan that will minimize costs to supply the terms of cost per 1,000 lbs and shipment quantities per 1,000 lbs. Round your answers to the nearest whole number.) St Louis Haute Atlanta Terre NYC Fr St Louis Total cost

Answer 1

Combined Costs is sum of production and transportation.

0 CombinedCosts per 1,000lbs BIRMINGH TERRE SAN S Solver Parameters NYC 380 AM 387 327 375 331 HAUTE | DALLAS | SPOKANE DIEGO 3 Philadelphia 4 Atlanta 5 St. Louis 6 Salt Lake Cit 7 Total Demand 531 8 (x 1,000 lbs) 391 343 365 327 931 398 350 365 303 331 720 920 1,220 1,020 397 421 368 386 321 406 Set Objective: 372 Max Min O Value Of: o 369 317 606 332 By Changing Variable Cells: SBS11:SGS14 Subject to the Constraints Solution (x 1000 lbs SBS15:SGS15 SBS7:SGS7 SHS11:SHS14SHS3:SHS6 Add BIRMINGHỊ TERRE SAN 10 NYC AM HAUTE | DALLAS | SPOKANE DIEGO Sent Change 11 Philadelphia 12 Atlanta 13 St. Louis 14 Salt Lake C 15 Received 16 Delete 920 931 289 Reset All 331 331 283 406 1,020 531 931 Make Unconstrained Variables Non-Negative Total costs Select a Solving Method: Simplex LP Options BIRMINGH TERRE SAN Solving Method Select the IPOPT Nonlinear engine for Solver Problems that are smooth nonlinear.Select the LP Simplex engine for linear Solver Problems. FROM/TO NYC AM HAUTE | DALLAS | SPOKANE DIEGO 19 Philadelphia24,700 20 Atlanta 21 St. Louis 22 Salt Lake Ci 23 Total Costs 158,440 137,340 11,696 339,815 106,641 Solve Close 89,711100,293130,326 1,098,962

EXCEL MODEL:

	CombinedCosts per 1,000 lbs.
FROM/TO	NYC	BIRMINGHAM	TERRE HAUTE	DALLAS	SPOKANE	SAN DIEGO	Capacity
Philadelphia	380	387	391	397	398	421	720
Atlanta	340	327	343	344	350	368	920
St. Louis	372	375	365	369	365	386	1220
Salt Lake City	332	331	327	317	303	321	1020
Total Demand	531	420	931	606	331	406
(x 1,000 lbs)
	Solution (x 1000 lbs)
=A2	=B2	=C2	=D2	=E2	=F2	=G2	Sent
=A3	65	0	0	0	0	0	=SUM(B11:G11)
=A4	466	420	0	34	0	0	=SUM(B12:G12)
=A5	0	0	931	289	0	0	=SUM(B13:G13)
=A6	0	0	0	283	331	406	=SUM(B14:G14)
Received	=SUM(B11:B14)	=SUM(C11:C14)	=SUM(D11:D14)	=SUM(E11:E14)	=SUM(F11:F14)	=SUM(G11:G14)
	Total costs
=A10	=B10	=C10	=D10	=E10	=F10	=G10
=A11	=B3*B11	=C3*C11	=D3*D11	=E3*E11	=F3*F11	=G3*G11
=A12	=B4*B12	=C4*C12	=D4*D12	=E4*E12	=F4*F12	=G4*G12
=A13	=B5*B13	=C5*C13	=D5*D13	=E5*E13	=F5*F13	=G5*G13
=A14	=B6*B14	=C6*C14	=D6*D14	=E6*E14	=F6*F14	=G6*G14
Total Costs						=SUM(B19:G22)