Jade Barger has run Remedial Maids, a specialty cleaning service for medical and dental offices, for the past 10 years. Her static budget and actual results for April 2020 are shown below. (Click the icon to view the actual and budgeted income statements.) (Click the icon to view the employee information.) Read the requirements. Requirement 1. How many offices, on average, did Barger 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 Y )= B Next, calculate the budgeted and actual number of offices for each employee type. Experienced employee Less experienced employees Budgeted Actual number of offices number of offices Data table Requirements 1. How many offices, on average, did Barger budget for each employee? How many offices did each employee actually clean? 2. Prepare a flexible budget for April 2020. 3. Compute the sales price variance and the labor efficiency variance for each labor type. 4. What information, in addition to that provided in the income statements, would you want Barger to gather, if you wanted to improve operational efficiency? Offices cleaned Remedial Maids Actual and Budgeted Income Statements For the Month Ended April 30, 2020 Budget Actual 240 280 $ 38,400 $ 51,800 Revenue Formula labels Variable costs: Costs of supplies 1,320 2,070 More MTO B Labor costs A Contribution margin C Operating income D Revenue E Wage paid to experienced employee per office F Wage paid to less experienced employees per office 5,760 6,750 Labor 7,080 8,820 Total variable costs Contribution margin 31,320 42,980 9,100 9,100 Fixed costs $ 22,220 $ 33,880 Operating income Print Done Print Done Print Done Jade 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. Barger pays her experienced employee $30 per office and the other two employees $15 per office. There were no wage increases in April. Print Done