Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 25% each of the last three years. He computed the following cost and revenue estimates for each product: Product A Product B Initial investment: Cost of equipment (zero salvage value) $ 340,000 Annual revenues and costs: Sales revenues $ 380,000 $ 172,000 $ 68,000 Fixed out-of-pocket operating costs $ 83,000 $525,000 $ 480,000 $225,000- $ 105,000 $ 66,000 Variable expenses Depreciation expense The company's discount rate is 17%. Click here to view Exhibit 14B-1 and Exhibit 14B-2, to determine the appropriate discount factor(s) using tables. Required: 1. Calculate each product's payback period. 2. Calculate each product's net present value. 3. Calculate each product's internal rate of return. 4. Calculate each product's profitability index. 5. Calculate each product's simple rate of return. 6a. For each measure, identify whether Product A or Product B is preferred. 6b. Based on the simple rate of return, which of the two products should Lou's division accept?

Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 25% each of the last three years. He computed the following cost and revenue estimates for each product: Product A Product B Initial investment: Cost of equipment (zero salvage value) $ 340,000 Annual revenues and costs: Sales revenues $ 380,000 $ 172,000 $ 68,000 Fixed out-of-pocket operating costs $ 83,000 $525,000 $ 480,000 $225,000- $ 105,000 $ 66,000 Variable expenses Depreciation expense The company's discount rate is 17%. Click here to view Exhibit 14B-1 and Exhibit 14B-2, to determine the appropriate discount factor(s) using tables. Required: 1. Calculate each product's payback period. 2. Calculate each product's net present value. 3. Calculate each product's internal rate of return. 4. Calculate each product's profitability index. 5. Calculate each product's simple rate of return. 6a. For each measure, identify whether Product A or Product B is preferred. 6b. Based on the simple rate of return, which of the two products should Lou's division accept?

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter17: Activity Resource Usage Model And Tactical Decision Making

Section: Chapter Questions

Problem 26P: St. Johns Medical Center (SJMC) has five medical technicians who are responsible for conducting...

See similar textbooks

Similar questions

St. Johns Medical Center (SJMC) has five medical technicians who are responsible for conducting cardiac catheterization testing in SJMCs Cath Lab. Each technician is paid a salary of 36,000 and is capable of conducting 1,000 procedures per year. The cardiac catheterization equipment is one year old and was purchased for 250,000. It is expected to last five years. The equipments capacity is 25,000 procedures over its life. Depreciation is computed on a straight-line basis, with no salvage value expected. The reading of the catheterization results is conducted by an outside physician whose fee is 120 per test. The technicians report with the outside physicians note of results is sent to the referring physician. In addition to the salaries and equipment, SJMC spends 50,000 for supplies and other costs needed to operate the equipment (assuming 5,000 procedures are conducted). When SJMC purchased the equipment, it fully expected to perform 5,000 procedures per year. In fact, during its first year of operation, 5,000 procedures were run. However, a larger hospital has established a clinic in the city and will siphon off some of SJMCs business. During the coming years, SJMC expects to run only 4,200 cath procedures yearly. SJMC has been charging 850 for the procedureenough to cover the direct costs of the procedure plus an assignment of general overhead (e.g., depreciation on the hospital building, lighting and heating, and janitorial services). At the beginning of the second year, an HMO from a neighboring community approached SJMC and offered to send its clients to SJMC for cardiac catheterization provided that the charge per procedure would be 550. The HMO estimates that it can provide about 500 patients per year. The HMO has indicated that the arrangement is temporaryfor one year only. The HMO expects to have its own testing capabilities within one year. Required: 1. Classify the resources associated with the cardiac catheterization activity into one of the following: (1) committed resources, or (2) flexible resources. 2. Calculate the activity rate for the cardiac catheterization activity. Break the activity rate into fixed and variable components. Now, classify each activity resource as relevant or irrelevant with respect to the following alternatives: (1) accept the HMO offer, or (2) reject the HMO offer. Explain your reasoning. 3. Assume that SJMC will accept the HMO offer if it reduces the hospitals operating costs. Should the HMO offer be accepted? 4. Jerold Bosserman, SJMCs hospital controller, argued against accepting the HMOs offer. Instead, he argued that the hospital should be increasing the charge per procedure rather than accepting business that doesnt even cover full costs. He also was concerned about local physician reaction if word got out that the HMO was receiving procedures for 550. Discuss the merits of Jerolds position. Include in your discussion an assessment of the price increase that would be needed if the objective is to maintain total revenues from cardiac catheterizations experienced in the first year of operation. 5. Chandra Denton, SJMCs administrator, has been informed that one of the Cath Lab technicians is leaving for an opportunity at a larger hospital. She met with the other technicians, and they agreed to increase their hours to pick up the slack so that SJMC wont need to hire another technician. By working a couple hours extra every week, each remaining technician can perform 1,050 procedures per year. They agreed to do this for an increase in salary of 2,000 per year. How does this outcome affect the analysis of the HMO offer? 6. Assuming that SJMC wants to bring in the same revenues earned in the cardiac catheterization activitys first year less the reduction in resource spending attributable to using only four technicians, how much must SJMC charge for a procedure?
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 18% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: $ 170,000 $ 380,000 Sales revenues Variable expenses $350,000 $ 250,000 $ 120,000 $ 170,000 Depreciation expense $ 34,000 $ 76,000 Fixed out-of-pocket operating costs $ 70,000 $ 50,000 The company's discount rate is 15% Click here to view Exhibit 148-1 and Exhibit 148-2, to determine the appropriate discount factor using tables Required: 1 Calculate the payback period for each product 2 Calculate the net present value for each product. 3. Calculate the internal rate of return for each product. 4 Calculate the profitability Index for…
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 19% each of the last three years. He computed the following cost and revenue estimates for each product: Product A Product B Initial investment: Cost of equipment (zero salvage value) $ 190,000 $ 400,000 Annual revenues and costs: Sales revenues $ 270,000 $ 370,000 Variable expenses $ 128,000 $ 178,000 Depreciation expense $ 38,000 $ 80,000 Fixed out-of-pocket operating costs $ 72,000 $ 52,000 The company's discount rate is 17%. Click here to view Exhibit 14B-1 and Exhibit 14B-2, to determine the appropriate discount factor(s) using tables. Required: 1. Calculate each product's payback period. 2. Calculate each product's net present value. 3. Calculate each product's internal rate of return. 4. Calculate each product's profitability index. 5.…
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 24% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) $ 330,000 $ 515,000 Annual revenues and costs: Sales revenues $ 370,000 $ 470,000 Variable expenses $ 168,000 $ 218,000 Depreciation expense $ 66,000 $ 103,000 Fixed out-of-pocket operating costs $ 82,000 $ 68,000 The company’s discount rate is 15%. Required: 4. Calculate the project profitability index for each product. 5. Calculate the simple rate of return for each product.
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 24% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) $ 330,000 $ 515,000 Annual revenues and costs: Sales revenues $ 370,000 $ 470,000 Variable expenses $ 168,000 $ 218,000 Depreciation expense $ 66,000 $ 103,000 Fixed out-of-pocket operating costs $ 82,000 $ 68,000 The company’s discount rate is 15%. Required: 1. Calculate the payback period for each product. 2. Calculate the net present value for each product. 3. Calculate the internal rate of return for each product.
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 24% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) $ 330,000 $ 515,000 Annual revenues and costs: Sales revenues $ 370,000 $ 470,000 Variable expenses $ 168,000 $ 218,000 Depreciation expense $ 66,000 $ 103,000 Fixed out-of-pocket operating costs $ 82,000 $ 68,000 The company’s discount rate is 15%. Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor using tables. Required: 1. Calculate the payback period for each product. Product A (Years) Product B (Years) Payback Period 2. Calculate the net present value for…
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 20% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: $250,000 $. 460,000 $300,000 $400,000 Sales revenues 190,000 $ 140,000 $ 39,000 Variable expenses $ 81,000 Depreciation expense Fixed out-of-pocket operating $ 75,000 $55,000 costs The company's discount rate is 18%. Click here to view Exhibit 13B-1 and Exhibit 13B-2, to determine the appropriate discount factor using tables. Required: Calculate the payback period for each product. (Round your answers to 2 decimal 1. places.) Product A Product B Payback period 2.94 years 2.97 years
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 23% each of the last three years. He computed the following cost and revenue estimates for each product: Product A Product B Initial investment: Cost of equipment (zero salvage value) $ 310,000 $ 510,000 Annual revenues and costs: Sales revenues $ 360,000 $ 460,000 Variable expenses $ 164,000 $ 214,000 Depreciation expense $ 62,000 $ 102,000 Fixed out-of-pocket operating costs $ 81,000 $ 65,000 The company’s discount rate is 18%. Click here to view Exhibit 14B-1 and Exhibit 14B-2, to determine the appropriate discount factor(s) using tables. Required: 1. Calculate each product’s payback period. 2. Calculate each product’s net present value. 3. Calculate each product’s internal rate of return. 4. Calculate each…
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 23% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) $ 390,000 $ 585,000 Annual revenues and costs: Sales revenues $ 420,000 $ 500,000 Variable expenses $ 185,000 $ 222,000 Depreciation expense $ 78,000 $ 117,000 Fixed out-of-pocket operating costs $ 90,000 $ 70,000 The company’s discount rate is 21%. Required: 1. Calculate the payback period for each product. 2. Calculate the net present value for each product. 3. Calculate the internal rate of return for each product. 4. Calculate the profitability index for each product. 5. Calculate the simple rate of return for each…
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 17% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) $ 176,600 $ 390,000 Annual revenues and costs: Sales revenues $ 260,000 $ 360,000 Variable expenses $ 124,000 $ 174,000 Depreciation expense $ 36,000 $ 78,000 Fixed out-of-pocket operating costs $ 71,000 $ 50,000 The company’s discount rate is 15%. Click here to view Exhibit 12B-1 and Exhibit 12B-2, to determine the appropriate discount factor using tables. Required: 1. Calculate the payback period for each product. 2. Calculate the net present value for each product. 3. Calculate the internal rate of return for each…
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 22% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product AProduct BInitial investment: Cost of equipment (zero salvage value)$ 340,000$ 540,000Annual revenues and costs: Sales revenues$ 380,000$ 460,000Variable expenses$ 170,000$ 206,000Depreciation expense$ 68,000$ 108,000Fixed out-of-pocket operating costs$ 86,000$ 66,000 The company’s discount rate is 20%. Click here to view Exhibit 14B-1 and Exhibit 14B-2, to determine the appropriate discount factor using tables. Required: 1. Calculate the payback period for each product. 2. Calculate the net present value for each product. 3. Calculate the internal rate of return for each product. 4. Calculate the profitability index for…
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 19% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) $ 180,000 $ 390,000 Annual revenues and costs: Sales revenues $ 270,000 $ 360,000 Variable expenses $ 130,000 $ 180,000 Depreciation expense $ 44,000 $ 86,000 Fixed out-of-pocket operating costs $ 80,000 $ 60,000 The company’s discount rate is 16%. Click here to view Exhibit 14B-1 and Exhibit 14B-2, to determine the appropriate discount factor using tables. Required: 3. Calculate the internal rate of return for each product. Calculate the internal rate of return for each product. (Round your percentage answers to 1…