I am not really even sure what this particular question is asking so this answer would probably be most helpful: Calculate the budgeted and actual number of offices for each employee type
A (Click the icon to view the employee information.) Jan Barnsworth 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.) Read the requirements. Requirement 1. How many offices, on average, did Barnsworth 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.) Data Table i More Info - X Jan 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 $40 per office and the other two employees $20 per office. There were no wage increases in April. Cleaning Maids Actual and Budgeted Income Statements For the Month Ended April 30, 2017 Budget Actual 260 300 Offices cleaned $ 44,200 $ 60,000 Revenue Print Done Variable costs: Costs of supplies 1,300 7.800 2,075 9,600 Labor 9.100 11.675 Choose from any drop-down list and then click Check Answer. Total variable costs Contribution margin 35,100 9,100 48,325 9,100 Fixed costs parts remaining $ 26,000 $ 39,225 Operating income 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.) x X )+(l J x y = 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 Requirement 3. Compute the sales price variance and the labor efficiency variance for each labor type. Begin with the sales price variance. Determine the formula then compute the sales price variance. Label the variance as favorable (F) or unfavorable (U). Sales price ( Actual sales price Budgeted sales price) X Actual # of offices = variance Next, determine the formula you will use to compute the labor efficiency variances. (Actual # of offices cleaned Budgeted quantity of input allowed for actual output) x Budgeted wage rate per office Now compute the labor efficiency variance for each type of labor. Label the variance as favorable (F) or unfavorable (U). Labor efficiency variance Experienced worker Less experienced workers Requirement 4. What information, in addition to that provided in the income statements, would you want Babich to gather, if you wanted to improve operational efficiency? In addition to understanding the variances computed above, Babich should attempt to keep track of the number of offices cleaned by each employee , as well as the number of hours actually spent on each office A (Click the icon to view the employee information.) Jan Barnsworth 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.) Read the requirements. Requirement 1. How many offices, on average, did Barnsworth 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.) Data Table i More Info - X Jan 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 $40 per office and the other two employees $20 per office. There were no wage increases in April. Cleaning Maids Actual and Budgeted Income Statements For the Month Ended April 30, 2017 Budget Actual 260 300 Offices cleaned $ 44,200 $ 60,000 Revenue Print Done Variable costs: Costs of supplies 1,300 7.800 2,075 9,600 Labor 9.100 11.675 Choose from any drop-down list and then click Check Answer. Total variable costs Contribution margin 35,100 9,100 48,325 9,100 Fixed costs parts remaining $ 26,000 $ 39,225 Operating income 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.) x X )+(l J x y = 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 Requirement 3. Compute the sales price variance and the labor efficiency variance for each labor type. Begin with the sales price variance. Determine the formula then compute the sales price variance. Label the variance as favorable (F) or unfavorable (U). Sales price ( Actual sales price Budgeted sales price) X Actual # of offices = variance Next, determine the formula you will use to compute the labor efficiency variances. (Actual # of offices cleaned Budgeted quantity of input allowed for actual output) x Budgeted wage rate per office Now compute the labor efficiency variance for each type of labor. Label the variance as favorable (F) or unfavorable (U). Labor efficiency variance Experienced worker Less experienced workers Requirement 4. What information, in addition to that provided in the income statements, would you want Babich to gather, if you wanted to improve operational efficiency? In addition to understanding the variances computed above, Babich should attempt to keep track of the number of offices cleaned by each employee , as well as the number of hours actually spent on each office
