Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 5 Intan Bhd. has furnished the following information to prepare its cash budget for the second quarter of year 2023: Month Sales (units)

image text in transcribedimage text in transcribed

Question 5 Intan Bhd. has furnished the following information to prepare its cash budget for the second quarter of year 2023: Month Sales (units) Purchases Wages and Overheads (RM) (RM) salaries (RM) January 5,500 16,000 10,000 5,000 February 5,400 20,000 12,000 5,000 March 5,600 18,000 12,000 5,000 April 4,000 16,000 12,000 4,000 May 4,500 14,000 14,000 4,000 June 3,800 14,000 14,000 4,000 Additional information: 1. Opening cash balance in April 2023 is expected to be RM26,000. The selling price for each unit is RM4. 2. 3. 4. 5. 10% of the total sales are cash sales. 30% of the credit sales will be paid one month after sales and the remaining balance will be paid two months after sales. 25% of purchases will be paid in the month of purchase and the remaining balance will be paid the following month of purchase. Wages and salaries are to be paid 60% in the month incurred and the remaining balance will be paid in the following month. Overheads are to be paid in the month incurred. The depreciation for machinery is RM1,000 per month. Required: a) Prepare the Schedule of Cash Collections from sales for April, May and June. (10 marks) b) Prepare the Cash Budget for April, May and June using the format provided below. April May Beginning cash balances Add: Cash receipts Cash collection from sales Other cash received Less: Cash payments Cash payment to suppliers (purchases of materials) Payment for other expenses Ending cash balances June

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

Survey of Accounting

Authors: Carl S Warren

5th Edition

9780538489737, 538749091, 538489731, 978-0538749091

More Books

Students also viewed these Accounting questions