1. The CEO of your company would like you to come up with a layout plan that generates lower costs than the initial plan. Your facility currently includes 8 departments. The size, from-to, and cost matrixes show below. Use the add-in in Excel and provide the initial plan and its cost, as well as a few alternative layouts with lower costs (you need to use the algorithm solver and exchange departments to find lower-cost plans.). In your report, include the cost and a screenshot of the layouts. Also, attach your Excel file

Layout Data

Problem Name:	Production
Number Depts.:	8
Fixed Points:	0
Dimension:	m

Facility Information

Scale-m/unit	1	Cells
Length-m	12	12
Width-m	12	12
Area-sq.m	144	144
Department Information	Name	F/V	Area	Cells
Dept. 1	D 1	V	18	18
Dept. 2	D 2	V	15	15
Dept. 3	D 3	V	16	16
Dept. 4	D 4	V	19	19
Dept. 5	D 5	V	28	28
Dept. 6	D 6	V	8	8
Dept. 7	D 7	V	22	22
Dept. 8	D 8	V	18	18

Flow Matrix

FROM	D 1	D 2	D 3	D 4	D 5	D 6	D 7	D 8
D 1	0	26	36	19	45	26	19	0
D 2	0	0	45	15	28	30	0	18
D 3	0	0	0	35	20	10	0	20
D 4	0	0	0	0	20	24	0	30
D 5	0	0	5	9	0	38	22	10
D 6	0	0	19	10	4	0	15	8
D 7	0	0	0	0	4	0	0	0
D 8	0	0	0	8	0	4	3	0

Cost Matrix

	TO
FROM	D 1	D 2	D 3	D 4	D 5	D 6	D 7	D 8
D 1	1	1	1	1	1	1	1	1
D 2	1	1	1	1	1	1	1	1
D 3	1	1	1	1	1	1	1	1
D 4	1	1	1	1	1	1	1	1
D 5	1	1	1	1	1	1	1	1
D 6	1	1	1	1	1	1	1	1
D 7	1	1	1	1	1	1	1	1
D 8	1	1	1	1	1	1	1	1

Calculation/Analysis: