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...
-
Briefly explain the difference between a competitive-bid underwriting and a negotiated underwriting.
-
Express the phase angle of the Sears function as the function of the reduced frequency and compare it with the phase of the Theodorsen function on a graph.
-
What is the answer if you add the ball pass frequencies of the inner and outer races?
-
Nichole Jordan comes to you for advice. She has just purchased a large amount of inventory with the terms 2/10, n/30. The amount of the invoice is $270,000. She is currently short of cash but has...
-
How do you think a risk manager might work through a difference of opinion with a unit manager? Explain in details.
-
The file azcounties.dat gives data from the 2000 U.S. Census on population and housing unit counts for the counties in Arizona (excluding Maricopa County and Pima County, which are much larger than...
-
Michelle Roy works for Affordable Transport in Qubec and earns an annual salary of $55,500.00 paid on a monthly basis. In addition to her regular salary, Michelle's employer provides group term life...
-
From the individual workers standpoint, what are the pros and cons of being an employee versus an independent contractor?
-
Calculate total average costs for the bookstore in Problem 25-5. Illustrate the store's short-run equilibrium by calculating demand, marginal revenue, average total costs, and marginal costs. What is...
-
Let \(\mathbf{F}=\left\langle-z^{2}, 2 z x, 4 y-x^{2}ightangle\), and let \(C\) be a simple closed curve in the plane \(x+y+z=4\) that encloses a region of area 16 (Figure 20). Calculate \(\oint_{C}...
-
In Turpin v. Sortini, the California Supreme Court said it was difficult to understand how awarding damages to a child who would not have been born if not for the defendants negligence would disavow...
-
What are the functions and responsibilities of the governing board of a healthcare corporation?
-
In Mississippi v. AT&T and Comptroller of the Treasury v. Wynne, the courts considered whether a state tax, if adopted in an identical way by every other state, would result in having interstate...
-
XYZ Inc. a calendar year, accrual basis corporation, had the following items during 2021: Gross revenue from operations Cost of goods sold $420,000 ($180,000) $9,000 LT capital gain .LT capital...
-
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?
-
What are the differences between the light stall and the deep stall. Comment on the differences as regards the sectional lift and the moment coefficients.
-
At high angles of attack, the empirical formulae for the lift and moment coefficients for airfoils pitching at high frequencies are given in terms of maximum dynamic moment coefficient \(\left(C_{M}...
-
During dynamic stall, the drag coefficient is less for pitch-up than for pitch-down, whereas the lift coefficient is larger for pitch-up than for pitch-down. Why?
Study smarter with the SolutionInn App