The Housing Department of Lanit (DBL) has invited tenders to re-roofing 150 houses on an estate. Gonit Construction Company (GCC) is one of the DBL registered vendors and has submitted a tender for this contract. At the same time, several contractors from the private sector have also submitted their tender. DBL has been able to narrow the choice of contractor to the four tenderers who have submitted the lowest bids as follows: Company MBE GCC PJSB AHSB RM 798,600 805,850 812,300 826,500 The tender evaluation process requires that the three private tenderers be appraised based on financial soundness and work quality. These tenderers were required to provide their latest final accounts year ended 30 June 2020 for this appraisal. Details of the account are as follows: Statement of Financial Position as at 30 June 2020 MBE PJSD AHSD RM Fixed assets (net book value) Inventories and work in progress Debtors Bank Creditors Dividend Loan Total RM 55,400 26,700 69,300 -11,000 -92,600 0 0 RM 1,542,400 149,000 130,800 10,400 -140,600 -91,800 -800,000 800,200 2,906,800 449,200 240,600 -6,200 -279,600 -70,000 -1,200,000 2,040,800 47,800 Capital Ordinary shares @ RM1 each Reserves Total 47,800 0 0 0 250,000 550,200 800,200 0 1,000,000 1,040,800 2,040,800 47,800 Profit and loss account for year ended 30 June 2020 MBE PJSB AHSB RM Turnover Direct costs Other operating costs Interest Profit before taxation RM 611,600 -410,000 -165,000 1,741,200 -1,190,600 -211,800 -85,000 253,800 RM 3,080,400 -1,734,800 -811,200 -96,000 438,400 36,600 MBE employs six operatives and has been used by DBL for four small maintenance contracts worth between RM60,000 and RM75,000 which they have completed to an appropriate standard. DBL has employed PJSB on a contract to replace flat roofs on the apartment block, but there have been numerous complaints about the standard of the work. AHSB is a company that the council has not employed in the past, and, as much of its work has been carried out elsewhere, its quality of work is not known. GCC has been suffering from the effects of increasing competition in recent years and achieved a return on capital employed of only 3.5% in the previous financial year. GCC's manager has successfully renegotiated more beneficial service level agreements with DBL with effect from 1 July 2020. GCC has also reviewed its fixed asset base, which has resulted in the disposal of a depot which was surplus to a requirement and in the rationalization of vehicles and plant. The consequence of this is that GCC's average capital employed for next year is likely to be 15% lower than the latest the year 2020. Further analysis of the tender bids is provided below: MBE RM 384,000 290,000 GCC RM 401,400 250,000 PJSB RM 453,600 230,000 AHSB RM 380,400 290,000 Labour Materials Overheads (including profit) TOTAL 124,600 154,450 128,700 156, 100 798,600 805,850 812,300 826,500 The DBI Tender Committee can reject tenders on financial and/or quality grounds. However, each tender must be appraised on these criteria and reasons for acceptance or rejection must be justified in the appraisal process. In your capacity as Finance Director responsible for reporting to the DBL Tender Committee, you are required to prepare the followings: a. A common size statement of both profit and loss account and statement of financial position for all three tenderers. Examine the results and discuss your findings. (15 marks) The Housing Department of Lanit (DBL) has invited tenders to re-roofing 150 houses on an estate. Gonit Construction Company (GCC) is one of the DBL registered vendors and has submitted a tender for this contract. At the same time, several contractors from the private sector have also submitted their tender. DBL has been able to narrow the choice of contractor to the four tenderers who have submitted the lowest bids as follows: Company MBE GCC PJSB AHSB RM 798,600 805,850 812,300 826,500 The tender evaluation process requires that the three private tenderers be appraised based on financial soundness and work quality. These tenderers were required to provide their latest final accounts year ended 30 June 2020 for this appraisal. Details of the account are as follows: Statement of Financial Position as at 30 June 2020 MBE PJSD AHSD RM Fixed assets (net book value) Inventories and work in progress Debtors Bank Creditors Dividend Loan Total RM 55,400 26,700 69,300 -11,000 -92,600 0 0 RM 1,542,400 149,000 130,800 10,400 -140,600 -91,800 -800,000 800,200 2,906,800 449,200 240,600 -6,200 -279,600 -70,000 -1,200,000 2,040,800 47,800 Capital Ordinary shares @ RM1 each Reserves Total 47,800 0 0 0 250,000 550,200 800,200 0 1,000,000 1,040,800 2,040,800 47,800 Profit and loss account for year ended 30 June 2020 MBE PJSB AHSB RM Turnover Direct costs Other operating costs Interest Profit before taxation RM 611,600 -410,000 -165,000 1,741,200 -1,190,600 -211,800 -85,000 253,800 RM 3,080,400 -1,734,800 -811,200 -96,000 438,400 36,600 MBE employs six operatives and has been used by DBL for four small maintenance contracts worth between RM60,000 and RM75,000 which they have completed to an appropriate standard. DBL has employed PJSB on a contract to replace flat roofs on the apartment block, but there have been numerous complaints about the standard of the work. AHSB is a company that the council has not employed in the past, and, as much of its work has been carried out elsewhere, its quality of work is not known. GCC has been suffering from the effects of increasing competition in recent years and achieved a return on capital employed of only 3.5% in the previous financial year. GCC's manager has successfully renegotiated more beneficial service level agreements with DBL with effect from 1 July 2020. GCC has also reviewed its fixed asset base, which has resulted in the disposal of a depot which was surplus to a requirement and in the rationalization of vehicles and plant. The consequence of this is that GCC's average capital employed for next year is likely to be 15% lower than the latest the year 2020. Further analysis of the tender bids is provided below: MBE RM 384,000 290,000 GCC RM 401,400 250,000 PJSB RM 453,600 230,000 AHSB RM 380,400 290,000 Labour Materials Overheads (including profit) TOTAL 124,600 154,450 128,700 156, 100 798,600 805,850 812,300 826,500 The DBI Tender Committee can reject tenders on financial and/or quality grounds. However, each tender must be appraised on these criteria and reasons for acceptance or rejection must be justified in the appraisal process. In your capacity as Finance Director responsible for reporting to the DBL Tender Committee, you are required to prepare the followings: a. A common size statement of both profit and loss account and statement of financial position for all three tenderers. Examine the results and discuss your findings. (15 marks)