From the following information prepare a monthly cash budget for the three months ending 31st Dec.2023...
Fantastic news! We've Found the answer you've been seeking!
Question:
![From the following information prepare a monthly cash budget for the three months ending 31st Dec.2023 Month](https://dsd5zvtm8ll6.cloudfront.net/questions/2024/01/659ba5f0c3fdb_1704699376156.jpg)
Transcribed Image Text:
From the following information prepare a monthly cash budget for the three months ending 31st Dec.2023 Month June July Aug. Sep. Oct. Nov. Dec. Credit terms Sales 3 months to debtors. 20% of sales are on cash. On an average, 50% of credit sales are paid on the due dates while the other 50% are paid in the month following Creditors for material - 2 months. Lag in payment Sales Materials (RM) (RM) 36,000 22,000 39,000 25,000 42,000 30,000 45,000 27,000 50,000 28,500 52,000 30,000 60,000 33,000 Wages (RM) (RM) 7,800 3,000 9,000 3,250 10,000 3,500 11,400 3,600 12,600 3,800 13,800 4,200 15,200 4,500 Other information Plant and Machinery to be installed in Aug. at a cost of RM150,000. It will be paid for by monthly installments of RM6,000 each from 1st Oct.; Preference share dividend @ 5% on RM280,000 are to be paid on 1st Dec. Calls on 4,000 equity shares @ RM4 per share expected on 1st November; Dividends from investments amounting to RM7,500 are expected on 31st Dec.; Income tax (advance) to be paid in December RM 5,000 Cash and Bank Balance on 1st Oct. expected RM18,000. Production Wages. 1/4 month, overheads - 1/2 month. Admin. Selling, etc (RM) 1,850 2,200 2,400 2,800 3,000 3,200 3,500 Required: Prepare cash budget for 3 months period ending 31st December 2023 in detail with appropriate workings. From the following information prepare a monthly cash budget for the three months ending 31st Dec.2023 Month June July Aug. Sep. Oct. Nov. Dec. Credit terms Sales 3 months to debtors. 20% of sales are on cash. On an average, 50% of credit sales are paid on the due dates while the other 50% are paid in the month following Creditors for material - 2 months. Lag in payment Sales Materials (RM) (RM) 36,000 22,000 39,000 25,000 42,000 30,000 45,000 27,000 50,000 28,500 52,000 30,000 60,000 33,000 Wages (RM) (RM) 7,800 3,000 9,000 3,250 10,000 3,500 11,400 3,600 12,600 3,800 13,800 4,200 15,200 4,500 Other information Plant and Machinery to be installed in Aug. at a cost of RM150,000. It will be paid for by monthly installments of RM6,000 each from 1st Oct.; Preference share dividend @ 5% on RM280,000 are to be paid on 1st Dec. Calls on 4,000 equity shares @ RM4 per share expected on 1st November; Dividends from investments amounting to RM7,500 are expected on 31st Dec.; Income tax (advance) to be paid in December RM 5,000 Cash and Bank Balance on 1st Oct. expected RM18,000. Production Wages. 1/4 month, overheads - 1/2 month. Admin. Selling, etc (RM) 1,850 2,200 2,400 2,800 3,000 3,200 3,500 Required: Prepare cash budget for 3 months period ending 31st December 2023 in detail with appropriate workings. From the following information prepare a monthly cash budget for the three months ending 31st Dec.2023 Month June July Aug. Sep. Oct. Nov. Dec. Credit terms Sales 3 months to debtors. 20% of sales are on cash. On an average, 50% of credit sales are paid on the due dates while the other 50% are paid in the month following Creditors for material - 2 months. Lag in payment Sales Materials (RM) (RM) 36,000 22,000 39,000 25,000 42,000 30,000 45,000 27,000 50,000 28,500 52,000 30,000 60,000 33,000 Wages (RM) (RM) 7,800 3,000 9,000 3,250 10,000 3,500 11,400 3,600 12,600 3,800 13,800 4,200 15,200 4,500 Other information Plant and Machinery to be installed in Aug. at a cost of RM150,000. It will be paid for by monthly installments of RM6,000 each from 1st Oct.; Preference share dividend @ 5% on RM280,000 are to be paid on 1st Dec. Calls on 4,000 equity shares @ RM4 per share expected on 1st November; Dividends from investments amounting to RM7,500 are expected on 31st Dec.; Income tax (advance) to be paid in December RM 5,000 Cash and Bank Balance on 1st Oct. expected RM18,000. Production Wages. 1/4 month, overheads - 1/2 month. Admin. Selling, etc (RM) 1,850 2,200 2,400 2,800 3,000 3,200 3,500 Required: Prepare cash budget for 3 months period ending 31st December 2023 in detail with appropriate workings.
Expert Answer:
Answer rating: 100% (QA)
This is a request to prepare a cash budget for the three months ending December 31 2023 by using the given information To prepare a cash budget we will have to consider the inflows and outflows of cas... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Buhle Company ( Pty ) Ltd has put together the following data in order to complete their operating budget for the second quarter of 2 0 1 9 : April May June July Sales ( units ) 7 3 2 0 0 6 8 9 0 0 6...
-
Select a bioprocess for hydrogen production. Select an type organic waste, and give data on the following; feedstock, production capacity, raw material needed, energy requirements. Then give a...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
The California State Auditors Office assesses the fiscal health of the states cities and posts the information on Fiscal Health of California Cities (www.auditor.ca.gov/ bsa/cities_risk_index). The...
-
Find P ( 1 < z <1), P ( 2 < z <2), and P( 3 < z < 3). How do these values compare with the empirical rule?
-
Are the following functions even or odd or neither even nor odd? Product of an odd times an even function
-
1.66 Source: Nitzan, I. & Ein-gar, D. The commitment projection effect: When multiple payments for a product affect defection from a service, Journal of Marketing Research, Vol. 56, No. 5, October...
-
Optimum Health Inc. provides diet, fitness, and nutrition services to clients who want a healthier lifestyle. The company customizes a program for each client based on their individual goals that...
-
Tax Dilemma The income of any person, including a company, accruing in or derived from Malaysia or received in Malaysia from outside Malaysia is subject to income tax or in other words all...
-
Your client, Bigco, is considering buying Littleco. Littlecos particulars are as follows: Assets: FMV=100mm; adjusted basis 40mm Liabilities: none Market Value of stock: 130mm Location: Incorporated...
-
Why are questions about Employment Status useful on a job application form?Why are questions about Employment Status useful on a job application form? Multiple Choice They indicate the candidate's...
-
Hogan Business Systems has a small number of sales on account but is mostly a cash business. Consequently, it uses the direct write-off method to account for uncollectible accounts. During 2011 Hogan...
-
Bourret Inc. experienced the following events for the first two years of its operations. 2011: 1. Provided \(\$ 60,000\) of services on account. 2. Provided \(\$ 25,000\) of services and received...
-
A flowrate of lubricant oil is \(5 \mathrm{~kg} / \mathrm{s}\) passing through a Venturi tube. The ratio of areas of the Venturi tube is \(0.005 \mathrm{~m}^{2} /0.002 \mathrm{~m}^{2}\). The density...
-
Sketch on separate axes, in the interval 0 360, the graphs of: In each case show the coordinates of any maximum and minimum points, and of any points at which the curve meets the axes. a y = sec...
-
The wheel of radius \(r=300 \mathrm{~mm}\) rolls to the right without slipping and has a velocity \(v_{O}=3 \mathrm{~m} / \mathrm{s}\) of its center \(O\). Calculate the velocity of point \(A\) on...
-
Consider the Thai Baht and the Peruvian New Sol. a. If Thai inflation rates decreased, all else equal, explain what that would do to the value of the Baht (relative to the Sol). b. If Thailand didnt...
-
Which of the following is FALSE regarding the purchasing power parity (PPP). a. The PPP is a manifestation of the law of one price b. The PPP says that a country with a higher expected inflation can...
-
Jonah Company manufactures deep-sea fishing rods, which it distributes internationally through a chain of wholesalers. The following data is taken from the budget prepared by Jonah's controller at...
-
The following items were gathered from Daniels Distributings general ledger: Purchase of marketable securities......... $200,000 Depreciation and amortization expense....... . 31,980 Declaration of...
-
Jordan Auto has developed the following production plan for its new auto part. Each unit passes through two departments before completion. The company has developed the following direct labor...
-
The is the point at which the contractor assumes total responsibility for each additional dollar of contract cost. a. breakeven point b. Share Ratio Point c. Point of Reconciliation d. Point of Total...
-
Your organization hired a specialist in a certain field to provide training for a short period of time. Which reason for outsourcing would this example fall under? a. reducing costs b. allowing the...
-
An item you need for a project has a daily lease cost of $200. If you decide to purchase the item, the investment cost is $6,000 and the daily cost is $100. After how many days will the lease cost be...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App