Due to budget reductions, the bridge department for the town of Deep River had t

Question

Due to budget reductions, the bridge department for the town of Deep River had their bridge repair budget reduced for the coming year, and the bridge department now has sufficient resources to repair only one bridge per year. The cost of repair for several bridges needing repair are shown below. Also shown is the average number of cars per day that travel over each bridge. Which one should be repaired first from a cost effectiveness perspective if the effectiveness measure is the average number of cars using the bridge per day. Show excel formula's/calculations. Bridge Repair Cost Average Cars per day Adams $405,000 1400 Jackson $300,000 1440 Jefferson $345,000 1640 Madison $336,000 1550 Monroe $285,000 1300 Washington $360,000 1500 Due to budget reductions, the bridge department for the town of Deep River had their bridge repair budget reduced for the coming year, and the bridge department now has sufficient resources to repair only one bridge per year. The cost of repair for several bridges needing repair are shown below. Also shown is the average number of cars per day that travel over each bridge. Which one should be repaired first from a cost effectiveness perspective if the effectiveness measure is the average number of cars using the bridge per day. Show excel formula's/calculations. Bridge Repair Cost Average Cars per day Adams $405,000 1400 Jackson $300,000 1440 Jefferson $345,000 1640 Madison $336,000 1550 Monroe $285,000 1300 Washington $360,000 1500

Explanation / Answer

Bridge Repair Cost Average Cars Cost per Car Adams 405000 1400 289.285714 Jackson 300000 1440 208.333333 Jefferson 345000 1640 210.365854 Madison 336000 1550 216.774194 Monroe 285000 1300 219.230769 Washington 360000 1500 240 If the emphasis on the maximum no of cars that can be travel through the bridge then Bridge Jefferson Should be repaired first. If the emphasis is on the cost of repair per car then Jackson should be repaired first due to low average cost per car

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.