Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is financial statment analysis subject.. Plz help me.. the marks is very high.. 15 marks.. plz The Housing Department of Kolea (DBK) has invited
This is financial statment analysis subject.. Plz help me.. the marks is very high.. 15 marks.. plz
The Housing Department of Kolea (DBK) has invited fenders to re-roofing 150 houses on an estate. KTS Construction Company (KTS) is one of the DBK 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 DBK has been able to narrow the choice of contractor to the four tenderers who have submitted the lowest bids as follows. Company ATS KTS BTS CTS 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 ATS BTS CTS Fixed assets (net book value) Inventories and work in progress Debtors Bank Creditors Dividend Loan Total RM 55 400 26,700 69,300 -17,000 -92,600 0 0 47 800 RM 1,542,400 149,000 130,800 10,400 -140.600 -91,800 -800.000 800,200 RM 2,906,800 449,200 240,600 +6.200 -279,600 -70,000 -1,200,000 2,040,800 Capital Ordinary shares @ RM1 each Reserves 47,800 0 0 47,800 0 250.000 550,200 800,200 0 1,000,000 1,040,800 2,040,800 Total Profit and loss account for year ended 30 June 2020 ATS BTS CTS RM RM Turnover Direct costs Other operating costs Interest Profit before taxation 611,600 -410,000 - 165,000 RM 1,741,200 -1,190,600 -211,800 -85,000 253,800 3,080,400 -1,734,800 -811,200 -96,000 438,400 36,600 ATS employs six operatives and has been used by DBK for 4 small maintenance contracts worth between RM60,000 and RM75,000 which they have completed to an approprate standard. DBK has employed BTS on a contract to replace flat roofs on the apartment block, but there have been numerous complaints about the standard of the work. CTS 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. KTS 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 KTS's manager has successfully renegotiated more beneficial service level agreements with DBK with effect from 1 July 2020. KTS 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 KTS'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 ATS RM 384.000 290,000 RTS RM 401,400 250.000 BTS RM 453,600 230,000 CTS RM 380,400 290,000 Labour Matenals Overheads (including profit) TOTAL 124.600 154 450 128.700 156 100 798,600 805,850 812 300 826,500 The DBK 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. 6/7 In your capacity as Finance Director responsible for reporting to the DBK 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) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started