infoPractice Pack
infoPractice Pack
Effect of Proposals on Divisional Performance
A condensed income statement for the Electronics Division of Gihbli Industries Inc. for the year ended December 31 is as follows:
Sales | $4,160,000 |
Cost of goods sold | 2,884,200 |
Gross profit | $ 1,275,800 |
Operating expenses | 735,000 |
Income from operations | $ 540,800 |
Invested assets | $3,200,000 |
Assume that the Electronics Division received no charges from service departments.
The president of Gihbli Industries Inc. has indicated that the division’s return on a $3,200,000 investment must be increased to at least 20.8% by the end of the next year if operations are to continue. The division manager is considering the following three proposals:
Proposal 1: Transfer equipment with a book value of $640,000 to other divisions at no gain or loss and lease similar equipment. The annual lease payments would be less than the amount of
Proposal 2: Reduce invested assets by discontinuing a product line. This action would eliminate sales of $680,000, reduce cost of goods sold by $454,400, and reduce operating expenses by $200,000. Assets of $1,620,200 would be transferred to other divisions at no gain or loss.
Proposal 3: Purchase new and more efficient machinery and thereby reduce the cost of goods sold by $422,400 after considering the effects of depreciation expense on the new equipment. Sales would remain unchanged, and the old machinery, which has no remaining book value, would be scrapped at no gain or loss. The new machinery would increase invested assets by $1,600,000 for the year.
Required:
1. Using the DuPont formula for
Electronics Division | ||
Profit margin | fill in the blank d18b9afde04d005_1% | |
Investment turnover | fill in the blank d18b9afde04d005_2 | |
ROI | fill in the blank d18b9afde04d005_3% |
2. Prepare condensed estimated income statements and compute the invested assets for each proposal.
Gihbli Industries Inc.—Electronics Division | |||
Estimated Income Statements | |||
For the Year Ended December 31 | |||
Proposal 1 | Proposal 2 | Proposal 3 | |
Sales | $fill in the blank da993f00d03dffc_1 | $fill in the blank da993f00d03dffc_2 | $fill in the blank da993f00d03dffc_3 |
Cost of goods sold | fill in the blank da993f00d03dffc_4 | fill in the blank da993f00d03dffc_5 | fill in the blank da993f00d03dffc_6 |
Gross profit | $fill in the blank da993f00d03dffc_7 | $fill in the blank da993f00d03dffc_8 | $fill in the blank da993f00d03dffc_9 |
Operating expenses | fill in the blank da993f00d03dffc_10 | fill in the blank da993f00d03dffc_11 | fill in the blank da993f00d03dffc_12 |
Income from operations | $fill in the blank da993f00d03dffc_13 | $fill in the blank da993f00d03dffc_14 | $fill in the blank da993f00d03dffc_15 |
Invested assets | $fill in the blank da993f00d03dffc_16 | $fill in the blank da993f00d03dffc_17 | $fill in the blank da993f00d03dffc_18 |
3. Using the DuPont formula for return on investment, determine the profit margin, investment turnover, and return on investment for each proposal. Round your answers to one decimal place.
Proposal | Profit Margin | Investment Turnover | ROI |
Proposal 1 | fill in the blank e908f6f7bf8ef91_1% | fill in the blank e908f6f7bf8ef91_2 | fill in the blank e908f6f7bf8ef91_3% |
Proposal 2 | fill in the blank e908f6f7bf8ef91_4% | fill in the blank e908f6f7bf8ef91_5 | fill in the blank e908f6f7bf8ef91_6% |
Proposal 3 | fill in the blank e908f6f7bf8ef91_7% | fill in the blank e908f6f7bf8ef91_8 | fill in the blank e908f6f7bf8ef91_9% |
4. Which of the three proposals would meet the required 20.8% return on investment.
Proposal 1 | |
Proposal 2 | |
Proposal 3 |
5. If the Golf Division were in an industry where the profit margin could not be increased, how much would the investment turnover have to increase to meet the president's required 20.8% return on investment? Enter your increase in investment turnover answer as a percentage of current investment turnover. If required, round your answer to one decimal place.
Trending nowThis is a popular solution!
Learn your wayIncludes step-by-step video
Step by stepSolved in 3 steps with 2 images
- Birrell Scientific Inc. manufactures electronic products, with two operating divisions, the GPS Systems and Communication Systems divisions. Condensed divisional income statements, which involve no intracompany transfers and which include a breakdown of expenses into variable and fixed components, are as follows: Birrell Scientific Inc.Divisional Income StatementsFor the Year Ended December 31, 20Y5 GPS SystemsDivision CommunicationSystems Division Total Sales: 75,000 units @ $60 per unit $4,500,000 $4,500,000 150,000 units @ $115 per unit $17,250,000 17,250,000 $4,500,000 $17,250,000 $21,750,000 Expenses: Variable: 75,000 units @ $40 per unit $(3,000,000) $(3,000,000) 150,000 units @ $90 per unit* $(13,500,000) (13,500,000) Fixed 250,000 (600,000) (850,000) Total expenses $(3,250,000) $(14,100,000)…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
- Please do not give salutations in image format thankuharrow_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_forwardUsing 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_forward
- PDT 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_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_forwardCorrections 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 Statements For the Year Ended December 31, 20Y9 Passenger Division Cargo Division Revenues $2,314,000 $2,314,000 Operating expenses 1,873,300 2,082,600 Income from operations before $440,700 $231,400 service department charges Less service department charges: Training $108,800 $108,800 Flight scheduling 80,850 80,850 Reservations 108,000 297,650 108,000 297,650 Income from operations $143,050 $(66,250) 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 information is available: Passenger Cargo Total Division Division Number…arrow_forwardProfit Center Responsibility Reporting XSport Sporting Goods Co. operates two divisions—the Winter Sports Division and the Summer Sports Division. The following income and expense accounts were provided from the trial balance as of December 31, 20Y9, the end of the fiscal year, after all adjustments, including those for inventories, were recorded and posted: Sales—Winter Sports Division $26,775,000 Sales—Summer Sports Division 29,580,000 Cost of Goods Sold—Winter Sports Division 16,065,000 Cost of Goods Sold—Summer Sports Division 17,085,000 Sales Expense—Winter Sports Division 4,590,000 Sales Expense—Summer Sports Division 4,080,000 Administrative Expense—Winter Sports Division 2,677,500 Administrative Expense—Summer Sports Division 2,626,500 Advertising Expense 927,000 Transportation Expense 408,800 Accounts Receivable Collection Expense 224,000 Warehouse Expense 2,550,000 The bases to be used in allocating expenses, together with other essential…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