1. While Company ABC involves both in manufacturing process and retail service, their products are always stored in two warehouses before shipped to three retail outlets.

From\To	Shipping Cost		Shipping Capacity		Output
	Warehouse A	Warehouse B	Warehouse A	Warehouse B
Factory A	200	360	125	175	300
Factory B	320	270	150	200	200

Table 2a. shipping cost (in dollars) and capacity (in units) to each warehouse, monthly output from each factory

From\To	Shipping Cost							Shipping Capacity
	Outlet A	Outlet B	Outlet C	Outlet A	Outlet B	Outlet C
Warehouse A	470	505	490	100	150	100
Warehouse B	390	410	440	125	150	75
Demand	175	200	125	175	200	125

Table 2b. shipping cost (in dollars) and capacity (in units) to each retail outlet, monthly demand to each customer

According to Table 2a and 2b, you are required to:

1. Formulate a distribution network which aims at minimizing the total shipping cost up from factories down to outlets,
2. Draw the network represent this distribution problem and indicate/ label all information needed for this distribution network.
3. Solve the formulated model with a spreadsheet.

2.

Urban planning is notably vital when it comes to sustainable development. For instance, allocating at most three fire stations to the community in Paradise City is one of the decisions to be made. The city is segregated into five districts while there should be no more than one station planned for each area. Moreover, emergencies are assigned to different stations with the following arrangement.

Usually to particular station based on their occurred locations accordingly Sometimes to other districts for exceptional cases

	District	A	B	C	D	E	Average predicted frequency of emergency
	A	5	20	15	25	10	2
Average	B	12	4	20	15	25	1
respond
	C	30	15	6	25	15	3
time to an emergency
	D	20	10	15	4	12	1
	E	15	25	12	10	5	3

Table 3 respond time to an emergency (in minutes) and average frequency of emergencies (per day)

There also obtains additional criteria for station allocation due to limited resources.

Requirement I

Only one district can be served if the fire station(s) is/are located in District A and District B

Requirement II

More than one district can be served if the fire station(s) is/are located in District C, District D, and District E

Requirement III

Only one fire station can be located in District C or District D

To minimize the overall respond time to an emergency, you are required to formulate and solve the corresponding model in Paradise City with a spreadsheet.

A. What are the decision variables?

B. What is the objective function for this problem?

C. Are there any transshipment nodes in this problems? Explain.

D. What are the constraints for this problem?

E. What is the optimal solution for this problem?

F. Upload a screenshot of Excel spreadsheet for this problem.

G. Upload a screenshot of your Excel Solver Setup for this problem