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 7 publications

(5 citation statements)

References 3 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Entezaminia et al [41] stated that it is usually performed from 3 to 18 months. Filho et al [42], and Feng et al [19] also planned with a horizon of 12 months. On the other hand, Kopanos et al [43] used a horizon of only five days and, Bilgen and Dogan [44] of 7 days and three weeks.…”

Section: Discussionmentioning

confidence: 99%

“…Therefore, it is possible to affirm that, in the literature discussed here, the planning models usually seek to minimize costs through strategies according to the reality of the study site. For example, Filho et al [42] considered inventory levels, production rates, overtime, regular labor, and subcontracting. On the other hand, Feng et al [18] used minimum inventory costs, ideal production rate, and production balance load rate, seeking minimization.…”

Section: Discussionmentioning

confidence: 99%

See 1 more Smart Citation

Model for Integrating the Electricity Cost Consumption and Power Demand into Aggregate Production Planning

et al. 2022

View full text Add to dashboard Cite

The constant increases in electricity tax costs and the mandatory contracting of power demand in advance by companies connected to the high-voltage electrical system drive organizations to improve energy planning in their production processes. In addition, market uncertainties make only stochastic methods insufficient for forecasting future production demand. To fill this gap, this study proposes a model that integrates the cost with electricity consumption and power demand into the aggregate production planning, considering the market uncertainties. The model was empirically applied in the food industry, considering a family of potato chips products. From the collected data, a demand forecast was carried out for a later realization of the aggregate planning, using the Holt–Winters forecast model. Before modeling, the new energy demand was calculated, and finally, the model solution verification was performed. In the case study, after application, it was possible to reduce two workers and a cost reduction of R$ 14,288.00. Moreover, the proposal managed to define a power demand that minimized the costs of electric energy and the total costs of the aggregate production planning.

show abstract

Section: Discussionmentioning

confidence: 99%

Section: Discussionmentioning

confidence: 99%

Model for Integrating the Electricity Cost Consumption and Power Demand into Aggregate Production Planning

et al. 2022

View full text Add to dashboard Cite

show abstract

“…fluktuasi permintaan, yang secara langsung bertanggung jawab atas kelebihan atau kekurangan sumber daya yang tersedia di organisasi (Filho et al 2010).…”

Section: Pendahuluanunclassified

Perencanaan Produksi Agregat CV XYZ Dengan Jumlah Tenaga Kerja Tetap

Fairuzzahira¹,

Sukardi²,

Arkeman³

2020

jabm

View full text Add to dashboard Cite

CV XYZ is a growing plywood company. In increasing the company's competitiveness, CV XYZ seeks to find more ideal production planning for the company. The difference between supply and demand of CV XYZ has a total gap of 7,676 m3 over a period of 30 months. This proves that the current CV XYZ production planning is not ideal to be able to keep up with fluctuating demand. This study aims to analyze medium term production planning. Demand forecasting method is used to determine demand in the coming 12 months period. To compare the current CV XYZ strategy with the level, chase, mixed strategy. Based on calculations that have been made using demand and CV XYZ production variables, it is known that the ideal method used for future production planning is the chase strategy. The chase strategy focuses on eliminating existing inventory in the company, using adjusting the number of working days to the number of demands, as well as purchasing units from subcontracts. The use of a chase strategy has a 43% lower cost impact.

show abstract

“…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

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

Cited by 7 publications

References 3 publications

Model for Integrating the Electricity Cost Consumption and Power Demand into Aggregate Production Planning

Model for Integrating the Electricity Cost Consumption and Power Demand into Aggregate Production Planning

Perencanaan Produksi Agregat CV XYZ Dengan Jumlah Tenaga Kerja Tetap

Management and Production Engineering Review

Contact Info

Product

Resources

About