state budget and actual results for April Jan Bonino has run Healing Maids, a specialty cleaning service for medical and dental offices, for the past 10 years. Her static budget and actual results for April 2017 are shown below. (Click the icon to view the actual and budgeted income statements.) (Click the icon to view the (Click the icon to view the employee information.) Read the requirements. Requirement 1. How many offices, on average, did Bonino budget for each employee? How many offices did each employee actually clean? Determine the formula to show how many offices, on average, the employees cleaned. (X = number of offices cleaned by experienced employee, Y = number of offices cleaned by both less experienced employees) (Click the icon for information regarding the formula selections.) (D x X )+(D * Y = 0 Jan Bonino has run Healing Maids, a specialty cleaning service for medical and dental offices, for the past 10 years. Her static budget and actual results for April 2017 are shown below. (Click the icon to view the actual and budgeted income statements.) Requirement 1. How many offices, on average, did Bonino budget for each employee? How many offices did each employee actually clean? Determine the formula to show how many offices, on average, the employees cleaned. (X = number of offices cleaned by experienced employee, Y = number of offices cleaned by both less experienced employees) (Click the icon for information regarding the formula selections.) ( D x + x y )-D Data Table Healing Maids Actual and Budgeted Income Statements For the Month Ended April 30, 2017 Budget Actual Offices cleaned 290 320 Revenue $ 40,600 $ 56,000 Variable costs: Costs of supplies 2,250 Labor 7,540 7,940 Total variable costs 8,990 10,190 Contribution margin 31,610 45,810 Fixed costs 9,500 9,500 $ 22,110 $ 36,310 Operating income 1,450 Print Done 0 Formula labels A Contribution margin B Labor costs C Operating income D Revenue E Wage paid to experienced employee per office F Wage paid to less experienced employees per office Print Done A Requirements 1. How m 2. How many offices, on average, did Bonino budget for each employee? How many cars did each employee actually detail? Prepare a flexible budget for April 2017. Compute the sales price variance and the labor efficiency variance for each labor type. What information, in addition to that provided in the income statements, would you want Bonino to gather, if you wanted to improve operational efficiency? 4. Print Done state budget and actual results for April Jan Bonino has run Healing Maids, a specialty cleaning service for medical and dental offices, for the past 10 years. Her static budget and actual results for April 2017 are shown below. (Click the icon to view the actual and budgeted income statements.) (Click the icon to view the (Click the icon to view the employee information.) Read the requirements. Requirement 1. How many offices, on average, did Bonino budget for each employee? How many offices did each employee actually clean? Determine the formula to show how many offices, on average, the employees cleaned. (X = number of offices cleaned by experienced employee, Y = number of offices cleaned by both less experienced employees) (Click the icon for information regarding the formula selections.) (D x X )+(D * Y = 0 Jan Bonino has run Healing Maids, a specialty cleaning service for medical and dental offices, for the past 10 years. Her static budget and actual results for April 2017 are shown below. (Click the icon to view the actual and budgeted income statements.) Requirement 1. How many offices, on average, did Bonino budget for each employee? How many offices did each employee actually clean? Determine the formula to show how many offices, on average, the employees cleaned. (X = number of offices cleaned by experienced employee, Y = number of offices cleaned by both less experienced employees) (Click the icon for information regarding the formula selections.) ( D x + x y )-D Data Table Healing Maids Actual and Budgeted Income Statements For the Month Ended April 30, 2017 Budget Actual Offices cleaned 290 320 Revenue $ 40,600 $ 56,000 Variable costs: Costs of supplies 2,250 Labor 7,540 7,940 Total variable costs 8,990 10,190 Contribution margin 31,610 45,810 Fixed costs 9,500 9,500 $ 22,110 $ 36,310 Operating income 1,450 Print Done 0 Formula labels A Contribution margin B Labor costs C Operating income D Revenue E Wage paid to experienced employee per office F Wage paid to less experienced employees per office Print Done A Requirements 1. How m 2. How many offices, on average, did Bonino budget for each employee? How many cars did each employee actually detail? Prepare a flexible budget for April 2017. Compute the sales price variance and the labor efficiency variance for each labor type. What information, in addition to that provided in the income statements, would you want Bonino to gather, if you wanted to improve operational efficiency? 4. Print Done