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...
-
The diameter of the Moon is 3480 km. What is the volume of the Moon? How many Moons would be needed to create a volume equal to that of Earth?
-
Arm AB has a constant angular velocity of 16 rad/s counterclockwise. At the instant when = 90?, determine the acceleration (a) Of collar D, (b) Of the midpoint G of bar BD. 60 mm 200 mm D 120 mm
-
Assume that the weekly payroll of IDT, Inc., is $3,500. December 31, the end of the year, falls on Tuesday, but the company wont pay employees for the full week until its usual payday, Friday. What...
-
An airline company is interested in the opinions of their frequent flyer customers about their proposed new routes. Specifically they want to know what proportion of them plan to use one of their new...
-
Suppose you were a financial analyst trying to compare the performance of two companies. Company A uses the double-declining- balance depreciation method. Company B uses the straight-line method. You...
-
a. How much cash does Patterson have on hand relative to its total assets? b. What proportion of Patterson's assets has the firm financed using short-term debt? Long-term debt? c. What percent of...
-
Thermopolis Industries acquired common stock of Riverton, Inc. as an investment. Consider the following transactions. 2018: Purchase 4,000 (15%) of the common shares of Riverton, Inc. for $20.40 cash...
-
1. Given: a cash flow of $200 occurring in year four, and annual interest rate is 12%. a. Calculate the present value of the cash flow if interest is calculated once a year. b. Calculate the present...
-
What is Brazos partners investment strategy? Does is seem well-suited for a first-time fund? Assess the merits of the GTT transaction? How does the current recessionary climate affect Brazos'...
-
How can a company's organizational structure either foster or hinder innovation, and what strategies can be implemented to create a structure that encourages creativity and experimentation ?
-
A mass flow sensor measures the mass of air into an engine resulting in the following data. Mass is in [kg/min], output in [V]: M [kg/min] Output [V] M [kg/min] Output [V] M [kg/min] Output [V] 0...
-
1. Compute the sum of [29 -1] and [15]. 2. Compute the sum of [2 9 -1] and [1 5 3]. [3 14 2] [1 2 31 3. Compute the sum of A= 2 1 4 and B = 3 13 4 1 [23 41 2 5 14 5 2
-
You have just purchased an investment that generates the followingcash flows at 13.0 percent, compounded annually. End of year 1. $2.271 2. $3,690 3. $3.610 4. $854 What is the present value of this...
-
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...
-
You are given the following information about two companies, partly extracted from their most recent statement of financial position and income statement, and partly taken from the financial press....
-
You are given the following information about Swin Gin plc: You are required to calculate the P/E ratio for each year, and comment on how the market appears to have reacted to changes in EPS. Year 1...
-
Assess the usefulness of P/E ratios and suggest how they might be misleading.
Study smarter with the SolutionInn App