University of Jos Institutional Repository >
Natural Sciences >
Mathematics >

Please use this identifier to cite or link to this item: http://hdl.handle.net/123456789/2127

Title: Design and Full Automation of Excel Solution Templates for a Time-perspective Class of Machine Replacement Problems with Pertinent Dynamic Data
Authors: Ukwu, Chukwunenye
Keywords: Dynamic programming recursions
time optimal policy
Issue Date: 3-May-2016
Publisher: Archives of Current Research International
Series/Report no.: Vol. 4;No. 1.PP 1-15
Abstract: Aim: The aim of this paper is to design and automate optimal policy prescriptions and returns for a time perspective class of machine replacement problems with pertinent dynamic data. Methodology: The aim was achieved by the exploitation of the structure of the states in timeperspective dynamic programming recursions and the coding functionality in Microsoft Excel. Results: The paper designed and fully automated the solution templates for the determination of the optimal time replacement policies in machine replacement problems, with pertinent data given as dynamic functions of new machine purchase year and machine age. Conclusion: The automation of these templates obviates the need for manual inputs of the states and stage numbering as well as the inherent tedious and prohibitive manual computations associated with dynamic programming formulations and may be optimally appropriated for sensitivity analyses on such model, ensuring that problems that could take days to solve are solved in a matter of just a few minutes.
URI: http://hdl.handle.net/123456789/2127
ISSN: 2454-7077
Appears in Collections:Mathematics

Files in This Item:

File Description SizeFormat
Chukwunenye412016ACRI26021.pdf174.58 kBAdobe PDFView/Open
View Statistics

Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.


Valid XHTML 1.0! DSpace Software Copyright © 2002-2010  Duraspace - Feedback