Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION I The following is the information of Star Millenia Pte. Ltd. For the second half of 2021 Raw Production Administrative Sales materials Wages overhead

image text in transcribed
QUESTION I The following is the information of Star Millenia Pte. Ltd. For the second half of 2021 Raw Production Administrative Sales materials Wages overhead Month and Selling (RM) (RM) (RM) June (RM) (RM) 9,000 5.400 1.950 675 July 480 9.750 6,000 2.250 765 480 August 10,500 7,200 2,250 750 525 September 11.250 6,750 2.250 900 October 525 12.000 6,900 2,400 900 600 November 12.750 7,500 2,700 1,050 December 600 13.200 7,800 3.000 1.050 675 Additional information: a. Assume the cash and bank balance on 1 October 2021 is RM4.500. b. Ten percent of sales are made on cash. For credit sales, 50% percent are paid in third month following the sales and the remainder in the fourth month. C. Materials are paid in the third month of purchase. d. Three-fourths (3/4) of wages are paid in the month incurred and one-fourth (1/4) in the following month e. One half of the production overheads are paid as incurred and the balance in the following month f. Administrative and selling expenses are paid as incurred. g. The company plans to pay cash dividends of RM7,500 on 1 December 2021. h. Income tax (advance) is to be paid in December for RM1,500. i. Plant and machinery at a cost of RM7,200 is to be installed in August 2021. It will be paid for by monthly instalments of RM1,500 starting from 1 October 2021. j. In order to ensure the company is always able to pay for its short term obligations, the company would like to keep monthly ending cash balance of RM2,000. k. The company enjoys an open line credit facility from its bank up to a maximum of RM15,000 at a profit of 2% per annum. Any profit associated with a financing will be paid together with the repayment of the principal. Required: From the information given, prepare: a. a schedule of cash receipts from sales for the three months ending 31 December 2021. (7 marks) b. a cash budget for the three months ending 31 December 2021 and the total for the months. (15 marks) c. a note to discuss briefly the benefits of cash budgets for businesses. (3 marks [TOTAL: 25 MARKS

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Financial Accounting

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso

9th Edition

1118334329, 978-1118334324

More Books

Students also viewed these Accounting questions