BOR CPAs, Inc. is a closely held corporation owned by threestockholders who used the initials of their last names to form thecorporation’s name: Cyrus Bailey, John Ogden, and Samuel Rogers.The firm’s Certified Public Accountants (CPAs) perform audits ofboth public companies and privately owned companies. BOR’s CPAsalso provide tax services to both individuals and businesses.
The corporation is divided into two profit centers: the AuditDivision and the Tax Division. Each division is composed of twocost centers. The Audit Division is composed of two cost-centerdepartments: Public Company Audits and Private Company Audits. TheTax Division is composed of two cost-center departments also:Individual Tax and Business Tax.
BOR, a decentralized organization, is interested in evaluatingthe performance of the two divisions. The stockholders areresponsible for deciding on investment in the two divisions. CyrusBailey is in charge of the performance evaluation, and turns to youfor assistance. Mr. Bailey is only interested in evaluatingoperations at the profit center (division) level, and not at thecost center (department) level.
Mr. Bailey is considering temporarily using some of the stafffrom the Tax Division to assist the Audit Division during theupcoming busy audit season, and would like to evaluate the effectof this on net income. The Tax Division is estimated to have 800hours of excess capacity.
The unit for determining sales revenue in both divisions is the\"engagement\", which means the total agreed-upon work for a givenclient in either audit or tax for a given year. The company chargeson average a fee of $75,000 per audit engagement, and $15,750 pertax engagement.
The company has its own Payroll Office, which provides payrollservices to both divisions and will allocate its total expenses tothe two divisions as service department charges.
The following chart shows some basic data for the company:
| Hourly market rate for staff (the price the company would haveto pay from an outside contractor for staff services) | $110.00 |
| Average hourly cost rate for staff (the average price thecompany pays to its staff) | $60.00 |
| Number of paychecks issued by Audit Division | 110 |
| Number of paychecks issued by Tax Division | 340 |
| Total expense for Payroll Office | $31,500 |
| Amount of assets invested in Audit Division by BOR CPAs,Inc. | $10,000,000 |
| Amount of assets invested in Tax Division by BOR CPAs,Inc. | $4,000,000 |
Mr. Bailey would like you to start by analyzing the PayrollOffice expenses, and allocating the total expenses to eachdivision. He has decided to use the number of payroll checks as theactivity base for the allocation.
Fill in the following blanks, allocating the total expense forthe Payroll Office to each of the two divisions.
| Payroll Charge Rate | per payroll check |
| Division | Allocated Service Department Charges |
| Audit Division | |
| Tax Division | |
Mr. Bailey has prepared the following divisional incomestatement for you to review, assuming no transfer of excesscapacity hours occurs. He has also included the total amounts forBOR CPAs, Inc. in the rightmost column.
Complete the following Income Statements with your data from thePayroll panel. Enter all amounts as positive numbers.
BOR CPAs, Inc. |
Income Statements |
For the Year Ended December 31, 20Y1 |
1 | | Audit Division | Tax Division | Total Company |
2 | Fees earned: | | | |
3 | Audit fees (12 engagements) | $900,000.00 | | $900,000.00 |
4 | Tax fees (45 engagements) | | $708,750.00 | 708,750.00 |
5 | Transfer-pricing fees | | | 0.00 |
6 | Expenses: | | | |
7 | Variable: | | | |
8 | Audit hours provided by Audit Division | 216,000.00 | | 216,000.00 |
9 | Tax hours provided by Tax Division | | 283,500.00 | 283,500.00 |
10 | Excess capacity hours paid to salaried staff | | 48,000.00 | 48,000.00 |
11 | Audit hours provided by Tax Division | | 0.00 | 0.00 |
12 | Fixed expenses | 50,000.00 | 65,500.00 | 115,500.00 |
13 | Income from operations before service department charges | $634,000.00 | $311,750.00 | $945,750.00 |
14 | Service department charges for payroll | | | |
15 | Income from operations | | | |
Mr. Bailey asks that you prepare Divisional Income Statementsshowing what 20Y1 results would have been had the Audit Divisionpurchased all the excess capacity of the Tax Division, using amarket transfer price. The divisional managers tell you that, withthe excess capacity of the Tax Division of 800 hours, the AuditDivision can perform 4 more audits during the year, and the TaxDivision would charge the Audit Division the market rate of $110.00per hour for the additional hours required, selling all its excesscapacity to the Audit Division. The Tax Division would still beresponsible for paying the salaries of their employees.
Complete the following Income Statements. Enter all amounts aspositive numbers. If there is no amount or an amount is zero, enter“0â€.
BOR CPAs, Inc. |
Income Statements |
For the Year Ended December 31, 20Y1 |
1 | | Audit Division | Tax Division | Total Company |
2 | Fees earned: | | | |
3 | Audit fees (16 engagements) | $1,200,000.00 | | $1,200,000.00 |
4 | Tax fees (45 engagements) | | $708,750.00 | 708,750.00 |
5 | Transfer-pricing fees | | | |
6 | Expenses: | | | |
7 | Variable: | | | |
8 | Audit hours provided by Audit Division | 216,000.00 | | 216,000.00 |
9 | Tax hours provided by Tax Division | | 283,500.00 | 283,500.00 |
10 | Excess capacity hours paid to salaried staff | | | |
11 | Audit hours provided by Tax Division | | | |
12 | Fixed expenses | 50,000.00 | 65,500.00 | 115,500.00 |
13 | Income from operations before service department charges | | | |
14 | Service department charges for payroll | | | |
15 | Income from operations | | | |
Mr. Bailey asks that you prepare Divisional Income Statementsshowing what 20Y1 results would have been had the Audit Divisionpurchased all the excess capacity of the Tax Division, using a costtransfer price. The divisional managers tell you that, with theexcess capacity of the Tax Division of 800 hours, the AuditDivision can perform 4 more audits during the year, and the AuditDivision would pay the Tax Division's internal hourly rate of$60.00 per hour for the additional hours required, with the TaxDivision selling all its excess capacity to the Audit Division. TheTax Division would still be responsible for paying the salaries oftheir employees.
Complete the following Income Statements. Enter all amounts aspositive numbers. If there is no amount or an amount is zero, enter“0â€.
BOR CPAs, Inc. |
Income Statements |
For the Year Ended December 31, 20Y1 |
1 | | Audit Division | Tax Division | Total Company |
2 | Fees earned: | | | |
3 | Audit fees (16 engagements) | $1,200,000.00 | | $1,200,000.00 |
4 | Tax fees (45 engagements) | | $708,750.00 | 708,750.00 |
5 | Transfer-pricing fees | | | |
6 | Expenses: | | | |
7 | Variable: | | | |
8 | Audit hours provided by Audit Division | 216,000.00 | | 216,000.00 |
9 | Tax hours provided by Tax Division | | 283,500.00 | 283,500.00 |
10 | Excess capacity hours paid to salaried staff | | | |
11 | Audit hours provided by Tax Division | | | |
12 | Fixed expenses | 50,000.00 | 65,500.00 | 115,500.00 |
13 | Income from operations before service department charges | | | |
14 | Service department charges for payroll | | | |
15 | Income from operations | | | |
