Jeanine Baker 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 2017 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 Baker 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.) X )+( X Y ) = Data Table - th Remedial Maids Actual and Budgeted Income Statements For the Month Ended April 30, 2017 Budget Actual Offices cleaned 260 300 Revenue $ 46,800 $ 61,500 Variable costs Costs of supplies 1,300 1,600 Labor 7,800 9,600 Total variable costs 9,100 11,200 Contribution margin 37,700 50,300 Fixed costs 9,900 9,900 $ Operating income 27,800 $ 40,400 Print Done top-UUWIT IST and TETTUICK GRATISWC 0 Requirements Hid each ces clean 1. How many offices on average, did Baker budget for each employee? How many cars did each employee actually detail? 2. Prepare a flexible budget for April 2017 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 Baker to gather, if you wanted to improve operational efficiency? Print Done i More Info - Xce til 70 EH Jeanine 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. Baker pays her experienced employee $40 per office and the other two employees $20 per office. There were no wage increases in April Print Done actually clean? i Formula labels the formula to enced employee the icon for info X number of es) 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