# 1. Develop and calculate the NPV on an Excel Spreadsheet for the “Option 2 Plan” for the Corkford Brewery acquisition while considering the constraints and operating conditions laid out in the case as

1. Develop and calculate the NPV on an Excel Spreadsheet for the “Option 2 Plan” for the Corkford Brewery acquisition while considering the constraints and operating conditions laid out in the case as well as in the ‘Helpful Hints’ section of this document.  Interpret the drivers of the NPV and the implications to the broader business decision. (40 points)

i.     For example, the variable costs for Amber Ale is \$122.063 per unit

2. Develop and calculate the NPV on an Excel Spreadsheet for the “Option 3 Plan” for the Corkford Brewery acquisition while considering the constraints and operating conditions laid out in the case as well as in the ‘Helpful Hints’ section of this document.  Interpret the drivers of the NPV and the implications to the broader business decision. (40 points)

i.     For example, the variable costs for Amber Ale is \$122.063 per unit

3. Add a summary table that compares all three plans and shows all major cost categories. (20 points)

4. Let us consider a form of sensitivity analysis for this problem. Chose a variable (interest rate and time period cannot be used) and explore the impact on your plans. This question has two parts: (20 points)

Files:
SCM 801 Corkford Brewery Case Assignment JS NAA Posted 10262021.doc, Excel Workbook Changes.xlsx, 2021.11.10 To Brew or not Brew- The CORKFORD Brewery Acquisition.pdf, Net Value and Internal Rate of Return.pdf, Hilton Chapter 16 PV and NPV_20201016114132569.pdf, 2021.11.10 Present and Future Value Tables.pdf
1. Develop and calculate the NPV on an Excel Spreadsheet for the “Option 2 Plan” for the Corkford Brewery acquisition while considering the constraints and operating conditions laid out in the case as

1. Develop and calculate the NPV on an Excel Spreadsheet for the “Option 2 Plan” for the Corkford Brewery acquisition while considering the constraints and operating conditions laid out in the case as well as in the ‘Helpful Hints’ section of this document.  Interpret the drivers of the NPV and the implications to the broader business decision. (40 points)

i.     For example, the variable costs for Amber Ale is \$122.063 per unit

2. Develop and calculate the NPV on an Excel Spreadsheet for the “Option 3 Plan” for the Corkford Brewery acquisition while considering the constraints and operating conditions laid out in the case as well as in the ‘Helpful Hints’ section of this document.  Interpret the drivers of the NPV and the implications to the broader business decision. (40 points)

i.     For example, the variable costs for Amber Ale is \$122.063 per unit

3. Add a summary table that compares all three plans and shows all major cost categories. (20 points)

4. Let us consider a form of sensitivity analysis for this problem. Chose a variable (interest rate and time period cannot be used) and explore the impact on your plans. This question has two parts: (20 points)

Files:
SCM 801 Corkford Brewery Case Assignment JS NAA Posted 10262021.doc, Excel Workbook Changes.xlsx, 2021.11.10 To Brew or not Brew- The CORKFORD Brewery Acquisition.pdf, Net Value and Internal Rate of Return.pdf, Hilton Chapter 16 PV and NPV_20201016114132569.pdf, 2021.11.10 Present and Future Value Tables.pdf