Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

Instructions: All answers must be typed in and workings must be shown QUESTION 2 REQUIRED Use the information given below to prepare the Cash Budget

Instructions: All answers must be typed in and workings must be shown

image text in transcribed

QUESTION 2 REQUIRED Use the information given below to prepare the Cash Budget for a project of Sanhall Limited for March, April and May 2021. (Provide separate monetary columns for each month.) INFORMATION The following forecasts have been made by Sanhall Limited in respect of Project Z for February to May 2021: 1. The sales manager anticipates the following sales volumes at a price of R250 per unit from the product produced from Project Z: February March April May 3 600 units 2 600 units 3 400 units 4 100 units 2. Forty (40%) percent of the sales are for cash and the rest is on credit. Twenty percent (20%) of the cash sales are subject to a 10% discount. Debtors pay their accounts in the month after the sale. The unit costs of production include the following: Direct materials R70 per unit Direct labour R60 per unit 3. The purchases manager expects to purchase direct materials to manufacture the following quantities of the product each month: February March April May 4 100 units 3 100 units 3 900 units 4600 units 4. Sixty (60%) percent of the materials are purchased for cash and the balance is purchased on credit. Creditors are paid in the month after the purchase. 5. Direct labour costs are incurred in line with the number of units produced and are paid for in the month in which they were incurred. 6. Variable overheads are estimated at R30 per unit. Fixed overheads are budgeted at R90 000 per month, excluding R10 000 for depreciation. Overheads are payable in the month in which they are incurred. 7. The directors intend to purchase additional machinery with a cost price of R180 000 on 31 March 2021 on credit. A deposit of 20% is payable on 31 March 2021 and the balance of the debt will be paid in six equal monthly instalments, commencing April 2021. 8. Ten percent (10%) of the total sales (before any discounts) for May 2021 will be transferred into a fixed deposit account on the last day of that month. 9. Leasing costs R72 000 per annum and is payable monthly. 10. A favourable bank balance of R30 000 is expected on 28 February 2021

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Principles Volume 1

Authors: Jerry J. Weygandt, Donald E. Kieso, Paul D. Kimmel, Barbara Trenholm, Valerie Warren, Lori Novak

8th Canadian Edition

978-1119502425

Students also viewed these Accounting questions