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 $48,024, 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:
Line Item Description | Residential | Commercial | Government Contract |
---|---|---|---|
Sales | $460,000 | $609,000 | $1,399,000 |
Number of employees: | |||
Weekly payroll (52 weeks per year) | 110 | 85 | 90 |
Monthly payroll | 30 | 41 | 28 |
Number of purchase requisitions per year | 2,100 | 1,500 | 1,400 |
Required:
a. Determine the total amount of payroll checks and purchase requisitions processed per year by the company and each division.
Line Item Description | Residential | Commercial | Government Contract | Total |
---|---|---|---|---|
Number of payroll checks: | ||||
Weekly payroll × 52 | fill in the blank 1 | fill in the blank 2 | fill in the blank 3 | |
Monthly payroll × 12 | 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 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:
Department | Allocation Rate |
---|---|
Payroll Department | $fill in the blank 15 per distribution |
Purchasing Department | $fill in the blank 16 per requisition |
Department | Residential | Commercial | Government Contract | Total |
---|---|---|---|---|
Support department allocations: | ||||
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 |
c. Residential's support department allocations are fill in the blank 1 of 3
than the other two divisions because Residential is a fill in the blank 2 of 3
user of support department services. Residential has many employees on a weekly payroll, which translates into a fill in the blank 3 of 3
number of payroll transactions.
Trending nowThis is a popular solution!
Step by stepSolved in 5 steps with 5 images
- Grael 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_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,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_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_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: Revenues Cost of sales Selling, General and Administrative (all fixed) Corporate overhead Required: Region I $ 1,203,000 451,500 424,500 Region II $ 1,653,000 811,500 634,500 Region III $ 2,253,000 1,141,500 854,500 Total Corporation $ 5,109,000 2,404,500 1,913,500 438,000 a. Compute divisional operating income for the three regions. Ignore taxes. b. How have these regions performed? Complete this question by entering your answers in the tabs below. Required A Required B Compute divisional operating income for the three…arrow_forwardCost 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 $29,792, 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) 120 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:…arrow_forward
- 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. Th following quarterly income and expense accounts were provided from the trial balance as of December 31: $1,044,000 1,245,600 2,188,700 661,600 741,300 1,323,600 555,000 214,200 158,800 350,600 Revenues-N Region Revenues-S Region Revenues-W Region Operating Expenses-N Region Operating Expenses-S Region Operating Expenses-W Region Corporate Expenses-Dispatching Corporate Expenses-Equipment Management Corporate Expenses-Treasurer's General Corporate Officers' Salaries 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 releasing of completed trains. The Equipment Management Department manages the railroad…arrow_forwardUsing the following data for Ace Guitar Company: A Region Sales Cost of goods sold Selling expenses Support department expenses: Purchasing Payroll accounting $781,000 296,800 187,400 A Region Operating Income B Region Operating Income B Region $639,000 242,800 153,400 $238,600 159,000 Allocate support department expenses proportional to the sales of each region. Determine the divisional operating income for the A and B regions.arrow_forwardRenata Company has four departments: Materials, Personnel, Manufacturing, and Packaging. Information follows. Department Square Feet Asset Values Employees Materials 26 30,000 $ 9,300 Personnel 13 12,000 2,480 Manufacturing Packaging 52 66,000 37,820 39 12,000 12,400 Total 130 120,000 $ 62,000 The four departments share the following indirect expenses for supervision, utilities, and insurance according to their allocation bases. Indirect Expense Supervision Utilities Insurance Total Cost $ 82,700 Number of employees Allocation Base 52,000 Square feet occupied 23,500 Asset values $ 158,200 Allocate each of the three indirect expenses to the four departments.arrow_forward
- Divisional 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 $459,310 Commercial Division $62,630 Residential Division 214,350 Residential Division 37,130 Administrative expenses: Sales: Commercial Division $83,510 Commercial Division $695,920 Residential Division 76,550 Residential Division 382,760 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 %24arrow_forwardService Department Charges 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 requisitions. The Payroll Department had expenses of $75,400 and the Purchasing Department had expenses of $42,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 $1,000,000 $1,600,000 $3,200,000 Number of employees: Weekly payroll (52 weeks per year) 300 150 200 Monthly payroll 75 160 90 Number of purchase requisitions per year 4,000 3,500 3,000 a. Determine the total amount of payroll checks and purchase requisitions processed per year by the company and each division. Residential Commercial…arrow_forwardThe following partial financial information (in thousands of dollars) is available for Thole, Incorporated: Corporate overhead costs at Thole are allocated to divisions based on relative sales. Required: a. Complete the income statements for both divisions and the corporation as a whole. Note: Enter your answers in thousands. Enter all values as positive value. Round your answers to 1 decimal place. Sales Cost of sales Gross margin Selling, General and Administrative Allocated corporate costs Operating income Tax expense (@20%) After-tax income Gross margin percentage Operating margin Profit margin Pacific 20.0 (Thousands of Dollars) Southern 40.00 % 20.00 % 16.00 % 50.00 % 36.00 % 28.80 % $ Total 100.0 984.0 48.00 % 32.80 % 26.24 %arrow_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