A company has cost center production divisions comprised of branches. The branches are comprised of departments. Using information from the last problem, and the following data, prepare a budget report for the vice president of division A.

Last problem:

current data and empty table:

Actual 31,800 Budget 32,400 Admin Department A Department B Department C 81,680 133,200 78,330 149,400 Admin Budget Performance Report Branch Manager, Branch A Actual Budget Variance 331,800 $ 32,400 8600 3107,590 $100,660 -1930 $81,680 $78,330 -$3,350 $133,200 $149,400 316.200 Dept A. Dept B. Dept C. Total $354,270 33666.790 $112,520 Actual 000.000 50,520 Budget 50,000 Admin Branch A Branch B 258,150 302,640 250,200 326,400 Branch C Budget Performance Report VP of Division A 1. A company has cost center production divisions comprised of branches. The branches are comprised of departments. Department A is a reporting unit of Branch A. Using the following data, prepare a performance report for the Supervisor of Department A. a. Line wages Materials Supervisor Salary Utilities Depreciation Maintenance Insurance Actual 50,640 37,250 7,200 6,770 3,000 Budget 49,200 37,800 7,200 6,600 3,000 2,040 820 1,910 820 Budget Performance Report Supervisor, Department A Actual Budget Live Wages 356,640 $49.200 Materials 139,250 337,800 " Supervisor Salary 17,200 37,200 Utilities 136770 $6.600 Depreciation 33.000 33.000 Maintenance $1,910 $2,040 Insurance 1820 3920 Total 3107.590 $106,660 Variance -$1,4410 $550 0 -$170 #130 1930 b. Branch A is a reporting unit of Division A. Using information from the last problem (#1a) and the following data, prepare a budget report for the Manager of Branch A. Actual 31,800 Budget 32,400 Admin Department A Department B Department 81,680 133,200 78,330 149,400 Admin Budget Performance Report Branch Manager, Branch A Actual Budget Variance 331, 800 $ 32,400 $600 3107,590 $106,660 -1930 381.680 $78,330 -$3,350 $133,200 0149,400 316.200 Dept A. Dept B. Dept C. Total 8354,270 1360,790 $12,520 c. Using information from the last problem (#1b) and the following data, prepare a budget report for the Vice President of Division A. Actual 50,520 Budget 50,000 Admin Branch A Branch B Branch C 258,150 302,640 250,200 326,400 Budget Performance Report VP of Division A