學門類別
最新個案
- 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
Choosing Neighbourhood Community Projects
內容大綱
In November 2019, Jean Matthews had to decide how to allocate CA$300,000 toward neighbourhood improvement ideas submitted by city residents. Each of the four neighbourhoods in the city could receive up to CA$75,000 in funding, and Matthews had to consider the number of votes for each idea in her analysis. How should she identify which community projects to pursue?
學習目標
This exercise is intended for undergraduate-level courses on business analytics and optimization. The exercise provides students with an introduction to a version of the capital budgeting problem: deciding which ideas to fund that will maximize value, subject to budgetary constraints (this is also a version of the knapsack problem). After working through this exercise and the assignment questions, students will be able to do the following:<ul><li>Formulate a binary program (BP) for a project-selection application.</li><li>Implement and solve a BP model in a spreadsheet.</li><li>Develop logical constraints for a BP, such as “if-then” and “or” constraints.</li></ul>