2 A. The Rilex and Chill Coffee Shop has requested a cash budget for August. After examining the records of the company, you find the following: 1. Cash balance on 1 August is RM43,280. 2. Actual sales for June and July are as follows: June RM July RM Cash sales 10,200 14,700 Credit sales 26,100 33,900 Total sales 36,300 48,600 3. Credit sales are collected over three months: 30% in the month of sales, 40% in the second month, and 25% in the third month. The customers who paid in the month of sales are qualified for 3% discounts on the amount owed. While the sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. 4. Inventory purchases average 80% of a month's total sales. Of those purchases, 60% are paid for in the month of purchase. The remaining 40% is paid for in the following month. 5. Salaries and wages total RM13,800 per month. 6. The company received interest from the fixed deposit accounts of RM30,000 in August. 7. Taxes to be paid in August are RM5,200. 8. During August, an old piece of furniture has been sold for RM3,400 and the new one has been purchased for RM5,200. 9. Rental expenses are RM3,400 per month. 10. The administrative expense for August is RM15,000 including RM1,800 for depreciation. The owner also tells you that he expects cash sales of RM19,800 and credit sales of RM44,800 for August. No minimum cash balance is required. The owner of the company doesn't have access to short-term loans. Required: Using the information above, prepare: i. A schedule of collections received from customers. (5 marks) ii. A schedule of payments to suppliers. (5 marks) iii. A Cash Budget. (10 marks) (Note: Round up all figures to the nearest integer numbers). 5 B. The Amazing Company has budgeted the following unit sales: 2022 Units January 23,000 February 12,000 March 15,800 April 14,000 May 25,200 The finished goods units in hand on December 31, 2021, were 1,500 units. Each unit requires 3 kg of raw material which is estimated to cost an average of RM3.80 per kg. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 10% of next month's anticipated sales. They also have a policy of maintaining a raw materials inventory at the end of each month equal to 20% of the kg needed for the following month's production. There was 10,200 kg of raw materials on hand on December 31, 2021. Required: Using the information above, prepare: A Production Budget for the first quarter of 2022. ii. A Direct Material Budget for the first quarter of 2022. (Note: Round up all figures to the nearest integer numbers). (5 marks) (10 marks) (Total: 35 Marks)