Suria Borneo Sdn Bhd is attempting to estimate its needs for funds for the first quarter...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Suria Borneo Sdn Bhd is attempting to estimate its needs for funds for the first quarter of the year 2021. The following information is provided. Actual Sales (2020) October November December a) b) c) d) e) f) RM120,000 January RM100,000 February RM110.000 March April Forecasted Sales (2021) RM120,000 RM130,000 20 percent of sales are collected in the month of sales, 50 percent one month following the sales and 30 percent second month following the sales. RM140.000 RM150,000 | Purchases of raw materials are equal to 60 percent of sales and are made one month before the anticipated sales. Payments for the purchases are made as follows: 50 percent in the month of purchase, 35 percent one month after purchase and 15 percent two months after purchase. A quarterly dividend of RM50,000 will be received in March. Other fixed expenses: Insurance Rent Depreciation RM4,000 RM5,000 RM10,000 Wages are 20 percent of the month's sales and are made in the month in which they incurred. Based on the above information, you are required to assist the company to prepare a cash budget for the first quarter of 2021. Determine whether the company requires any financing if the minimum cash balance is RM10,000. Suria Borneo Sdn Bhd is attempting to estimate its needs for funds for the first quarter of the year 2021. The following information is provided. Actual Sales (2020) October November December a) b) c) d) e) f) RM120,000 January RM100,000 February RM110.000 March April Forecasted Sales (2021) RM120,000 RM130,000 20 percent of sales are collected in the month of sales, 50 percent one month following the sales and 30 percent second month following the sales. RM140.000 RM150,000 | Purchases of raw materials are equal to 60 percent of sales and are made one month before the anticipated sales. Payments for the purchases are made as follows: 50 percent in the month of purchase, 35 percent one month after purchase and 15 percent two months after purchase. A quarterly dividend of RM50,000 will be received in March. Other fixed expenses: Insurance Rent Depreciation RM4,000 RM5,000 RM10,000 Wages are 20 percent of the month's sales and are made in the month in which they incurred. Based on the above information, you are required to assist the company to prepare a cash budget for the first quarter of 2021. Determine whether the company requires any financing if the minimum cash balance is RM10,000.
Expert Answer:
Related Book For
Horngrens Financial and Managerial Accounting
ISBN: 978-0133866292
5th edition
Authors: Tracie L. Nobles, Brenda L. Mattison, Ella Mae Matsumura
Posted Date:
Students also viewed these accounting questions
-
In its income statement for the first quarter of fiscal year 2018, The Gap, Inc., reported net sales of $3,783 million and cost of goods sold and occupancy expenses of $2,356 million, resulting in a...
-
Budgeted sales for the first quarter of the year for the Delta Company are as follows: Budgeted Sales January ........$400,000 February ....... 200,000 March......... 600,000 1. The Company normally...
-
A manufacturer has budgeted sales for the first quarter of the next year to be 30,000 units. The inventory in hand at the beginning of quarter is 5,000 units. The desired ending inventory is 10,000...
-
Bob Bristol just called to congratulate you on your excellent work on the various assignments at CII.He now wants you to do some capacity analysis for Meghan Willoughby, the Chief Purser. Meghan is...
-
The QwikFill Corporation recently hired David Oxley to figure out ways to improve profit. David notes that, like virtually all gas stations, QwikFills stations also had an air pump that customers...
-
Eggs with a mass of 0.15 kg per egg and a specific heat of 3.32 kJ/kg C are cooled from 32C to 10C at a rate of 200 eggs per minute. The rate of heat removal from the eggs is (a) 7.3 kW (b) 53 kW...
-
Suppose that we can use wire of \(1.0-\mathrm{mm}\) diameter to make either a single loop of wire or a solenoid, and we wish to compare, for a given current, the magnetic fields at the center of...
-
In 2006, the Russ College of Engineering and Technology of Ohio University announced that an investigation had found rampant and flagrant plagiarism in the theses of mechanical engineering graduate...
-
Journalize the employer's payroll tax expense for February 28. Notice that this journal entry is similar to the one on January 31. Use the February FICA amounts. Notice that Amy Hamilton reaches the...
-
(a) The steps in the accounting cycle for a merchandising company differ from the steps in the accounting cycle for a service company. Do you agree or disagree? (b) Is the measurement of net income...
-
Solve for x en (x+2)+ln(x+3)-In (10x)
-
The Pitfalls ofGlobalization In Prichard's article in this week's materials, he quotes Robert Salomon, a professor of international management. Salomon says: "The problem is that managers...
-
The first step in determining the investment objectives of a client is to establish: A His marginal rate of tax. B Hisrisktolerance. C Hislevelofinvestmentknowledge. D His prior experience in...
-
You are giving a presentation on accounting at a local business. You're expecting your audience to be uninterested in your topic because most of the attendees are required to be there and are not...
-
Develop a business case for a project Attached Files: File business_case.docx business_case.docx - Alternative Formats (12.033 KB) File Business Case Business Case - Alternative Formats (15.863 KB)...
-
There is a part a) and b) to this question. Assume the year 2021 has just finished. PIC is now asking you, the consultant that helped with the balanced scorecard in part 1 above, to explain its...
-
(a): Let r be a real number such that r 1. Use induction to prove the geometric series formula: n arn i=0 = a - arn+1 1-r (b): Define an, recursively, by ao = 1 and an = 1 + Eda,. Show, using strong...
-
You are a Loan Officer with an Investment Bank. Today you need to set your lending parameters. They are: LTV: 55% 10 Year T-Bill: TBD Rate Markup: 300 Basis Points Term: 30 Years Amortization: 30...
-
Certain item descriptions and amounts are missing from the monthly schedule of cost of goods manufactured and income statement of Maria Manufacturing Company. Fill in the blanks with the missing...
-
Columbia Enterprises reports the following information at December 31, 2016: Requirements 1. What is the actual manufacturing overhead of Columbia Enterprises? 2. What is the allocated manufacturing...
-
Prepare the balance sheet for Drought Design Studio as of December 31, 2016. The assets, liabilities, and equities of Drought Design Studio have the following balances at December 31, 2016. The...
-
Use the numbers for the alcohol and tobacco category from the table in the Application "Goods with a Large Consumer Surplus Loss from Price Increases" to draw a figure that illustrates the roles that...
-
Change the answer given in the Challenge Solution for the short run rather than for the long run.
-
Because many consumers choose between coffee and tea, the coffee and tea demand functions depend on both prices. Suppose the demand curves for coffee and tea are where \(Q_{c}\) is the quantity of...
Study smarter with the SolutionInn App