1. 2. 3. 5. 6. 7. 8. 10. Use the information provided below to prepare the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. 2. 3. 5. 6. 7. 8. 10. Use the information provided below to prepare the Cash Budget of Project Spa for Ubuhle Ltd for January, February and March 2020. (Use separate monetary columns for each month.) INFORMATION The budgeted sales schedule for Project Spa for the five months ended 31 March 2020 is as follows: November 2019 December 2019 January 2020 February 2020 March 2020 R150 000 R220 000 R140 000 R130 000 R150 000 Cash sales account for 60% of the total sales. The balance of the sales is on credit and these customers pay two months after the sale. The monthly purchase of materials is expected to equal to 25% of the sales value of the same month but is paid for one month after the purchase. Fixed costs are estimated at R20 000 per month and they are payable in the month in which they are incurred. Variable production overheads are budgeted at R30 000 for January 2020 and are expected to increase by 10% each month. Marketing overheads are estimated 8% of the sales value of each month. Marketing overheads are paid for in the month after they are incurred. Production salaries and wages are expected to amount to R40 000 per month and are paid for in the applicable month. An increase of 7% is expected to take effect on 01 February 2020. A machine that costs R60 000 is expected to be purchased on credit on 29 February 2020. A deposit of R15 000 will be paid on 29 February 2020 and the balance will be paid in 5 equal monthly instalments commencing March 2020. Interest at a rate of 15% per year is payable monthly on a loan from Tec Bank. The loan balance is expected to be R120 000 on 01 January 2020. The loan agreement stipulates that instalments of R10 000 plus interest be made at the end of each month. A favourable bank balance of R50 000 is expected for Project Spa on 31 December 2019. 1. 2. 3. 5. 6. 7. 8. 10. Use the information provided below to prepare the Cash Budget of Project Spa for Ubuhle Ltd for January, February and March 2020. (Use separate monetary columns for each month.) INFORMATION The budgeted sales schedule for Project Spa for the five months ended 31 March 2020 is as follows: November 2019 December 2019 January 2020 February 2020 March 2020 R150 000 R220 000 R140 000 R130 000 R150 000 Cash sales account for 60% of the total sales. The balance of the sales is on credit and these customers pay two months after the sale. The monthly purchase of materials is expected to equal to 25% of the sales value of the same month but is paid for one month after the purchase. Fixed costs are estimated at R20 000 per month and they are payable in the month in which they are incurred. Variable production overheads are budgeted at R30 000 for January 2020 and are expected to increase by 10% each month. Marketing overheads are estimated 8% of the sales value of each month. Marketing overheads are paid for in the month after they are incurred. Production salaries and wages are expected to amount to R40 000 per month and are paid for in the applicable month. An increase of 7% is expected to take effect on 01 February 2020. A machine that costs R60 000 is expected to be purchased on credit on 29 February 2020. A deposit of R15 000 will be paid on 29 February 2020 and the balance will be paid in 5 equal monthly instalments commencing March 2020. Interest at a rate of 15% per year is payable monthly on a loan from Tec Bank. The loan balance is expected to be R120 000 on 01 January 2020. The loan agreement stipulates that instalments of R10 000 plus interest be made at the end of each month. A favourable bank balance of R50 000 is expected for Project Spa on 31 December 2019.
Expert Answer:
Answer rating: 100% (QA)
January 2020 Starting Bank Balance 31 December 2019 R50000 Cash Inflows Cash Sales 60 of January Sal... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
In view of the information provided below provide suggestions for the efficient management of trade debtors. INFORMATION MANAGEMENT OF TRADE DEBTORS Debtor management is central to the effective cash...
-
Calculate Annes remuneration for 15 April 2022. INFORMATION The normal wage of Anne is R200 per hour and her normal working day comprises 9 hours. The standard production time for each employee is 10...
-
Use the information provided below to prepare the following for Xpanda Limited for February and March 2022: Debtors Collection Schedule Cash Budget. INFORMATION The following budgeted information was...
-
1. Consider a household that has $300 to spend on back-to- school shoes. They visit one of the discount shoe stores where shoes are buy one pair for $50, get the second half off. a. Draw the budget...
-
Note that if Bonfiglio had borrowed money from a bank to pay the law firm, the bank would have had to comply with TILA. Why should the bank have to comply and not the law firm?
-
Aluminum dissolves readily in hot aqueous NaOH to give the aluminate ion, [Al(OH) 4 ] , and H 2 . Write a balanced equation for this reaction. If you begin with 13.2 g of Al, what volume (in liters)...
-
Briefly explain how the following programs would affect the elasticity of demand for labor in the steel industry: a. An increased tariff on steel imports. b. A law making it illegal to lay off...
-
Adria Lopez, owner of Success Systems, decides to diversify her business by also manufacturing computer workstation furniture. Required 1. Classify the following manufacturing costs of Success...
-
Discuss the differences between (Data Definition Language) DDL and (Data Manipulation Language) DML using SQL example.?
-
Fulcrum Industries manufactures dining chairs and tables. The following information is available: Dining Chairs Tables Total Cost 600 470 2,400 Machine setups Inspections Labor hours Problem 2. 200...
-
This data structure, working on a Hash Table that takes two keys rather than one. In terms of storage, this can be thought of as a hash table of hash tables, where a top-level key is used to...
-
The ending inventory was 8 5 % complete with respect to materials and 7 5 % complete with respect to conversion costs. The cost per equivalent unit for materials for the month in the first processing...
-
LEGACY Insights In February 2022, we wrote about Russian troops massing along the Ukrainian border, and how logistics professionals were left to watch the situation unfold with bated breath. As of...
-
my project consists of making drones to deliver food and medications to patients Both positive and negative risk exists in all projects. Risk management is another important skill for a project...
-
x+y+2=-1 2x+2y+32=-3 3x-y-27= 6 Which row operations do you need to follow in order to obtain the echelon form of the augmented matrix?
-
You have participated in several projects, and you are now very familiar with risk identification, risk analysis, risk response strategies, and risk monitoring. Because of your experience, your...
-
3. What is racial naturalism and racial historicism and what is the history of these terms? How did the transition from theories of racial naturalism to racial historicism influence the focus on the...
-
The graph of an equation is given. (a) Find the intercepts. (b) Indicate whether the graph is symmetric with respect to the x-axis, the y-axis, or the origin. -3 6 -6 3 x
-
Carl Conch and Mary Duval are married and file a joint return. They live at 1234 Mallory Sq. Apt. 64, Key West, FL 33040. Carl works for the Key Lime Pie Company and Mary is a homemaker after losing...
-
On July 1, 2012, Ted, age 73 and single, sells his personal residence of the last 30 years for $365,000. Ted's basis in his residence is $35,000. The expenses associated with the sale of his home...
-
Diego, age 28, married Dolores, age 27, in 2012. Their salaries for the year amounted to $46,479 and they had interest income of $3,500. Diego and Dolores' deductions for adjusted gross income...
-
How can environmental agents that do not cause gene mutations contribute to cancer?
-
With regard to genotypes, what is a true-breeding organism?
-
With regard to biological evolution, which of the following statements is incorrect? Explain why. A. During its lifetime, an animal evolves to become better adapted to its environment. B. The process...
Study smarter with the SolutionInn App