A (Click the icon to view the employee information.) Janice Babich has run Helping Hand 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.) Read the requirements. Requirement 1. How many offices, on average, did Babich 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.) ( E ) + ( F x Y B Next, calculate the budgeted and actual number of offices for each employee type. Budgeted Actual number of offices number of offices Experienced employee Less experienced employees Enter any number in the edit fields and then click Check Answer. Helping Hand Maids Actual and Budgeted Income Statements For the Month Ended April 30, 2017 Budget Actual 250 280 Offices cleaned Revenue $ 37,500 $ 49,000 Variable costs: Costs of supplies 1,750 2,500 Labor 6,500 7,200 Total variable costs 8,250 9,700 Contribution margin 29,250 39,300 Fixed costs 9,200 9,200 $ 20,050 $ 30,100 Operating income i Formula labels X 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 Janice has one employee who has been with her for all 10 years that she has been in business. In addition, at any given time she also employs two other less-experienced workers. It usually takes each employee 2 hours to clean an office, regardless of his or her experience. Babich pays her experienced employee $40 per office and the other two employees $20 per office. There were no wage increases in April. A (Click the icon to view the employee information.) Janice Babich has run Helping Hand 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.) Read the requirements. Requirement 1. How many offices, on average, did Babich 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.) ( E ) + ( F x Y B Next, calculate the budgeted and actual number of offices for each employee type. Budgeted Actual number of offices number of offices Experienced employee Less experienced employees Enter any number in the edit fields and then click Check Answer. Helping Hand Maids Actual and Budgeted Income Statements For the Month Ended April 30, 2017 Budget Actual 250 280 Offices cleaned Revenue $ 37,500 $ 49,000 Variable costs: Costs of supplies 1,750 2,500 Labor 6,500 7,200 Total variable costs 8,250 9,700 Contribution margin 29,250 39,300 Fixed costs 9,200 9,200 $ 20,050 $ 30,100 Operating income i Formula labels X 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 Janice has one employee who has been with her for all 10 years that she has been in business. In addition, at any given time she also employs two other less-experienced workers. It usually takes each employee 2 hours to clean an office, regardless of his or her experience. Babich pays her experienced employee $40 per office and the other two employees $20 per office. There were no wage increases in April