Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is financial statement analysis subject.. Its really urgent.. Plz help me The Housing Department of Kolea (DBK) has invited tenders to re-roofing 150 houses

This is financial statement analysis subject.. Its really urgent.. Plz help me
image text in transcribed
image text in transcribed
image text in transcribed
The Housing Department of Kolea (DBK) has invited tenders 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 RM RM Fixed assets (net book value) Inventories and work in progress Debtors Bank Creditors Dividend Loan Total 55,400 26,700 69,300 -11.000 -92,600 0 1,542,400 149,000 130,800 10,400 - 40.600 -97.800 -800,000 800,200 RM 2,906,800 449,200 240,600 -6/200 -279,600 -70,000 -1,200,000 2040,800 47,800 Capital Ordinary shares @ RM1 each Reserves 47,800 0 0 0 250,000 550, 200 800,200 1,000,000 1,040,800 2,040.800 Total 47,800 Profit and loss account for year ended 30 June 2020 ATS BTS CTS RM RM Turnover Direct costs Other operating costs Interest 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 Profit before taxation 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 appropriate 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 capitol 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 KTS RM 401,400 250,000 Labour CTS RM 380 400 290,000 BTS RM 453,600 230,000 Materials Overheads (including profit) TOTAL 124, 600 154,450 128,700 156.100 798,600 805,850 812,300 826,500 The DBK Tender Committee con reject tenders on financial and/or quality grounds. However each tender must be approised on these criteria and reasons for acceptance or rejection must be justified in the oppraisal process 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) b. A draft report to the committee evaluating the tender bids and recommending to whom the contract should be awarded. The report must cover evaluation on the financial aspect and performance risk of all the tenderers. Discuss the justification and additional approval terms (if any) for a successful tenderen (25 marks) (TOTAL 40 MARKS)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Governmental and Nonprofit Accounting

Authors: Robert Freeman, Craig Shoulders, Gregory Allison, Robert Smi

10th edition

132751267, 978-0132751261

Students also viewed these Accounting questions

Question

What was the positive value of Max Weber's model of "bureaucracy?"

Answered: 1 week ago