Waterways Continuing Problem (This is a continuation of the Waterways Problem from Chapters 1 through 6.)

WCP7.7 Phil Clark Jr., president of Waterways, was very pleased with how adopting a CVP approach to reporting operating income was helping management to make good business decisions with respect to planning, production, and sales for the coming year. He has a feeling that knowing how fixed and variable costs behave might also help them to find savings in the production department. Further, he is concerned that Waterways' production facility is working near full capacity right now, and he does not know if the company could generate enough new business to make adding another shift viable.

Phil decides to sit down with his brother Ben, vice-president of operations, and Ryan Smith, the plant manager, to see if they could do more with less, as he put it. Jordan Leigh, CFO, had recently presented them with a number of situations that required decisions that would impact operations in the plant. Phil thought that together the four of them could find some efficient solutions.

Part 1 Waterways packages some of its products into sets for do-it-yourself (DIY) installations. The smaller set that sells for $159 has variable costs of $79, while the larger set sells for $249 with variable costs of $159. Fixed costs are assigned at a rate of $6 per machine hour.

It takes 32 minutes of machining time to produce and package the smaller set. The larger set is more complicated and requires 60 minutes of production time. The machines operate for two shifts of eight hours each day for 20 days per month. Maintenance and set-ups are handled outside of these times.

Analysis of the current market trends reveals that monthly demand for the smaller set would not exceed 500 units, while Waterways could sell as many of the larger ones as it can produce.

Instructions Given the information above, determine the best use of these machines.

Part 2 As we learned in Chapter 6, Waterways markets a simple water controller and timer that it mass-produces. During 2020, the company sold 350,000 units at an average selling price of $8.00 per unit. The variable expenses were $1,575,000, and the fixed expenses were $800,000.

Waterways has determined the full cost to manufacture its timers is $6.79 per unit. Recently it was discovered that a competitor was selling this unit for $6.58 per unit. Ryan immediately suggested that Waterways buy the timer from the other supplier, but Jordan was not convinced. He cautioned Ryan that $77,120 worth of fixed costs would not be eliminated by buying the unit. However, he also knew that, if Waterways bought the unit from the competitor, it would free up 120 machine hours that could be used to produce the large DIY installations kits described in WCP7.7Part 1.

Instructions 1. Assuming Waterways requires 350,000 timers, evaluate whether it should continue to make the timer or if it should purchase it from the outside supplier. 2. What is the maximum price per unit Waterways should be willing to pay to purchase the timer from an outside supplier? 3. What non-financial factors might be considered in making this decision? Part 3 Waterways mass-produces a special clip that is used to install the irrigation pipes. Because of a limited supply of the raw material used in the manufacturing process, very few other companies can manufacture this clip. These units normally sell for $3.95 per unit. Waterways sells about 35,000 of the units each year.

A company in British Columbia that has been unable to secure enough material to produce the volume of units demanded by its customers has offered to pay $2.90 each for 15,000 units. This is just $0.30 above the variable cost of the unit. In addition, to complete production, it would require temporarily adding another shift to the production line, which in turn would increase variable manufacturing costs by $0.30 per unit. However, because the units are going to one company, selling costs would be reduced by $0.15 per unit.

An Alberta company has also asked for a special order. It is willing to pay $3.20 per unit but only needs 10,000 units. Waterways cannot manufacture this order without adding an extra shift. Special packaging required will cost $0.20 per unit.

Currently, Waterways has enough raw materials to produce 50,000 units.

Instructions 1. Determine the consequences of Waterways agreeing to provide the 15,000 units to the B.C. company. Would this be a wise special order to accept? 2. Should Waterways accept the special order from the Alberta company? 3. What would be the consequences of accepting both special orders? 4. What would be the opportunity cost of accepting the special order from the British Columbia company? The Alberta company? Part 4 Waterways is considering the replacement one of its two machines, an antiquated machine that has been slowing down production of its special clip because of breakdowns and added maintenance. Ryan Smith, the plant manager, estimates the machine has two years left of use. The undepreciated cost on the old machine is $30,000. He notes that the current machine is capable of producing an average of 1,200 units per month. The new model of the machine could produce twice as many units during the same time and variable costs would go down by $0.10 per unit. The replacement machine would cost $57,000 and has a two-year life expectancy.

Costs are not expected to change over the next two years.

Instructions Given the original information in WCP7.7Part 3, and assuming an unlimited supply of raw materials, determine if Waterways should replace the old machine.