Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(Click the icon to view the employee information.) Jeanine Barnsworth has run Cleaning Maids, a specialty cleaning service for medical and dental offices, for the

image text in transcribed

(Click the icon to view the employee information.) Jeanine 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. F: (Click the icon to view the actual and budgeted income statements.) Requirements - X Read the requirements 1. 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.) ) + Y ) = Data Table 2. 3. How many offices, on average, did Barnsworth 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 Barnsworth to gather, if you wanted to improve operational efficiency? 4. Formula labels Print Done Cleaning Maids Actual and Budgeted Income Statements For the Month Ended April 30, 2017 Budget Actual Offices cleaned 280 320 $ Revenue 36,400 $ 51,200 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 Variable costs: Costs of supplies 1.260 6,720 1,360 8,400 Labor 7.980 9.760 Print Done Total variable costs Contribution margin 28.420 9,800 41,440 9.800 Fixed costs $ 18,620 $ 31,640 Operating income Print Done (Click the icon to view the employee information.) Jeanine 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. F: (Click the icon to view the actual and budgeted income statements.) Requirements - X Read the requirements 1. 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.) ) + Y ) = Data Table 2. 3. How many offices, on average, did Barnsworth 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 Barnsworth to gather, if you wanted to improve operational efficiency? 4. Formula labels Print Done Cleaning Maids Actual and Budgeted Income Statements For the Month Ended April 30, 2017 Budget Actual Offices cleaned 280 320 $ Revenue 36,400 $ 51,200 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 Variable costs: Costs of supplies 1.260 6,720 1,360 8,400 Labor 7.980 9.760 Print Done Total variable costs Contribution margin 28.420 9,800 41,440 9.800 Fixed costs $ 18,620 $ 31,640 Operating income Print Done

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematics Of Finance

Authors: Petr Zima

2nd Edition

0070082030, 9780070082038

More Books

Students also viewed these Accounting questions

Question

What are the different processes employed for liquefying a gas?

Answered: 1 week ago

Question

What are the current HRM challenges in the textile industry?

Answered: 1 week ago