Question

Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are preparedRequired 1 Required 2 Required 3 Prepare the Production Departments planning budget Packaging Solutions Corporation Producti

Required 1 Required 2 Required 3 Prepare the Production Departments flexible budge Packaging Solutions Corporation Productio

Required 1 Required 2 Required 3 Prepare the Production Departments flexible budget performance report for March, including

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answers

[1]

WORKING COLUMNS

Planning Static Budget

Labor hours

4400

Expenses:

Direct Labor

(

$                      -  

)

$    16.20

x 4400

$          71,280.00

Indirect Labor

(

$         4,700.00

)

$      2.10

x 4400

)

$          13,940.00

Utilities

(

$         5,200.00

+

$      0.70

x 4400

)

$             8,280.00

Supplies

(

$         1,800.00

+

$      0.30

x 4400

)

$             3,120.00

Equipment Depreciation

(

$      18,200.00

+

$      2.80

x 4400

$          30,520.00

Factory Rent

(

$         8,500.00

)

$           -  

x 4400

$             8,500.00

Property Taxes

(

$         2,500.00

)

$           -  

x 4400

$             2,500.00

Factory Administration

(

$      13,300.00

)

$      0.60

x 4400

$          15,940.00

Total Expenses

$      54,200.00

$    22.70

$        154,080.00

[2]

WORKING COLUMNS

Flexible Budget

Labor hours

                         4,200

Expenses:

Direct Labor

(

$                      -  

)

$    16.20

x 4200

$             68,040.00

Indirect Labor

(

$         4,700.00

)

$      2.10

x 4200

)

$             13,520.00

Utilities

(

$         5,200.00

+

$      0.70

x 4200

)

$               8,140.00

Supplies

(

$         1,800.00

+

$      0.30

x 4200

)

$               3,060.00

Equipment Depreciation

(

$      18,200.00

+

$      2.80

x 4200

$             29,960.00

Factory Rent

(

$         8,500.00

)

$           -  

x 4200

$               8,500.00

Property Taxes

(

$         2,500.00

)

$           -  

x 4200

$               2,500.00

Factory Administration

(

$      13,300.00

)

$      0.60

x 4200

$             15,820.00

Total Expenses

$      54,200.00

$    22.70

$           149,540.00

[3]

Actual Result

Revenue & Spending Variance

Flexible Budget

Activity variance

Planning Static Budget

Labor hours

                          4,200

                         4,200

                      4,400

Expenses:

Direct Labor

$               69,600.00

$         1,560.00

U

$             68,040.00

$            3,240.00

F

$          71,280.00

Indirect Labor

$               13,120.00

$             400.00

F

$             13,520.00

$                420.00

F

$          13,940.00

Utilities

$                 8,670.00

$             530.00

U

$               8,140.00

$                140.00

F

$             8,280.00

Supplies

$                 3,330.00

$             270.00

U

$               3,060.00

$                  60.00

F

$             3,120.00

Equipment Depreciation

$               29,960.00

$                      -  

N

$             29,960.00

$                560.00

F

$          30,520.00

Factory Rent

$                 8,900.00

$             400.00

U

$               8,500.00

$                         -  

None

$             8,500.00

Property Taxes

$                 2,500.00

$                      -  

N

$               2,500.00

$                         -  

None

$             2,500.00

Factory Administration

$               15,170.00

$             650.00

F

$             15,820.00

$                120.00

F

$          15,940.00

Total Expenses

$            151,250.00

$         1,710.00

U

$           149,540.00

$            4,540.00

F

$        154,080.00

Add a comment
Know the answer?
Add Answer to:
Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...

    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: 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...

  • Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...

    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.20g $4,000 $2.00g $5,200 $0.70g $1,300 $0.10g Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration $18,200 $2.60g $8,100 $2,600 $13,800 $0.80g The Production Department planned...

  • Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...

    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 Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Cost Formulas $16.309 $4,800 + $2.009 $5,400 + $0.809 $1,700 + $0.209 $18,400 + $2.609 $8,100 $2,700 $13,500 +...

  • Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...

    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 Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Cost Formulas $16.609 $4,000 + $1.509 $5,300 + $0.909 $1,600 + $0.209 $18, 100 + $ 2.609 $8,300 $2,500...

  • Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...

    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 is the number of labor-hours worked in a month: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Cost Formulas $16.109 $4,200 + $1.809 $5,100 + $0.309 $1,700 + $0.309 $18, 600 + $2.609 $8,300 $2,500 $13,500 +...

  • Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...

    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.20q Indirect labor $4,400 + $1.40q Utilities $5,000 + $0.50q Supplies $1,600 + $0.30q Equipment depreciation $18,700 + $2.80q Factory rent $8,300 Property taxes $2,700 Factory administration $13,000 +...

  • Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...

    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 is the number of labor-hours worked in a month: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Cost Formulas $16.40 $4,400 + $2.00 $5,600 + $0.909 $1,300 + $0.109 $18,600 + $3.00 $8,600 $2,500 $13,400 + $0.909...

  • Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...

    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 Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Cost Formulas $16.209 $4,800 + $2.000 $5,200 + $0.609 $1,500 + $0.109 $18,300 + $2.709 $8,400 $2,900 $13,200 +...

  • Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...

    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.40q Indirect labor $4,300 + $1.50q Utilities $5,800 + $0.50q Supplies $1,700 + $0.10q Equipment depreciation $18,000 + $2.40q Factory rent $8,000 Property taxes $2,500 Factory administration $13,700 +...

  • Packaging Solutions Corporation manufactures and sells a wide variety of packaging products. Performance reports are prepared...

    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 is the number of labor-hours worked in a month: Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Cost Formulas $16.509 $4,700 + $1.909 $5,000 + $0.500 $1,300 + $0.400 $18,000 + $2.709 $8,300 $2,500 $13,200 + $0.709...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT