Modernization of the Economic Price Adjustment Software

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.

Authors:

• Roger L Goodwin

Keywords:

• Consumer Price Index
• Economic Price Adjustment
• contracts
• visualization tools
• database
• reports
• forms
• event procedures.

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.