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 $64,560, and the Purchasing Department had expenses of $40,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 | $2,000,000 | $3,250,000 | $2,900,000 | ||||
Number of employees: | |||||||
Weekly payroll (52 weeks per year) | 400 | 250 | 150 | ||||
Monthly payroll | 80 | 30 | 10 | ||||
Number of purchase requisitions per year | 7,500 | 3,000 | 2,000 |
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 × 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: | |
Payroll Department | $fill in the blank 15 per distribution |
Purchasing Department | $fill in the blank 16 per requisition |
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 than the other two divisions because Residential is a user of support department services. Residential has many employees on a weekly payroll, which translates into a number of payroll transactions.
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 5 images
- 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,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_forwardSagararrow_forward
- Corrections to Service Department Charges for a Service Company Wild Sun Airlines Inc. has two divisions organized as profit centers, the Passenger Division and the Cargo Division. The following divisional income statements were prepared: Wild Sun Airlines Inc.Divisional Income StatementsFor the Year Ended December 31, 20Y9 Passenger Division Cargo Division Revenues $3,025,000 $3,025,000 Operating expenses 2,450,000 2,736,000 Income from operations beforeservice department charges $575,000 $289,000 Less service department charges: Training $125,000 $125,000 Flight scheduling 108,000 108,000 Reservations 151,200 384,200 151,200 384,200 Income from operations $190,800 $(95,200) The service department charge rate for the service department costs was based on revenues. Because the revenues of the two divisions were the same, the service department charges to each division were also the same. The following additional…arrow_forwardDivisional Performance Analysis and Evaluation The vice president of operations of Free Ride Bike Company is evaluating the performance of two divisions organized as investment centers. Invested assets and condensed income statement data for the past year for each division are as follows: Mountain Bike Division Road Bike Division Sales Cost of goods sold Operating expenses Invested assets Required: 1. Prepare condensed divisional income statements for the year ended December 31, 20Y7, assuming that there were no support department allocations. Free Ride Bike Company Divisional Income Statements For the Year Ended December 31, 20Y7 Sales Cost of goods sold Gross profit Operating expenses Operating income $ Road Bike Division Road Bike Division $3,410,000 1,500,000 1,330,300 3,100,000 $ Road Bike Division Mountain Bike Division 2. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and rate of return on investment for each division. If…arrow_forwardShow in excel formatarrow_forward
- 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_forwardOwen Audio shows the following information for its two divisions for year 1. Commercial Division Sales revenue Cost of sales Consumer Division $ 1,840,800 1,104,480 $ 5,829,200 3,781,100 Selling, General and Administrative Allocated corporate overhead 277,400 350,840 128,760 407,740 Required: a. Compute divisional operating income for the two divisions. Ignore taxes. b-1. What are the gross margin and operating margin percentages for both divisions? b-2. How well have these divisions performed?arrow_forwardCarry On Freight Inc. has three regional divisions organized 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, 20Y3. Revenues—Air Division $ 935,800 Revenues—Rail Division 1,110,300 Revenues—Truck Division 2,025,500 Operating Expenses—Air Division 593,000 Operating Expenses—Rail Division 660,800 Operating Expenses—Truck Division 1,224,900 Corporate Expenses—Shareholder Relations 142,300 Corporate Expenses—Customer Support 517,500 Corporate Expenses—Legal 180,000 General Corporate Officers' Salaries 314,300 The company operates three service departments: Shareholder Relations, Customer Support, and Legal. The Shareholder Relations Department conducts a variety of services for shareholders of the company. The Customer Support Department is the company's point of contact for…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_forwardSelected sales and operating data for three divisions of different structural engineering firms are given as follows: Division A Division B Division C Sales $ 15,400,000 $ 28,320,000 $ 25,400,000 Average operating assets $ 3,080,000 $ 7,080,000 $ 5,080,000 Net operating income $ 693,000 $ 396,480 $ 736,600 Minimum required rate of return 7.00 % 7.50 % 14.50 % Required: 1. Compute the margin, turnover, and return on investment (ROI) for each division. 2. Compute the residual income (loss) for each division. 3. Assume that each division is presented with an investment opportunity that would yield a 8% rate of return. a. If performance is being measured by ROI, which division or divisions will probably accept the opportunity? b. If performance is being measured by residual income, which division or divisions will probably accept the opportunity?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
- 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