SHOW EXCEL TABLES!

The city council of Ecocity is currently evaluating four potential landfill sites to be used in the city's solid waste disposal network. To determine the best option, monthly costs per ton have been estimated for each site, along with the transportation costs from various collection areas. Additionally, the monthly amortized cost for each proposed facility has been calculated. The table below shows the data collected.

 

From Collection Area	Transportation Cost per Ton to Landfill Site				Monthly Tons - Waste
	L1	L2	L3	L4
A	$14	$16	$10	$8	500
B	$12	$11	$12	$14	700
C	$13	$8	$9	$11	1500
D	$10	$15	$14	$12	1000
E	$8	$12	$10	$11	1800
F	$11	$10	$8	$6	1200
Operating Cost/ton	$8	$10	$9	$11
Fixed cost/month	$1,000	$800	$700	$900

 

Based on this information, what is the most efficient configuration and what is the minimum monthly cost for the system?

a) (5 pts) Specify the decision variables.

b) (5 pts) Specify the objective.

c) (15 points) Build a model in Excel and title it Question 2. Copy and paste your Excel model to your word document. According to Excel Solver, what is the most efficient configuration and what is the minimum monthly cost for the system?