OM Projects




Sample Projects

Inventory Replenishment Decisions Using an Ordering Alert System

Sponsor: Chinese Pharmaceuticals (HK) Company Ltd (
Project description: 
The main objective of this project is to create a monthly ordering alert system for product replenishment. This alert system will enable the company to:

  1. Facilitate the optimal stock level using the forecast demand while minimizing the chance of stock out.
  2. Keep a clearer track of the inventory level on a monthly basis to generate a more precise stock level for order quantity.
  3. Reconcile the forecast and actual demand data to indicate when the forecasting model will need to be adjusted.

Airline Crew Scheduling Problem Analysis and Specialized Set-Covering Solution for Creating a Flight Timetable

Sponsor: Air Hongkong (
Project description:
In the airline industry, crew planning and scheduling is among the most challenging tasks. Researchers and software companies invest large amount of resources in developing the decision support tools that optimize the crew schedule. However, the objective of planning a schedule that covers all flights with the minimum numbers of crew members is not an easy task. The difficulty arises from the huge number of possibilities and the large amount of constraints. Some of the constraints would be the government regulations concerning duty time and required rest of the crew, availability of flights, aircraft maintenance schedules and crew training schedule. In this project, the team attempted to find the minimal number of crew pairs required for AHK to sustain its operations. The team developed a linear model with Microsoft Excel together with Risk Solver Premium Xpress Engine to identify the minimum of crew pairs required to handle all the flight schedules for Air Hongkong.

Assigning Part Time Workers in Auction Periods through Linear Optimization Model

Sponsor: Christie’s Hong Kong (
Project description:
In this project, the team developed a linear optimization model for scheduling of part time workers at Christie’s Hong Kong, the local office of the leading auction company. The assignment and planning process they built with the Excel optimization model was very different from the current practice of the company, which was done manually by the HR team. The Excel optimization model was able to help the HR team to achieve an optimal solution in hiring and assigning temporary workers and an assignment plan that would be easily updated by the HR managers

Shift Scheduling for Retail Operations

Sponsor: Arome Bakery (
Project description:
Arome Bakery is a retail business in which labor force plays a very important role. It needs a good arrangement of staffs in order to have efficient store operations. Currently, there are two 10-hour duty shifts in each store to run approximately 12 hours of retail business. There is huge time overlapping between two shifts. In order to deliver optimal services, allocation of manpower resources is needed to be carefully determined. The objective of this project is to identify methods to facilitate daily manpower planning for the stores.

Inventory Models for Perishable Products

Sponsor: Arome Bakery (
Project description:
Cake and bread items are fresh in nature because product shelf life is short and quality is perishable quickly.  Arome provides more than 6 product categories, carrying over 200 SKUs with 1-3 days shelf life.  Inaccurate stock projection will result in wastage and high food cost.  It is very critical to strike the balance between product ordering and stock keeping according to sales projection.  The major output of this project is to develop a guideline for operations crew in stock projection.

Inventory Decisions in a Drug Manufacturing Supply Chain

Sponsor: Chinese Pharmaceuticals (HK) Company Ltd. (
Project description:

  1. To evaluate the inventory purchase and management systems of the company: from raw materials purchase in China to drug manufacturer in HK, to warehouse, finally to chain stores;
  2. To provide recommendations including:
    (a) Optimal size of warehouse;
    (b) Order quantity of each product each time;
    (c) Time to order.