How would you evaluate the four recommendations made by the MBA team?

Overview

Kaffee Kostuum: A Dilemma in Retail Financials

Continue using the same spreadsheet template that you've used in the team-based part, but now use the other tabs (worksheets) of the file to answer the following questions.

1. How would you evaluate the four recommendations made by the MBA team? To analyze these recommendations, use the four tabs in the spreadsheet labeled "Variance Reduction," "Decentralized Ordering," "Location Pooling," and "Local Sourcing." The calculations will be similar to those in the team-based section; however, some initial values must be updated, particularly the green-colored cells.

General Motors: "Electrification" Capacity Constraints 

Continue using the same spreadsheet template that you've used in the team-based part, and answer the following questions (40 points) 

1. In the "Container Analysis" tab, the calculation for the first option is provided. Complete the analysis for the remaining options.
2. In the "Inventory Analysis" tab, the calculation for the first option is provided. Complete the analysis for the remaining options.
3. In the "Enterprise Analysis" tab, the calculation for the first option is provided. Complete the analysis for the remaining options.