Question
Goodies (Pty) Ltd is a retailer of childrens toys. The Management Accountant created the sales budgets for the last four months of the financial year
Goodies (Pty) Ltd is a retailer of childrens toys. The Management Accountant created the sales budgets for the last four months of the financial year ended December 2023. The budget is presented below: Month September October November December R R R R Cash Sales 60 000 50 000 70 000 30 000 Credit Sales 450 000 500 000 420 000 510 000 Total Sales 510 000 550 000 490 000 540 000 Additional information: Collections regarding credit sales are as follows: 50% in the month of the sale and is therefore subject to a 4% settlement discount. 25% one month after the month of sale. 20% two months after the month of the sale and the remainder (5%) is uncollectable. Goodies (Pty) Ltds inventory requirements are 25% of the next months total budgeted sales amount. Inventory is purchased in the month preceding its expected sale. All inventory purchases are made on credit. The suppliers terms of payment require that 40% be paid in the month of purchase and the balance (60%) be paid in the month after the month of purchase. Direct wages amount to R15 000 per month. Wages are all paid in cash as they occur. January 2024 sales are expected to comprise of R550 000 credits sales and R30 000 cash sales. The bank is expected to be in an overdraft of R42 000 on 31 October 2023. Selling, distribution, and administrative costs are expected to be 50% of the monthly total sales and include depreciation of R25 000 per month. REQUIRED: Prepare a cash budget for Goodies (Pty) Ltd for the months of November 2023 and December 2023. Show all workings. (30 marks) Relevant SAICA competency: C1.2 Decision-making based on budgeting and expenditure forecasting a) Understand the budgeting and expenditure forecasting processes which translate the organisations business strategy into financial targets and tactical plans and that can be executed in a risk-controlled manner.
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