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:
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
-
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...
-
The Federal Reserve releases transcripts of its Federal Open Market Committee (FOMC) meetings only after a five-year lag in order to preserve the confidentiality of the discussions. When the...
-
Deeds Company sells custom-made machine parts to industrial equipment manufacturers by bidding cost plus 40 percent, where cost is deï¬ned as manufacturing cost plus order processing cost....
-
For each of the following situations, calculate the \(z\)-statistic \((z)\), make a decision about the null hypothesis (reject, do not reject), and indicate the level of significance \((p>.05, p
-
During the most recent year, Butler paid $95,000 in interest to its lenders and $80,000 in dividends to its stockholders. Required 1. In which category of the statement of cash flows (operating,...
-
Identify the type of fund in which each activity is recorded: 1 ) The city receives a grant from the federal government to institute a meal delivery program for senior citizens. 2 ) To remedy a...
-
Papa-P Company directed its IT team to develop its own website wherein customers can place orders and will facilitate swift response to customer's inquiries as well. The development took four months...
-
Deduce the structure of the compound with the molecular formula C9H10O, by interpreting the data of the following spectrum IR Spectrum (liquid film) % Transmittance 100 50 Mass Spectrum Relative...
-
Each of the following substances exhibit the property of forming hydrogen bonding between molecules: water, HO ammonia, NH3 ethanol, C2H60 a. For each molecule, draw a diagram that clearly...
-
The tan delta curves of two composites are plotted as a function of frequency as shown in Fig. 2c. Which composite will show higher impact strength at 25 C and why? 0.04 99 Tan 6 0.03 25C composi...
-
Considering the following table of pK, values. PK values of organic and inorganic acids pKa Acid pK 51 38 CH3 CH3 NH3 H 35 CH3 CHOH 15.9 HO Acid HS HCO3 CH3COOH 4.76 C6H5COOH 4.19 15. HO+ 15.50 HSO4...
-
We want to design a circuit that numerically evaluates the integral of the function Y shown below (i.e. the area under the curve of Y) between two values of X (input parameters); X1 and X2 using a...
-
In December 2027. Taguan Bank reported a net income of P900,000, net of trading loss of P50,000. In January 2028, Taguan reported the following gross receipts: Interest income with a maturity of...
-
Compile data on consumption and expenditures for the following categories in 30 different countries: (1) food and beverages, (2) clothing and footwear, (3) housing and home operations, (4) household...
-
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...
-
Determine the irrep content for the equivalent reducible \(S_{3}\) representations \(\Gamma^{(4)}\) and \(\Gamma^{(5)}\) of Fig. 2.4 . Data from Fig. 2.4 F(1) (2) 1 (3) (4) r(5) (6) 1 0 0 0 0 0 0 1 0...
-
Prove that the direct product of two representations is a representation, and that the character of the direct product is the product of characters for the representations.
-
Demonstrate explicitly that for invariant subgroups the cosets form a group under the coset multiplication law (2.27).
Study smarter with the SolutionInn App