Canadian Valve Company (CVC) manufactures three types of industrial valves: flow-control valves, pressure-control valves, and custom valves. During the past three years, CVC has seen a decline in demand for the ow-control valve, steady demand for the pressure-control valve, and substantially increased demand for the custom valves. The income statement by product line is included in Appendix |. Jerry Chwang, vice-president of operations, is concerned about the recent trends he is witnessing in the company. 'We have top-of-the-line equipment and great employees. Most of our competitors generate a prot margin of 10% before taxes we do not. The cost of the flow-control valve is constantly increasing while the unit cost of the custom valve seems to be getting cheaper every year. It makes no sense.\" It is July 15, 2021, and you are a CPA working for Barden Management Consultants. Jerry is seeking your advice on changes that should be made to improve protability. He has provided you with the following information on the three product lines for the year ended June 30, 2021. Flow-control Pressure-control Custom Sales price $47.00 $68.00 $112.00 Direct material 10.00 14.00 22.00 Direct labour (1} 15.00 22.50 37.50 Variable overhead (2) 6.00 9.00 15.00 Total variable cost 31.00 45.50 74.50 Contribution margin $10.00 $22.50 $37.50 Units sold 50,000 25,000 5,000 Direct labour hoursl'unit 1.0 1.5 2.5 Machine hourslunit 0.1 0.2 2.0 Notes: (1) The standard labour rate is $15.00 per hour. (2) Variable overhead include small tools, lubricants, and indirect labour charges. It is apply at a rate of40% of direct labour. Task #3 Jerry is certain that a great way for CVC to improve protability is to expand its product line. He believes a new knife-gate valve has a very promising future. CVC's CEO still needs to be convinced; while she would like to increase prots, there are capacity concerns. Jerry provided you with the following information on the knife-gate valve: Estimated variable costs: Direct materials $20.00 per unit Direct labour (3.0 hours) $45.00 per unit Variable overhead $18.00 per unit Target selling price $115.00 per unit Estimated annual demand 5,000 units In addition, engineering advised that the knife-gate valve can be produced on existing machinery. According to the engineers, manufacturing the knife-gate value should not result in any increased to xed production costs. Only the allocation of xed costs will change. Jerry would like your help in drafting a production schedule that includes the knife-gate valve, to maximize prots for CVO. Appendix I Income Statement by Product Line For the year ended June 30, 2021 Flow- Pressure- control control Custom Total Volume (units) 50,000 25,000 5,000 80,000 Sales price $47 $68 $112 Revenue $2,350,000 $1,700,000 $560,000 $4,610,000 Variable costs: Direct material 500,000 350,000 110,000 960,000 Direct labour 750,000 562,500 187,500 1,500,000 Variable overhead 300,000 225,000 75,000 600,000 Total variable costs 1,550,000 1,137,500 372,500 3,060,000 Contribution margin 800,000 562,500 187,500 1,550,000 Fixed costs: Engineering2 40,000 30,000 10,000 80,000 Quality control 65,000 48,750 16,250 130,000 Depreciation 407,500 305,625 101,875 815,000 Other manufacturing* 125,000 62,500 12,500 200,000 Selling and administrative4 78,125 39,063 7,812 125,000 Total fixed costs 715,625 485,938 148,437 1,350,000 Net income $84,375 $76,562 $39,063 $200,000 Net income/revenue 3.6% 4.5% 7.0% 4.3% Notes: 1. It has been reliably determined that variable overhead is a function of direct labour dollars. 2. Engineering and quality control are allocated to products based on their relative proportion of total direct labour dollars. 3. Depreciation is allocated to products based on their relative proportion of total direct labour dollars. The depreciation charge includes $125,000 of R&D costs associated with the knife- gate valve. Because this product is not likely to be launched in the near future, it was decided to expense these costs. 4. Other fixed manufacturing overhead and fixed selling and administrative expenses are allocated to products based on the number of units sold.to ensure operational efficiency. Therefore, before I could give him a definitive answer, I would need to know what next year's production plan is.Appendix II Highlights from Employee Discussions Gord Downie (controller): Although I have no formal training in accounting. l have been doing this for a long time and am very proud of the intemal amounting system and the changes that l have introduced over the past five years. We've carefully analyzed the variable and xed costs using some pretty powerful software. I'm condent that we have an accurate handle on how costs behave as volume rises and falls in the various product lines. Stephanie Ll (marketing): Marketing expenses are included in the xed selling and administrative costs. The amount of time. energy. and expenses devoted to each of the product lines seems to depend on the volume sold. and I think the current allocation is appropriate. The big problem I hear about from the sales centres is around our prices. We currently base all of our prices on an approximate 50% markup over variable costs. I am not an expert. but I believe that our selling prices should be more in line with our competitors. and our price should be based on the total costs of the resources really consumed by a product. Instead of our current approach, I would like to see us using the malket benchmark. or a total cost + 10% margin pricing strategy. But I certainly would like a third party to analyze these three pricing strategies in order to gure out which one would provide the highest protability. Flow-control model: We charge $2.50 above our competitors' prices on the flow-control model. and this is really cutting into our sales volume. During the past three years. sales have dropped 24,000 units. If we could reduce price to a level at or below the current average market price of $44.50. I expect sales would jump back to 72,000 units per year. which. for us. has ahlvays been a level of production that we consider normal. Pressure-control model: With respect to the pressure-control model. | feel that the current sales price is aligned with the current market price and, thus. volume should remain at current levels for the foreseeable future if we don't make any changes to the product or its price. It has been stable for the past three years. Custom model: Sales of the custom valves have grown by 4.000 units over the past three years. It is difcult to nd out what our competitors are charging. but there is some evidence to suggest that our prices are very attractive to customers. I think we should reinforce the company's strategy of marketing base models and offering the custom model as a service to regular customers at a premium price. If we limit the selling price of the custom model at or below $350, we would be able to sell around 1.000 custom units per year, which is the level we operated at several years ago. Kris Bevin (engineering department): Our new computer-assisted design system has really changed the way we do things around here. When an order comes in, it is tagged as ow-control, pressure-control, or custom. I would guess that 75% of our time is spent on the custom orders, as they usually require signicant adaptations. With the reduced demand for the ow-control model, it currently takes up only about 5% of our time. The pressure-control model takes up the remainder of our efforts. If we were to return to more normal levels of production, I guess that we would spend about half of our time on the custom orders and split the remaining hours behiveen the other two lines. Mo Patna (quality control): Nothing leaves this plant that isn't strime to our customer's specications. We check the output of the work centres when they begin each job and monitor output randomly. Because the two basic models (ow-control and pressure-control valves) are produced in large batches. I estimate that each model currently takes about 20% of our time. If the volume of flow-control sales retumed to its normal level, I am sure that the amount of quality control would increase to about 30%. The pressure-control model would remain at 20% and the remaining time goes to the more difficult custom work. Dev Patel (supervisor machining and assembly): This new computer-aided manufacthing equipment has really improved our manufacturing procedures, but the machinery is very expensive. The annual depreciation charge is $690,000. We also incur $200,000 in other fixed manufacturing charges. which relate mostly to the volume of goods produced and sold. It seems logical to allocate the other manufacturing charge based on sales volume; however. I have never understood why the accounting system charges so little depreciation to the custom line. because we invested a lot in the machinery to accommodate these special orders for customers. Jerry asked me if our current manufacturing facility could accommodate a new product such as the knife-gate valve that is likely to gain in popularity in the near future. I told him that my biggest problem is scheduling the direct labour hours. The maximum number of direct labour hours per year is 112,000. and nothing can be done to increase this in the next 12 months. Also, the minimum level of production for a specific valve type is 500 units per year