Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following information was taken from the financial records of Platinum Plc. The bookkeeper of Platinum Plc prepared the following basic budget for the following

The following information was taken from the financial records of Platinum Plc. The bookkeeper of Platinum Plc prepared the following basic budget for the following two months: 31 December 2017 and January 2018:

Description

December

January

Sales

Purchases

380 000

180 000

388 000

186 000

The bank statement showed a credit balance of R11 500 on 1 December 2017.

Platinum Plc reported the following actual total sales for the three months ended 30 November 2017 (NB: 80% of the sales, including those reported in the table above, are on credit):

September R270 000

October R330 000

November R390 000

Credit sales are to be collected as follows:

30% in the month of the sale

40% after 30 days

28% after 60 days

2% are written off after 90 days

All purchases are on credit and creditors are paid two months after the expense occurred. Credit purchases for September, October, and November amounted to R162 400, R166 900 and R170 500 respectively. Stock balances at the end of November, December and January was R11 800, R16 400 and R15 600 respectively.

New delivery vehicle will be purchased on 1 December 2017 for R150 000 and depreciated at 10% p.a. on cost. Platinum Plc will finance the deposit of the vehicle of R50 000 with a loan from PNP Bank and settle the remaining R100 000 with 4 equal monthly instalments beginning 31 December 2017. The loan bears interest of 15% p.a. payable monthly in arrears. The capital on the loan is repayable in two years time as a lumpsum.

REQUIRED

(a)

Prepare the performance budget of Platinum Plc for the two months period commencing on 1 December 2017 to 31 January 2018.

(a)

Prepare the debtors collection schedule of Platinum Plc for the two months period commencing on 1 December 2017 to 31 January 2018.

(b)

Prepare the cash budget for Platinum Plc for the two months period commencing on 1 December 2017 to 31 January 2018.

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_2

Step: 3

blur-text-image_3

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

Contemporary Labor Economics

Authors: Campbell McConnell, Stanley Brue, David Macpherson

9th Edition

0073375950, 9780073375953

More Books

Students also viewed these Accounting questions

Question

2 / 5x 4 = 2x 3 / 4

Answered: 1 week ago

Question

What steps will Sara need to take to conduct a benefit audit?

Answered: 1 week ago