This assignment is part of the business plan you will create throughout the program. Use the company that you chose to work with in the second Competency Assessment of this course, which is the company you will use for your entire business plan.Part 1 of this assessment is intended to help you learn how to apply forecasting and demand models as part of a business operations plan. In Part 2, you'll demonstrate the ability to build a supply chain operations plan and diagram for a business by analyzing factors that affect sourcing, logistics, metrics, suppliers, and risk. Note that although you need to submit Part 1: Operations Forecasting as part of the competency assessment, it will not be graded. Completing Part 1 is meant to help build your knowledge in preparation to complete Part 2 and for use in your Integrative Business Capstone project in STRCB/581. You will be able to submit this assessment after you have completed the Reflection assignments in Competency 3. There is a Competency 3 - Assessment Submission that appears in the course.Save and upload each part of the assessment as a separate file and title the files so it's clear to see what part of the assessment they serve. Include your name in your documents on the first page, upper left.Although this part of the assessment is not graded, you still need to complete it and submit it. This activity is meant to help build your knowledge in preparation to complete Part 2 and for use in your Integrative Business Capstone project in STRCB/581.Choose 3 quantitative elements from the company you selected in Competency 2, Part 1.Develop forecasts by implementing the following approach:Collect data, including old demand forecast (subjective data) and the actual demand outcomes.Establish the forecasting method (from readings). Decide on the balance between subjective and objective data and look for trends and seasonality.Forecast future demand using a forecasting method.Make decisions based on step 3.Measure the forecast error where applicable. Look for biases and improve the process.Write a 525- to 700-word paper evaluating and summarizing the findings from the supported data points above. Insert the charts and supporting data from Excel and other tools in your paper.Continue to Part 2: Supply Chain Operations Plan.Use the company that you chose to work with in the second Competency Assessment of this course, which is the company you will use for your entire business plan.Build a supply chain plan and diagram for the company by analyzing factors that affect sourcing, logistics, metrics, suppliers, and risk.Create your supply chain diagram using one of the following tools:ExcelPowerPointVisioPictoGramPDFOther faculty-approved platformWrite an 875-word analysis of the supply chain operations plan. Include the following in your analysis:A visual depiction of your supply chain diagramYour supply chain planValue chain and flow of structureInputsOutputs, including customer service structureInventory points and forecastingSourcing activitiesRisksLocationsLogistics

Optimizing Performance: Finally, you will determine an optimal solution that will maximize the organization’s objectives. You will need to consider the level of sensitivity and uncertainty of alternative solutions in supporting your optimal solution. The analyses need to be submitted in an annotated excel file and include a rationale. A. Determine the values of the constraints to be used to generate the target number when running Solver. B. Using Solver, calculate the level of sensitivity of decision variables and describe the significance of the report. C. Using Solver, calculate the limits of decision variables and describe the significance of the report.D. Discuss solutions that will maximize profits for the organization based on the Solver analysis.

Option #1: Process Costing You Got Yogurt, Inc. manufactures yogurt that goes through three processing stages prior to completion. Information on work in the first department, flavor identification and blending, is given below for November: Data on Production: Pounds in process at November 1; materials 100% complete; conversion 70% complete                                 3,525 Pounds started into production during November                                                                                                    75,000 Pounds completed and transferred out                                                                                                                       ? Pounds in process, November 30; materials 85% complete; conversion 40% complete                                    6,100 Data on Costs: Work in process inventory, November 1: Materials cost                                                                                          $1,800 Conversion cost                                                                                                                                                                $3,700 Cost added during November:  Materials cost                                                                                                                                                                  $121,000 Conversion cost                                                                                                                                                              $147,700 The company uses the weighted-average method. Submit your assignment as an Excel spreadsheet document, clearly organized, with each tab or section labeled by item number that demonstrates the following:  Compute the equivalent units of production. Compute the costs per equivalent unit for the month. Determine the cost of ending work in process inventory and of the units transferred out to the next department. Prepare a cost reconciliation schedule for the month. Below the schedule, comment on what the cost reconciliation schedule tells us about the company’s costs.