You have 10 minutes for this test. You must provide us at the end of this time with an excel sheet, which will be printed. After you will have finished the test, we will discuss with you about your answers.

Part One:

 
A_C_T_E_D have foreseen the spending of 350,000 USD on different lines directly related to these activities.  As part of its primary budget forecasting, the allocation of funds were as following:

_30% on pipeline extension,

_25% on distribution of water tanks,

_35% on distribution of waste metallic containers,

_10% on support staff and cost.

1)      By using Excel, please precise the amount to be allocated to each of these lines.

After a call for tender, two contractors P1 and P2 were chosen on a 40%-60% basis for the activity “pipeline”. In accordance with A_C_T_E_D policies, it was decided to pay at the end of the week an advance which reaches 10% of the amount of the contract. Once 30% of work has been achieved at the end of the month, a further 25% would be paid.

2)      Precise, for each contractor, the amount to be paid at the end of the week and the amount foreseen to be paid at the end of the month.

Part Two:

How would you enter the following transactions on a cash flow excel sheet:

• Balance is 5,000USD on August 1^st, 2006.
• A_C_T_E_D received an installment from one of its donors amounting up to 10,000 USD on August 15^th.
• A_C_T_E_D paid to one of its contractors a further 30% installment (total amount of the contract 75,000 USD) on August 2^nd.
• A_C_T_E_D paid for the office monthly rent an amount of 1,020 JOD (exchange rate: 1USD = 0.709JOD), on August 10^th.

3)      What is the balance at the end of the month?