Aggregate Production Planning: Modeling and Solution via Excel Spreadsheet and Solver

Filho, Oscar Salviano Silva; Cezarino, Wagner; Ratto, João

doi:10.3182/20100908-3-pt-3007.00020

Cited by 4 publications

(2 citation statements)

References 3 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Another fundamental phase is to evaluate how much the plan is profitable or not to give maximum yield and if there is any productivity loss how we would be able to tackle this problem by reviewing every aspect of the implemented plan (Piper & Vachon, 2001). This evaluative phase is very significant but the most people are not interested to resolve this issue of loss of productivity (Filho et. al., 2010).…”

Section: Background and Introductionmentioning

confidence: 99%

Management and Production Engineering Review

REHMAN,

AHMAD,

ALI

et al. 2021

View full text Add to dashboard Cite

Traditionally the aggregate production plan helps in determining the inventory, production, and work-force, based on the demand forecasts without considering the productivity loss at a tactical level in supply chain planning. In this paper, we include the productivity loss into traditional aggregate production plan and the prescriptive analytics technique, linear programming, is used to solve this problem of practical interest in the domain of multifarious businesses and industries. In this study, we discussed two model variations of the aggregate production planning problem with and without productivity loss, i) fixed work-force, and ii) variable Work Force. The mathematical models were designated to be solved by using an open-source python pulp package in order to evaluate the impacts of the productivity loss on both the models. PuLP is an open-source modeling framework provided by the COIN-OR Foundation (Computational Infrastructure for Operations Research) for linear and integer Programing problems written in Python. The computational results indicate that the productivity loss has direct impact on the workforce hiring and firing.

show abstract

Section: Background and Introductionmentioning

confidence: 99%

Management and Production Engineering Review

REHMAN,

AHMAD,

ALI

et al. 2021

View full text Add to dashboard Cite

show abstract

“…The latter one has proved to be a powerful spreadsheet tool with robust programming capabilities known as Visual Basic for Applications (VBA). Application of Solver in the field of project scheduling was suggested by researchers like Silva Filho et al (2010), Trautmann and Gnägi (2015), and others.…”

Section: Introductionmentioning

confidence: 99%

An integration of spreadsheet and project management software for cost optimal time scheduling in construction

Valenko

Klanšek

2017

Organization, Technology and Management in Construction: An International Journal

View full text Add to dashboard Cite

Successful performance and completion of construction projects highly depend on an adequate time scheduling of the project activities. On implementation of time scheduling, the execution modes of activities are most often required to be set in a manner that enables in achieving the minimum total project cost. This paper presents an approach to cost optimal time scheduling, which integrates a spreadsheet application and data transfer to project management software (PMS). At this point, the optimization problem of project time scheduling is modelled employing Microsoft Excel and solved to optimality using Solver while organization of data is dealt by macros. Thereupon, Microsoft Project software is utilized for further managing and presentation of optimized time scheduling solution. In this way, the data flow between programs is automated and possibilities of error occurrence during scheduling process are reduced to a minimum. Moreover, integration of spreadsheet and PMS for cost optimal time scheduling in construction is performed within well-known program environment that increases the possibilities of its wider use in practice. An application example is shown in this paper to demonstrate the advantages of proposed approach.

show abstract

A systematic review of aggregate production planning literature with an outlook for sustainability and circularity

Aydın

Tirkolaee

2022

Environ Dev Sustain

View full text Add to dashboard Cite

Aggregate Production Planning: Modeling and Solution via Excel Spreadsheet and Solver

Cited by 4 publications

References 3 publications

Management and Production Engineering Review

Management and Production Engineering Review

An integration of spreadsheet and project management software for cost optimal time scheduling in construction

A systematic review of aggregate production planning literature with an outlook for sustainability and circularity

Contact Info

Product

Resources

About