formulas, where q is the number of labor-hours worked in a month: Cost Formulas Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration $16.50q $4,400 + $1.80q $5,600 + $0.60q $1,800+ $0.20q $18,800+ $2.70q $8,200 $2,500 $13,700 + $0.80q The Production Department planned to work 4,400 labor-hours in March; however, it actually worked 4,200 labor-hours during the month. Its actual costs incurred in March are listed below: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Actual Cost Incurred in March $ 70,920 $ 11,500 $ 8,630 $ 2,890 $ 30,140 $ 8,600 $ 2,500 $ 16,450 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. Answer is complete but not entirely correct.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question
100%

Hi,

I really need help with this three-part question.

Your assistance is appreciated.

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.
Complete this question by entering your answers in the tabs below.
Required 1 Required 2 Required 3
Prepare the Production Department's flexible budget for the month.
Packaging Solutions Corporation
Production Department Flexible Budget
For the Month Ended March 31
Actual labor-hours
Direct labor
Indirect labor
Utilities
Supplies
Equipment depreciation
Factory rent
Property taxes
Factory administration
Total expense
Answer is complete but not entirely correct.
$
$
0x
0x
0x
0x
0x
0X
0x
0X
0X
0
< Required 1
Required 3 >
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.
Complete this question by entering your answers in the tabs below.
Required 1
Required 2
Budgeted labor-hours
Direct labor
Indirect labor
Utilities
Supplies
Equipment depreciation
Prepare the Production Department's planning budget for the month.
Packaging Solutions Corporation
Production Department Planning Budget
For the Month Ended March 31
✓
Factory rent
Property taxes
Factory administration
Total expense
> Answer is complete but not entirely correct.
$
$
Required 3
0x
0X
0x
0x
0x
0x
0x
0x
0x
0
< Required 1
Required 2 >
PICCOLLAGE
Transcribed Image Text: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. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Prepare the Production Department's flexible budget for the month. Packaging Solutions Corporation Production Department Flexible Budget For the Month Ended March 31 Actual labor-hours Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Total expense Answer is complete but not entirely correct. $ $ 0x 0x 0x 0x 0x 0X 0x 0X 0X 0 < Required 1 Required 3 > 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. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Budgeted labor-hours Direct labor Indirect labor Utilities Supplies Equipment depreciation Prepare the Production Department's planning budget for the month. Packaging Solutions Corporation Production Department Planning Budget For the Month Ended March 31 ✓ Factory rent Property taxes Factory administration Total expense > Answer is complete but not entirely correct. $ $ Required 3 0x 0X 0x 0x 0x 0x 0x 0x 0x 0 < Required 1 Required 2 > PICCOLLAGE
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 g is the number of labor-hours worked in a month:
Direct labor
Indirect labor
Utilities
Supplies
Equipment depreciation
Factory rent
Property taxes
Factory administration
The Production Department planned to work 4,400 labor-hours in March; however, it actually worked 4,200 labor-hours during the
month. Its actual costs incurred in March are listed below:
Direct labor
Indirect labor
Utilities
Supplies
Equipment depreciation
Factory rent
Property taxes
Factory administration
Cost Formulas
$16.509
$4,400+ $1.80q
$5,600 + $0.60q
$1,800 + $0.209
$18,800 + $2.709
$8,200
$2,500
$13,700 + $0.809
Labor-hours
Direct labor
Indirect labor
Actual Cost
Incurred in
March
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.
Utilities
Supplies
Equipment depreciation
Factory rent
Property taxes
Factory administration
Total expense
Complete this question by entering your answers in the tabs below.
$ 70,920
$ 11,500
$ 8,630
Required 1
Required 2 Required 3
Calculate the spending variances for all expense items. (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.)
Packaging Solutions Corporation
$2,890
$ 30,140
$ 8,600
$ 2,500
$ 16,450
4,200
S 70,920
11,500
8,630
2,890
30,140
8,600
2,500
Answer is complete but not entirely correct.
16,450
S 151,630
Spending Variances
For the Month Ended March 31
Actual
Results
Spending Variances
s
S
0X U
0X F
0X U
0X U
0 None
0X U
0 None
0X F
0
U
>
Flexible
Budget
S
S
0
0x
0x
0X
0x
0x
0x
0x
0x
Transcribed Image Text: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 g is the number of labor-hours worked in a month: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration The Production Department planned to work 4,400 labor-hours in March; however, it actually worked 4,200 labor-hours during the month. Its actual costs incurred in March are listed below: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Cost Formulas $16.509 $4,400+ $1.80q $5,600 + $0.60q $1,800 + $0.209 $18,800 + $2.709 $8,200 $2,500 $13,700 + $0.809 Labor-hours Direct labor Indirect labor Actual Cost Incurred in March 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. Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Total expense Complete this question by entering your answers in the tabs below. $ 70,920 $ 11,500 $ 8,630 Required 1 Required 2 Required 3 Calculate the spending variances for all expense items. (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.) Packaging Solutions Corporation $2,890 $ 30,140 $ 8,600 $ 2,500 $ 16,450 4,200 S 70,920 11,500 8,630 2,890 30,140 8,600 2,500 Answer is complete but not entirely correct. 16,450 S 151,630 Spending Variances For the Month Ended March 31 Actual Results Spending Variances s S 0X U 0X F 0X U 0X U 0 None 0X U 0 None 0X F 0 U > Flexible Budget S S 0 0x 0x 0X 0x 0x 0x 0x 0x
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Performance measurements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education