requirement 1-4

Barnsworth has run Therapeutic Maids a specialty cleaning service for medical and dents Orices for the past 10 years. Her static budget and actual results for April 2020 are shown below Click the con to view the actual and budgeted income statements Gick the icon to wow the employer information Read the requirements Requirement 1. How many offices on average, dd Barnsworth budget for each employee? How many offices did each employee actually clean? Determine the formula to show how many offices on werage, the employees cleaned. (X-number of offices cleaned by experienced employee Yunumber of offices citaned by both experienced employees) Click the con for information regarding the formula selections) ) Nest colose the budgeted and actual number of rices for each employee type Budgeted Actual number of offices number of offices Experienced employee Los experienced employees Help Me Solve This e Text Pages Get More Help Clear All Check Answer ir Data Table Therapeutic Maids Actual and Budgeted Income Statements For the Month Ended April 30, 2020 an Actual ee Budget 230 250 Offices cleaned $ 36,800 $ 47,500 Revenue Variable costs: Costs of supplies 1,610 6,210 1,810 6,900 Labor 7,820 8,710 Total variable costs Contribution margin 28,980 38,790 9,700 9,700 Fixed costs $ 19,280 $ 29,090 Operating income Print Done More Info Jill 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. Barnsworth pays her experienced employee $30 per office and the other two employees $15 per office. There were no wage increases in April. Print Done 448 44- 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 1. 2. 3. How many offices, on average, did Barnsworth budget for each employee? How many offices did each employee actually clean? Prepare a flexible budget for April 2020. 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 Barnsworth to gather, if you wanted to improve operational efficiency? . 4