Question
The following is the information of Star Millenia Pte. Ltd. For the second half of 2021: Month Sales (RM) Raw materials (RM) Wages (RM) Production
The following is the information of Star Millenia Pte. Ltd. For the second half of 2021:
Month
Sales (RM)
Raw materials (RM)
Wages (RM)
Production overhead (RM)
Administrative and Selling (RM) June 9,000 5,400 1,950 675 480 July 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 525 October 12,000 6,900 2,400 900 600 November 12,750 7,500 2,700 1,050 600 December 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.
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