Metropolitan Dental Associates is a large dental practice in Chicago. The firm’s controller is preparing the budget for the next year. The controller projects a total of 48,000 office visits, to be evenly distributed throughout the year. Eighty percent of the visits will be half-hour appointments, and the remainder will be one-hour visits. The average rates for professional dental services are $40 for half-hour appointments and $70 for one-hour office visits. Ninety percent of each month’s professional service revenue is collected during the month when services are rendered, and the remainder is collected the month following service. Uncollectible billings are negligible. Metropolitan’s dental associates earn $60 per hour.Metropolitan uses activity-based budgeting to budget office overhead and administrative expenses. Two cost drivers are used: office visits and direct professional labor. The cost-driver rates are as follows: Patient registration and records .............................................................. $2.00 per office visit (of any length)All other overhead and administrative expenses ................................... $5.00 per direct professional labor hour Required: Prepare the following budget schedules.1. Direct-professional-labor budget for the month of June.2. Cash collections during June for professional services rendered during May and June.3. Overhead and administrative expense budget for the month of June.4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following information changes: a total of 54,000 office visits are expected for the year and 70 percent of the office visits are half-hour appointments.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Metropolitan Dental Associates is a large dental practice in Chicago. The firm’s controller is preparing the budget for the next year. The controller projects a total of 48,000 office visits, to be evenly distributed throughout the year. Eighty percent of the visits will be half-hour appointments, and the remainder will be one-hour visits. The average rates for professional dental services are $40 for half-hour appointments and $70 for one-hour office visits. Ninety percent of each month’s professional service revenue is collected during the month when services are rendered, and the remainder is collected the month following service. Uncollectible billings are negligible. Metropolitan’s dental associates earn $60 per hour.
Metropolitan uses activity-based budgeting to budget office overhead and administrative expenses. Two cost drivers are used: office visits and direct professional labor. The cost-driver rates are as follows:
Patient registration and records .............................................................. $2.00 per office visit (of any length)
All other overhead and administrative expenses ................................... $5.00 per direct professional labor hour
Required: Prepare the following budget schedules.
1. Direct-professional-labor budget for the month of June.
2. Cash collections during June for professional services rendered during May and June.
3. Overhead and administrative expense budget for the month of June.
4. Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following information changes: a total of 54,000 office visits are expected for the year and 70 percent of the office visits are half-hour appointments.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 10 images
