Vol 12, No 2 (2024)

Machine Scheduling and Spreadsheet Modeling in a Fashion Management Class

Jaideep T. Naidu, Nioka Wyatt

Abstract

This paper is a result of several semesters of teaching an Operations Management class in the Fashion Management program. Topics like flow shop and parallel machine models are traditionally discussed in an Industrial Engineering class. However, we discussed these topics successfully in a fashion management class by providing examples that our students could relate to. This included examples in apparel production and fashion retailing. The students were also able to learn several logical Excel based formulas while creating spreadsheets for these topics. For the flow shop model, we create a spreadsheet model that reflects all details of the Gantt chart including idle times. In the case of parallel machines, the spreadsheet involves the more complex Nested IF functions. The students showed enthusiasm even when creating the more challenging spreadsheet models.

Full text:     Download pdf PDF

Keywords

spreadsheet modeling; Flow shop models; Parallel machines; supply chain.

Publication information

Volume 12, Issue 2
Year of Publication: 2024
ISSN: 1857 - 8721
Publisher: EDNOTERA

How to cite

Naidu, J.T., Wyatt, N.: Machine Scheduling and Spreadsheet Modeling in a Fashion Management Class. Journal of Applied Economics and Business, Vol 12, No. 2, 20-30. (2024)