member of the planning and analysis staff. Forrest has been asked by Bill Rolland, chief financial officer of IDI, to prepare a net-present-value analysis for a proposed capital equipment expenditure that should improve the profitability of the western plant. This analysis will be given to the board of directors for approval. Several years ago, as director of planning and analysis at IDI, Rolland was instrumental in convincing the board to open the western plant. However, recent competitive pressures have forced all of IDI?s manufacturing divisions to consider alternatives to improve their market position. To Rolland?s dismay, the western plant may be sold in the near future unless significant improvement in cost control and production efficiency are achieved.

Please see attachment.

Instant Dinners, Inc Instant Dinners, Inc. (IDI), is an established manufacturer of microwavable frozen foods. Leland Forrest is a member of the planning and analysis staff. Forrest has been asked by Bill Rolland, chief financial officer of IDI, to prepare a net-present-value analysis for a proposed capital equipment expenditure that should improve the profitability of the western plant. This analysis will be given to the board of directors for approval. Several years ago, as director of planning and analysis at IDI, Rolland was instrumental in convincing the board to open the western plant. However, recent competitive pressures have forced all of IDI's manufacturing divisions to consider alternatives to improve their market position. To Rolland's dismay, the western plant may be sold in the near future unless significant improvement in cost control and production efficiency are achieved. Western's production manager, an old friend of Rolland, has submitted a proposal for the acquisition of an automated-material-handling system. Rolland is anxious to have this proposal approved as it will ensure the continuation of the western plant and preserve his friend's position. The plan calls for the replacement of a number of forklift trucks and operators with a computer-controlled conveyor belt system that feeds directly into the refrigeration units. This automation would eliminate the need for a number of material handlers and increase the output capacity of the plant. Rolland has given this proposal to Forrest and instructed him to use the following information to prepare his analysis. Automated-Material-Handling System Projections Projected useful life 10 years Purchase and installation of equipment$ 4,500,000 Increased working capital needed* 1,000,000 Increased annual operating costs (exclusive of depreciation) 200,000 Equipment repairs to maintain production efficiency (end of year 5) Increase in annual sales revenue 700,000 Reduction in annual manufacturing costs Reduction in annual maintenance costs 800,000 500,000 300,000 Estimated salvage value of conveyor belt system 850,000 * The working capital will be released at the end of the 10-year useful life of the conveyor belt system. The forklift trucks have a net book value of $500,000 with a remaining useful life of five years and no salvage value for depreciation purposes. If the conveyor belt system is purchased now, these trucks will be sold for $100,000. IDI has a 40 percent tax rate, has chosen the straight-line depreciation method for both book and tax purposes, and uses a 12 percent discount rate. For the purpose of analysis, all tax effects and cash flows from the equipment acquisition and disposal are considered to occur at the time of the transaction while those from operations are considered to occur at the end of each year. When Forrest completed his initial analysis, the proposed project appeared quite healthy. However, after investigating equipment similar to that proposed, Forrest discovered that the estimated salvage value of $850,000 was very optimistic. Information previously provided by several vendors estimates this value to be only $100,000. Forrest also discovered that industry trade publications considered eight years to be the maximum life of similar conveyor belt systems. As a result, Forrest prepared a second analysis based on this new information. Use Appendix A for your reference. (Use appropriate factor(s) from the tables provided.) Required: Prepare a net-present-value analysis of the purchase and installation of the material-handling system using the revised estimates obtained by Leland Forrest. (For this problem, ignore the half-year convention. Assume annual straight-line depreciation of $562,500, which is $4,500,000 8.) (Round your "Discount factor" to 3 decimal places. Negative amounts should be indicated by a minus sign.)