During October, Keliihoomalu Clinic budgeted for 2,700 patient-visits, but its actual level of activity was 2,200 patient-visits. Revenue should be $27.30 per patient-visit. Personnel expenses should be $21,100 per month plus $6.80per patient-visit. Medical supplies should be $500 per month plus $4.90 per patient-visit. Occupancy expenses should be $5,700 per month plus $0.90 per patient-visit. Administrative expenses should be $3,700 per month plus $0.40per patient-visit.Required:Prepare the clinic's flexible budget for October based on the actual level of activity for the month. What is net operating income per the flex budget?

Lets understand the basics. Management prepare flexible budget to know the amount of net operating…

During October, Keliihoomalu Clinic budgeted for 2,700 patient-visits, but its actual level of activity was 2,200 patient-visits. Revenue should be $27.30 per patient-visit. Personnel expenses should be $21,100 per month plus $6.80 per patient-visit. Medical supplies should be $500 per month plus $4.90 per patient-visit. Ocupancy expenses should be $5700 per month plus $0.90 per patient-visit. Administrative expenses should be $3,700 per month plus $0.40 per patient-visit. Required: Prepare the clinic's flexible budget for October based on the actual level of activity for the month. What is net operating income per the flex budget?

During October, Keliihoomalu Clinic budgeted for 2,700 patient-visits, but its actual level of activity was 2,200 patient-visits. Revenue should be $27.30 per patient-visit. Personnel expenses should be $21,100 per month plus $6.80 per patient-visit. Medical supplies should be $500 per month plus $4.90 per patient-visit. Ocupancy expenses should be $5700 per month plus $0.90 per patient-visit. Administrative expenses should be $3,700 per month plus $0.40 per patient-visit. Required: Prepare the clinic's flexible budget for October based on the actual level of activity for the month. What is net operating income per the flex budget?

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter12: Activity-based Management

Section: Chapter Questions

Problem 4CE: Foy Company has a welding activity and wants to develop a flexible budget formula for the activity....

See similar textbooks

Similar questions

The sales department of Macro Manufacturing Co. has forecast sales for its single product to be 20,000 units for June, with three-quarters of the sales expected in the East region and one-fourth in the West region. The budgeted selling price is 25 per unit. The desired ending inventory on June 30 is 2,000 units, and the expected beginning inventory on June 1 is 3,000 units. Prepare the following: a. A sales budget for June. b. A production budget for June.
Mesa Aquatics, Inc. estimated direct labor hours as 1,900 in quarter 1, 2,000 in quarter 2.2,200 in quarter 3, and 1,800 in quarter 4. a sales and administration budget using the information provided.
Nozama.com Inc. sells consumer electronics over the Internet. For the next period, the budgeted cost of the sales order processing activity is 250,000 and 50,000 sales orders are estimated to be processed. a. Determine the activity rate of the sales order processing activity. b. Determine the amount of sales order processing cost associated with 30,000 sales orders.
A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
Eastman, Inc., manufactures and sells three products: R, S, and T. In January, Eastman, Inc., budgeted sales of the following. At the end of the year, actual sales revenue for Product R and Product S was 3,075,000 and 3,254,000, respectively. The actual price charged for Product R was 25 and for Product S was 20. Only 10 was charged for Product T to encourage more consumers to buy it, and actual sales revenue equaled 540,000 for this product. Required: 1. Calculate the sales price and sales volume variances for each of the three products based on the original budget. 2. Suppose that Product T is a new product just introduced during the year. What pricing strategy is Eastman, Inc., following for this product?
At the beginning of the period, the Fabricating Department budgeted direct labor of 72,000 and equipment depreciation of 18,500 for 2,400 hours of production. The department actually completed 2,350 hours of production. Determine the budget for the department, assuming that it uses flexible budgeting.
Lens Junction sells lenses for $45 each and is estimating sales of 15,000 units in January and 18,000 in February. Each lens consists of 2 pounds of silicon costing $2.50 per pound, 3 oz of solution costing $3 per ounce, and 30 minutes of direct labor at a labor rate of $18 per hour. Desired inventory levels are: Â Prepare a sales budget, production budget. direct materials budget for silicon and solution, and a direct labor budget.
Digital Solutions Inc. uses flexible budgets that are based on the following data: Prepare a flexible selling and administrative expenses budget for October for sales volumes of 500,000, 750,000, and 1,000,000.
TIB makes custom guitars and prepared the following sales budget for the second quarter It also has this additional information related to its expenses: Direct material per unit $55, Direct labor per hour 20, Variable manufacturing overhead per hour 3.50, Fixed manufacturing overhead per month 3,000, Sales commissions per unit 20, Sales salaries per month 5,000, Delivery expense per unit 0.50, Utilities per month 4,000. Administrative salaries per month 20,000, Marketing expenses per month 8,000, Insurance expense per month 11,000, Depreciation expense per month 9,000. Prepare a sales and administrative expense budget for each month in the quarter ended June 30. 2018.
The following data were obtained from the financial records of Sonicbrush, Inc., for March: Sales are expected to increase each month by 15%. Prepare a budgeted income statement.
Pilsner Inc. purchases raw materials on account for use in production. The direct materials purchases budget shows the following expected purchases on account: Pilsner typically pays 25% on account in the month of billing and 75% the next month. Required: 1. How much cash is required for payments on account in May? 2. How much cash is expected for payments on account in June?
The sales department of F. Pollard Manufacturing Co. has forecast sales in March to be 20,000 units. Additional information follows: Materials used in production: Prepare the following: a. A production budget for March (in units). b. A direct materials budget for the month (in units and dollars).