An Intelligent Decision Support System to Aid Profit Planning in Manufacturing Companies
Keywords:
Management Accounting, Break-Even Analysis, Multi-product Break Even Point, Market Demand, Profit PlanningAbstract
In order to assure accuracy in profit planning and decision-making, this study uses an intelligent decision support system to investigate an appropriate approach for calculating the "Break-Even" point in multi-product segments while taking into account the implications for contribution margin, demand, and capacity. The research's methodology and findings may be used to propose new projects, grow businesses, and make decisions in processes that focus on many products. Data are used to illustrate the advanced level of break-even analysis and application, and a description of the convenient and system-generated method of computation is given. A mathematical approach has been used based on actual data to show how to determine the break-even point without sacrificing the influencing aspects such as contribution margin, capacity, product mix, and demand for each. The researchers have created a good system application-oriented platform to make it simple to calculate the break-even point, which will be crucial for decision-making and profit planning even with more than 500 SKU (Stock Keeping Unit). This research evaluated the data and created formulas for actual data structure-based analysis. The study's conclusions have a significant influence on those companies that need to determine the true break-even threshold. The challenge area of concern might be the applicability of this activity for other sectors and other countries as this research was centred on the plastic bag industry in Malaysia. Future research can also analyse other important factors like start-up and semi-variable costs as they are not included in the current study. The identified break-even threshold can still be used effectively given the current market demand and the product's capacity.
Downloads
References
Alleyne, P., Weekes, D., & Marshall (2011) ‘An Exploratory Study Of Management Accounting Practices In Manufacturing Companies In Barbados’ Accessed On 26 November 2018
Alnasser, N., Samih, O., Shaban And Al-Zubi, Z (2014) ‘The Effect Of Using Break-Even-Point In Planning, Controlling, And Decision Making In The Industrial Jordanian Companies’ Accessed on 26 November 2018
Alvis, J (2002) ‘Cost-Volume-Profit Analysis’ Accessed On 12 November 2018
Anderson, D., Sweeney, D., Williams, T., Camm, J., Cochran, J., Fry, M. And Ohlman, J. (2018) ‘An Introduction To Management Science: Quantitative Approach’ Accessed On 20 October 2018
Anderson, S., (2001) ‘Direct And Indirect Effects Of Product Mix Characteristics On Capacity Management Decisions And Operating Performance’ Accessed on 14 May 2019
Bansal, Verma, Y., Garg, Singh, M. (2014) ‘Breakeven Analysis’ Accessed On 15 November 2018
Berryman, C., and Nobe, M., (1999) ‘Practical Business Application of Break Even Analysis in Graduate Construction Education’ Accessed on 4 May 2019 <https://www.researchgate.net/publication/255667451_Practical_Business_Application_of_Break_Even_Analysis_in_Graduate_Construction_Education >
Campbell, C., (2018) ‘Break-Even Analysis: How To Predict If Your Next Venture Will Be Profitable’ Accessed On 9 June 2019 < Business Finance Https://Www.Shopify.My/Blog/Break-Even-Analysis >
Correia, I., & Saldanha-Da-Gama, F. (2014). ‘The Impact of Fixed and Variable Costs in A Multi-Skill Project Scheduling Problem: An Empirical Study. Computers & Industrial Engineering’ Accessed On 19 November 2018
Crncan, A., Hadelan, L., Kranjac, D., Jelic, S., Kralik, I And Kristic, J (2018) ‘Break-Even Analysis Of Poultry Egg Production In Croatia’ Accessed On 29 October 2018
Debare, I. (2010). ‘How To Perform A Break-Even Analysis’ Accessed On 17 November 2018
Dubas, K., Hershey, L., Nijhawan, I., Mehta, R., (2011) ‘Breakeven and profitability analyses in marketing management using R Language’ Accessed on 10 May 2019 <https://businessperspectives.org/images/pdf/applications/publishing/templates/article/assets/4234/im_en_2011_03_Dubas.pdf >
Enyi Patrick Enyi (2005) ‘Applying relative solvency to working capital management – the break-even approach’ Accessed on 15 June 2019 <https://papers.ssrn.com/sol3/papers.cfm?abstract_id=744364>.
Felipe Scavarda, L. , Schaffer, J., Scavarda, A., Reis, C., And Schleich, H., (2009) ‘Product Variety: An Auto Industry Analysis And A Benchmarking Study‘ Benchmarking: An International Journal ISSN: 1463-5771 Accessed On 8 March 2019 <https://www.emerald.com/insight/content/doi/10.1108/14635770910961399/full/html>
Felipe Scavarda, L., Reichhart, A., Hamacher, S., & Holweg, M., (2010) ‘International Journal Of Operations & Production Management’ ISSN: 0144-3577, Accessed On 5 March 2019
Gary Simpson (1984) ‘ The cost of capital and Break-even analysis’ accessed on 15 June 2019 <https://www.jstor.org/stable/41948060?read-now=1&refreqid=excelsior%3Afdf66d09803b5d165f0a74da420db7ca&seq=1#page_scan_tab_contents>
Gawade, A (2016) ‘A Study On Breakeven Analysis With Refreance To Sadashivrao Mandlik Kagal Taluka Sahakari Sakhar Karkhana Ltd’ Accessed on 12 May 2019 < Http://Www.Ijstm.Com/Images/Short_Pdf/1459446903_1142b.pdf >
Gutierrez, P.H, Dalsted, N.L (2004) ‘Break-even method of investment analysis’ Accessed on 15 June 2019 <https://mountainscholar.org/bitstream/handle/10217/193357/AEXT_ucsu2062237592004.pdf?sequence=1>.
Hemanta, S., (2012) ‘Capacity Utilization in Small Scale Industries of India: Some Empirical Evidence From Under Developed Industrial Structure,” Journal of Social and Economic Statistics, Vol. 1, No. 1, Pp. 39-5. Accessed on 14 June 2019
Homa, K (2018) ‘Breakeven Analysis Simplex and Complex’ Accessed On 25 November 2018
Ionescu, A. and Dumitru, C. (2015). ‘Break-Even in The Decision-Making Process’. Accessed 28 Nov. 2018,
Janjic, V., Todorovic, M., & Jovanovic, D., (2010) ‘Cvp Analysis-The Impact Of Cost Structure On The Result Of The Company’ Accessed On 15 June 2019
Kampf, R., Majerčák, P., and Švagr, P., (2016) ‘Application of Break-Even Point Analysis Primjena Break-Even Point analize’ Accessed on 24 June 2019 <https://www.google.com.my/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&ved=2ahUKEwjnz6eY_LXjAhUIgI8KHa_iBpoQFjABegQIAxAC&url=https%3A%2F%2Fhrcak.srce.hr%2Ffile%2F239680&usg=AOvVaw26gJazv4UdhvAeKsuyzfF >
Kim, K., And Chhajed, D., (2000) ‘Commonality In Product Design: Cost Saving, Valuation Change And Cannibalization’ Accessed On 16 May 2019
Lazzari And Morinigo (2003) ‘Analysis Of Multi-Product Break-Even With Uncertain Information’ Accessed On 12 January 2019
Martin (2014) ‘Break Even Analysis’ Accessed On 17 November 2018
Nagle, T and Muller, G (2018) ‘The Strategy and Tactics Of Pricing’ Accessed On 14 November 2018
Ndaliman and Suleiman. (2011) ‘An Economic Model For Break-Even Analysis’ Accessed On 13 November 2018
Ndaliman, M., And Bala, K., (2007) ‘ Practical Limitations Of Break-Even Theory’ Accessed On 22 February 2019
Pierluigi Morano and Francesco Tajani (2013) ‘ Break Even Analysis for the Financial Verification of Urban Regeneration Projects’ Accessed on 15 June 2019 <http://citeseerx.ist.psu.edu/viewdoc/download?doi=10.1.1.911.3689&rep=rep1&type=pdf>
Pine, J., (1993) ‘Mass Customization: The New Frontier in Business Competition’. Harvard Business Press. Accessed On 28 April 2019
Potkany, M., & Krajcirova, L. (2015). ‘Quantification Of The Volume Of Products To Achieve The Break-Even Point And Desired Profit In Non-Homogeneous Production’ Accessed On 12 November 2018 < Https://Ac.Els-Cdn.Com/S2212567115008114/1-S2.0-S2212567115008114-Main.Pdf?_Tid=Cbdf5d47-00ac-4b47-9ff6-Bd4b30838197&Acdnat=1544238450_21a2569a6474a78ffa845929147e1db3 >
Shahidul, M., And Shazali, S., (2011) ‘Dynamics of Manufacturing Productivity: From Labour Intensive Industries’ International Journal of Manufacturing Technology Management, Vol. 22, No. 5, Pp. 664-674. Accessed on 18 June 2019
Sharma, M., (2014) ‘Study Of Banking Break Even Point: An Innovative Tool For Banking Industry’ Accessed on 12 April 2019 <http://Www.Google.Com.My/Url?Sa=T&Rct=J&Q=&Esrc=S&Source=Web&Cd=13&Cad=Rja&Uact=8&Ved=2ahukewiu0fah9rxjahwlixakhalxa9qqfjamegqiabac&Url=Http%3A%2F%2Finternationaljournalcorner.Com%2Findex.Php%2Fijird_Ojs%2Farticle%2Fdownload%2F135459%2F94583&Usg=Aovvaw0h9gyj33ri512vu0tb5pcu>
Soto, J., (2009) ‘Financial Crisis: The Failure of Accounting Reform’ Accessed On 12 December 2018< Https://Mises.Org/Library/Financial-Crisis-Failure-Accounting-Reform >
Swayamsree, N., (1968) ‘Break-Even Analysis’ Accessed On 12 June 2019
Tang Tri, H. Phan Hoai, V. Nguyen Huu, T. And Nghuyenthi Thu, H (2016). ‘Break-Even Analysis In Business For Small And Medium-Sized Enterprises: Study In Gia Lai Province – Vietnam’ Accessed On 23 November 2018
Tang, S., (2006) ‘Perspectives in Supply Chain Risk Management. International Journal Of Production Economics, 103, 451-488’ Accessed On 8 May 2019
Tracy, B. (2014) ‘Conducting A Break-Even Analysis’ Accessed On 10 November 2018 <https://Www.Entrepreneur.Com/Article/73782>
Tsorakidis, N., Papadoulos, S., Zerres, M. And Zerres, C. ‘Break-Even Analysis’ Accessed On 12 June 2019 < Https://Ercd.Files.Wordpress.Com/2013/07/Break-Even-Analysis-1-By-Nikolaos-Tsorakidis.Pdf >
Valentino Piana (2006) ‘Firm-Specific Fixed and Variable Costs: A Model of Market Dynamic’ Accessed on 2 June 2019 <http://www.economicswebinstitute.org/fixedvar.html >
Varalakshmi, K., (2016) ‘Returns To Efficient Utilization Of Processing Capacity empirical Evidence From Micro Level Study’ Accessed on 21 June 2019
Zagursky,R. (2017) ‘Using Break-Even Analysis To Improve Business Growth’ Accessed On 23 November 2018
Zimmerer, T., Scarborough, N. M., & Wilson, D. (2000) ‘Essentials of Entrepreneurship and Small Business Management. Pearson/Prentice Hall’ Accessed On 25 November 2018 < Https://Www.Pearson.Com/Us/Higher-Education/Product/Zimmerer-Essentials-Of-Entrepreneurship-And-Small-Business-Management-5th-Edition/9780132294386.Html>
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Shantinee Thasan, Abdul Rahman, Parameswaran Subramanian, Maria Josephine Williams
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
All papers should be submitted electronically. All submitted manuscripts must be original work that is not under submission at another journal or under consideration for publication in another form, such as a monograph or chapter of a book. Authors of submitted papers are obligated not to submit their paper for publication elsewhere until an editorial decision is rendered on their submission. Further, authors of accepted papers are prohibited from publishing the results in other publications that appear before the paper is published in the Journal unless they receive approval for doing so from the Editor-In-Chief.
IJISAE open access articles are licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. This license lets the audience to give appropriate credit, provide a link to the license, and indicate if changes were made and if they remix, transform, or build upon the material, they must distribute contributions under the same license as the original.
