Business case ILS as part of its global expansion strategy has acquired a warehouse and a truck fleet in the country This is the first logistics operation that ILS has acquired in this country A specific strategic objective is to obtain Walmart as a customer Walmart currently uses ILS in other countries 2 ILS recently acquired a warehouse in the country employing 50 warehouse employees and 50 drivers ILS paid $400,000 for the business In addition, ILS allocated $100,000 recognizing that the facility had a number of issues ILS will form a project team working with existing employees to resolve the issues during Year 0 Given that the problems can be solved ILS expects to see a net cash flow (revenue costs depreciation add back) of $150,000 per year starting in Year 1 Assume a five year investment life with a salvage value of $400,000 for continued earnings for year 6 and beyond ILS plans to secure business from Walmart and other customers in the area surrounding the warehouse once the current issues are resolved Attaining Walmarts business is a strategic objective Propose a business case for the project Calculate the Net Present Value (NPV) for the project business case (Use Microsoft Excel to derive the NPV assuming the data belowsubmit an Excel spreadsheet as an appendix Purchase price of $400,000 One time project costs total of $100,000 spent in Year 0 Net benefits after taxes of $150,000 per year for five years Salvage value for Year 6 and beyond of $400,000 ) Summarize your results of NPV in the paper and refer to the Appendix Develop a milestone schedule that includes five to seven elements Use the case study to derive the milestones If the case is lacking, feel free to include a solution or milestone that you think Walmart would value

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Aug 26, 2024

Business case: ILS as part of its global expansion strategy has acquired a warehouse and a truck fleet in the country. This is the first

Business case:
ILS as part of its global expansion strategy has acquired a warehouse and a truck fleet in the country. This is the first logistics operation that ILS has acquired in this country. A specific strategic objective is to obtain Walmart as a customer. Walmart currently uses ILS in other countries. 2 ILS recently acquired a warehouse in the country employing 50 warehouse employees and 50 drivers. ILS paid $400,000 for the business. In addition, ILS allocated $100,000 recognizing that the facility had a number of issues. ILS will form a project team working with existing employees to resolve the issues during Year 0. Given that the problems can be solved ILS expects to see a net cash flow (revenue costs + depreciation add back) of $150,000 per year starting in Year 1. Assume a five-year investment life with a salvage value of $400,000 for continued earnings for year 6 and beyond. ILS plans to secure business from Walmart and other customers in the area surrounding the warehouse once the current issues are resolved. Attaining Walmarts business is a strategic objective
Propose a business case for the project.
- Calculate the Net Present Value (NPV) for the project business case. (Use Microsoft Excel to derive the NPV assuming the data belowsubmit an Excel spreadsheet as an appendix:
  - Purchase price of $400,000.
  - One-time project costs total of $100,000 spent in Year 0.
  - Net benefits after taxes of $150,000 per year for five years.
  - Salvage value for Year 6 and beyond of $400,000.)
- Summarize your results of NPV in the paper and refer to the Appendix.
Develop a milestone schedule that includes five to seven elements
- Use the case study to derive the milestones. If the case is lacking, feel free to include a solution or milestone that you think Walmart would value.