Pursuing effectiveness and efficiency: Data model for workforce scheduling at Alvarino

Abstract

This case involves actual data obtained from an interview with a partner, a manager and two associates at a firm located in Singapore, Alvarino (pseudonym). The firm is part of a global network of accountancy and business advisory firms. The network comprises of more than 100 independently owned and managed firms that straddle more than 100 geographical locations across the world. The case illustrates issues that Alvarino experienced in scheduling their staff for audit advisory engagement. As a service oriented and cost-conscious business, workforce scheduling is essential to help Alvarino’s management optimise its workforce allocation. The objective of this case is to create a data model that maps user and data requirements to optimise Alvarino’s workforce-scheduling processes.