Wednesday, 14 November 2012

"What's going on in that lab?" asked Derek Warren, chief administrator for Cottonwood Hospital, as

"What's going on in that lab?" asked Derek Warren, chief administrator for Cottonwood Hospital, as he studied the prior month’s reports. "Every month the lab teeters between a profit and a loss. Are we going to have to increase our lab fees again?"
     "We can't," replied Lois Ankers, the controller. "We're getting lots of complaints about the last increase, particularly from the insurance companies and governmental health units. They're now paying only about 80% of what we bill. I'm beginning to think the problem is on the cost side."
     To determine if lab costs are in line with other hospitals, Mr. Warren has asked you to evaluate the costs for the past month. Ms. Ankers has provided you with the following information:

a.
Two basic types of tests are performed in the lab—smears and blood tests. During the past month, 3,100 smears and 800 blood tests were performed in the lab.
b.
Small glass plates are used in both types of tests. During the past month, the hospital purchased 15,500 plates at a cost of $59,520. This cost is net of a 4% purchase discount. A total of 2,100 of these plates were unused at the end of the month; no plates were on hand at the beginning of the month.
c.
During the past month, 2,100 hours of labor time were used in performing smears and blood tests. The cost of this labor time was $22,785.
d. The lab’s variable overhead cost last month totaled $16,170.

     Cottonwood Hospital has never used standard costs. By searching industry literature, however, you have determined the following nationwide averages for hospital labs:

Plates:
Three plates are required per lab test. These plates cost $4 each and are disposed of after the test is completed.
Labor:
Each smear should require 0.4 hours to complete, and each blood test should require 0.8 hours to complete. The average cost of this lab time is $11.3 per hour.
Overhead:
Overhead cost is based on direct labor-hours. The average rate of variable overhead is $7.2 per hour.

Required:
1.
Compute the materials price variance for the plates purchased last month, and compute a materials quantity variance for the plates used last month. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Omit the "$" sign in your response.)

  Materials price variance     F
  Materials quantity variance     U


2. For labor cost in the lab:

a.
Compute a labor rate variance and a labor efficiency variance. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Omit the "$" sign in your response.)

  Labor rate variance     F
  Labor efficiency variance     U


b.
In most hospitals, three-fourths of the workers in the lab are certified technicians and one-fourth are assistants. In an effort to reduce costs, Cottonwood Hospital employs only one-half certified technicians and one-half assistants. Would you recommend that this policy be continued?
No

3a.
Compute the variable overhead rate and efficiency variances. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Omit the "$" sign in your response.)

  Variable overhead rate variance     U
  Variable overhead efficiency variance     U


3b.
Is there any relation between the variable overhead efficiency variance and the labor efficiency variance?
Yes


Explanation: 1.
The standard quantity of plates allowed for tests performed during the month would be:

  Smears 3,100  
  Blood tests 800  
  
  Total 3,900  
  Plates per test ×3  
  
  Standard quantity allowed 11,700  
  



The variance analysis for plates would be:

Standard Quantity Allowed
for Actual Output,
at Standard Price
Actual Quantity of
Input, at
Standard Price
Actual Quantity
of Input,
at Actual Price
(SQ × SP) (AQ × SP) (AQ × AP)
11,700 plates ×
$4 per plate
13,400 plates ×
$4 per plate
= $46,800 = $53,600 $59,520
Materials quantity

variance = $6,800 U

15,500 plates ×

$4 per plate

= $62,000    

Materials price variance
= $2,480 F

Note that all of the price variance is due to the hospital’s 4% quantity discount. Also note that the $6,800 quantity variance for the month is equal to nearly 15% of the standard cost allowed for plates. This variance may be the result of using too many assistants in the lab.

2.
a.
The standard hours allowed for tests performed during the month would be:

  Smears: .4 hour per test × 3,100 tests 1,240  
  Blood tests: .8 hour per test × 800 tests 640  
  
  Total standard hours allowed 1,880  
  



The variance analysis of labor would be:

Standard Hours Allowed
for Actual Output,
at Standard Rate
Actual Hours
of Input,
at Standard Rate
Actual Hours
of Input,
at Actual Rate
(SH × SR) (AH × SR) (AH × AR)
1,880 hours ×
$11.3 per hour
2,100 hours ×
$11.3 per hour
= $21,244    = $23,730 = $22,785
Labor efficiency variance
= $2,486 U
Labor rate variance
= $945 F

Spending Variance = $1,541 U


2.
b.
The policy probably should not be continued. Although the hospital is saving $0.45 per hour by employing more assistants relative to the number of senior technicians than other hospitals, this savings is more than offset by other factors. Too much time is being taken in performing lab tests, as indicated by the large unfavorable labor efficiency variance. And, it seems likely that most (or all) of the hospital's unfavorable quantity variance for plates is traceable to inadequate supervision of assistants in the lab.

3a.

The variable overhead variances follow:

Standard Hours Allowed
for Actual Output,
at Standard Rate
Actual Hours
of Input,
at Standard Rate
Actual Hours
of Input,
at Actual Rate
(SH × SR) (AH × SR) (AH × AR)
1,880 hours ×
$7.20 per hour
2,100 hours ×
$7.20 per hour
= $13,536     = $15,120 $16,170
Variable overhead
efficiency variance
= $1,584 U
Variable overhead
rate variance
= $1,050 U

Spending variance = $2,634 U


3b.
Yes, the two variances are related. Both are computed by comparing actual labor time to the standard hours allowed for the output of the period. Thus, if there is an unfavorable labor efficiency variance, there will also be an unfavorable variable overhead efficiency variance.

Sonne Company produces a perfume called Whim. The direct materials and direct labor standards for one bottle of Whim are given below:

Sonne Company produces a perfume called Whim. The direct materials and direct labor standards for one bottle of Whim are given below:

  Standard Quantity or Hours Standard Price  
or Rate    
Standard
Cost   
  Direct materials 6.50  ounces $ 1.90  per ounce $ 12.35    
  Direct labor 0.30  hours $ 13.00  per hour $ 3.90    


During the most recent month, the following activity was recorded:
a. 20,500 ounces of material were purchased at a cost of $1.70 per ounce.
b. All of the material was used to produce 3,000 bottles of Whim.
c. 800 hours of direct labor time were recorded at a total labor cost of $12,000.

Required:
1.
Compute the direct materials price and quantity variances for the month. (Input all amounts as positive values. Do not round your per unit rates. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Round your intermediate calculations and final answers to the nearest dollar amount. Omit the "$" sign in your response.)

     
  Direct materials price variance $   F
  Direct materials quantity variances $   U


2.
Compute the direct labor rate and efficiency variances for the month. (Input all amounts as positive values. Do not round your per unit rates, round other intermediate calculations and your final answer to nearest whole dollar. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Round your intermediate calculations and final answers to the nearest dollar amount. Omit the "$" sign in your response.)

     
  Direct labor rate variance $   U
  Direct labor efficiency variances $   F



Explanation:

Friday, 9 November 2012

Following is selected financial information of Trimark for the year ended December 31, 2011. Financial Statements

Following is selected financial information of Trimark for the year ended December 31, 2011.
Financial Statements

    
  Cash used by investing activities $ (1,750 )
  Net increase in cash   550  
  Cash used by financing activities   (2,550 )
  Cash from operating activities   4,850  
  Cash, December 31, 2010   3,900  


Required:
Prepare the 2011 statement of cash flows for Trimark Company. (Amounts to be deducted should be indicated by a minus sign. Omit the "$" sign in your response.)

Trimark
Statement of Cash Flows
For Year Ended December 31, 2011
  Cash from operating activities correct $ 4,850 correct  
  Cash used by investing activities correct -1,750 correct  
  Cash used by financing activities correct -2,550 correct  
  
  Net increase in cash correct $ 550 correct  
  Cash, December 31, 2010 correct 3,900 correct  
  
  Cash, December 31, 2011 correct $ 4,450 correct  
  

Following is selected financial information for Boardwalk for the year ended December 31, 2011. Retained earnings, Dec. 31, 2011 $ 18,750 Cash dividends $ 2,000 Net income 11,750 Retained earnings, Dec. 31, 2010 9,000

Following is selected financial information for Boardwalk for the year ended December 31, 2011.

              
  Retained earnings, Dec. 31, 2011 $ 18,750   Cash dividends $ 2,000  
  Net income   11,750   Retained earnings, Dec. 31, 2010   9,000  


Required:
Prepare the 2011 statement of Retained earnings for Boardwalk. (Amounts to be deducted should be indicated with a minus sign. Omit the "$" sign in your response.)

Boardwalk
Statement of Owner’s Equity
For Year Ended December 31, 2011
  Retained earnings, Dec. 31, 2010 correct $ 9,000 correct  
  Add: Net income correct 11,750 correct  
  
  20,750 correct  
  Less: Cash dividends correct -2,000 correct  
  
  Retained earnings, Dec. 31, 2011 correct $ 18,750 correct  
  

The following is selected financial information for Sun Energy Company for the year ended December 31, 2011: revenues, $82,000; expenses, $63,796; net income, $18,204. Required: Prepare the 2011 calendar-year income statement for Sun Energy Company. (Input all amounts as positive values. Omit the "$" sign in your response.)

The following is selected financial information for Sun Energy Company for the year ended December 31, 2011: revenues, $82,000; expenses, $63,796; net income, $18,204.

Required:
Prepare the 2011 calendar-year income statement for Sun Energy Company. (Input all amounts as positive values. Omit the "$" sign in your response.)

Sun Energy Company
Income Statement
For Year Ended December 31, 2011
  Revenues correct $ 82,000 correct  
  Expenses correct 63,796 correct  
  
  Net income correct $ 18,204 correct  
  

The following is selected financial information for Affiliated Company as of December 31, 2011: liabilities, $41,638; equity, $67,362; assets, $109,000.

The following is selected financial information for Affiliated Company as of December 31, 2011: liabilities, $41,638; equity, $67,362; assets, $109,000.

Required:
Prepare the balance sheet for Affiliated Company as of December 31, 2011. (Omit the "$" sign in your response.)

Affiliated Company
Balance Sheet
December 31, 2011
  Assets correct $ 109,000 correct  
  
 Total Assets $ 109,000 correct  
  

  Liabilities correct $ 41,638 correct  
  Equity correct 67,362 correct  
  
 Total Liabilities and Equity $ 109,000 correct  
  

The following table contains financial information from 5 different companies:


The following table contains financial information from 5 different companies:



Company
A
Company
B
Company
C
Company
D
Company
E

  December 31, 2010
















      Assets
$
37,000  

$
28,860  

$
23,680  

$
65,860

$
101,010


      Liabilities

30,340  


20,202  


12,787  


45,443


?      


  December 31, 2011
















      Assets

40,000  


28,800  


?      


72,800


110,400


      Liabilities

?      


19,584  


13,132  


34,944


87,216


  During year 2011
















      Stock issuances

6,000  


1,400  


9,750  


?    


6,500


      Net income (loss)

8,840  


?      


1,100  


10,439


7,482


      Cash dividends

3,500  


2,000  


5,875  


0


11,000


Required:
Answer the following questions about Company A (Omit the "$" sign in your response):

1a.
What is the amount of equity on December 31, 2010?

  Amount of equity
$ 6,660 correct  

1b.
What is the amount of equity on December 31, 2011?

  Amount of equity
$ 18,000 correct  

1c.
What is the amount of liabilities on December 31, 2011?

  Amount of liabilities 
$ 22,000 correct  

 
Explanation:
Company A: 
  





a.
  Equity on December 31, 2010:





  Assets
$
37,000



  Liabilities

(30,340
)

  






 Equity
$
6,660


   









b.
 Equity on December 31, 2011:





 Equity, December 31, 2010
$
6,660



 Plus stock issuances

6,000



 Plus net income

8,840



 Less cash dividends

(3,500
)

  






 Equity, December 31, 2011
$
18,000


  









c.
 Amount of liabilities on December 31, 2011:





 Assets
$
40,000



 Equity

(18,000
)

  






 Liabilities
$
22,000


  









Answer the following questions about Company B (Omit the "$" sign in your response):

2a.
What is the amount of equity on December 31, 2010?

  Amount of equity
$ 8,658 correct  

2b.
What is the amount of equity on December 31, 2011?

  Amount of equity
$ 9,216 correct  

2c.
What is net income for year 2011?

  Net income
$ 1,158 correct  

 
Explanation
Explanation:
Company B:

a. and b.

12/31/2010

12/31/2011

  Equity:




    Assets
$
28,860


$
28,800


    Liabilities

(20,202
)


(19,584
)

  








    Equity
$
8,658



9,216


  
















c.
  




  Net income for 2011:




    Equity, December 31, 2010
$
8,658


    Plus stock issuances

1,400


    Plus net income

   ?


    Less cash dividends

(2,000
)

  




    Equity, December 31, 2011
$
9,216


  









  
Therefore, net income must have been   $ 1,158.

3.
Calculate the amount of assets for Company C on December 31, 2011. (Omit the "$" sign in your response)

  Amount of Assets
$ 29,000 correct  

Explanation:
Company C:
First, calculate the beginning balance of equity:


Dec. 31, 2010
  Assets

$
23,680


  Liabilities


(12,787
)

  





  Equity

$
10,893


  










Next, find the ending balance of equity as follows:

  




  Equity, December 31, 2010
$
10,893


  Plus stock issuances

9,750


  Plus net income

1,100


  Less cash dividends

(5,875
)

  




  Equity, December 31, 2011
$
15,868


  









Finally, find the ending amount of assets by adding the ending balance of equity to the ending balance of liabilities:


Dec. 31, 2011

  Liabilities

$
13,132



  Equity


15,868



  






  Assets

$
29,000



  









4.
Calculate the amount of stock issuances for Company D during year 2011. (Omit the "$" sign in your response):









 Amount of stock issuances
$  


Explanation:
Company D:
First, calculate the beginning and ending owner’s equity balances:


12/31/2010

12/31/2011

  Assets
$
65,860


$
72,800


  Liabilities

(45,443
)


(34,944
)

  








  Equity
$
20,417



37,856


  
















Then, find the amount of stock issuances during 2011:

  



  Equity, December 31, 2010
$
20,417

  Plus stock issuances

?

  Plus net income

10,439

  Less cash dividends

0

  



  Equity, December 31, 2011
$
37,856

  







Thus, stock issuances must have been: $ 7,000

5.
Calculate the amount of liabilities for Company E on December 31, 2010. (Omit the "$" sign in your response):

  Amount of Liabilities
$  


Explanation:
Company E:
First, compute the balance of equity as of December 31, 2011:
 
  

  Assets

$
110,400


  Liabilities


(87,216
)

  





  Equity

$
23,184


  









 
Next, find the beginning balance of equity as follows:

  




  Equity, December 31, 2010
$
?


  Plus stock issuances

6,500


  Plus net income

7,482


  Less cash dividends

(11,000
)

  




  Equity, December 31, 2011
$
23,184


  









Thus, the beginning balance of equity was $20,202.

Finally, find the beginning amount of liabilities by subtracting the beginning balance of equity from the beginning balance of assets:


Dec. 31, 2010
  Assets

$
101,010


  Equity


(20,202
)

  





  Liabilities

$
80,808