The
information provided from the last chapter statistical-budgeting System
is summarised in cost per metre square per technology.
In this chapter we show its application in financial terms to
the income levels of the community, interest rate on loan, years of payments and
monthly payments.
The reference data used in this chapter has been taken from the
project "Programa de vivienda para el sur de Machala, Ecuador 1993"
|
Sucres
|
US Dollar
|
Dollar
rate at June 1993
|
1,950.oo
|
1.oo
|
Minimum
monthly income salary
|
117,000.oo
|
60.oo
|
Total
cost of house
|
11,470,439.oo
|
5,882.28
|
|
|
|
House
floor area:
|
|
71.oo
m2
|
Total
families involved in the project
|
|
250
|
Two applications are proposed:
1 Graphical Variable Correlations
2 Trade-off Technologies for affordability and cost recovery
Software
|
Graphical Variable Correlations
Correlations between
technological alternatives, affordability, cost recovery and income
categories provide a graphical method.
This graph provides the flexibility of starting from any
entry or variable.
The entries are represented on "X" and
"y" axes, the variables are represented on
converging axes.
For the graphical representation (charts) the software is
based on Claris Cad® version 2.02 and for the animation on Microsoft
Power Point 3.0. |
|
Trade-off Software
This is a software
with five spreadsheets-Charts. They are interlinked with two input
spreadsheets. This software uses the same information as the graphical
variable correlations but provides the exact output figures for each
input. |
|