Starting Age Zero-Based Excel Automation of Optimal Policy Prescriptions and Returns for Machine Replacement Problems with Stationary Data and Age Transition Perspectives
Journal of Scientific Research and Reports · pp. 1–11 · Published 21 May 2016
10.9734/JSRR/2016/26134Abstract
Aim: This investigation aimed at automating the computations of optimal replacement policies and rewards for a class of equipment replacement problems with zero starting age, based on age perspectives and stationary pertinent data. Methodology: The aim was achieved by the exploitation of the structure of the states given as functions of the decision periods, in age-transition dynamic programming recursions. Results: Optimal Excel interface and solution implementation templates were designed and automated for the determination of the optimal replacement policies in machine replacement problems, with pertinent data given only as a function of 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 exploited for sensitivity analyses on such models, paving the way for the solutions of practical and large-scale problems.
References (8)
- 1 Operations Research -- An Introduction [DOI]
- 2 Operations research : applications and algorithms
- 3 A Stochastic Dynamic Programming Approach for the Equipment Replacement Optimization under Uncertainty [DOI]
- 4 Application of the Equipment Replacement Dynamic Programming Model in Conveyor Belt Replacement: Case Study of a Gold Mining Company [DOI]
- 5 Equipment Replacement Decision Making:Opportunities and Challenges [DOI]
- 6 A Reward Functional to Solve the Replacement Problem [DOI]
- 7 An Iterative Decision Rule to minimize cost of Acceptance Sampling Plan in Machine Replacement Problem [DOI]
- 8 Alternative Layout and Automation of Optimality Results for Machine Replacement Problems Based On Stationary Data and Age Transition Perspectives [DOI]
Cited by 1
C. Ukwu, Freeda Ibrahim Dazel, Imegi Johnmac Ozemelah · 2017
Related research
- Colorectal Cancer Risk and Prevention Knowledge among Adults Attending Public Health Facilities in Obudu, Cross River State, Nigeria — shares topic coverage
- Awareness of Causes and Health Risks Associated with High Blood Cholesterol among Men in Awka Etiti, Anambra State, Nigeria — shares topic coverage
- Effects of Age and Sex on the Healing of Acetic-Acid Induced Ulcerative Colitis in Adult Wistar Rats — shares topic coverage
- Demographic Factors and Bystander CPR in Nigerian Athletes — shares topic coverage
- Impact of Age and Marital Status of Orthodontic Patients on their Satisfaction with Duration of Treatment, Perception and Attitude towards Accelerated Orthodontics — shares topic coverage
Article metrics
Real usage data collected on this platform.
55
Page views
0
PDF downloads
23
Outbound clicks
1
Citations
Views over time
Views by country
Approximate, from request IP at view time — not citizenship or institution. Countries with fewer than 5 views are grouped as "Other".
Traffic sources
Referring site, by host.
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.