ScenarioIn the Module Overview, we stated that an "aggregate plan will include the quantity and timing of production for the intermediate future (typically 3-18 months ahead).” Some factors such as demand, pay rate, and the ability to use overtime or subcontract some of the production must be taken into consideration to keep the total cost of production as low as possible.You have been asked to build the aggregate planning schedule for your factory for the next six months and to determine the best option.This chart provides the variables and cost for each variable.VariablesCostInventory carrying cost$7 per unit per monthSubcontracting cost$25 per unitAverage pay rate$12 per hour (8 hours per day)Overtime pay rate$18 per hour (above 8 hours per day)Labor-hours needed to produce one unit1.5 hours per unitUnits per day produced50Beginning inventory0Planned ending inventory0Lost sales per unit$30 This chart provides the demand for the product and the number of production days per month.MonthsDemandProduction DaysJanuary130022February80018March60021April150021May130022June130020Step 1: Prepare Your Aggregate PlanUse the Excel OM Aggregate Planning spreadsheet and the data to prepare your aggregate plan. Produce a graph of your plan. The intent is to use a level strategy (or level scheduling) with no overtime, no safety stock, and no subcontractors.Hint 1 - Consider that it takes 1.5 hours to produce a unit when determining your cost per unit for average and overtime pay.Hint 2 - To determine regular time production, you need to multiply the units per day produced by the number of production days.Continue to Step 2: Update Your Aggregate Plan Using OvertimeStep 2: Update Your Aggregate Plan Using OvertimeIn the plan produced in Step 1, the production rate did not meet the total demand. If you were able to use overtime to meet the shortfall, what would your aggregate plan look like?Use the Excel OM Aggregate Planning spreadsheet and the data to prepare an updated aggregate plan.Continue to Step 3: Update Your Aggregate Plan Using OutsourcingStep 3: Update Your Aggregate Plan Using OutsourcingInstead of paying overtime, you might be able to outsource the shortfall in production. Use the Excel OM Aggregate Planning spreadsheet and the data to prepare an updated aggregate plan using outsources instead of paying overtime.Continue to Step 4: Summarize and SubmitStep 4: Summarize and SubmitOn a fourth tab of the spreadsheet, summarize your cost and determine which of the three options produces the lowest overall cost. Be sure to provide a detailed analysis along with your summary data.Submit one spreadsheet containing a tab for each step. Save your assignment using a naming convention that includes your first and last name and the activity number (or description). Do not add punctuation or special characters.Review the Problems Rubric for detailed grading information.

I am part of team. My deliverable is below   Describe the process   Pictorial view of the process   Identify, describe and outline   deliverables   Outlined Methodology review to   include frequencies Susans Consulting Company (SCC) – Problem Overview Company Overview: Susans Consulting Company (SCC) has been in business for ten years and has experienced a significant turnover in the project management group, which has prompted senior leadership to investigate.  A preliminary review by senior leadership has determined that Project Managers are frustrated with the amount of required project management documentation, which has impacted their ability to manage projects successfully.  A recent review of the project management process has determined that SCC has spent between 30-40% of its total project budget on projects' overhead costs to include project management costs. A review of industry standards is between 5-15% higher than most companies. In addition, senior leaders found that projects are being delivered between 25% and 50% over budget and late 95% of the time. Note: Project Management overhead includes the PM's time managing the project, attending meetings, and developing the required documentation.    Request: SCC has reached out to your team because you are experts in defining project management processes and delivering projects on time. The SCC request includes the following: The development of a new project management process which at a minimum should include the following: The ability to track issues, risks, and changes The ability to view project activities to include the ability to view what has been completed and what activities the team is currently working on and what will be done over the next reporting period The ability to view the project costs to include what has been spent to date, baseline budget, any changes to the budget, remaining budget, and cost of the project at completion In addition, to building a new project management process, SCC would like you and your team to manage a project using the new process.  Assignment:  Step 1:  Identify a project manager – this individual is responsible for the team assignment ensuring that team members are completing their assigned work and will be responsible for turning in the assignment. General Note:  Your instructor will act as the sponsor both for the project and for the methodology build-out.  Any questions should be directed to me. Step 2:  Build a Methodology Identify and describe the methodology to be used by the company.   This should include both a narrative and pictorial representation of the methodology.  Identify and describe the required deliverables for your process. Identify and describe the proposed review and update process for your methodology.  Identify one or more prioritization techniques that will be used to prioritize work - examples can be PV, IRR, NPV, Pay Back Period, and/or dot voting Identify at least 3-5 risks a company should think about when identifying a new methodology.   Identify and describe the optimum organizational structure for the methodology Step 3: The Project Using your new methodology, SCC would like you and you to complete the following project: Scope: The scope of the project consists of 9 applications Initial Development Cost (YR 0) Year 1 IncomeYear 2 IncomeYear 3 IncomeYear 4 IncomeYear 5 IncomeApplication 1 $                                       350,000.00 $      65,000.00 $      74,750.00 $      89,700.00 $      94,185.00 $      95,126.85Application 2 $                                       275,000.00 $      52,000.00 $      62,400.00 $      68,640.00 $      70,012.80 $      71,413.06Application 3 $                                       500,000.00 $      65,000.00 $      79,300.00 $      83,265.00 $      89,926.20 $      94,422.51Application 4 $                                       450,000.00 $      50,000.00 $      65,000.00 $      69,550.00 $      73,723.00 $      77,409.15Application 5 $                                       300,000.00 $    130,000.00 $    143,000.00 $    145,860.00 $    160,446.00 $    170,072.76Application 6 $                                       450,000.00 $      82,000.00 $      94,300.00 $      95,243.00 $      96,195.43 $    100,043.25Application 7 $                                       750,000.00 $    230,000.00 $    287,500.00 $    301,875.00 $    316,968.75 $    323,308.13Application 8 $                                       550,000.00 $      75,000.00 $      91,500.00 $      93,330.00 $    100,796.40 $    103,820.29Application 9 $                                       250,000.00 $      65,000.00 $      85,800.00 $      88,374.00 $      93,676.44 $      95,549.97 Given the critical nature of the project, the company has developed a high-level budget and potential income for each application.  Year 0 is the projected cost the company has estimated for the build of the component.  This includes a 15% overhead cost for project management work Year 1-Year 5 is the amount of revenue the company has estimated for the product The Acceptable Rate of Return for all projects with the company is 10% Step 4:  Manage a project Describe the process that your team will use to elicit and decompose the requirements for the project Develop a Project Overview Statement document for the project Create a WBS for the project.  Remember your WBS is a deliverable base, so there should be a section of your WBS which outlines our project management deliverables Using the following information develop a Gantt chart Optimistic EstimatePessimistic EstimateMost Likely EstimateApplication 14 months9 months6 monthsApplication 21 month5 months3 monthsApplication 35 months10 months7 monthsApplication 41 month7 months4 monthsApplication 55 months10 months8 monthsApplication 62 months9 months5 monthsApplication 75 months12 months7 monthsApplication 83 months13 months9 monthsApplication 94 months11 months8 months Describe strategies you can use to bring the project timeline to 12 months. Develop a team agreement  Using your defined prioritization process, prioritize each application. Using the defined organizational structure, create a pictorial and narrative description of the organizational structure for the project. Identify at least ten potential stakeholders for your project.  Identify at least five risks to include both threats and opportunities associated with the project.  For each risk, please include the following information: Category Impact Probability Description of the risk Mitigation Strategy Describe the process your team can use to determine if the projects are making the appropriate revenue.