(Click the icon to view the employee information.) Read the requirements. Jeanine Bailey has run Cleaning 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 Bailey 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 Data Table Cleaning Maids Actual and Budgeted Income Statements For the Month Ended April 30, 2017 Budget Actual 290 320 Offices cleaned Revenue S 49.300 S 65.600 Variable costs Costs of supplies 1.450 1550 Labor 7.540 7.940 Total variable costs 8.990 9.490 Contribution margin 40 310 56 110 Data Table Actual 320 65.600 For the Month Ended April 30, 2017 Budget Offices cleaned 290 Revenue S 49.300 S Variable costs Costs of supplies 1.450 7.540 Labor Total variable costs 8.990 Contribution margin 40 310 Fixed costs 9.200 $ 31.110 S Operating income 1,550 7.940 9.490 56 110 9.200 46.910 Print Donate More Info x 1 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. Bailey pays her experienced employee $40 per office and the other two employees $20 per office. There were no wage increases in April. Print Done Requirements x 1. 2. 3. How many offices, on average, did Bailey 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 Bailey to gather, if you wanted to improve operational efficiency? 4. Print Dane Requirement 2. Prepare a flexible budget for June 2017. (Round your answers to the nearest whole dollar.) Cleaning Maids Income Statement Variances For the month ended April 30, 2017 23 Flexible Actual Budget 290 budget Offices cleaned 320 Revenue S 49,300 $ 65,600 Enter any number in the edit fields and then click Check Answer. 5 parts remaining Clear All Check Answer 11 surpr0CUT Flexible Actual Budget 290 budget Offices cleaned 320 Revenue $ 49,300 $ 65,600 Variable costs Costs of supplies Labor 1,450 7.540 1.550 7.940 8,990 9,490 Total variable costs Contribution margin 40,310 9,200 56,110 9.200 Fixed costs 6 Operating income 31,110 $ 46,910 Enter any number in the edit fields and then click Check Answer 5 parts remaining