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 54,000 office visits, to be evenly distributed throughout the year. Seventy 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 $80 for half-hour appointments and $130 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 $110 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 All other overhead and administrative expenses Required: $ 3.00 $ 8.00 per office visit (of any length) per direct professional labor hour 1. Prepare the direct-professional-labor budget schedule for the month of June. 2. Prepare the budget schedule for cash collections during June for professional services rendered during May and June. 3. Prepare the overhead and administrative expense budget schedule for the month of June. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Prepare the direct-professional-labor budget schedule for the month of June. Professional services in June: One-hour visits hours hours 0 hours Half-hour visits Total direct professional labor Hourly rate for dental associates Total direct professional labor cost $ 0 May June Half-hour visits Billing rate Total billings for half-hour visits $ 0 $ 0 One-hour visits Billing rate Total billings for one-hour visits $ 0 $ 0 Total billings during month Percentage of month's billings collected during June Collections during June Total collections in June Required 1 Required 2 Required 3 % $ 0 % Prepare the overhead and administrative expense budget schedule for the month of June. Patient registration and records Other overhead and administrative expenses Total overhead and administrative expenses $ 0

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 54,000 office visits, to be evenly distributed throughout the year. Seventy 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 $80 for half-hour appointments and $130 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 $110 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 All other overhead and administrative expenses Required: $ 3.00 $ 8.00 per office visit (of any length) per direct professional labor hour 1. Prepare the direct-professional-labor budget schedule for the month of June. 2. Prepare the budget schedule for cash collections during June for professional services rendered during May and June. 3. Prepare the overhead and administrative expense budget schedule for the month of June. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Prepare the direct-professional-labor budget schedule for the month of June. Professional services in June: One-hour visits hours hours 0 hours Half-hour visits Total direct professional labor Hourly rate for dental associates Total direct professional labor cost $ 0 May June Half-hour visits Billing rate Total billings for half-hour visits $ 0 $ 0 One-hour visits Billing rate Total billings for one-hour visits $ 0 $ 0 Total billings during month Percentage of month's billings collected during June Collections during June Total collections in June Required 1 Required 2 Required 3 % $ 0 % Prepare the overhead and administrative expense budget schedule for the month of June. Patient registration and records Other overhead and administrative expenses Total overhead and administrative expenses $ 0

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 11CE: Shalimar Company manufactures and sells industrial products. For next year, Shalimar has budgeted...

See similar textbooks