學門類別
政大
哈佛
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- Snapchat’s Dilemma: Growth or Financial Sustainability
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Did I Just Cross the Line and Harass a Colleague?
- TNT Assignment: Financial Ratio Code Cracker
- Porsche Drive (A): Vehicle Subscription Strategy
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
-
Foxcore Retail (A): Designing a Database
On April 2, 2017, the two founders of Foxcore Retail were preparing for a third summer managing their small retail business in Ontario, Canada. They had spent the weekend reviewing budgeting, staffing schedules, and inventory planning for their biggest expansion to date. There was only one pressing concern that had not been solved. In the past, employees had tracked sales by hand, on paper, which led to headaches when it came to calculating sales representatives’ commissions. Additionally, the two partners knew that by not documenting key information about each sale, they were missing the opportunity to collect valuable data that could provide insight into the performance of employees, events, and products. As the business grew, they were starting to notice the impact of these inefficiencies on customer service, and it was clear that this was the right time to implement a more disciplined database system. -
Foxcore Retail (B): Database Implementation
Supplement for product 9B18E016. -
Custom Closet Contractors: Making the Database Cut
In the summer of 2017, after completing his third year of business school, a student was eager to apply his newly developed business and technology skill sets at his father’s company during his four-month summer position. His father’s business, Custom Closet Contractors, designed and manufactured custom home organization solutions for home builders and individual clients. In the past year, the successful company’s sales growth had slowed, while expenses as a percentage of sales had increased. The company had experienced operational problems leading to higher expenses, and the student had found that part of the problem was the lack of data organization, which led to miscommunication between the front office and the production staff. To solve the problem, he proposed to design a centralized database and set to work trying to understand the business processes in order to design a data model.