You are a management accountant working in the Finance team at Miles private hospital. You have...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are a management accountant working in the Finance team at Miles private hospital. You have been assigned to assist the ENT (Ear, Nose and Throat) specialists that operate out of rented premises on level 6 at the hospital. You are to prepare their master budget for 2021 and make recommendations on how they could improve their operations. There are three (3) ENT Specialists in the practice; Dr Janet Courtney, Dr Samantha Downer and Dr John Malouf. They are supported by two (2) administrative aff; Daniel Hall and Julie Sky. The following information has been gathered about the practice: ENT Clinic, John Flynn Hospital Balance Sheet As at 31 December 2020 Assets Cash Accounts Receivable ENT Equipment Less: Accumulated Depreciation Total Assets Liabilities & Shareholder Equity Accounts Payable Bank Loan Retained Earnings Total Liabilities & Shareholders Equity $AUD 56,500 48,895 1,560,000 (190,000) $1,475,395 56,400 600,000 818,995 $1,475,395 ENT Equipment: Depreciation on the ENT equipment totals $95,000 per year. Depreciation is recorded monthly. Bank Loan: The business has an interest only loan and the interest is paid monthly. The principle can be repaid at any time. The interest rate payable on the loan is 8% per annum. Expected patient visits for each of the ENT specialist 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 hour surgeries: Expected patient visits for each of the ENT specialist 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 hour surgeries: January 2021 February 2021 March 2021 April 2021 May 2021 June 2021 July 2021 August 2021 September 2021 October 2021 November 2021 December 2021 January 2022 February 2020 Dr Janet Courtney Dr Samantha Downer Dr John Malouf 95 95 95 90 80 80 80 70 70 50 50 40 40 40 50 40 40 80 80 80 80 80 80 80 80 80 80 80 80 80 80 95 95 95 95 95 95 95 95 95 95 95 The average fees received for the two (2) different types of appointments are $260 for half an hour (30 minutes) appointments and $400 for one hour surgeries (60 minutes). Cash collections: Sixty per cent (60%) of the revenue received for each month s ENT s services and surgeries is collected during the month when the services and surgeries are rendered and the remainder (40%) is collected the following month. The following table outlines the operating costs for the year. Operating Costs $1 000 /month $120/month $10 000/year $200/month $200/month $2600/month $700 / quarter Rent Utilities (Water & Electricity) Insurance Telephone, Internet & IT support General Office Expenses Surgical supplies Repairs & maintenance of ENT equipment Each ENT Specialist s Individual Salary Each Administrative Assistants Salary $300 000/year excluding on-costs $70 000/year excluding on-costs Payment Paid monthly Paid quarterly Paid monthly Paid monthly Paid monthly Paid quarterly Paid March, June, September & December Paid monthly Paid monthly 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. Salaries: The ENT specialists and administrative staff all receive an annual salary that is paid monthly. It is estimated that their on-costs² are 30% of their annual salary. They work 37.5 hours per week. Each employee s 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. Ignore GST and Income Tax. 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 Budget 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. You are a management accountant working in the Finance team at Miles private hospital. You have been assigned to assist the ENT (Ear, Nose and Throat) specialists that operate out of rented premises on level 6 at the hospital. You are to prepare their master budget for 2021 and make recommendations on how they could improve their operations. There are three (3) ENT Specialists in the practice; Dr Janet Courtney, Dr Samantha Downer and Dr John Malouf. They are supported by two (2) administrative aff; Daniel Hall and Julie Sky. The following information has been gathered about the practice: ENT Clinic, John Flynn Hospital Balance Sheet As at 31 December 2020 Assets Cash Accounts Receivable ENT Equipment Less: Accumulated Depreciation Total Assets Liabilities & Shareholder Equity Accounts Payable Bank Loan Retained Earnings Total Liabilities & Shareholders Equity $AUD 56,500 48,895 1,560,000 (190,000) $1,475,395 56,400 600,000 818,995 $1,475,395 ENT Equipment: Depreciation on the ENT equipment totals $95,000 per year. Depreciation is recorded monthly. Bank Loan: The business has an interest only loan and the interest is paid monthly. The principle can be repaid at any time. The interest rate payable on the loan is 8% per annum. Expected patient visits for each of the ENT specialist 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 hour surgeries: Expected patient visits for each of the ENT specialist 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 hour surgeries: January 2021 February 2021 March 2021 April 2021 May 2021 June 2021 July 2021 August 2021 September 2021 October 2021 November 2021 December 2021 January 2022 February 2020 Dr Janet Courtney Dr Samantha Downer Dr John Malouf 95 95 95 90 80 80 80 70 70 50 50 40 40 40 50 40 40 80 80 80 80 80 80 80 80 80 80 80 80 80 80 95 95 95 95 95 95 95 95 95 95 95 The average fees received for the two (2) different types of appointments are $260 for half an hour (30 minutes) appointments and $400 for one hour surgeries (60 minutes). Cash collections: Sixty per cent (60%) of the revenue received for each month s ENT s services and surgeries is collected during the month when the services and surgeries are rendered and the remainder (40%) is collected the following month. The following table outlines the operating costs for the year. Operating Costs $1 000 /month $120/month $10 000/year $200/month $200/month $2600/month $700 / quarter Rent Utilities (Water & Electricity) Insurance Telephone, Internet & IT support General Office Expenses Surgical supplies Repairs & maintenance of ENT equipment Each ENT Specialist s Individual Salary Each Administrative Assistants Salary $300 000/year excluding on-costs $70 000/year excluding on-costs Payment Paid monthly Paid quarterly Paid monthly Paid monthly Paid monthly Paid quarterly Paid March, June, September & December Paid monthly Paid monthly 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. Salaries: The ENT specialists and administrative staff all receive an annual salary that is paid monthly. It is estimated that their on-costs² are 30% of their annual salary. They work 37.5 hours per week. Each employee s 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. Ignore GST and Income Tax. 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 Budget 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.
Expert Answer:
Answer rating: 100% (QA)
answers E F B D 1 Labour Budget Oncosts of 2 Specialist salary Assistant Salary specialist 3 January ... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these accounting questions
-
You are a management accountant working in the controllers office. Rick Koch, a very powerful executive, approaches you in the parking lot and asks you to do him a favor. The favor involves...
-
You are a management accountant for Time Treasures Company, whose company has recently signed an outsourcing agreement with Spotless, Inc., a janitorial service company. Spotless will provide all of...
-
You are a management accountant working for a company called BHP, which manufactures iron ore. BHP's investment to progress the development of ground-breaking technology to reduce carbon emissions...
-
The Rosa model of Mohave Corp. is currently manufactured as a very plain umbrella with no decoration. The company is considering changing this product to a much more decorative model by adding a...
-
Read and report on Letter Ruling 200203010. What were the facts before the IRS? What Code section was addressed? How did the IRS rule?
-
What is the Macaulay duration of a 7 percent coupon bond with five years to maturity and a current price of $1,025.30? What is the modified duration?
-
Differentiate between Type I and Type II errors.
-
Solvo produces three types of trucks on one assembly line: the long-haul (L), the short-haul (S) and the vocational truck (V). Next month the company has orders for 500 long-haul trucks, 750...
-
At the end of May, the sales journal of Mountain View appears as follows. Assume beginning inventory balance for May to be $8,572. Sales Journal Accounts Receivable Debit Invoice Date May 6 Account...
-
Julio buys a koi fishpond (and fish to put in it) for his wife on their anniversary. He pays $8000 for the pond and fish with $2000 down. The dealer charges add-on interest of 3.5% per year, and...
-
Describe what factors contribute to the pension benefit obligation. Discuss the effect of the increase or decrease on the PBO. How is this change reported in the financial statements and what other...
-
An accrual basis calendar year taxpayer, Celery Inc., contracted with Carrot Company to repair ten pieces of equipment in their manufacturing facility. On November 30, 2024, Celery and Carrot signed...
-
A florist is buying a number of motorcycles to expand its delivery service. These will cost $78,000 but are expected to increase profits by $3000 per month over the next four years. What is the...
-
Charlies Chocolates stockholders made investments of $50,000 and received dividends of $20,000. The company has revenues of $83,000 and expenses of $64,000. Calculate its net income.
-
Item2 Item 2 When a CPA firm examines projected financial statements, the firm's report should include a separate paragraph that: Multiple Choice Limits distribution of the projections to specified...
-
Ragston, Inc. began renting a warehouse on January 1, 2022. The monthly rent is $33,600 and is due on the first day of the month. Ragston paid the rent in full on the first of each of the first 10...
-
Comfort Manufacturing is a small textile manufacturer using machine-hours as the single indirect-cost rate to allocate manufacturing overhead costs to the various jobs contracted during the year. The...
-
Sandcastles, Inc.s management has recently been looking at a proposal to purchase a new brick molding machine. With the new machine, the company would not have to buy bricks. The estimated useful...
-
The manager of a large semiconductor production department expressed his disdain for the cost information he was presently given: Cost variances are useless to me. 2 I dont want to ever have to look...
-
List some methods of gaming performance indicators.
-
How can management accounting information produce behavioral and organizational reactions?
-
Using the potential theory obtain the damping for a cycle of (i) plunge, (ii) pitch oscillations.
-
Obtain the vortex lift line slope, given by Eq. 8.14, for a supersonic delta wing. Eq. 8.14 Ky = -(cos A) ?
-
The state-space representation is based on a state function \(x\) satisfying the first order ODE \(\tau_{1} \dot{x}=x_{o}\left(\alpha-\tau_{2} \dot{\alpha} ight)-x\), where argument...
Study smarter with the SolutionInn App