In divisional Income statements prepared for Lefevre 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 regulations. The Payroll Department had expenses of $60,720, and the Purchasing Department had expenses of $29,480 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate records:
Residential Commercial Government Contract
Sales $616,000 $817,000 $1,875,000
Number of employees:
Weekly payroll (52 weeks per year) 200 80 85
Monthly payroll 32 43 30
Number of purchase 2,800 2,000 1,900
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
Monthly payroll
Total
Number of purchase requisitions per year:
b. Using the activity base information in (a), determine the annual amount of payroll and purchasing costs charged back to the Residential, Commercial, and Government Contract divisions from payroll and purchasing services. Do not round interim calculations.
Service department charge rates:
Payroll Department $ per distribution
Purchasing Department $ per requisition
Residential Commercial Government Contract Total
Service department charges:
Payroll Department $ $ $ $
Purchasing Department $ $ $ $
Total $ $ $ $
c. Residential's service department charge is than the other two divisions because Residential is a user of service department services. Residential has many employees on a weekly payroll, which translates into a number of payroll transactions.