I need help solving this. all of the information is provided below.
P7-35 (similar to) Question Help Jill Bailey has run Therapeutic 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. i (Click the icon to view the employee information.) (Click the icon to view the actual and budgeted income statements.) Read the requirements. 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.) Data Table - X E x ) + ( X Y ) = B i X F Next, calculate the budgeted and actual number of offices for each employee type. Actual i Formula labels - X Budgeted Therapeutic Maids number of offices number of offices Actual and Budgeted Income Statements Experienced employee For the Month Ended April 30, 2017 A Contribution margin Less experienced employees Budget Actual B Labor costs 240 280 Operating income Offices cleaned i More Info X D Revenue Revenue $ 40,800 $ 56,000 E Wage paid to experienced employee per office Variable costs: F Wage paid to less experienced employees per office Costs of supplies 1,320 2,095 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 Labor 5,760 6,750 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 Print Done Total variable costs 7,080 8,845 $30 per office and the other two employees $15 per office. There were no wage Contribution margin 33,720 47,155 increases in April. Fixed costs 9,800 9,800 Operating income 23,920 $ 37,355 ? Print Done remaining Clear All Print Done