Given Data

Can you also show the equations on how you got everything?

MIRROR PRODUCTS, INC. Production Department Planning Budget For the Month Ended April 30 Planning Budget Labor-hours Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Total expenses In the report below, in the third column, use Excel to compute a spending variance for each cost. Then, in the last column, select F for favorable or U for unfavorable. Do not select a letter if 0 variance. MIRROR PRODUCTS, INC. Production Department Spending Variances For the Month Ended April 30 Actual Flexible Spending Variances Results Budget Labor-hours Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Total expenses In the report below, in the third column, use Excel to compute a spending variance for each cost. Then, in the last column, select F for favorable or U for unfavorable. Do not select a letter if variance. MIRROR PRODUCTS, INC. Production Department Spending Variances For the Month Ended April 30 Actual Flexible Spending Variances Results Budget Labor-hours Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration Total expenses Information: Mirror Products, Inc. manufactures and sells several different products. Performance reports are prepared each month for each department. The cost formulas used for the Production Department are given below. q represents the number of direct-labor hours. Also reported below are the actual costs incurred by the Production Department in April. Although the company planned to work 4,200 direct labor-hours in April, it actually worked 4,100 direct labor-hours. Cost Formulas: Fixed Cost Variable Cost per a 4,200 Planned direct labor-hours (9) for the month Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration 19.00 1.75 1.00 0.50 4,000 + 5,500 + 1,400 + 20,000 9,000 3,500 13,500 + 1.00 Actual Hours and Costs Incurred in April: Actual direct labor-hours (q) worked 4,100 Direct labor Indirect labor Utilities Supplies Equipment depreciation 78,500 12,000 9,100 3,200 20,500 Cost Formulas: Fixed Cost Variable Cost per q 4,200 Planned direct labor-hours (q) for the month Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration 19.00 1.75 1.00 0.50 4,000 + 5,500 + 1,400 + 20,000 9,000 3,500 13,500 + 1.00 Actual Hours and Costs Incurred in April: Actual direct labor-hours (q) worked 4,100 Direct labor Indirect labor Utilities Supplies Equipment depreciation Factory rent Property taxes Factory administration 78,500 12,000 9,100 3,200 20,500 9,000 3,400 18,000