Case Study D: Free Choice Project Management Company Project Completion (Cont. from case study A, B and C)

Below are the notes taken during the project to create a greener space outside of the organizations buildings. The project is now complete, and you have been asked to provide a basic financial report.

As a reminder, initial estimations totaled $27,970, and the organization allowed $30,000 as the budget.

Concrete removal:

specialist company successfully broke up existing concrete within the estimated timeframe, cost $6,500 as agreed

removal company underestimated the amount of concrete to be removed and required an extra day with another available lorry, extra $600 ($4,000 total)

signage and safety issues implemented according to legislation; noise kept to a minimum during work hours

all signage required cost $100 ($155 estimated)

colleagues volunteered time to help lorries access the area

Turf/lawn:

50m turf ($1,750) and 50m topsoil/labour ($750) as agreed

turf labour increased by three days due to bad weather, budgeted $900 (actual cost $1,350)

Planting:

plant order (465 plants) large enough to warrant discount, budgeted $3,325 (actual cost $3,000)

planting company needed four days to complete project (budgeted $750, cost $600)

sprinkler system, installation and connection totalled $680 (as budgeted)

new costing required for ongoing utility charges (water, $65 extra per month)

Paving:

30m paving purchased ($1,260) and 5m not required (return value $210)

paving specialist company required for four days ($880 as agreed)

Shaded area:

changed material as recommended by specialist, new cost is $20 per m (20m)

6 x wooden posts ($35 each)

shading installation required further digging work, new cost $350 (estimated $290)

shading fixings came in at $255 (estimated $135)

3 x benches ($1,000), 20 x chairs ($3,500), 5 x tables ($1,500) budgeted $5,500

Other:

project manager worked extra 10 hours over the agreed 25 ($45 per hour).

USING THE CASE STUDY ABOVE PLEASE ANSWER ONLY THIS QUESTION.

Question 1:

Using the information provided in case study D, complete a financial report by using the following template:

Guideline: the learner is provided an example answer in the orange letters below table

Project Phase	Budgeted Cost	Actual Cost	Comments
Concrete removal	$9,900	$10,500	Removal company required extra day
Turf/lawn
Planting
Paving
Shaded area
Other

I will upvote you if ypu provide with a complete answer of this question.