Question
As at 31 December 2020 Assets-AUD Cash-156,000 Accounts Receivable- 33,400 Orthodontic Equipment- 650,000 Less: Accumulated Depreciation-( 120,000) Total Assets= $719,400 Liabilities & Shareholder Equity Accounts
As at 31 December 2020
Assets-AUD
Cash-156,000
Accounts Receivable- 33,400
Orthodontic Equipment- 650,000
Less: Accumulated Depreciation-( 120,000)
Total Assets= $719,400
Liabilities & Shareholder Equity
Accounts Payable 59,400
Bank Loan400,000
Retained Earnings 260,000
Total Liabilities & Shareholders' Equity $719,400
The following table outlines the operating costs for the year. Operating Costs
Payment
Utilities (Water & Electricity)-$100 / month Paid quarterly
Insurance- $5 500 / yearPaid monthly
Lead Orthodontist Salary x1-$186 000 / year excluding on-costs Paid monthly
Graduate Orthodontist x 1-$90 000 / year excluding on-costs Paid monthly
Assistant Orthodontist x 2- $60 000 /year excluding on-costsPaid monthly
Administration Staff Wages- $2 500/month Paid monthly
General Office Expenses- $500 /monthPaid monthly
Rent- $1 000 /month Paid monthly
Orthodontist supplies- $400 / monthPaid quarterly
Additional Background Information
Salaries: There are two orthodontists (one who is a graduate) and two assistant orthodontists. They are all paid an annual salary. It is estimated that their on-costs are 30% of their annual salary. They work 37.5 hours per week. Each appointment requires an orthodontist (lead or graduate) and an assistant.
Each employees allowance for annual leave, public holidays and sick leave amounts to 8 weeks per year. They are also given an allowance for non-billable time of 2 hours per week which includes professional development, department meetings and idle time.
Payments: It is estimated that 30% of all operating expenses will be paid in the month they are due and the remaining 70% will be paid in the following month.
Loan: The business has an interest only loan. The interest is paid monthly. The principle can be repaid at any time. The interest rate payable on the loan is 15% per annum.
Orthodontic Equipment: Depreciation on the Orthodontic equipment totals $20,000 for the year. Depreciation is recorded monthly.
Repairs and maintenance: The orthodontic equipment repairs and maintenance is estimated to be $700 each quarter payable in March, June, September, and December.
Cash collections: Twenty per cent (20%) of each month's professional services revenue is collected during the month when the services are rendered and the remainder is collected the month following service.
Expected patient visits for 2021 are indicated in the table below. 75% of the visits are expected to be half-hour appointments and the remainder will be one hours visits:
Month- Expected Patients
January 2021- 300
February 2021- 350
March 2021- 320
April 2021- 300
May 2021- 350
June 2021-370
July 2021-380
August 2021- 400
September 2021- 400
October 2021- 400
November 2021- 400
December 2021- 400
The average fees received for the two (2) different types of appointments are $110 for half an hour (30 minutes) and $330 for one hour (60 minutes).
Budget Schedules & Expected Outcomes
Using the information provided, we need operating and financial budgets for the twelve-month period from January 2021 to December 2021.
Operating Budgets:
1. Monthly Revenue
2. Labour Budget (including labour cost per appointment type)
3. Monthly Operating Expense Budget
Financial Budgets:
1. Budgeted Income Statement for the year ended 31 December 2021
2. Monthly Cash flow Budget for the year ended 31 December 2021
3. Budgeted Balance Sheet for the year ended 31 December 2021
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