學門類別
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Snapchat’s Dilemma: Growth or Financial Sustainability
- Did I Just Cross the Line and Harass a Colleague?
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
- TNT Assignment: Financial Ratio Code Cracker
- Winsol: An Opportunity For Solar Expansion
407 ETR Highway Extension: Material Procurement
內容大綱
In April 2016, the chairman of the partnership charged with building the $1 billion Highway 407 East Extension Phase 2 in Ontario was reviewing an e-mail from the procurement team that recommended allocation of more than $45 million in contracts for the purchase of granular base material for the highway construction. He knew that the procurement team had worked for several weeks to negotiate and analyze the supplier’s quotes, but after reviewing the recommendation, the chairman wondered whether the team’s recommendation captured the optimal supplier mix and the most cost-effective selection of suppliers. It was certainly a good solution, but was it the optimal solution? Even with an experienced team, this was a difficult optimization problem to solve.
學習目標
The case can be used at undergraduate, graduate, and postgraduate levels in finance, management, purchasing, cost accounting courses, and other courses related to assessing cost-effectiveness. Students can use Excel Solver in this case to solve an optimization problem that is not solvable intuitively or experientially by an experienced team. After completion of this case, the student will be able to:<ul><li>assess the cost-effectiveness of various bids from suppliers;</li><li>analyze the impact various suppliers’ quotes and conditions have on the company’s bottom line; and</li><li>evaluate the differences suppliers’ transportation costs, maximum capacities, and offers of discounts have on the overall cost of a project of this magnitude.</li><ul>