Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the information given below to prepare the Cash Budget for March, April and May 2022. (Provide separate monetary columns for each month.) INFORMATION The
Use the information given below to prepare the Cash Budget for March, April and May 2022. (Provide separate monetary columns for each month.) INFORMATION The following forecasts have been made by Mentos Limited in respect of Project Z for February to May 2022: 1. The project manager anticipates the following sales volumes at a price of R200 per unit from the product produced from Project Z: February March April May 4 200 units 3 000 units 4 000 units 4 800 units Sixty percent (60%) of the sales are for cash and the rest is on credit. Debtors pay their accounts one month after the sale is made. 2. The unit costs of production include the following: Direct materials Direct labour R60 per unit R50 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 800 units 3 600 units 4 500 units 5 400 units 4. Seventy percent (70%) of the direct materials purchased is for cash and the balance is 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 R25 per unit. Fixed overheads are budgeted at R96 000 per month, excluding R14 000 for depreciation. Overheads are payable in the month in which they are incurred. 7. The production manager intends to purchase additional machinery with a cost price of R150 000 on 31 March 2022 on credit. A deposit of 20% is payable on the date of purchase and the balance of the debt is payable in six equal monthly instalments, commencing April 2022. 8. On 31 May 2022, 5% of the total sales for May 2022 will be transferred into a fixed deposit account. 9. Leasing payments cost R86 400 per annum and is payable monthly. 10. An unfavourable bank balance of R30 000 is expected on 28 February 2022
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started