please help with the attached question. (time phased budget for project management)

You are the project manager on a home renovation project. You are still in the planning phase of the project. The network diagram has been drawn up and you now have to do the cost estimates in order to compile a time phased budget. The following information is available: NETWORK DIAGRAM: 0 5 B 15 15 D 20 5 days 10 days 5 days 0 5 15 15 20 5 C 10 5 days Key 5 10 ES EF LS LF GENERAL COST INFORMATION: Refer below for an extract of a price list from the preferred supplier of building materials: Product Unit of Price measure Cement 60 kg R70 Building 1.5 m3 R450 sand Bricks Pallet R800 Tiles m2 R250 Tile 1 kg R48 cement Labour rates: Labour grade Grade 1 Grade 2 Grade 3 Rate R360 per day R40 per hour R30 per hour 15 ADDITIONAL INFORMATION ON ACTIVITIES: . 0 Activity A requires the following: Thirty (30) hours Grade 1 labour in total used evenly over the duration of the activity; Three (3) Grade 3 labourers per day for the duration of this activity; Rental of specialised equipment amounting to R2 200 for the entire activity; A sub-contractor that has provided a valid quotation for work required amounting to R5 100. O . . . . O . . Activity B requires the following: Fifty (50) hours Grade 1 labour used evenly over the duration of the activity. Ten (10) hours Grade 2 labour in the first week and 5 in the second week. One hundred and sixty (160) hours Grade 3 labour used evenly over the duration of the activity; The following materials used evenly over the duration of the activity: o 720kg of cement; 12 m3 of building sand; o 6 pallets of clay bricks Activity C requires the following: Twenty (20) hours Grade 1 labour in total; Eighty (80) hours Grade 2 labour in total; Forty (40) hours Grade 3 labour in total; Materials costing R14 000 used evenly over the duration of the activity. Activity D requires the following: Thirty (30) hours Grade 1 labour in total used evenly over the duration of the activity; Ninety (90) hours Grade 2 labour in total used evenly over the duration of the activity; Seventy (70) hours Grade 3 labour in total used evenly over the duration of the activity; The following materials used evenly over the duration of the activity o 85m2 of tiles o 5kg of tile cement INDIRECT COST - PROJECT OVERHEADS: In addition to the direct cost described per activity, the following indirect cost will be incurred for this project only: Fuel and other travel cost: R5 400 Rental of machinery: R8 450 General material: R2 200 . . . . BILLING: The total bill for the project to the client amounts to R120 000. A 10% deposit is required upfront, followed by four (4) equal payments at the end of each week of the project. . . ASSUME THE FOLLOWING: Each work week consists of 5 days, each work day consists of 8 hours; The company assigns General and Administrative expenses as at a rate of 8% of total direct labour cost; Labourers are paid at the end of each week. Rental fees are payable at the end of the week in which it is incurred. Where no additional information is provided, you may assume that all cost are incurred equally throughout the period to which it pertains. Sub-Contractors are paid once their work have been completed. Project overheads (indirect cost) are allocated to activities proportionate to total direct cost. As insufficient information is provided regarding the timing of the cash flows of indirect expenses, you may assume that the cash flows occur in the period that it is assigned. . . . YOU ARE REQUIRED TO: Based on the information above compile a weekly time phased budget (cost and income) for the project. PLEASE SHOW ALL CACULATIONS QUESTION 3 (10 marks) Your company has been awarded a contract to do the road markings of a road through the Groot Karoo. The distance that has to be marked is 210 kilometres and the estimated cost of the entire project is R441 000. The project has to be delivered within 35 work days. On day 24, 156km has been completed at a total cost of R335 400. YOU ARE REQUIRED TO: A. Determine the planned Value on day 24; B. Determine the Earned Value on day 24; C. Determine the Schedule Variance (in Rand); D. Determine the Time Variance in (in days); E. Determine the Cost Variance. PLEASE SHOW ALL CACULATIONS