Design and Full Automation of Excel Solution Templates for a Time-perspective Class of Machine Replacement Problems with Pertinent Dynamic Data
Archives of Current Research International · pp. 1–15 · Published 3 May 2016
10.9734/ACRI/2016/26021Abstract
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 time-perspective 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.
References (6)
- 1 Operations Research -- An Introduction [DOI]
- 2 Operations research : applications and algorithms
- 3 Sensitivity Analysis of the Replacement Problem [DOI]
- 4 Application of Replacement Theory in Determination of Pavement Design Life
- 5 Optimal replacement in a system of n-machines with random horizon [DOI]
- 6 Optimal Maintenance Policies for Power Equipment [DOI]
Cited by 0
No indexed citations yet.
Related research
Article metrics
Real usage data collected on this platform.
0
Page views
0
PDF downloads
0
Outbound clicks
0
Citations
Views by country
Approximate, from request IP at view time — not citizenship or institution. Countries with fewer than 5 views are grouped as "Other".
No views recorded yet.
Traffic sources
Referring site, by host.
No traffic recorded yet.
Views and downloads exclude known bots/crawlers. Citations combines this platform's own DOI-resolved index with each external source's own reported total — see Cited by above for individually listed citing works. Last refreshed 0 seconds ago.