Skip to main content
SpringerLink
Log in

Planning Production and Workforce in a Discrete-Time Financial Model Using Scenarios Modeling

  • Original Research
  • Published:
SN Operations Research Forum Aims and scope Submit manuscript

Abstract

Production planning interacts with a number of functional aspects within the entire system of a company. Two of those aspects involve workforce and financial planning, which are usually conflicting, in the sense that more workforce increases the financial costs but it may also increase production capability. In effect, there should exist an adequate balance on the production levels such that the cash-flows can generate the highest profits. This suggests that these three elements of the system (production, workforce and cash-flows) are tightly connected, and that they should be planned together in a single framework. This paper explores this interaction using a mixed integer linear programming formulation for a general outline of this three elements system. The model includes sequences of overlapping work-shifts and sequences of overlapping short-term loans. We discuss a number of scenarios concerning some of the uncertain parameters involved in the process, assuming that they do not follow any known distribution function, so handling uncertainty using a scenarios modeling methodology. Contrarily to usual lot-sizing problems, we consider demand as an upper limit for setting the production. So, we want to plan production and workforce in order to assist the cash-flows along the planning horizon, to the best convenience of the financial profits. We discuss a small fictitious example using a single-product with a homogeneous type of workers in the process. We then indicate a number of generalizations, including some real-world applications.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11

Similar content being viewed by others

References

  1. Absi N, Detienne B, Dauzère-Pérès S (2012) Heuristics for the multi-item capacitated lot-sizing problem with lost sales. Comput Oper Res 40 (1):264–272. https://doi.org/10.1016/j.cor.2012.06.010

    Article  Google Scholar 

  2. Albrecht W, Steinrücke M (2017) Continuous-time production, distribution and financial planning with periodic liquidity balancing. J Sched 20 (3):219–237. https://doi.org/10.1007/s10951-016-0488-7

    Article  Google Scholar 

  3. Albrecht W, Steinrücke M (2020) Assessing site integration into semi-continuous production, distribution and liquidity planning of supply chain networks. EURO J Transp Logist 9(1):100002. https://doi.org/10.1016/j.ejtl.2020.100002

    Article  Google Scholar 

  4. Belvaux G, Wolsey LA (2001) Modelling practical lot-sizing problems as mixed-integer programs. Manag Sci 47(7):993–1007. https://doi.org/10.1287/mnsc.47.7.993.9800

    Article  Google Scholar 

  5. Brahimi N, Absi N, Dauzère-Pérès S, Nordli A (2017) Single-item dynamic lot-sizing problems: An updated survey. Eur J Oper Res 263 (3):838–863. https://doi.org/10.1016/j.ejor.2017.05.008

    Article  Google Scholar 

  6. Chen Z, Zhang RQ (2019) A cash-constrained dynamic lot-sizing problem with loss of goodwill and credit-based loan. International Transactions in Operational Research, early view. https://doi.org/10.1111/itor.12675

  7. Dembo RS (1991) Scenario optimization. Ann Oper Res 30:63–80. https://doi.org/10.1007/BF02204809

    Article  Google Scholar 

  8. Escudero LF, Kamesam PV, King AJ, Wets RJ-B (1993) Production planning via scenario modelling. Ann Oper Res 43:311–335. https://doi.org/10.1007/BF02025089

    Article  Google Scholar 

  9. Figueira G, Santos MO, Almada-Lobo B (2013) A hybrid VNS approach for the short-term production planning and scheduling: A case study in the pulp and paper industry. Comput Oper Res 40(7):1804–1818. https://doi.org/10.1016/j.cor.2013.01.015

    Article  Google Scholar 

  10. Fisk J (1980) An interactive game for production and financial planning. Comput Oper Res 7(3):157–168. https://doi.org/10.1016/0305-0548(80)90002-7

    Article  Google Scholar 

  11. Graves SC (2002) Manufacturing planning control. In: Pardalos P., Resende M. (eds) Handbook of Applied Optimization. Oxford University Press, New York, pp 728–746

  12. Hnaien F, Afsa HM (2017) Robust single-item lot-sizing problems with discrete-scenario lead time. Int J Prod Econ 185:223–229. https://doi.org/10.1016/j.ijpe.2017.01.008

    Article  Google Scholar 

  13. Kirka Ö, Köksalan M (1996) An integrated production and financial planning model and an application. IIE Trans 28:677–686

    Article  Google Scholar 

  14. Loparic M, Pochet Y, Wolsey LA (2001) The uncapacitated lot-sizing problem with sales and safety stocks. Math Program 89:487–504. https://doi.org/10.1007/PL00011411

    Article  Google Scholar 

  15. Martins P (2016) Computational Management Science LNEMS 682. In: Fonseca RJ, Weber G-W, Telhada J (eds). https://doi.org/10.1007/978-3-319-20430-7_15

  16. Martins P, Quelhas AP (2016) Workforce planning and financing on a production/capital discrete-time model. Int Trans Oper Res 23 (3):507–538. https://doi.org/10.1111/itor.12181

    Article  Google Scholar 

  17. Muñoz M.A., Ruiz-Usano R, Framiñán JM, et al (2000) A mathematical programming model for the integration of aggregate production planning with short-term financial planning. In: Proceedings of the First World Conference on Operations Management (POM 2000), Sevilla, Spain

  18. Pastor R, Altimiras J, Mateo M (2009) Planning production using mathematical programming: the case of a woodturning company. Comput Oper Res 36 (7):2173–2178. https://doi.org/10.1016/j.cor.2008.08.005

    Article  Google Scholar 

  19. Pochet Y (2001) Mathematical programming models and formulations for deterministic production planning problems. In: Jünger M, Naddef D (eds) Computational Combinatorial Optimization LNCS 2241. Springer, Berlin, pp 57–111

  20. Samuelson PA, Nordhaus WD (2010) Economics, 19th edn. McGraw-Hill International Edition, New York

    Google Scholar 

  21. Toledo CFM, de Oliveira RRR, França P M (2013) A hybrid multi-population genetic algorithm applied to solve the multi-level capacitated lot sizing problem with backlogging. Comput Oper Res 40(4):910–919. https://doi.org/10.1016/j.cor.2012.11.002

    Article  Google Scholar 

  22. Zhao C, Guan Y (2014) Extended formulations for stochastic lot-sizing problems. Oper Res Lett 42:278–283. https://doi.org/10.1016/j.orl.2014.04.003

    Article  Google Scholar 

  23. https://ec.europa.eu/eurostat/statistics-explained/index.php/Inflation_in_the_euro_area. Accessed 23 June 2020

  24. https://www.statista.com/statistics/878412/number-of-smes-in-europe-by-size/. Accessed 23 June 2020

  25. https://www.statista.com/statistics/878412/number-of-smes-in-europe-by-size/#statisticContainer. Accessed 23 June 2020

Download references

Acknowledgments

I would like to thank the reviewers for the very constructive comments and suggestions that helped improving the paper.

Funding

This work has been partially supported by the Portuguese National Funding: Fundação para a Ciência e a Tecnologia - FCT, under the project UIDB/04561/2020.

Author information

Authors and Affiliations

  1. Coimbra Business School - ISCAC, Polytechnic Institute of Coimbra, Coimbra, Portugal

    Pedro Martins

  2. Centro de Matemática, Aplicações Fundamentais e Investigação Operacional (CMAFcIO), University of Lisbon, Lisbon, Portugal

    Pedro Martins

Authors
  1. Pedro Martins
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Pedro Martins.

Ethics declarations

Conflict of Interest

The author declares that there is no conflict of interest.

Additional information

Publisher’s Note

Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Martins, P. Planning Production and Workforce in a Discrete-Time Financial Model Using Scenarios Modeling. SN Oper. Res. Forum 1, 35 (2020). https://doi.org/10.1007/s43069-020-00035-y

Download citation

  • Received:

  • Accepted:

  • Published:

  • DOI: https://doi.org/10.1007/s43069-020-00035-y

Keywords

Search

Navigation