can someone help me solve this.
Cost Department Allocations In divisional income statements prepared for Demopolis Company, the Payroll Department costs are charged back to user divisions on the basis of the number of payroll distributions, and the Purchasing Department costs are charged back on the basis of the number of purchase requisitions. The Payroll Department had expenses of $34,472, and the Purchasing Department had expenses of $15,370 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate records: Residential Commercial Government Contract Sales $ 321,000 $ 426,000 $ 978,000 Number of employees: Weekly payroll (52 weeks per year) 165 70 75 Monthly payroll 28 39 26 Number of purchase requisitions per year 2,200 1,600 1,500 Required: a. Determine the total amount of payroll checks and purchase requisitions processed per year by the company and each division. Residential Commercial Government Contract Total Number of payroll checks: Weekly payroll x 52 Monthly payroll x 12 Total Number of purchase requisitions per year Required: a. Determine the total amount of payroll checks and purchase requisitions processed per year by the company and each division. Residential Commercial Government Contract Total Number of payroll checks: Weekly payroll x 52 Monthly payroll x 12 Total Number of purchase requisitions per year b. Using the cost driver information in (a), determine the annual amount of payroll and purchasing costs allocated to the Residential, Commercial, and Government Contract divisions from payroll and purchasing services. Do not round interim calculations. Round your answers to two decimal places. Support department allocation rates: Payroll Department per distribution Purchasing Department $ per requisition Residential Commercial Government Contract Total Support department allocations: Payroll Department $ $ Purchasing Department Support department allocation rates: Payroll Department per distribution Purchasing Department $ per requisition Residential Commercial Government Contract Total Support department allocations: Payroll Department $ Purchasing Department Total Partially completed budget performance reports for Delmar Company, a manufacturer of light duty motors, follow: Delmar Company Budget Performance Report-Vice President, Production For the Month Ended June 30 Plant Actual Budget Over Budget (Under) Budget Eastern Region $553,500 $553,500 $0 Central Region 394,500 398,500 (4,000) Western Region (9) (h) (0) $6) $(k) $(1) $(4,000) Delmar Company Budget Performance Report-Manager, Western Region Plant For the Month Ended June 30 Department Actual Budget Over Budget (Under) Budget Chip Fabrication $(a) $(b) $(c) Electronic Assembly 79,240 1,030 80,270 125,770 Final Assembly 126,780 $(1,010) $(d) $(e) $(f) $(1,010) Delmar Company Budget Performance Report-Manager, Western Region Plant For the Month Ended June 30 Department Actual Budget Over Budget (Under) Budget Chip Fabrication $(a) $(b) $(c) Electronic Assembly 80,270 79,240 1,030 Final Assembly 125,770 126,780 $(1,010) $(d) $(e) $(f) $(1,010) Delmar Company Budget Performance Report-Supervisor, Chip Fabrication For the Month Ended June 30 Actual Budget Over Budget (Under) Budget Cost Factory wage $28,280 $26,430 $1,850 Materials 62,210 62,650 $(440) Power and light 3,700 3,110 590 Maintenance 6,710 6,130 580 $100,900 $98,320 $3,020 $(440) a. Complete the budget performance reports by determining the correct amounts for the lettered spaces (a-I) as marked above. a. $ 100,900 9. $ Budget Performance Report-Supervisor, Chip Fabrication For the Month Ended June 30 Cost Actual Budget Over Budget (Under) Budget Factory wages $28,280 $26,430 $1,850 Materials 62,210 62,650 $(440) Power and light 3,700 3,110 590 Maintenance 6,710 6,130 580 $100,900 $98,320 $3,020 $(440) a. Complete the budget performance reports by determining the correct amounts for the lettered spaces (a-1) as marked above. a. $ 100,900 g. $ b. s 98,320 h. $ c. $ 2,580 i. $ d. $ 306,940 j. $ e. $ k. $ f. $ I. $
