Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared monthly for each department. The planning budget and flexible budget for the Production Department are based on the following formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor $16.30q Indirect labor $4,100 + $2.00q Utilities $5,100 + $0.50q Supplies $1,300 + $0.40q Equipment depreciation $18,100 + $2.50q Factory rent $8,500 Property taxes $2,700 Factory administration $13,300 + $0.60q The Production Department planned to work 4,200 labor-hours in March; however, it actually worked 4,000 labor-hours during the month. Its actual costs incurred in March are listed below: Actual Cost Incurred in March Direct labor $ 66,780 Indirect labor $ 11,680 Utilities $ 7,590 Supplies $ 3,190 Equipment depreciation $ 28,100 Factory rent $ 8,900 Property taxes $ 2,700 Factory administration $ 15,050 Required: 1. Prepare the Production Department’s planning budget for the month. 2. Prepare the Production Department’s flexible budget for the month. 3. Calculate the spending variances for all expense items.

Respuesta :

Answer:

Packaging Solutions Corporation

1. Planning Budget

Direct labor                              $68,460

Indirect labor                            $12,500

Utilities                                       $7,200

Supplies                                     $2,980

Equipment depreciation        $28,600

Factory rent                              $8,500

Property taxes                          $2,700

Factory administration           $15,820

2. Flexible Budget

Direct labor                             $65,200

Indirect labor                            $12,100

Utilities                                       $7,100

Supplies                                   $2,900

Equipment depreciation        $28,100

Factory rent                             $8,500

Property taxes                         $2,700

Factory administration          $15,700

3. Spending Variances:

                                                  Flexible  Actual       Spending

                                                  Budget  Budget       Variance

Direct labor                             $65,200  $66,780     $1,580 U

Indirect labor                            $12,100    $11,680       $420 F

Utilities                                       $7,100    $7,590       $490 U

Supplies                                   $2,900     $3,190       $290 U

Equipment depreciation        $28,100  $28,100        $0     None

Factory rent                             $8,500   $8,500        $0     None

Property taxes                         $2,700   $2,700        $0     None

Factory administration          $15,700  $15,050        $650 F

Explanation:

a) Data and Calculations:

Planned labor-hours in March = 4,200

Actual labor-hours in March = 4,000

Cost Formulas

Direct labor $16.30q

Indirect labor $4,100 + $2.00q

Utilities $5,100 + $0.50q

Supplies $1,300 + $0.40q

Equipment depreciation $18,100 + $2.50q

Factory rent $8,500

Property taxes $2,700

Factory administration $13,300 + $0.60q

Actual Cost Incurred In March:

Direct labor                      $ 66,780

Indirect labor                     $ 11,680

Utilities                               $ 7,590

Supplies                             $ 3,190

Equipment depreciation $ 28,100

Factory rent                      $ 8,900

Property taxes                  $ 2,700

Factory administration   $ 15,050

Flexible Budget:

Direct labor $16.30 * 4,000 = $65,200

Indirect labor $4,100 + $2.00  * 4,000 = $12,100

Utilities $5,100 + $0.50 * 4,000 = $7,100

Supplies $1,300 + $0.40 * 4,000 = $2,900

Equipment depreciation $18,100 + $2.50 * 4,000 = $28,100

Factory rent $8,500

Property taxes $2,700

Factory administration $13,300 + $0.60 * 4,000 = $15,700

Planning Budget

Direct labor $16.30 * 4,200 = $68,460

Indirect labor $4,100 + $2.00 * 4,200 = $12,500

Utilities $5,100 + $0.50 * 4,200 $7,200

Supplies $1,300 + $0.40 * 4,200 $2,980

Equipment depreciation $18,100 + $2.50 * 4,200 = $28,600

Factory rent $8,500

Property taxes $2,700

Factory administration $13,300 + $0.60 * 4,200 = $15,820