Question

to Ballas is $11, to Atlanta is $8, and to Denver is $12. How many units should be shipped from each plant to each regional distribution center? What is the total cost for this? :9-13 Finnish Furniture manufactures tables in facilities located in three cities-Reno, Denver, and Pittsburgh. The tables are then shipped to three retail stores located in Phoenix, Cleveland, and Chicago. Management wishes to develop a distribution sched- ule that will meet the demands at the lowest pos- sible cost. The shipping cost per unit from each of the sources to each of the destinations is shown in the following table: TO FROM RENO DENVER PITTSBURGH PHOENIX CLEVELAND CHICAGO 16 14. 12 10 19 13 12 18 The available supplies are 120 units from Reno, 200 from Denver, and 160 from Pittsburgh. Phoenix has a demand of 140 units, Cleveland has a demand of 160 units, and Chicago has a demand of 180 units. How many units should be shipped from each manu- facturing facility to each of the retail stores if cost is to be minimized? What is the total cost? AC 2:9-14 The state of Missouri has three major power- generating companies (A, B, and C). During the months of peak demand, the Missouri Power

9-13 write the equations for the problem from gne chart. develope a spreadsheet for a linear programmkng solution to this problem. and hse SOLVER to find the solution.

please show how to do this in EXCEL!

Answer 1

	PHEONIX(PH)	CLEVELAND(CL)	CHICAGO(CH)
RENO(R)	10	16	19	120
DENVER(D)	12	14	13	200
PITTSBURG(P)	18	12	12	160
	140	160	180
	PHR	PHD	PHP	CLR	CLD	CLP	CHR	CHD	CHP	Total
DECISION VARIABLE	1	1	1	1	1	1	1	1	1
COST	10	16	19	12	14	13	18	12	12	SUM OF ALL DECISION VARIABLES MULTIPLIED BY COST
PH	3	140	CONSTRAINTS		1
CL	3	160	CONSTRAINTS
CH	3	180	CONSTRAINTS
R	3	120	CONSTRAINTS
D	3	200	CONSTRAINTS
P	3	160	CONSTRAINTS

By this way. you will get the answer

ANSWER IS

	PH	CL	CH
R	120	0	0	120
D	20	0	180	200
P	0	160	0	160
	140	160	180

Cost is 5760

	PHR	PHD	PHP	CLR	CLD	CLP	CHR	CHD	CHP
	120	20	0	0	0	160	0	180	0
	1	1	1	1	1	1	1	1	1
Part Requirements by Product					Part Inventory Levels
Part Name	PH	CL	CH		Used	Available
PH(just for multiplication i put 1 here)	1	1	1		140	140
CL	1	1	1		160	160
CH	1	1	1		180	180
R	120	0	0		120	120
D	20	0	180		200	200
P	0	160	0		160	160
Profit per Unit	10	16	19	12	14	13	18	12	12	5760