Friday, 19 August 2022 07:02

ACCOUNTING TERM 3 CASE STUDY: BUDGETING

Share via Whatsapp Join our WhatsApp Group Join our Telegram Group

GRADE 12 ACCOUNTING: TERM 3 CASE STUDY BUDGETING: INFORMATION SHEET

JOHN’S DELIVERY SERVICES
The information relates to John’s Delivery Services for the budget period July – September 2022.
John Dew, the owner, started the business on 1 July 2022, after he was retrenched from his previous employment at a large delivery service company.

John’s investment (capital contribution) in the business comprises:

  • His retrenchment package which amounted to R580 000.
  • The following fixed assets, at carrying value on 1 July 2022.
Description of Asset Date of purchase Carrying value on 1 July 2022 Depreciation policy that he used to calculate the carrying value
Delivery truck 1 July 2019 R84 000 20% on cost
Maintenance equipment 1 July 2020 R162 000 10% (on diminishing balance)
Office furniture 1 January 2021 R116 250 R22 500 per annum

To supplement his capital contribution, he has negotiated, and received a loan from Plus Bank for R240 000. The money was deposited into the business bank account on 1 July 2022. The terms of the loan are as follows:

  • R6 000 to be paid at the end of each month, commencing on 31 July 2022
  • Interest at 14% p.a. payable on the last day of each month (not capitalised).

John also has a fixed deposit that will mature on 31 July 2022. This earns interest at 8,5% p.a. (not capitalised). He intends to use this money and the interest, for business purposes.
On 1 July 2022, John purchased a used bakkie for R165 000 in the name of the business, and uses the same depreciation policy for both business vehicles. He employed his cousin, Vinny, to drive this bakkie, making deliveries to clients. Vinny earns a monthly salary of R16 000.
John runs the business from premises that he rented from the inception of the business, and pays a fixed monthly rental of R5 500. The premises has a garage for the vehicles, a workshop and an office. He employs his friend as the maintenance and general handyman, who earns R6 000 per month, and a receptionist who manages the clients and the general office administration duties. She is paid R1 120 per week (5 days per week; 4 weeks per month; 7 hours per day).
Delivery services are offered to cash and credit customers. Fee income from cash customers accounts for 30% of the budgeted total fee income. Although credit terms are 30 days, John expects 45% of outstanding accounts to be settled in the month of services rendered and 55% to be received in the month following the month of services being rendered.
Packing material and other consumable stores are related to the provision of services and is budgeted at 25% of the total fee income.

  • 60% of these supplies are purchased on credit.
  • Creditors are paid in the month following the month of purchases, to receive the 5% early-payment discount.

The receptionist requested that John reduce her terms of employment as she wants to take up another part-time job opportunity as a tutor for evening class learners, commencing on 1 September 2022.
John agreed to this proposal as the receptionist is mainly needed in the mornings. As from 1 September, she will work for only 4 hours per day (instead of the 7 hours) and her pay will be adjusted accordingly.
Extract from the Cash Budget for the Budget period:

RECEIPTS JULY R AUGUST R SEPTEMBER R
Cash Fee income from delivery services ? 108000 114000
Receipts from debtors ? 240450 ?
Loan: Plus Bank 240000 - -
Fixed deposit ? - -
Interest on fixed deposit 850 - -
PAYMENTS       
Cash purchases of packing material and other consumables 33 000 36 000 ?
Payment to creditors - 47 025 ?
Salaries and wages 26 480 26 480 ?
Drawings (John’s remuneration) 22 000 25 000 25 000
Deposit on bakkie 24 750    
Monthly instalment on bakkie   5 850 5 850
Rent for the premises 5 500 5 500 5 500
Advertising 13 200 13 500 13 800
Fuel 66 000 72 000 76 000
Sundry expenses 34 000 34 000 34 000
Instalment on loan 6 000 6 000 6 000
Interest on loan 2 800 2 730 ?

Incomplete Debtors Collection Schedule:

MONTH CREDIT FEE INCOME AUGUST SEPTEMBER
July 231 000 127 050  
August 252 000  113 400  ?
September ?   ?

Comparison of PROJECTED figures and ACTUAL figures for July 2022:

  Projected Actual 
Fee income 330 000 280 500
Advertising 13 200 12 800
Packing material 82 500 70 125
Fuel 66 000 79 200

TOTAL: 50

Last modified on Friday, 19 August 2022 07:16