Prepare the annual budget for 2021 and make recommendations

Assignment Help Managerial Accounting
Reference no: EM132640784

ACC00714 Managerial Accounting - Southern Cross University

SMILE Orthodontic Clinic is a (fictional) Orthodontic Clinic located on the Gold Coast.

You are a managerial accountant that has been hired by the managing director of the Orthodontic Clinic to prepare the annual budget for 2021 and make recommendations for improving its operations.

The following information has been gathered about the clinic:

 

SMILE Orthodontic Clinic Balance Sheet

As at 31 December 2020

Assets

 

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 Loan

400,000

Retained Earnings

260,000

Total Liabilities & Shareholders' Equity

$719,400

The orthodontic clinic is located in Burleigh and operates out of rented premises. The following table outlines the operating costs for the year.

 

 

Operating Costs

Payment

Utilities (Water & Electricity)

$100 / month

Paid quarterly

Insurance

$5 500 / year

Paid 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-costs

Paid monthly

Administration Staff Wages

$2 500/month

Paid monthly

General Office Expenses

$500 /month

Paid monthly

Rent

$1 000 /month

Paid monthly

Orthodontist supplies

$400 / month

Paid 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:

 

 

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).

PART ONE:

Budget Schedules & Expected Outcomes

Using the information provided, prepare the following 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
Your budget spreadsheet must be submitted in Excel Format (not as an appendix in your WORD document). The first worksheet should contain your raw/input data and assumptions from this assignment overview sheet. All future worksheets should be linked to this data. Show all calculations and use Excel functions where possible. While you should use examples in your text as a guide, the key to using spreadsheets is that they are structured so that others can use them and follow the flow of information without difficulty.

PART TWO:

Analysis & Report to Managing Directors of Orthodontic Clinic

Write a report for the managing director of the orthodontic clinic. The report should include:

• an overview of the expected results for the 2021 year including total sales, operating expenses and expected cash position;
• a cost-volume-profit (CVP) analysis to indicate the breakeven point (in patients and revenue) and provide recommendations regarding how to improve the current margin of safety.
• an analysis of the business operations (i.e. current incomes and expenses) and recommendations regarding how to improve the profitability of the orthodontic clinic. Use industry data (e.g. market rate for salaries) to support any recommendations for changes.
• Use visual aids such as tables and graphs to enhance your report presentation. The report should be submitted as a WORD (not PDF) document.

Attachment:- Managerial Accounting.rar

Reference no: EM132640784

Questions Cloud

Explain conflict of right and a conflict of interest : What is the difference between a conflict of right and a conflict of interest?
Imoprtance Of Strategic IT Planning : Given the growth in telecommuting and other mobile work arrangements, how might offices physically change in the coming years?
Different sources of conflict in employment relations : What are the different sources of conflict in employment relations and explain extensively the strategies to resolve conflict in employment relations?
Describing the nature of leadership : Describing the nature of leadership and distinguishing it from management.
Prepare the annual budget for 2021 and make recommendations : Write a report for the managing director of the orthodontic clinic and Use visual aids such as tables and graphs to enhance your report presentation.
Calculate cataleya corporation the degree of operating : Calculate Cataleya Corporation's the degree of operating leverage at the new projected sales level and Cataleya Corporation's new Earnings Before Interest
Power impact on expressions of conflict : Explain extensively on how might a level of power impact on expressions of conflict?
Anova and repeated measures anova designs : ANOVA and Repeated Measures ANOVA Designs. Explain your reasoning. Do you think that the design influenced the statistical significance observed?
Explain extensively the exchange theory : Explain extensively the exchange theory and state its relation to the concept of employee engagement?

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Calculate the equivalent units and assign the january costs

Calculate the equivalent units and assign the January costs to units completed (and transferred out) and to units in ending work in process

  Development of a conceptual framework

Why might a company want to engage in off-balance sheet financing and what are the four options that manufacturing and service companies have to transform breakeven or loss customers into profitable ones?

  Does guarantee that a profit will be earned for the period

If a company fully allocates all its overhead costs to a jobs, does this guarantee that a profit will be earned for the period? Why or why not?

  Find the variable and fixed cost elements of the annual cost

If a rental car were driven 80,000 kilometres during a year, what total cost would you expect to be incurred? Find the variable and fixed cost elements

  In which kind of manufacturing operations abc

Elaborate your answer while explaining key concepts like cost pools, cost drivers, pool rate etc. You may draw a diagram to illustrate you explanation

  Old guard-materials budget-reason for ending inventory

Each gallon of Old Guard, a popular aftershave lotion, requires 3 ounces of ocean scent. Budgeted production of Old Guard for the first three quarters of 2013 is:

  Jeffrey vaughn president of frame-it company was just

jeffrey vaughn president of frame-it company was just concluding a budget meeting with his senior staff. it was

  What is the overhead cost assigned to product s

What is the overhead cost assigned to Product S1 under activity-based costing? (Round the Intermediate calculation to two decimal places)

  Determine the abc cost of a resident day for each category

Determine the ABC cost of a resident day for each category of residents using assistance contacts as the cost driver. ABC-A Service Application

  What is the contribution margin per unit

Question 1: What is the contribution margin per unit? Question 2: What is the break-even point in units?

  Explain to results to the industrial engineer of THT

Do a cost of quality report for THI. The report should list all cost items categorized by type of quality cost, including percentages in relation to revenues

  Find what is the present value of a ten year

Find What is the present value of a 10-year, $30,000 after-tax annual cash flow stream at 10%? Assume the cash flows occur at the end of each period.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd