Deliverable 3 - Ranking Capital Investment Projects Excel and Power Point

Competency

Interpret financial decision-making criteria.

Scenario

You are an operations manager for New Foods Company. The company manufactures organic versions of common food items, such as cookies and bread. New Foods has built a reputation for good taste and quality in its products and has developed partnerships with several health food retailers. An opportunity exists to expand into a traditional grocery store chain with a new partnership. This opportunity will require increased production. However, your firm has not previously sold its products in this channel and uncertainty exists about the volume of new product sales that may result.

The executive leadership team of New Foods Company wants to grow the firm and it has been working with the local government on potential tax credits for creating new jobs in the area. The leadership team has also identified a commercial bank that will provide loans for any plant and equipment purchases. An overarching goal of the leadership team is to maintain product quality and the brand’s reputation.

Three options for increasing production have been identified.

• The first option is to purchase and refurbish a manufacturing plant location in a nearby town that has been closed for several years. Equipment to operate this plant would also have to be acquired. The location is large enough to build production for the expected volume and have excess space to accommodate growth of 200% in the future. This refurbished location could be operational in 12 months.


• The second option is to lease capacity from another food manufacturing firm that does not make its own branded products but operates as a co-manufacturer for others. This firm currently has enough available capacity for the expected volume, but not to increase above that level. This production process could be operational in 3 months.


• The third option is to expand your existing plant location by purchasing adjacent land and constructing a new building. Equipment to operate this expansion would also have to be acquired. The land is large enough to build production for the expected volume and have excess space to accommodate growth of 50% in the future. This new location could be operational in 18 months.

Instructions

Using the financial data provided in the Excel file, calculate a net present value, internal rate of return, and payback period for each option.

Prepare a PowerPoint presentation that summarizes the calculated results from the financial analysis and provides the key operational and strategic points for each option. One slide must be a ranked list of the three project options. Include a justification of which financial metrics and non-financial data were prioritized for ranking the three options.

Submit the Excel file with the completed calculations and the PowerPoint presentation.