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\mathrm{.}20$q

Indirect labor $$4,600+$ $$1\mathrm{.}60$q

Utilities $$5,700+$ $$0\mathrm{.}40$q

Supplies $$1,700+$ $$0\mathrm{.}30$q

Equipment depreciation $$18,700+$ $$2\mathrm{.}80$q

Factory rent $$8,000$

Property taxes $$2,700$

Factory administration $$13,500+$ $$0\mathrm{.}80$q

The Production Department planned to work $4,000$ labor$-$hours in March; however, it actually worked $3,800$ labor$-$hours during the month. Its actual costs incurred in March are listed below:

Actual Cost Incurred in March

Direct labor $ $63,120$

Indirect labor $ $10,180$

Utilities $ $7,690$

Supplies $ $3,110$

Equipment depreciation $ $29,340$

Factory rent $ $8,400$

Property taxes $ $2,700$

Factory administration $ $15,930$

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.