Jan Barnsworth has run Cleaning Maids, a specialty cleaning service for medical and dental offices, for...
Fantastic news! We've Found the answer you've been seeking!
Transcribed Image Text:
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. A (Click the icon to view the employee information.) E (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 More Info Cleaning Maids 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. Actual and Budgeted Income Statements For the Month Ended April 30, 2017 Budget Actual 260 300 Offices cleaned 2$ 44,200 $ 60,000 Revenue Print Done Variable costs: Costs of supplies 1,300 2,075 7,800 9,600 Labor 9,100 11,675 Total variable costs Choose from any drop-down list and then click Check Answer. Contribution margin 35,100 48,325 9,100 9,100 7 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.) )+ ( 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 Flexible budget 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 Actual # of offices variance X 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 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. A (Click the icon to view the employee information.) E (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 More Info Cleaning Maids 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. Actual and Budgeted Income Statements For the Month Ended April 30, 2017 Budget Actual 260 300 Offices cleaned 2$ 44,200 $ 60,000 Revenue Print Done Variable costs: Costs of supplies 1,300 2,075 7,800 9,600 Labor 9,100 11,675 Total variable costs Choose from any drop-down list and then click Check Answer. Contribution margin 35,100 48,325 9,100 9,100 7 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.) )+ ( 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 Flexible budget 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 Actual # of offices variance X 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
Expert Answer:
Answer rating: 100% (QA)
1 Let XNumber of offices cleaned by experienced employee YNumber of offices cleaned by less experien... View the full answer
Related Book For
Essentials of Marketing
ISBN: 978-0078028885
13th edition
Authors: William D. Perreault, Joseph P. Cannon
Posted Date:
Students also viewed these accounting questions
-
Explain which transportation mode would probably be most suitable for shipping the following goods to a large Los Angeles department store: a. 300 pounds of Maine lobster. b. 15 pounds of...
-
Explain which transportation mode would probably be most suitable for shipping the following goods to a large Los Angeles department store: a. 300 pounds of Maine lobster. b. 15 pounds of...
-
The budgeted and actual revenues and expenditures of Seaside Township for a recent year (in millions) were as presented in the schedule that follows. 1. Prepare journal entries to record the budget....
-
The Archaic period also gave rise to some economic, social and political cooperation, best represented by the emergence of Kingdoms Republics Tyrannies Poleis
-
(a) What is the standard normal curve? (b) How is it applied to a set of data? (c) What three criteria should be met for it to give an accurate description of the scores in a sample?
-
Repeat Problem for a carrier frequency of 12 GHz.
-
Draw an energy diagram for the cart in Figure 9.2 \(b\). Figure 9.2 The work done on a system is positive if the system gains kinetic energy and negative if the system loses kinetic energy. (a) Cart...
-
Xavier Company is going through a Chapter 7 bankruptcy. All assets have been liquidated, and the company retains only $25,200 in free cash. The following debts, totaling $38,050, remain: Government...
-
1. In the system shown in figure, all surfaces are smooth. Rod is moved by external agent with acceleration 0.9 ms vertically downwards. Force exerted on the rod by the wedge will be Newtons.
-
Determine the objectives of the test. You are auditing both quantities and pricing of the final inventory accumulation. a. Explain the assertions that you are testing. b. Explain the evidence that...
-
A passenger on an airplane that is flying at 9000 ft (2740 m) above sea level opens a bottle of water, empties the contents, and then screws the cap back on the bottle. What may be expected to occur...
-
You want you to sell 1.46 million British pounds (GBP) using put options and foreign exchange market. How much would be the net proceeds to sell GBP1.46 million if the spot rate is A$1.8501 at the...
-
A commonality design can minimise the manufacturing and servicing cost of the system. Each of the human comfort areas will be equipped with an AHU system. The AHU will use cold water to absorb the...
-
1. Program to Print the below triangle using for loop. 5 4 4 3 3 3 2 2 2 2 1 1 1 1 1
-
complete any financial tasks that will take more than 2 hours. 20% Task Time to Complete (in hours) Pay consulting fees 2 Create project budget 3 Write technical report 5 Research project ideas 2...
-
By Using R Studio, please correct my mistakes of the attached files. Could you look at the red parts? Please make sure that everything is running correctly. Q1. Build an animated bubble chart with a...
-
Two cars leave towns 800 kilometers apart at the same time and travel toward each other. One car's rate is 10 kilometers per hour less than the other's. If they meet in 5 hours, what is the rate of...
-
In the busy port of Chennai, India, the number of containers loaded onto ships during a 15-week period is as follows: 1. Develop a linear trend equation to forecast container loadings. 2. Using the...
-
Discuss why economies of scale in transportation might encourage a producer to include a regional merchant wholesaler in the channel of distribution for its consumer product.
-
Discuss some of the likely problems facing the marketing manager in a small firm who plans to search the Internet for information on competitors marketing plans.
-
Promotion has been the target of considerable criticism. What specific types of promotion are probably the object of this criticism? Give a particular example that illustrates your thinking.
-
Consider the feedback system shown in Figure 10.26. a. Using Routh's stability criterion, determine the range of the control gain \(K\) for which the closed-loop system is stable. b. Use MATLAB...
-
Figure 10.40 shows a negative feedback control system. a. Design a P controller such that the damping ratio of the closed-loop system is 0.5 . b. Estimate the rise time, overshoot, and \(2 \%\)...
-
The transfer function of a dynamic system is given by \[G(s)=\frac{s+1}{4 s^{4}+5 s^{3}+2 s^{2}+s+6} \] a. Using Routh's stability criterion, determine the stability of the system. b. Using MATLAB,...
Study smarter with the SolutionInn App