Needed ASAP

Exercise 9-30 Professional Services Budger; Dental Practice; Activity-Based Budgeting (LO 9-3, 9-4, 9-5) Metropolitan Dental Associates is a latge 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. Seventy percent of the visits wil be halfhour appointments, and the remainder will be one hour visits. The average rates for professional dental services are $50 for half-hour appointments and $110 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 dentar associates earn $80 per hout: Mettopolitan uses activity-bosed budgeting to budget oftice overhead and administrative expenses. Two cost drivers are used office visits and direct prolessional labor. The cost-diver rates are as follows: Required: 1. Piepare the direct professional fabor budget schedule for the month of June 2. Prepate the budget schedule for cash collections duing June for professional services rendered duning May and June. 3. Prepare the ovethead and administrative expense budget schedule for the month of june Complete this question by entering your answers in the tabs below. Prepare the direct-professional-labor budget schedule for the month of June. Prepare the budget schedule for cash collections during June for professional services'rendered during May and June. Complete this question by entering your answers in the tabs below. Prepare the overhead and administrative expense budget schedule for the month of June