Modernization of the Economic Price Adjustment Software

Authors: Roger L Goodwin

Abstract:

The US Consumer Price Indices (CPIs) measures hundreds of items in the US economy. Many social programs and government benefits index to the CPIs. The purpose of this project is to modernize an existing process. This paper will show the development of a small, visual, software product that documents the Economic Price Adjustment (EPA) for longterm contracts. The existing workbook does not provide the flexibility to calculate EPAs where the base-month and the option-month are different. Nor does the workbook provide automated error checking. The small, visual, software product provides the additional flexibility and error checking. This paper presents the feedback to project.

Keywords: Consumer Price Index, Economic Price Adjustment, contracts, visualization tools, database, reports, forms, event procedures.

Digital Object Identifier (DOI): doi.org/10.5281/zenodo.1106891

References:

[1] N. Aliane, ”Spreadsheet-based control system analysis and design (Focus on Education),” Control Systems, IEEE, Vol 28, Issue 5, September 19, 2008, page 108.
[2] M. J. Boskin, E. R. Dulberger, R. J. Gordon, Z. Grilliches, and D. W. Jorgenson, ”Toward a More Accurate Measure of the Cost of Living,” Final Report to the Senate Finance Commitee, December 4, 1996.
[3] R. Bradley, ”Analytical Bias Reduction for Small Samples in the U.S. Consumer Price Index,” Journal of Business & Economic Statistics, Vol. 25, No. 3 (Jul., 2007), pp. 337-346.
[4] G. Deltas and E. Zacharias, ”Sampling Frequency and the Comparison between Matched-Model and Hedonic Regression Price Indexes,” Journal of Business & Economic Statistics, Vol. 22, No. 1 (Jan., 2004), pp. 94-106.
[5] F. G. Forsyth and R. F. Fowler, ”The Theory and Practice of Chain Price Index Numbers,” Journal of the Royal Statistical Society, Series A (General), Vol. 144, No. 2 (1981), pp. 224-246.
[6] D. W. Jorgenson and D. T. Slesnick, ”Indexing Government Programs for Changes in the Cost of Living,” Journal of Business & Economic Statistics, Vol. 17, No. 2 (Apr., 1999), pp. 170-181.
[7] H. M. P. Kersten, ”Nonresponse Assessment of a Consumer Price Index,” Journal of Business & Economic Statistics, Vol. 3, No. 4 (Oct., 1985), pp. 336-343.
[8] B. R. Moulton and K. J. Stewart, ”An Overview of Experimental U.S. Consumer Price Indexes,” Journal of Business & Economic Statistics, Vol. 17, No. 2 (Apr., 1999), pp. 141-151.
[9] S. Rudolph, A. Savikhin, D. S. Ebert,”FinVis: Applied visual analytics for personal financial planning,” Visual Analytics Science and Technology, October 12-13, 2009, pages 195- 202.
[10] U.S. Government Printing Office, http: // www. gpo. gov/ vendors/ index.htm.