Prepare a cash budget for the period 1 November and 31 December 2018. The members of Networx
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The members of Networx Ltd decide to prepare a Cash Budget for November and December 2018. The following information is available: Actual Budgeted August September October November December R R R R R Sales: Cash 194 500 235 700 275 000 250 500 368 000 Credit 287 300 350 000 410 000 400 400 697 000 Purchases 510 000 490 000 495 000 520 000 680 000 Salaries & Wages 72 600 72 600 72 600 72 600 72 600 Sundry Expenses 17 800 18 400 22 000 22 600 25 700 Additional information: 1. Cash in respect of credit sales is collected as follows: 50% within 30 days 30% within 60 days 15% within 90 days The balance is written off as irrecoverable. 2. The following discounts are allowed on sales: 10% on cash sales 7.5% on credit sales if accounts are settled within 30 days. 3. All salaries, wages and sundry expenses are paid in cash. 4. Sundry expenses include depreciation of R4 200 per month. 5. Seventy-five (75%) of all purchases are on credit and paid within 30 days. The balance is paid in cash. 6. A year-end bonus to employees totalling R20 000 will be paid in December. 7. The cash in the bank on 31 October 2018 was R44 500. The members of Networx Ltd decide to prepare a Cash Budget for November and December 2018. The following information is available: Actual Budgeted August September October November December R R R R R Sales: Cash 194 500 235 700 275 000 250 500 368 000 Credit 287 300 350 000 410 000 400 400 697 000 Purchases 510 000 490 000 495 000 520 000 680 000 Salaries & Wages 72 600 72 600 72 600 72 600 72 600 Sundry Expenses 17 800 18 400 22 000 22 600 25 700 Additional information: 1. Cash in respect of credit sales is collected as follows: 50% within 30 days 30% within 60 days 15% within 90 days The balance is written off as irrecoverable. 2. The following discounts are allowed on sales: 10% on cash sales 7.5% on credit sales if accounts are settled within 30 days. 3. All salaries, wages and sundry expenses are paid in cash. 4. Sundry expenses include depreciation of R4 200 per month. 5. Seventy-five (75%) of all purchases are on credit and paid within 30 days. The balance is paid in cash. 6. A year-end bonus to employees totalling R20 000 will be paid in December. 7. The cash in the bank on 31 October 2018 was R44 500.
Expert Answer:
Answer rating: 100% (QA)
Cash Budget Novemer December Beginning Balance 44500 15420 Cash Collections 563170 691885 Total Cash Available 607670 707305 Cash Disbursements Purchases 501250 560000 Salaries and Wages 72600 72600 Sundry Expenses 18400 21500 Bonus to employees 20000 Land Purchases Total Cash Disbursements 592250 674100 Ending Balance 15420 33205 Cash collections schedule Novemer December Cash Sales 225450 331200 Credit Sales Collection ... View the full answer
Related Book For
Management Accounting
ISBN: 9780730369387
4th Edition
Authors: Leslie G. Eldenburg, Albie Brooks, Judy Oliver, Gillian Vesty, Rodney Dormer, Vijaya Murthy, Nick Pawsey
Posted Date:
Students also viewed these accounting questions
-
Prepare a cash budget for the Ace Manufacturing Company, indicating receipts and disbursements for May, June, and July. The firm wishes to maintain at all times a minimum cash balance of $20,000....
-
Prepare a Cash Budget for the months of July and August 2017 Assume any interest will be paid at the end of the month that follows the month when the money was borrowed Also assume that any surplus...
-
Suppose we have a new population and we are interested in two features named X1, which can take any non-negative integer value, and X2, which takes the values A, B, or C for 30%, 30%, and 40% of the...
-
You are the VP of Human Resources for a company with 250 employees. You have both outside sales representatives and inside sales representatives that work primarily by phone. James is an outside...
-
You are a loan officer with Third Texas Bank. Dan Scott owns two successful restaurants, each of which has applied to your bank for a $250,000 one-year loan for the purpose of opening a second...
-
A monatomic ion has a charge of +1. The nucleus of the ion has a mass number of 85. The number of neutrons in the nucleus is 1.30 times that of the number of protons. How many electrons are in the...
-
How to obtain a dismissal of a lawsuit?
-
The following data represent total assets, book value, and market value of common shareholders equity (dollar amounts in millions) for Abbott Labs, IBM, and Target Stores. Abbott Labs manufactures...
-
How does transformative leadership transcend conventional paradigms to cultivate organizational innovation and adaptability in dynamic markets ?
-
Reproduced below from Farthington Supply's accounting records is the Accounts Receivable Subledger along with selected General Ledger accounts. During the year 2014, there were no recoveries of...
-
Suppose the bank has a portfolio of risky assets (loans) that cost 100 at t=0. The bank finances the portfolio with debt (d) and equity (e), where d + e = 100. Suppose the return R from the risky...
-
McKay operated a large farm on which he grew a variety of vegetables for commercial canners. He also grew a smaller quantity for sale to local retailers and wholesalers as fresh produce. On August...
-
When you can draw from your own experiences, including past conversations, you will be less inclined to "overthink" it, as a multimodal learner might be inclined to do. So it's important, as you...
-
Calculate the labour cost to Ascot Manufacturers in respect of S. Mbeki for the week ended 29 October 2022. INFORMATION (6 marks) Project H of Ascot Manufacturers is involved in the manufacture of...
-
Your lawyer has filed the case with the court and has attempted to serve a copy of the complaint and a writ of summons with the care facility executives in Florida, but he has so far been unable to...
-
Swifty Corporation leased equipment to Windsor, Inc. on January 1, 2020. The lease agreement called for annual rental payments of $1,193 at the beginning of each year of the 3-year lease. The...
-
Can prices be potentially unethical or unjust? Be sure to provide clear reasoning for your view. For example, if you say that price gouging is unfair, you must explain why price gouging is wrong, in...
-
D Which of the following is considered part of the Controlling activity of managerial accounting? O Choosing to purchase raw materials from one supplier versus another O Choosing the allocation base...
-
Franklin Industries CEO was talking with the CFO about the appropriate standard cost to use for the new product being launched in the coming year. The CEO argued that standard cost based on ideal...
-
When we covered costvolumeprofit (CVP) analysis in chapter 4, we calculated the amount of pre-tax profit needed to achieve a given level of after-tax profit. We could calculate a pre-tax rate of...
-
What is the link between sustainability strategies and management accounting?
-
Refer to the financial statements of Best Buy in Appendix A near the end of the book. Look at the cad consolidated statements of earnings (income statement).How many years are included and what are...
-
Accounting is an information and measurement system that ____________information about an organizations business activities. a. Translates b. Records c. Chooses d. Prints out
-
External users of financial information include: a. Purchasing managers b. Service managers c. The chief executive officer d. Lenders
Study smarter with the SolutionInn App