Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

A. The Bake with Joy Company has requested a cash budget for June. After examining the records of the company, you find the followings: 1.

image text in transcribed

A. The Bake with Joy Company has requested a cash budget for June. After examining the records of the company, you find the followings: 1. Cash balance on 1 June is RM35,560. 2. Actual sales for April and May are as follows: Cash sales Credit sales Total sales April RM 12,800 24.700 37,500 May RM 14,200 32,600 46,800 3. Credit sales are collected over a three-month period: 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 3% 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, 40% are paid for in the month of purchase. The remaining 60% are paid for in the following month. 5. Salaries and wages total RM12,500 per month. 6. The company received interest from the fixed deposit accounts of RM30,000 in June. 7. Taxes to be paid in June are RM5,200. 8. Rental expenses are RM4,240 per month. 9. The administrative expense for June is RM15,000 including RM2,000 for depreciation. The owner also tells you that he expects cash sales of RM19,100 and credit sales of RM43,500 for June. 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: a) A schedule of collections received from customers for the month of June. (5 marks) b) A schedule of payments to suppliers for the month of June. (5 marks) c) A Cash Budget for the month of June. (10 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

Managerial Accounting A Focus on Ethical Decision Making

Authors: Steve Jackson, Roby Sawyers, Greg Jenkins

5th edition

978-0324663853

Students also viewed these Accounting questions