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 $51,792, and the Purchasing Department had expenses of $22,000 for the year. The following annual data for Residential, Commercial, and Government Contract divisions were obtained from corporate records:
Residential |
Commercial |
Government Contract |
|||||
Sales | $ 460,000 | $ 609,000 | $ 1,399,000 | ||||
Number of employees: | |||||||
Weekly payroll (52 weeks per year) | 170 | 65 | 70 | ||||
Monthly payroll | 36 | 47 | 34 | ||||
Number of purchase | |||||||
requisitions per year | 2,100 | 1,500 | 1,400 |
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 | fill in the blank 1 | fill in the blank 2 | fill in the blank 3 | |
Monthly payroll | fill in the blank 4 | fill in the blank 5 | fill in the blank 6 | |
Total | fill in the blank 7 | fill in the blank 8 | fill in the blank 9 | fill in the blank 10 |
Number of purchase requisitions per year | fill in the blank 11 | fill in the blank 12 | fill in the blank 13 | fill in the blank 14 |
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 your interim calculations, round your answers to two decimal places, if required.
Service department charge rates: | |
Payroll Department | $fill in the blank 15 per payroll check |
Purchasing Department | $fill in the blank 16 per purchase requisition |
Residential | Commercial | Government Contract | Total | |
Service department charges: | ||||
Payroll Department | $fill in the blank 17 | $fill in the blank 18 | $fill in the blank 19 | $fill in the blank 20 |
Purchasing Department | fill in the blank 21 | fill in the blank 22 | fill in the blank 23 | fill in the blank 24 |
Total | $fill in the blank 25 | $fill in the blank 26 | $fill in the blank 27 |
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 2 images
- Profit Center Responsibility Reporting for a Service Company Thomas Railroad Company organizes its three divisions, the North (N), South (S), and West (W) regions, as profit centers. The chief executive officer (CEO) evaluates divisional performance, using operating income as a percent of revenues. The following quarterly income and expense accounts were provided from the trial balance as of December 31: Revenues—N Region $1,027,800 Revenues—S Region 1,251,100 Revenues—W Region 2,070,600 Operating Expenses—N Region 651,300 Operating Expenses—S Region 744,600 Operating Expenses—W Region 1,252,200 Corporate Expenses—Dispatching 455,000 Corporate Expenses—Equipment Management 295,000 Corporate Expenses—Treasurer’s 156,300 General Corporate Officers’ Salaries 345,200 The company operates three support departments: the Dispatching Department, the Equipment Management Department, and the Treasurer’s Department. The Dispatching Department manages the scheduling and…arrow_forwardLauderdale Corporation is organized in three geographical divisions (regions) with managers responsible for revenues, costs, and assets in their respective regions. The firm is highly decentralized and managers are evaluated solely on divisional performance. Corporate overhead (all fixed) is allocated to the regions based on regional gross margin (regional revenue minus regional cost of sales). The following information is from Lauderdale's first year of operations: Region I Region II Region III Total Corporation Revenues $ 1,200,000 $ 1,650,000 $ 2,250,000 $ 5,100,000 Cost of sales 450,000 810,000 1,140,000 2,400,000 Selling, General and Administrative (all fixed) 420,000 630,000 850,000 1,900,000 Corporate overhead 432,000 Information on the division assets in the three regions of Lauderdale Corporation follows: Region I $ 700,000 Region II 630,000 Region III 1,287,500 Lauderdale Corporation has a cost of capital of 8.6 percent. Required: Compute…arrow_forwardInterdepartment Services: Step Method Jane Cooper's Department Stores allocates the costs of the Personnel and Payroll departments to three retail sales departments, Housewares, Clothing, and Furniture. In addition to providing services to the operating departments, Personnel and Payroll provide services to each other. Copper's allocates Personnel Department costs on the basis of the number of employees and Payroll Department costs on the basis of gross payroll. Cost and allocation information for June is as follows: Direct department cost Number of employees Gross payroll Personnel Payroll Housewares Clothing Furniture $15,600 $6,400 15 $ 33,500 $ 24,400 $40,000 24 12 12 $ 12,000 $6,600 $ 21,200 $26,100 $ 16,200 (a) Determine the percentage of total Personnel Department services that was provided to the Payroll Department. (Round your answer to one decimal place.) 0 % % (b) Determine the percentage of total Payroll Department services that was provided to the Personnel Department.…arrow_forward
- Division P reported Income from Operations of $875,000 and Total Service Department Charges of $575,000. Therefore, which statement is correct: Income from Operations before Service Department Charges was $1,450,000 O Income from Operations before Service Department Charges was $300,000 Net Income was $300,000 Gross Profit was $300,000arrow_forwardGrael Technology has two divisions, Consumer and Commercial, and two corporate service departments, Tech Support and Purchasing. The corporate costs for the year ended December 31, 20Y7, are as follows: Tech Support Department $336,000 Purchasing Department 67,500 Other corporate administrative costs 448,000 Total corporate costs $851,500 The other corporate administrative costs include officers’ salaries and miscellaneous smaller costs required by the corporation. The Tech Support Department allocates the divisions for services rendered, based on the number of computers in the department, and the Purchasing Department allocates divisions for services, based on the number of purchase orders for each department. The usage of service by the two divisions is as follows: Tech Support Purchasing Consumer Division 300 computers 1,800 purchase orders Commercial Division 180 2,700 Total 480 computers 4,500 purchase orders The service department allocations…arrow_forwardDivisional Income Statements The following data were summarized from the accounting records for Ruiz Industries Inc. for the year ended November 30, 20Y8: Cost of goods sold: Support department allocations: Commercial Division $368,440 Commercial Division $50,240 Residential Division 184,440 Residential Division 31,950 Administrative expenses: Sales: Commercial Division $66,990 Commercial Division $558,240 Residential Division 65,870 Residential Division 329,360 Prepare divisional income statements for Ruiz Industries Inc. Ruiz Industries Inc. Divisional Income Statements For the Year Ended November 30, 20Y8 Commercial Division Residential Division $ $ $ $ $ $ $ $arrow_forward
- Lauderdale Corporation is organized in three geographical divisions (regions) with managers responsible for revenues, costs, and assets in their respective regions. The firm is highly decentralized and managers are evaluated solely on divisional performance. Corporate overhead (all fixed) is allocated to the regions based on regional gross margin (regional revenue minus regional cost of sales). The following information is from Lauderdale's first year of operations: Region I Region II Region III Total Corporation Revenues $ 1,202,000 $ 1,652,000 $ 2,252,000 $ 5,106,000 Cost of sales 451,000 811,000 1,141,000 2,403,000 Selling, General and Administrative (all fixed) 423,000 633,000 853,000 1,909,000 Corporate overhead 436,000 Information on the division assets in the three regions of Lauderdale Corporation follows: Region I $ 702,000 Region II 632,000 Region III 1,290,500 Lauderdale Corporation has a cost of capital of 8.6 percent. Required: Compute…arrow_forward1)PLEASE ANSWERED WITH IN THE FORMAT BY PROVIDING FORMULA IN DETAILS2)PLEASE PROVIDE ANSWER IN TEXT Divisional income statement with support department allocations Horton Technology has two divisions, Consumer and Commercial, and two corporate support departments, tech services and purchasing.The corporate expenses for the year ended December 21, 20Y7, are as follows:arrow_forwardRundle Transport Company divides its operations into four divisions. A recent income statement for its West Division follows. RUNDLE TRANSPORT COMPANY West Division Income Statement for Year 3 Revenue $ 620,000 Salaries for drivers (470,000 ) Fuel expenses (62,000 ) Insurance (82,000 ) Division-level facility-sustaining costs (52,000 ) Companywide facility-sustaining costs (142,000 ) Net loss $ (188,000 ) Required By how much would companywide income increase or decrease if West Division is eliminated? Should West Division be eliminated? Assume that West Division is able to increase its revenue to $690,000 by raising its prices. Determine the amount of the increase or decrease that would occur in companywide net income if the segment were eliminated. Should West Division be eliminated if revenue were $690,000? What is the minimum amount of revenue required to justify continuing the operation of West Division?arrow_forward
- Using the data below for the Ace Guitar Company: Sales Cost of goods sold Selling expenses Support department expenses: Purchasing Payroll accounting A Region A Region Operating Income B Region Operating Income $544,000 206,700 130,600 B Region $ $816,000 310,100 195,800 Allocate support department expenses proportional to the sales of each region. Determine the divisional operating income for the A and B regions. For interim calculations, round percentages to two decimal places and all other amounts to the nearest whole dollar. $228,500 152,300arrow_forwardPDT Co. has two divisions, East and West. Invested assets and condensed income statement data for each division for the past year ended December 31 are as follows: East Division West Division Revenues $1,200,000 $800,000 Operating expenses 950,000 640,000 Service department charges 145,000 72,000 Invested assets 800,000 500,000 (a) Prepare condensed income statements for the past year for each division. (b) Using the expanded expression, determine the profit margin, investment turnover, and rate of return on investment for each division. Round to one decimal place.arrow_forwardSubject- accountarrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education