1 | |||||||||||
a. | Budget performance report-Manager,Western region plant | ||||||||||
Department | Budget | Actual | Over budget | Under budget | |||||||
Chip fabrication | 99780 | 102180 | 2400 | ||||||||
(Total of budgeted performance reprt-Supervisor-Chip fabrication) | (a) | (b) | c) | ||||||||
Electronic assembly | 91820 | 93010 | 1190 | ||||||||
Final assembly | 147830 | 146650 | -1180 | ||||||||
339430 | 341840 | 3590 | -1180 | ||||||||
(d) | e) | f) | |||||||||
Budget performance report-Vice president,Production | |||||||||||
Plant | Budget | Actual | Over budget | Under budget | |||||||
Eastern region | 390900 | 390900 | 0 | ||||||||
Central region | 281400 | 278600 | -2800 | ||||||||
Western region | 339430 | 341840 | 2410 | ||||||||
(Total of budgeted performance report-Manager-Western region plant) | (g) | (h) | (i) | ||||||||
1011730 | 1011340 | 2410 | -2800 | ||||||||
(j) | (k) | (l) | |||||||||
b. | MEMO | ||||||||||
To: | |||||||||||
The western region plant has experienced the budget overrun.It's budget reveals that the Chip fabrication department caused the majority of the budget overrun. | |||||||||||
The supervisor of the chip fabrication department should investigate the reasons for the budget overruns in factory wages,power and light and maintenance | |||||||||||
2 | |||||||||||
a. | Residential | Commercial |
Government contract |
Total | |||||||
Number of payroll checks: | |||||||||||
Weekly payroll | 210 | 70 | 75 | 355 | |||||||
Monthly payroll | 36 | 47 | 34 | 117 | |||||||
Total | 246 | 117 | 109 | 472 | |||||||
Number of purchase requisitions per year | 2000 | 1400 | 1300 | 4700 | |||||||
b. | Service department charge rates: | ||||||||||
Payroll department | Service department charge rates=Department expenses/Total payroll=79456/472=$ 168.34 per payroll check | ||||||||||
Purchasing department | Service department charge rates=Department expenses/Total number of purchase requisitions per year=27730/4700=$ 5.9 per purchase requisition | ||||||||||
Cost allocation=Actual usage of allocation base by the department*Service department charge rates | |||||||||||
Residential | Commercial |
Government contract |
Total | ||||||||
Service department charges: | |||||||||||
Payroll department | 41411.64 | 19695.78 | 18349.06 | 79456.48 | |||||||
(246*168.34) | (117*168.34) | (109*168.34) | |||||||||
Purchasing department | 11800 | 8260 | 7670 | 27730 | |||||||
(2000*5.9) | (1400*5.9) | (1300*5.9) | |||||||||
Total | 53211.64 | 27955.78 | 26019.06 | 107186.5 | |||||||
c. | Residential's service department charge is more than other two divisions because residential is a large user of service department services. | ||||||||||
Residential has many employees on a weekly payroll,which translates into a large number of check-issuing transactions | |||||||||||
B e rformance Reports for Counters competed bunga performance reports for Grand Company. A mandauer auty...
Plant Eastern Region Garland Company Budget Performance Report-Vice President, Production For the Month Ended November 30 Budget Actual Over BudgetUnder Budget $390,900 $390,900 $0 281,400 278,600 (2,800) (9) (h) $6) $(k) $(2,800) Central Region Western Region $(1) Garland Company Budget Performance Report-Manager, Western Region Plant For the Month Ended November 30 Department Budget Actual Over Budget Under Budget Chip Fabrication $(a) $(b) $(C) Electronic Assembly 91,820 93,010 1,190 Final Assembly 147,830 146,650 $(1,180) $(d) $(e) $(f) $(1,180) Cost Factory wages...
Garland Company Budget Performance Report-Vice President, Production For the Month Ended November 30 Plant Budget Actual Over Budget Under Budget Eastern Region $390,900 $390,900 $0 Central Region 281,400 278,600 (2,800) Western Region (g) (h) (i) $0) $(k) $0) $(2,800) Garland Company Budget Performance Report-Manager, Western Region Plant For the Month Ended November 30 Department Budget Actual Over Budget Under Budget Chip Fabrication $(a) $(b) $(c) Electronic Assembly 91,820 93,010 1,190 147,830 146,650 $(1,180) Final Assembly $(d) $(e) $(f) $(1,180) Garland...
Budget Performance Reports for Cost Centers Partially completed budget performance reports for Garland Company, a manufacturer of light duty motors, follow: Garland Company Budget Performance Report—Vice President, Production For the Month Ended November 30 Plant Budget Actual Over Budget Under Budget Eastern Region $360,600 $360,600 $0 Central Region 259,600 257,000 (2,600) Western Region (g) (h) (i) $(j) $(k) $(l) $(2,600) Garland Company Budget Performance Report—Manager, Western Region Plant For the Month Ended November 30 Department Budget Actual Over Budget Under...
Budget Performance Reports for Cost Centers Partially completed budget performance reports for Garland Company, a manufacturer of light duty motors, follow: Garland Company Budget Performance Report—Vice President, Production For the Month Ended November 30 Plant Actual Budget Over Budget Under Budget Eastern Region $433,800 $433,800 $0 Central Region 312,300 309,200 $3,100 Western Region (g) (h) (i) $(j) $(k) $(l) $2,380 Garland Company Budget Performance Report—Manager, Western Region Plant For the Month Ended November 30 Department Actual Budget Over Budget Under...
Budget Performance Reports for Cost Centers Partially completed budget performance reports for Garland Company, a manufacturer of light duty motors, follow: Garland Company Budget Performance Report-Vice President, Production For the Month Ended November 30 Under Budget Plant Budget Actual over Budget Eastern Region $421,800 $421,800 $0 Central Region 303,700 (3,000) 300,700 Western Region (g) (h) (i) $G) $(k) $0) $(3,000) Garland Company Budget Performance Report-Manager, Western Region Plant For the Month Ended November 30 Budget Actual Over Budget Under Budget...
ses EX 24-1 Budget performance reports for cost centers OBJ. 2 Partially completed budget performance reports for Garland Company, a manufacturer of light duty motors, follow: Plant Eastern Region Central Region Western Region Garland Company Budget Performance Report-Vice President, Production For the Month Ended November 30 Actual Budget Over Budget $2,409,400 $2,420,000 2,998,400 3,000,000 (h) (k) Under Budget $(10,600) (1,600) $(12,200) Under Budget Garland Company Budget Performance Report-Manager, Western Region Plant For the Month Ended November 30 Department Actual Budget...
Budget Performance Reports for Cost Centers Partially completed budget performance reports for Garland Company, a manufacturer of light duty motors, follow: Garland Company Budget Performance Report—Vice President, Production For the Month Ended November 30 Plant Budget Actual Over Budget Under Budget Eastern Region $521,400 $521,400 $0 Central Region 375,400 371,600 (3,800) Western Region (g) (h) (i) $(j) $(k) $(l) $(3,800) Garland Company Budget Performance Report—Manager, Western Region Plant For the Month Ended November 30 Department Budget Actual Over Budget Under...
Budget Performance Reports for Cost Centers Partially completed budget performance reports for Garland Company, a manufacturer of light duty motors, follow: Garland Company Budget Performance Report-Vice President, Production For the Month Ended November 30 Plant Budget Actual Over Budget Under Budget Eastern Region $533,100 $533,100 $0 Central Region 383,800 380,000 (3,800) Western Region (g) (h) (i) $0) $(k) $(1) $(3,800) Garland Company Budget Performance Report-Manager, Western Region Plant For the Month Ended November 30 Department Budget Actual over Budget Under...
Budget Performance Reports for Cost Centers Partially completed budget performance reports for Garland Company, a manufacturer of light duty motors, follow: Garland Company Budget Performance Report—Vice President, Production For the Month Ended November 30 Plant Budget Actual Over Budget Under Budget Eastern Region $398,700 $398,700 $0 Central Region 287,100 284,200 (2,900) Western Region (g) (h) (i) $(j) $(k) $(l) $(2,900) Garland Company Budget Performance Report—Manager, Western Region Plant For the Month Ended November 30 Department Budget Actual Over Budget Under...
Partially completed budget performance reports for Garland Company, a manufacturer of light duty motors, follow: Garland Company Budget Performance Report—Vice President, Production For the Month Ended November 30 Plant Actual Budget Over Budget Under Budget Eastern Region $401,300 $401,300 $0 Central Region 288,900 286,000 $2,900 Western Region (g) (h) (i) $(j) $(k) $(l) $2,570 Garland Company Budget Performance Report—Manager, Western Region Plant For the Month Ended November 30 Department Actual Budget Over Budget Under Budget Chip Fabrication $(a) $(b) $(c)...