Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following information relates to Tea Limited, a company that will commence business on 1 January 2021. The company is preparing its budget for 2021

image text in transcribed

image text in transcribed

The following information relates to Tea Limited, a company that will commence business on 1 January 2021. The company is preparing its budget for 2021 and will detail the projected activities for each quarter of the year. Information: 1. Cash at bank on 1 January 2021 amounted to R150 000. 2. Projected sales per quarter for 2021: First quarter R750 000 Second quarter R825 000 Third quarter R930 000 Fourth quarter R980 000 Fifty percent (50%) of the sales are for cash and fifty percent (50%) are on credit. Cash customers are entitled to a 5% cash discount. 3. Collection of credit sales: . 60% of the credit sales are collected in the quarter of the sale. 30% is collected in the following quarter and the balance is written off as a bad debt. 4. Purchases for each quarter are expected to be as follows: First quarter R100 000 Second quarter R120 000 Third quarter R140 000 Fourth quarter R180 000 All purchases are on credit. 75% of the purchases will be paid for in the quarter of purchase and the remaining 25% in the following quarter 5. Fixed overheads total R200 000 per year and are paid for equally each quarter. 6. Administrative expenses are paid for in the quarter in which they are incurred and are estimated at a total of R20 000 per quarter 7. An investment of R150 000 matures on 30 June 2021, and interest of R15 000 will also be received on this date. Required: 21 Prepare the Debtors Collection Schedule for the four quarters of 2021 22 Prepare the Cash Budget for the four quarters of 2021. (6 marks) (14 marks) 120 Marks

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

How To Build A Cyber Resilient Organization Internal Audit And IT Audit

Authors: Eugene Fredriksen

1st Edition

1032402210, 978-1032402215

More Books

Students also viewed these Accounting questions