Packaging Solutions Corporation manufactures and sells a wide variety of packagi
ID: 2564372 • Letter: P
Question
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: Direct labor $ 16.40 q Indirect labor $ 4,200 + $ 1.40 q Utilities $ 5,800 + $ 0.40 q Supplies $ 1,500 + $ 0.30 q Equipment depreciation $ 18,100 + $ 2.60 q Factory rent $ 8,300 Property taxes $ 2,400 Factory administration $ 13,200 + $ 0.50 q The actual costs incurred in March in the Production Department are listed below: Actual Cost Incurred in March Direct labor $ 70,480 Indirect labor $ 9,540 Utilities $ 7,950 Supplies $ 3,030 Equipment depreciation $ 29,020 Factory rent $ 8,700 Property taxes $ 2,400 Factory administration $ 14,630 Required: 1. The company had budgeted for an activity level of 4,400 labor-hours in March. Complete the Production Department’s planning budget for the month. 2. The company actually worked 4,200 labor-hours in March. Complete the Production Department’s flexible budget for the month. 3. Complete the Production Department’s flexible budget performance report for March, including both the spending and activity variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.)
Explanation / Answer
1.
Packaging Solutions Corporation
Production Department Planning Budget
For the Month Ended March 31
Budgeted labor-hours (q)
4,400
Direct labor ($16.40q)
$ 72,160
Indirect labor ($4,200 + $1.40q)
$ 10,360
Utilities ($5,800 + $0.40q)
$ 7,560
Supplies ($1,500 + $0.30q)
$ 2,820
Equipment depreciation ($18,100 + $2.60q)
$ 29,540
Factory rent ($8,300)
$ 8,300
Property taxes ($2,400)
$ 2,400
Factory administration ($13,200 + $0.50q)
$ 15,400
Total expense
$ 148,540
2.
Packaging Solutions Corporation
Production Department Flexible Budget
For the Month Ended March 31
Actual labor-hours (q)
4,200
Direct labor ($16.40q)
$ 68,880
Indirect labor ($4,200 + $1.40q)
$ 10,080
Utilities ($5,800 + $0.40q)
$ 7,480
Supplies ($1,500 + $0.30q)
$ 2,760
Equipment depreciation ($18,100 + $2.60q)
$ 29,020
Factory rent ($8,300)
$ 8,300
Property taxes ($2,400)
$ 2,400
Factory administration ($13,200 + $0.50q)
$ 15,300
Total expense
$ 144,220
3.
Packaging Solutions Corporation
Production Department Flexible Budget Performance Report
For the Month Ended March 31
Actual Results
Spending Variances
Flexible Budget
Activity Variances
Planning Budget
Labor-hours (q)
4,200
4,200
4,400
Direct labor ($16.40q)
$ 70,480
$ 1,600
U
$ 68,880
$ 3,280
F
$ 72,160
Indirect labor ($4,200 + $1.40q)
9,540
$ 540
F
$ 10,080
$ 280
F
$ 10,360
Utilities ($5,800 + $0.40q)
7,950
$ 470
U
$ 7,480
$ 80
F
$ 7,560
Supplies ($1,500 + $0.30q)
3,030
$ 270
U
$ 2,760
$ 60
F
$ 2,820
Equipment depreciation ($18,100 + $2.60q)
29,020
$ 0
$ 29,020
$ 520
F
$ 29,540
Factory rent ($8,300)
8,700
$ 400
U
$ 8,300
$ 0
$ 8,300
Property taxes ($2,400)
2,400
$ 0
$ 2,400
$ 0
$ 2,400
Factory administration ($13,200 + $0.50q)
14630
$ 670
F
$ 15,300
$ 100
F
$ 15,400
Total expense
$ 145,750
$ 1,530
U
$ 144,220
$ 4,320
F
$ 148,540
Packaging Solutions Corporation
Production Department Planning Budget
For the Month Ended March 31
Budgeted labor-hours (q)
4,400
Direct labor ($16.40q)
$ 72,160
Indirect labor ($4,200 + $1.40q)
$ 10,360
Utilities ($5,800 + $0.40q)
$ 7,560
Supplies ($1,500 + $0.30q)
$ 2,820
Equipment depreciation ($18,100 + $2.60q)
$ 29,540
Factory rent ($8,300)
$ 8,300
Property taxes ($2,400)
$ 2,400
Factory administration ($13,200 + $0.50q)
$ 15,400
Total expense
$ 148,540
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.