expand icon
book Cost Management: A Strategic Emphasis 5th Edition by David Stout, Edward Blocher, Gary Cokins cover

Cost Management: A Strategic Emphasis 5th Edition by David Stout, Edward Blocher, Gary Cokins

Edition 5ISBN: 0073526940
book Cost Management: A Strategic Emphasis 5th Edition by David Stout, Edward Blocher, Gary Cokins cover

Cost Management: A Strategic Emphasis 5th Edition by David Stout, Edward Blocher, Gary Cokins

Edition 5ISBN: 0073526940
Exercise 41

Partial Financial Productivity Use the data for Frisen Communication Inc. in problem 16-39 to complete the requirements.

Required

1. Compute the partial financial productivity ratios for 2009 and 2010.


2. On the basis of the partial financial productivity ratios you computed, what conclusions can you draw about the firm’s productivity in 2010 relative to 2009?


3. Separate the change of the partial financial productivity ratio from 2009 to 2010 into productivity changes, input price changes, and output changes.


4. Does the detailed information provided by separating the change of the partial financial production ratio offer any additional insight into the relative productivity for 2009 and 2010?

Step-by-step solution
Verified
like image
like image

Step 1 of 4

1.,2.,3. See spreadsheet solution below:

 

 

 

 

 

2010

 

 

 

2009

 

Units manufactured

 

 

 

5,00,000

 

 

 

6,00,000

 

Units of CSU10 used

 

 

 

8,00,000

 

 

 

8,25,000

Number of labor hours used

 

1,50,000

 

 

 

2,00,000

 

Cost of CSU10 per unit

 

 

 

$156

 

 

 

$135

Direct labor wage rate per hour

 

$56

 

 

 

$63

 

 

 

 

 

 

 

 

 

 

 

Total Materials Cost

 

 

 

124,800,000

 

=800,000 x $156/unit

 

$11,13,75,000

 

Total Labor Cost

 

 

 

$84,00,000

 

=150,000 x $56/hr

 

$1,26,00,000

   Total  Materials and Labor Cost

 

133,200,000

 

?

 

$12,39,75,000

Financial Partial Productivity

 

 

 

 

 

 

 

   Materials

 

 

 

        0.004006

 

=500,000/124,800,000

 

          0.005387

 

   Labor

 

 

 

        0.059524

 

=500,000/8,400,000

 

          0.047619

Operational Partial Productivity

 

 

 

?

 

 

 

   Materials

 

 

 

          0.62500

 

=500,000/800,000

 

          0.727273

 

   Labor

 

 

 

          3.33333

 

=500,000/150,000

 

          3.000000

Current Output at Prior Year Productivity

 

 

 

?

 

 

 

   Materials

 

 

 

    6,87,500.00

 

=500,000/.727273

 

 

 

   Labor

 

 

 

    1,66,666.67

 

=500,000/3.0

 

 

Decomposition of Partial Productivity (as done in Exhibit 16.5)

 

 

 

?

 

 

 

 

 

A

 

 

 

B

 

 

 

C

 

 

 

D

 

 

 

Output

 

Current output/

 

 

 

Current output/

 

 

 

Current output/

 

 

 

Prior output/

 

 

 

Input Amount

 

Current Input x

 

Productivity

 

Cur. Ouptut at Prior Prod.

 

Input Price

 

Cur. Ouptut at Prior Prod.

 

Output

 

Prior Input x

 

Total 

 

Input Cost

 

Current input cost

 

Change

 

*Current input cost

 

Change

 

*Prior input cost

 

Change

 

Prior input cost

 

Change

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Output

 

5,00,000

 

 

 

5,00,000

 

 

 

5,00,000

 

 

 

6,00,000

 

 

 

Input Amount

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

   Materials

 

8,00,000

 

 

 

6,87,500

 

 

 

6,87,500

 

 

 

8,25,000

 

 

 

   Labor

 

1,50,000

 

 

 

1,66,667

 

 

 

1,66,667

 

 

 

2,00,000

 

 

 

Cost per unit of input

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

   Materials

 

$156

 

 

 

$156

 

 

 

$135

 

 

 

$135

 

 

 

     Labor

 

$56

 

 

 

$56

 

 

 

$63

 

 

 

$63

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Direct materials

 

                   0.004006

 

      (0.000656)

 

                   0.004662

 

         (0.000725)

 

                0.005387

 

               -  

 

           0.005387

 

   (0.001381)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Direct Labor

 

                   0.059524

 

        0.005952

 

                   0.053571

 

          0.005952

 

                0.047619

 

               -  

 

           0.047619

 

     0.011905

1.?    <div class=answer> 1.,2.,3. See spreadsheet solution below: <table cellspacing=5 cellpadding=5 border=0>     <tbody>      <tr>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right><span class=bold><span class=underline>2010</span></span> </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right><span class=bold><span class=underline>2009</span></span> </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> Units manufactured </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>5,00,000 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>6,00,000 </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> Units of CSU10 used </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>8,00,000 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>8,25,000 </td>      </tr>      <tr>       <td colspan=2 style=padding:.75pt .75pt 0cm .75pt; height:20.1pt valign=bottom nowrap> Number of labor hours used </td>       <td valign=bottom>   </td>       <td><p align=right>1,50,000 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>2,00,000 </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> Cost of CSU10 per unit </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>$156 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>$135 </td>      </tr>      <tr>       <td colspan=2 style=padding:.75pt .75pt 0cm .75pt; height:20.1pt valign=bottom nowrap> Direct labor wage rate per hour </td>       <td valign=bottom>   </td>       <td><p align=right>$56 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>$63 </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> Total Materials Cost </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=center>124,800,000 </td>       <td valign=bottom>   </td>       <td> =800,000 x $156/unit </td>       <td valign=bottom>   </td>       <td><p align=right>$11,13,75,000 </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> Total Labor Cost </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right><span class=underline>$84,00,000</span> </td>       <td valign=bottom>   </td>       <td> =150,000 x $56/hr </td>       <td valign=bottom>   </td>       <td><p align=right><span class=underline>$1,26,00,000</span> </td>      </tr>      <tr>       <td colspan=2 style=padding:.75pt .75pt 0cm .75pt; height:20.1pt valign=bottom nowrap>    Total  Materials and Labor Cost </td>       <td valign=bottom>   </td>       <td><p align=center>133,200,000 </td>       <td valign=bottom>   </td>       <td> ? </td>       <td valign=bottom>   </td>       <td><p align=right>$12,39,75,000 </td>      </tr>      <tr>       <td colspan=2 style=padding:.75pt .75pt 0cm .75pt; height:20.1pt valign=bottom nowrap> <span class=bold><span class=underline>Financial Partial Productivity</span></span> </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>    Materials </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td> <span class=bold>        0.004006</span> </td>       <td valign=bottom>   </td>       <td> =500,000/124,800,000 </td>       <td valign=bottom>   </td>       <td> <span class=bold>          0.005387</span> </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>    Labor </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td> <span class=bold>        0.059524</span> </td>       <td valign=bottom>   </td>       <td> =500,000/8,400,000 </td>       <td valign=bottom>   </td>       <td> <span class=bold>          0.047619</span> </td>      </tr>      <tr>       <td colspan=2 style=padding:.75pt .75pt 0cm .75pt; height:20.1pt valign=bottom nowrap> <span class=bold><span class=underline>Operational Partial Productivity</span></span> </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td> ? </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>    Materials </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td> <span class=bold>          0.62500</span> </td>       <td valign=bottom>   </td>       <td> =500,000/800,000 </td>       <td valign=bottom>   </td>       <td> <span class=bold>          0.727273</span> </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>    Labor </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td> <span class=bold>          3.33333</span> </td>       <td valign=bottom>   </td>       <td> =500,000/150,000 </td>       <td valign=bottom>   </td>       <td> <span class=bold>          3.000000</span> </td>      </tr>      <tr>       <td colspan=2 style=padding:.75pt .75pt 0cm .75pt; height:20.1pt valign=bottom nowrap> <span class=bold><span class=underline>Current Output at Prior Year Productivity</span></span> </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td> ? </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>    Materials </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td> <span class=bold>    6,87,500.00</span> </td>       <td valign=bottom>   </td>       <td> =500,000/.727273 </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>    Labor </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td> <span class=bold>    1,66,666.67</span> </td>       <td valign=bottom>   </td>       <td> =500,000/3.0 </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td colspan=2 style=padding:.75pt .75pt 0cm .75pt; height:20.1pt valign=bottom nowrap> <span class=bold><span class=underline>Decomposition of Partial Productivity (as done in Exhibit 16.5)</span></span> </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td> ? </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold><span class=underline>A</span></span> </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold><span class=underline>B</span></span> </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold><span class=underline>C</span></span> </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold><span class=underline>D</span></span> </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> Output </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold>Current output/</span> </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold>Current output/</span> </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold>Current output/</span> </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold>Prior output/</span> </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> Input Amount </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold>Current Input x</span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold>Productivity</span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold>Cur. Ouptut at Prior Prod.</span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold>Input Price</span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold>Cur. Ouptut at Prior Prod.</span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold>Output</span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold>Prior Input x</span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold>Total </span> </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> Input Cost </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold><span class=underline>Current input cost</span></span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold><span class=underline>Change</span></span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold><span class=underline>*Current input cost</span></span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold><span class=underline>Change</span></span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold><span class=underline>*Prior input cost</span></span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold><span class=underline>Change</span></span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold><span class=underline>Prior input cost</span></span> </td>       <td valign=bottom>   </td>       <td><p align=center><span class=bold><span class=underline>Change</span></span> </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> Output </td>       <td valign=bottom>   </td>       <td><p align=right>5,00,000 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>5,00,000 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>5,00,000 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>6,00,000 </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> Input Amount </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>    Materials </td>       <td valign=bottom>   </td>       <td><p align=right>8,00,000 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>6,87,500 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>6,87,500 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>8,25,000 </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>    Labor </td>       <td valign=bottom>   </td>       <td><p align=right>1,50,000 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>1,66,667 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>1,66,667 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>2,00,000 </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> Cost per unit of input </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>    Materials </td>       <td valign=bottom>   </td>       <td><p align=right>$156 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>$156 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>$135 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>$135 </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>      Labor </td>       <td valign=bottom>   </td>       <td><p align=right>$56 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>$56 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>$63 </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td><p align=right>$63 </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> <span class=bold>Direct materials</span> </td>       <td valign=bottom>   </td>       <td><p align=right>                   0.004006 </td>       <td valign=bottom>   </td>       <td><p align=right><span class=bold>      (0.000656)</span> </td>       <td valign=bottom>   </td>       <td><p align=right>                   0.004662 </td>       <td valign=bottom>   </td>       <td><p align=right><span class=bold>         (0.000725)</span> </td>       <td valign=bottom>   </td>       <td><p align=right>                0.005387 </td>       <td valign=bottom>   </td>       <td><p align=right>               -   </td>       <td valign=bottom>   </td>       <td><p align=right>           0.005387 </td>       <td valign=bottom>   </td>       <td><p align=right><span class=bold>   (0.001381)</span> </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>       <td valign=bottom>   </td>       <td>   </td>      </tr>      <tr>       <td valign=bottom>   </td>       <td> <span class=bold>Direct Labor</span> </td>       <td valign=bottom>   </td>       <td><p align=right>                   0.059524 </td>       <td valign=bottom>   </td>       <td><p align=right><span class=bold>        0.005952</span> </td>       <td valign=bottom>   </td>       <td><p align=right>                   0.053571 </td>       <td valign=bottom>   </td>       <td><p align=right><span class=bold>          0.005952</span> </td>       <td valign=bottom>   </td>       <td><p align=right>                0.047619 </td>       <td valign=bottom>   </td>       <td><p align=right>               -   </td>       <td valign=bottom>   </td>       <td><p align=right>           0.047619 </td>       <td valign=bottom>   </td>       <td><p align=right><span class=bold>     0.011905</span> </td>      </tr>     </tbody>    </table> 1.?


Step 2 of 4


Step 3 of 4


Step 4 of 4

close menu
Cost Management: A Strategic Emphasis 5th Edition by David Stout, Edward Blocher, Gary Cokins
cross icon