Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following figures are available for Insure (Pty) Ltd: Actual (2018) Budget (2018) January February March April May Sales 96 000 120 000 60 000

The following figures are available for Insure (Pty) Ltd:

Actual (2018)

Budget (2018)

January

February

March

April

May

Sales

96 000

120 000

60 000

160 000

200 000

Purchases

100 000

50 000

160 000

84 000

60 000

Sales commission

400

600

1 200

800

400

Wages

800

800

800

?

?

  1. 40% of all sales are for cash.
  2. 35% of all purchases are for cash.
  3. Collection from debtors are as follows:
    20% is collected in the month of the sale and 2% discount is granted on these collections.
    60% is collected in the month following the month of sale.
    15% is collected in the second month following the month of sale.
    The remaining 5% is written off as a bad debt.
  4. Insure (Pty) Ltd will make an investment of R50 000 in fixed deposit on 01 April 2018.
  5. Interest of R500 per month on the fixed deposit is expected to be received from 30 April 2018.
    1. Creditors are paid 2 months after date of invoice.
    2. Rent expense amounts to R8 000 per month and is payable on the first day of each month.
    3. Wages will be increased by 10% in April and will increase by a further 5% in May 2018.
    4. A new machine is expected to be purchased for R10 000 cash in May 2018.
    5. Commission is paid to sales personnel in the month following the month in which it was earned.
    6. On 31 March 2018, Insure (Pty) Ltd had a bank overdraft of R28 000.

      Required:

Prepare the debtors‘ collection schedule for April and May 2018. (10)

Prepare the cash budget for April and May 2018.   (20)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Answer Month Sales Collections 20 in month 60 in 1st following month 15 i... 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

Management Accounting

Authors: Will Seal, Carsten Rohde, Ray Garrison, Eric Noreen

6th Edition

0077185536, 978-0077185534

More Books

Students also viewed these Accounting questions