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 60,000 office visits, to be evenly distributed throughout the year. Eighty percent of the visits will be halfhour appointments, and the remainder will be one-hour visits. The average rates for professional dental services are $70 for half-hour appointments and $125 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 $105 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: Required: 1. Prepare the direct-professional-labor budget schedule for the month of June. 2. Prepare the budget schedule for cash collections during June for professionai 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. Prepare the direct-professional-labor budget schedule for the month of June. Complete this question by entering your answers in the tabs Delow. 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. 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 60,000 office visits, to be evenly distributed throughout the year. Eighty percent of the visits will be halfhour appointments, and the remainder will be one-hour visits. The average rates for professional dental services are $70 for half-hour appointments and $125 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 $105 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: Required: 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. Prepare the overhead and administrative expense budget schedule for the month of June. 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 60,000 office visits, to be evenly distributed throughout the year. Eighty percent of the visits will be halfhour appointments, and the remainder will be one-hour visits. The average rates for professional dental services are $70 for half-hour appointments and $125 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 $105 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: Required: 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. Prepare the budget schedule for cash collections during June for professional services rendered during May and June. 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 60,000 office visits, to be evenly distributed throughout the year. Eighty percent of the visits will be halfhour appointments, and the remainder will be one-hour visits. The average rates for professional dental services are $70 for half-hour appointments and $125 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 bililings are negligible. Metropolitan's dental associates earn $105 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: Required: 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. Prepare the direct-professional-labor budget schedule for the month of June