Question

In: Accounting

Exercise 9-30 Professional Services Budget; Dental Practice; Activity-Based Budgeting (LO 9-3, 9-4, 9-5) Metropolitan Dental Associates...

Exercise 9-30 Professional Services Budget; Dental Practice; Activity-Based Budgeting (LO 9-3, 9-4, 9-5)

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 $65 for half-hour appointments and $120 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 $100 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 $ 3.00 per office visit (of any length)
All other overhead and administrative expenses $ 8.00 per direct professional labor hour

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.

Solutions

Expert Solution

Solution 1:

Professional services in June:
One hour- visits 1350 hours
Half- hour visits 1575 hours
Total direct professional labor 2925 hours
Hourly rate for dental associates $100.00
Total direct professional labor costs $292,500.00

solution 2:

Particulars May June
Half hourly visits 3150 3150
Billing rate $65.00 $65.00
Total billings for half hourly visits $204,750.00 $204,750.00
One hour visits 1350 1350
Billing rate $120.00 $120.00
Total billings for one hour visits $162,000.00 $162,000.00
Total billings during month $366,750.00 $366,750.00
% of month billings collected during june 10% 90%
Collections during june $36,675.00 $330,075.00
Total collections in june $366,750.00

Solution 3:

Overhead and administrative expense budget - June
Patient registration and records (4500*$3) $13,500.00
Other overhead and administrative expenses (2925*$8) $23,400.00
Total $36,900.00

Related Solutions

Required information Problem 9-31 Production and Direct-Labor Budgets; Activity-Based Overhead Budget (LO 9-3, 9-4, 9-5, 9-6)...
Required information Problem 9-31 Production and Direct-Labor Budgets; Activity-Based Overhead Budget (LO 9-3, 9-4, 9-5, 9-6) [The following information applies to the questions displayed below.] Spiffy Shades Corporation manufactures artistic frames for sunglasses. Talia Demarest, controller, is responsible for preparing the company’s master budget. In compiling the budget data for 20x1, Demarest has learned that new automated production equipment will be installed on March 1. This will reduce the direct labor per frame from 1.0 hour to 0.75 hour. Labor-related...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO 8-7, LO8-9, LO 8-10 Endless Mountain Company manufactures a single product that is popular with recreation enthusiasts. The company sells its product to retailers throughout the quadrant of the United States. It is in the process of creating a master budget for reports a balance sheet as December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current Assets: Cash...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO 8-7, LO8-9, LO 8-10 Endless Mountain Company manufactures a single product that is popular with recreation enthusiasts. The company sells its product to retailers throughout the quadrant of the United States. It is in the process of creating a master budget for reports a balance sheet as December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current Assets: Cash...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO 8-7, LO8-9, LO 8-10 Endless Mountain Company manufactures a single product that is popular with recreation enthusiasts. The company sells its product to retailers throughout the quadrant of the United States. It is in the process of creating a master budget for reports a balance sheet as December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current Assets: Cash...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO...
Integration Exercise 9 Master Budgeting. LO 8-2, LO 8-3, LO 8-4, LO 8-5, LO 8-6, LO 8-7, LO8-9, LO 8-10 Endless Mountain Company manufactures a single product that is popular with recreation enthusiasts. The company sells its product to retailers throughout the quadrant of the United States. It is in the process of creating a master budget for reports a balance sheet as December 31, 2016 as follows: Endless Mountain Company Balance Sheet December 31, 2016 Assets Current Assets: Cash...
Exercise 9-44 (Algo) Activity-Based Costing versus Traditional Costing (LO 9-4, 5, 6) Doaktown Products manufactures fishing...
Exercise 9-44 (Algo) Activity-Based Costing versus Traditional Costing (LO 9-4, 5, 6) Doaktown Products manufactures fishing equipment for recreational uses. The Miramichi plant produces the company’s two versions of a special reel used for river fishing. The two models are the M-008, a basic reel, and the M-123, a new and improved version. Cost accountants at company headquarters have prepared costs for the two reels for the most recent period. The plant manager is concerned. The cost report does not...
Problem 9-42 Preparation of Master Budget (LO 9-3, 9-4, 9-5) [The following information applies to the...
Problem 9-42 Preparation of Master Budget (LO 9-3, 9-4, 9-5) [The following information applies to the questions displayed below.] FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box C P Direct material required per 100 boxes: Paperboard ($0.34 per pound) 50 pounds 90 pounds Corrugating medium ($0.17 per pound) 40...
which among these is plausible: 1. Zero based budgeting 2. Activity based budgeting 3. Rolling budget.
which among these is plausible: 1. Zero based budgeting 2. Activity based budgeting 3. Rolling budget.
Integration Exercise 4 Plantwide and Departmental Overhead Allocation; Activity-Based Costing; Segmented Income Statements [LO 3-1, LO...
Integration Exercise 4 Plantwide and Departmental Overhead Allocation; Activity-Based Costing; Segmented Income Statements [LO 3-1, LO 3-2, LO 3-3, LO 3-4, LO 4-4, LO 4-5, LO 5-1, LO 5-3, LO 5-4] Koontz Company manufactures two models of industrial components—a Basic model and an Advanced Model. The company considers all of its manufacturing overhead costs to be fixed and it uses plantwide manufacturing overhead cost allocation based on direct labor-hours. Koontz’s controller prepared the segmented income statement that is shown below...
Required information Problem 9-42 Preparation of Master Budget (LO 9-3, 9-4, 9-5) [The following information applies...
Required information Problem 9-42 Preparation of Master Budget (LO 9-3, 9-4, 9-5) [The following information applies to the questions displayed below.] FreshPak Corporation manufactures two types of cardboard boxes used in shipping canned food, fruit, and vegetables. The canned food box (type C) and the perishable food box (type P) have the following material and labor requirements. Type of Box C P Direct material required per 100 boxes: Paperboard ($0.40 per pound) 35 pounds 75 pounds Corrugating medium ($0.20 per...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT