Question
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.
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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Essentials of Accounting for Governmental and Not-for-Profit Organizations
Authors: Paul A. Copley
10th Edition
007352705X, 978-0073527055
