Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Mr. Justin, a director of Kingston Berhad was concerned about the company's cash flow. Budgeted sales of the company's product for the next five months
Mr. Justin, a director of Kingston Berhad was concerned about the company's cash flow. Budgeted sales of the company's product for the next five months as follows: MONTH UNIT March 20,000 Apri 30.000 May 37.000 June 25,000 July 15,000 Additional information: The selling price is RM10 per unit Company collects 48 percent of sales in the month of the sale 25 percent are collected in the month following sale, 22 percent are collected in the next two months and the remaining 5 percent are uncollectible. Sales on February is RM308,000 and also unable to collect the remaining 5 percent of their credit sales Mr Justin had arranged a bank loan of RM60,000 which will be credited to company's current account in May 2019 Purchases are equal 70 percent of the next month sales.44 percent of purchases are cash and the remaining balance will be paid in the following month. Wages of RM12,000 per month are paid in the month in which they are earned. It is expected that the wages will be increased by 10 percent from 1 May 2019. The rent will cost RM80.000 per annum payable three monthly in advance in January, Apri, July and December The dividend of RM12,000 for the year 2018 will be paid in June 2019. Other monthly fixed expenses are: (a) Utilities RM5,500 (b) General expenses and administration RM20,000 (c) Depreciation and charges RM6,500 (d) Selling expenses is equal to 10 percent of sales each month The company plans to purchase new equipment for RM50,000 in May which RM30,000 will finance by loan with a monthly payment of RM570 and RM70 of interest pay in the following month. The old equipment to be replaced can be sold for RM2,000 Cost of renovation is RM24,600 will be paid equally in May and June Income taxes for the first half year are estimated at RM20,000 and will be paid in June. Interest on accumulated loan is at 9 percent annual interest and paid in the following month The cash balance at 31 March 2019 is RM42,000 and it would like to maintain minimum desired balance of RM48.000 per month Mr. Justion has requested Mrs.Jasina, accountant to prepare a cash budget for the second quarter ending June 2019. You are required to assist Mrs. Jaslina to prepare the requested cash budget
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