You are the new manager of the WSOM Spirit Shop and are responsible for sourcing and selling a line of 6 spirit items (see exhibit A). Most of your sales will likely occur during September, so you have plenty of time to line up your supply plans given that it is currently late April. Having just aced MBAC-507 (and having done a particularly spectacular job on the Sport Obermeyer case), you have quite insightfully created a supply chain with dual-sourcing capabilities. One vendor is located in Vietnam and provides very low costs, but with longer lead times. The second vendor is located in Cleveland and offers higher costs with super short lead times. The Vietnamese vendor has a minimum order of 50 units (per item). The Cleveland vendor does not have a minimum order. Detailed lead times and vendor costs can be found in the WSOM Spirit Shop spreadsheet, Exhibit B (this spreadsheet can be found on Canvas in the Final Exam module). Note, the Vietnamese vendor's pricing includes the cost of delivery to Cleveland. You have six undergraduate marketing majors on your team who have provided sales forecasts (see Spirit Shop spreadsheet, Exhibit A). There is a July early-order opportunity for students to place orders at a discount (to be fulfilled in September). Historically, these early orders have been very accurate indicators of total demand. Assume that any units not sold will be shipped to a surplus clothing store at a cost of $2.50 per unsold item. Questions:

1. Using the data provided, make a recommendation for how many units of each style you should order from the Vietnamese vendor and from the Cleveland vendor. Explain the rationale behind your recommendations (and show your calculations).
2. Assume the Cleveland vendor goes out of business. How would your answer above change? What additional/alternate analytic techniques would you employ (hint, this now becomes a single period "newsvendor" problem)?
3. What is your total expected profit under each of the two scenarios above?
4. In light of your analysis, which model (one supplier or two suppliers) would you choose, and why?