One Million Three Hundred and Sixteen Thousand, Eight hundred and Fifty Eight Dollars
You have immediate and unrestricted access .
You are the project engineer for this job and report to the company General Manager Construction, who has control of the allowances, contingency and profit margin (i.e. 26% mark-up included in the Contract Price).The Chief Financial Officer of the company has issued you with the following budget for which you are to control expenditure for the project:
Prime Cost (PC) expenditures are nominated by the owner and are for the values and at the intervals indicated in Table 1 above. PC sums are paid by your company to the relevant subcontractor in the week shown in T Those amounts are then claimed from the Owner in the month paid (Table 1) and your company receives payment one month later.
the Principal has agreed that it will pay monthly claims, within 30 days of receiving an approved certified payment certificate and invoice. It takes an average of 2 weeks from the end of a month for the company’s supervisor to measure the work and submit a progress claim to the client and it will take the client’s manager a further 2 weeks to certify the payment.
The defects liability period on this contract is 26 weeks from contract practical completion.
The contract form is AS4000, cash retention is 10% (the company is not able to obtain bank guarantees to allow payment in full) and will be retained to the end of the defects liability period of 26 weeks. See the attached extract from AS4000.
Your company prides itself on paying trade subcontractors and material suppliers within 14 days of an invoice and invoices are generally received within 7 days of material supply or work done. As a result the company has loyal, well established and reliable suppliers and subcontractors.
The accounting department advises that employees are paid fortnightly and the average accrual period for expenses is 3 weeks.
Most subcontractors are small businesses and they submit weekly claims for payment.
The bank charges your company an interest rate on the outstanding cash flow of 10.4% (on overdrafts) and zero % on positive balances.
The forecast expenditure for the project (without the PC items) follows an ‘S’ Curve (Sigmoid function) with the characteristics listed in Table 2.
The table of weekly Paid and Earned cost was supplied by the project scheduler and is in terms of the value of work done (Paid cost to suppliers and subcontractors) and the value of work earned priced at the contract payment rate, as set out in Table 2.
Assignment Requirements – What You Need to Do:
Prepare a brief (2 pages) report in Memorandum format to the Construction Manger explaining the Cash flow expected for this project including the following information:
Notification of the maximum amount of bridging finance required to cover negative expenditure and the week at which that will occur.
Total expected cost of finance through to completion.
The week in which you expect the project to attain a positive cash flow.
Contractors expenses and income as ‘S’ curves on a single graph.
Contractor's Cumulative Cash flow as a graph and in an attached table.
You are to prepare a professional excel model as supporting documentation for this analysis and submit this on Blackboard with your Memorandum.
You will be assessed on both the excel model and the memorandum.
project management assignment help, business management assignment help, business management assignment, management assignment help services, strategic management assignment help, management accounting assignment, management homework help, marketing management assignment help, human resource assignment help, human resource management assignment help, managerial accounting assignment help, management accounting assignment help, financial management assignment help, it management assignment help, project management homework help, hospitality management assignment help, hr management assignment help, operations management homework help, brand management assignment help, database management homework help