Question
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
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