PROGRAMME Higher Certificate in Project Management MODULE Project Schedule, Cost and Budget Control YEAR One (1) INTAKE Jan2023 Intake TOTAL MARKS 60 SECTION A Answer ALL the questions in this section. [60 MARKS] QUESTION 1 (20 Marks) REQUIRED Prepare the Cash Budget for a project of Mega Enterprises for the period 01 June 2023 to 31 August 2023. (Note: The Cash budget must reflect separate monetary columns for each month.) INFORMATION The following budgeted information was supplied by Mega Enterprises for one of its projects: 1. A favourable bank balance of R200 000 is expected on 31 May 2023. 2. The expected monthly sales are as follows: Units May 4 000 June 6 000 July 6 500 August 5 000 The selling price per unit is R300. All the units produced are sold in the same month. 3. Cash sales usually make up 60% of the total sales. The balance of the sales is on credit. Debtors pay in the month after the sale. 4. Material purchases are expected to be as follows: May R480 000 June R600 000 July R640 000 August R540 000 Forty percent (40%) of the material purchases is for cash and balance is paid for in the following month. 5. Labour costs amount to R70 per unit and are paid in the month in which they are incurred. 6. Manufacturing overheads are budgeted at R74 000 per month, excluding R6 000 for depreciation on machinery. Manufacturing overheads are payable in the month in which they are incurred. 7. Selling and administrative costs contain a fixed portion of R80 000 per month and a variable component of 20% of the monthly sales value. These costs are paid by the end of the applicable month. 8. Equipment with a cost price of R700 000 is to be purchased during June 2023. A deposit of 20% of the purchase price will be paid in the month of the purchase and the balance plus finance charges of R40 000 will be paid in twelve equal monthly instalments commencing July 2023. 9. Ten percent (10%) of the sales value for each month will be invested in the following month. QUESTION 2 (20 Marks) REQUIRED Use the information provided below to calculate the following independently: 2.1 Total Marginal Income and Net Profit/Loss (4 marks) 2.2 Break-even value (4 marks) 2.3 Selling price per unit that will enable the project to break even (4 marks) 2.4 Total Marginal Income and Net Profit/Loss if the variable manufacturing costs increase by 5% (4 marks) 2.5 Break-even quantity if the selling price drops by 10%. (4 marks) INFORMATION Caprice Limited plans to start Project Midas and the following are the forecasts for 2024: Sales 50 000 units at R60 per unit Direct materials cost per unit R16 Direct labour cost per unit R14 Variable selling costs per unit 10% of the sales price Manufacturing overhead costs (all fixed) R400 000 Fixed selling and administrative costs R560 000 QUESTION 3 (20 Marks) REQUIRED Use the information provided below to calculate the following: 3.1 Payback Period (expressed in years, months and days) (3 marks) 3.2 Accounting Rate of Return on average investment (expressed to two decimal places) (5 marks) 3.3 Net Present Value (4 marks) 3.4 Net Benefit Cost Ratio (expressed to two decimal places) (3 marks) 3.5 Internal Rate of Return (expressed to two decimal places) using interpolation if the net cash flows are R300 000 per year for five years. (5 marks) INFORMATION An investment in a project has the following net cash flows and net profits: Year Net cash flows Net profit 0 (R1 000 000) 1 R220 000 R20 000 2 R210 000 R10 000 3 R450 000 R250 000 4 R320 000 R120 000 5 R470 000 R270 000 The project has no scrap value. The minimum required rate of return is 12%.