ACADEMiCiNTEGRITY: This IS a group assignment. You are on your honor. You cannot discuss any aspect of this case or anything related to it with any other teams. You cannot use any other outside resources other than your notes, course articles and material, and your own team members. You cannot use the Internet, Google, etc. to help with the case. The case can be purchased online. This case is the same one we explored for the MAS 1 Western Optimization. Assignment Document Overview: This assignment document contains the following information to help you complete the case assignment: I. Assignment Objectives ||. Assignment Overview |||. Assignment Formatting IV. Helpful Hints V. Eastern MAS Assignment Deliverables for Part 1: New Markets and Part 2: The Project VI. Assignment Questions for Part 1: New Markets and Part 2: The Project VII. Grading Criteria VIII. Cover Sheet Template IX. Honor Code Pledge X. Assignment Checklist i. Assignment Objectives: 1. Utilize a simulation tool to help determine an optimal supply chain design required to meet corporate objectives to move into a new geographical marketing area. Predict financial analysis {N PV) and performance metric assessment to evaluate the design. Analyze risk factors associated with that design and propose mitigation solutions to those items. Demonstrate the use of Project Management techniques to help assess your supply chain network design. Create a professional Power Point presentation {using the notes section for more in-depth responses to assignment questions) to illustrate your recommendations, analysis, and approach to engage the MAS audience to accept your proposal. PPS-\"l" ii. Assignment Overview: You are to develop a 8 to 10slide professional Power Point presentation. Typically, you will place on the Power Point slides themselves, a set of bullet points, graphs, etc., just iike a real presentation. Please do not use full sentences or paragraphs on the slides. | suggest you evaluate your Power Point slides in the \"Slide Show Mode\" before you submit them. We will be grading based upon this view! Since you cannot answer the questions totally on the slides themselves, teams should utilize the \"Notes Portion\" (see Notes Page under the View Tab of the PowerPoint slide presentation) of the PowerPoint slides for areas that require further explanation. When you use the "Notes\" section, you are limited to the PowerPoint slide on the top of the \"Notes Portion\" and the text information below it. I would suggest on this portion of the slide to reference the question you are l answering by stating on the rst line (11, O2, etc. By seeing this marker-{11, Q2, etc.-we will know what question you are answering. No need to repeat the questions. 0 One of the earlier slides should include an agenda slide and/or objective slide--this slideis} is not counted toward the total. Also, you will be required to have a summary slide--this slide is not counted toward the total. o Please note: The team should place citations on the slides as needed that illustrate the problems/questions/goals/objectives, etc. you are trying to obtain. 0 Please see the Course Schedule and the Weekly Announcement for due dates for these deliverables. Also note that a Dropbox has been set up for this assignment. During this presentation and simulation, you can change any item your team deems necessary to obtain the optimal supply chain performance within the limits of the case. The only items you CANNOT change are the time fence and the plant warehouse! See the questions below to help direct your focus for the presentation. Assume your team is a conSuIting firm. You are competing with all the other teams in this section of SCM 850 this semester to have MAS's upper management accept your group's recommendations and implement them. Be careful...the presentation must be completed in a professional manner trying to meet or exceed the goals of the MAS Manufacturing Company. Consequently, when you submit information and the report to me, it needs to be compiled in a professional, well analyzed. and thoughtful manner. Additionally, please make sure you format all items professionally--for example all Excel tables should print out in a landscape mode on an 8 if: by 11 sheets, all items must have titles, etc. The MAS's "Board of Directors\" has requested that your team must add at least one new manufacturing plant (in addition to the Denver one) into your plan. It cannot be opened any earlier than Year #3. It should be considered a grassroots plant. In addition to the assignment document, you may find it helpful to review the Case Road Map located in Lesson 1 of Module 4. The Case Road Map will outline all the related tasks and deliverables in this assignment. A print-friendly version of this document is provided in Lesson 1. Please Note--A Small Notation Problem--The Labeling of the Word "Year": As you have noticed when you run the simulation, it labels the timeline and uses the word "Year\" as Year 1, 2, 3, 4, and 5. Unfortunately--in some of the introductory information, podcasts, readings, etc. many times we refer to the initial year as Year 0. As mentioned, the actual simulation starts with Year 1--so Year 1 from the simulation and Year 0 from the other information are the same! Please make the appropriate adjustments depending upon how you label your documents. In any case, you should not have more than five total yearseither Year 0 through Year 4 or Year 1 through Year 5. You can see in either situation they have a total of five years. lll. Assignment Formatting: Points will be deducted for not following formatting directions... 0 Please attach the cover page and pledge listed below. 0 All Excel spreadsheets must fit on one page, in landscape mode, and all pages must have a title. 0 One Excel spreadsheet should show the NPV cash flow calculations for Option 2: East of the Mississippi from Year 1 through Year 5 (Some folks call Year 0 our Year 1)! o All Critical Path Diagrams that are submitted must be in a PDF format. Feel free to calculate the CPM by hand or by using Microsoft \"Project Management\" software but submit to me in a PDF format that can be printed out. 0 Please add typed titles to all appendices, Excel les, etc. iV. Heipfuf Hints: The Eastern MAS Expansion Case Part 1 and Part 2: Discount rate 15% Year 1 is the base year--sometimes it is referred to as the 0 Year. For the initial Year 1, you will use your Optimized Solution from the Western MAS Case submitted on earlier in the semester, when you optimized just the Western States--that is your new base case--not the very original one that comes up at the beginning of a simulation run. The new base case is your team's Western Optimized Case! You cannot change it without permission. You need to run a simulation for each year after that year and hand in the entire ru n--you have already run one for Year 1so no need to submit it a second time unless you have permission to change it! The tax rate is 34%. NPV is based on Year 1 through and includes Year 5. No depreciation or working capital to consider. No administrative, marketing, or general SG&A to consider. The larger the NPV, the better--this approach is different from the Scott Case-MAS includes revenues. You must add one additional manufacturing plant no earlier than year 3. Option #2 East of the Mississippi: Supply Chain Income Statement Impacts SalesUtilize your team's Year 1 (0) Western MAS optimized solution from February 26th for starting point in Year 1 (0). The sales for each year thereafter come from the Supply Chain Income Statement for each year -- Year 2, Year 3, etc. COGS Utilize the \"Supply Chain Financial Statements\" page of your team's Year 1 (0) optimized solution for variable costs as the Year 1 (0) starting point for this exercise--yariable costs are the COGS-and the COGS for each year thereafter from the appropriate year Supply Chain Income Statement. Fixed Costs See \"Supply Chain Financial Statements" page of your team's Year 1 (0) optimized solution for fixed costs as the Year 1 (0) starting point for this exercise and the fixed costs for each year thereafter from the appropriate year Supply Chain Income Statement. lnventory See "Supply Chain Financial Statements\" page of your team's Year 1 (0) optimized solution for income statement inventory costs as the Year 1 (0) starting point for this exercise and the fixed costs for each year thereafter from the appropriate year Supply Chain Income Statement. Supply Chain Assets Employed Investment Impacts Other Annual Capital Outlays None PlantsUtilize optimized simulation for Year 1 (0)for years Year 1 (0) through Year 5 use the incremental costs between each year! See "Supply Chain Financial Statements\" page under the heading "Supply Chain Assets Employed\" for the appropriate year. In other words, the incremental cost is the difference between the previous year and the current year...not the absolute cost. Plant WarehousesSee optimized simulation for Year 1 (0) for years Year 1 (0) through Year 5 use the incremental costs between each year! See \"Supply Chain Financial Statements\" page under the heading "Supply Chain Assets Employed" for the appropriate year. In other words, the incremental cost is the difference between the previous year and the current year...not the absolute cost. DC'sSee optimized simulation for Year 1 (0) for years Year 1 {0) through Year 5 use the incremental costs between each year! See \"Supply Chain Financial Statements\" page under the heading \"Supply Chain Assets Employed\" for the appropriate year. In other words, the incremental cost is the difference between the previous year and the current year...not the absolute cost. InventorySee optimized simulation for Year 1 l0) for years Year 1(0) through Year 5 use the incremental costs between each year! See \"Supply Chain Financial Statements\" page under the heading \"Supply Chain Assets Employed\" for the appropriate year. In other words, the incremental cost is the difference between the previous year and the current year...not the absolute cost. 1. Eastern MAS Case Assignment Deliverabfes: \\Ithough the Eastern MAS Project is one major assignment, we are utilizing two windows (points) in time for items to be lelivered--the Lesson 2 Part 1 deliverables are submitted first, and the Lesson 3 Part 2 deliverables are submitted a :ouple of weeks later. Please see the Course Schedule for due dates. )nce the Part 1 Delivera bles are placed in the Part 1 Dropbox they cannot be changed. Consequently, what is submitted n Lesson 2 Part 1 Deliverables' Dropbox cannot be modified and placed in the Lesson 3 Part 2 Deliverables' Dropbox. lllso, there will be no intermittent feedback on the initial placement of deliverables in the Part 1 Dropbox. Feedback on hese deliverables will be provided with the final feed back given on the entire assignment at the conclusion ofthe entire Issignment. .esson 2 (Part 1- New Markets) Deliverables (Presentation Analysis and Quality): 1. A copy of your Project Definition Document: (Please note, the terms Project Definition Document, Project Plan, or Project Charter are considered synonymous for this assignment.) Defining the project is the first step in every project! Based upon your work in other SCM courses, other non-PSU courses, or work-related approaches you have used, please develop a brief project definition assuming you will move into the Eastern Market. Regardless of what was discussed in other courses, this item should be no more than one page. The document should include (but is not limited to) the project's goals, the overall project costs, the overall timeline, the various risks and/or constraints, etc. You need to determine what belongs in this document. What is your recommended network design for MAS in Year 5? Submit a printout showing the simulation results ofthis year. This final optimized "new" supply chainis based upon your previous experience that impacts what DC's, manufacturing plants, etc. need to be opened and when, to meet the new market needs. This deliverable is information required to answer Question 1 below. Remember answering the actual Question 1 is part of the Power Point Deck, which is not required at this point in time--just the printout ofthe Year 5 simulation run is required now. Remember once the printout of the run is submitted during this portion ofthe assignment--it CANNOTbe changed! Please focus and concentrate your attention on an optimized Year 5 run! You must add a second manufacturing plant in addition to Denver no earlier than Year 3. A list of activities, costs, and implementation timelines--this information will be the basis for the NPV calculation and a CPM document. Please ballpark these items based upon your experience-mo need to do research--just