SCM 4240: Group Assignment 1, Part 1This assignment is to be submitted online via the Canvas system by the due date and time listed on the syllabus. Two files are to be submitted online. One file should be an Excel workbook containing all relevant and completed Excel spreadsheet(s)(with relevant cells highlighted) associated with the assignment. The second file should be an appropriately formatted PDF document containing all the relevant answers to questions 1 to 5, including charts associated with the assignment, and references to highlighted cells in the Excel spreadsheet. All charts should be formatted to look professiongl. Points may be deducted for formatting related issues. Only one student from each group should submit all the files.Stonehaven, Inc. Case Analysis QuestionsPart ADownload the Excel template for the Stonehaven case from the class website. Fill in the Excel spreadsheet with the appropriate data and formulas to compute the required information. Assume that the same batch size is used in each portion of the Stonehaven factory, and that the kitting time is proportional to the batch size. For this part of the analysis, consider each department in the Gdansk factory "in isolation" - that is, when doing the calculations, imagine for the moment that the rest of the production system has no impact on the department you are considering. For the purposes of these calculations, assume material handling times are negligible. For both questions 1 and 2, reference the cells in the accompanying Excel spreadsheet which contain numbers/calculations in support of your answer. For all of the questions, USE the following data for the cutting, stitching, and lasting departments. All other data are in the original Case.\table[[Cutting,\table[[Die Change Time],[(minutes/die change)]],\table[[Stamp (Run) Time],[(minutes/piece)]]],[Machine 1- Cut shoe leather,5.75,0.07],[Machine 2- Cut linings,5.25,0.05],[Machine 3- Cut insole,4.5,0.09]]\table[[Stitching,\table[[Run Time/Pair],[(minutes)]],Number of Workers],[Work Group 1- Prefit,4.00,3],[Work Group 2- Join,2.00,3],[Work Group 3- Ornament,5.00,4]]\table[[Lasting,\table[[Run Time/Pair],[(minutes)]],],[Station 1- Staple insole,0.85,],[Station 2- Toe and heel seat lasts,0.7,],[Station 3- Rough sole, pound,1.10,],[Station 4- Cement sole, pull last,0.60,],[Station 5- Inspect, pack,0.70,]]For the typical 100-pair batch, what is the daily capacity (in batches and in pairs of shoes), the batch cycle time, and the average manufacturing throughput time per batch (in minutes) within each of the following departments?A. CuttingB. Stitching (Hint: Use Little's Law)C. LastingIf the batch size were reduced to 10 pairs, what would be the daily capacity (in batches and in pairs of shoes), the batch cycle time, and the average manufacturing throughput time per batch (in minutes) within each of the following departments?A. CuttingB. Stitching (Hint: Use Little's Law)C. LastingPart BNow consider the factory as a system, and take into account interactions between the departments. For both questions 3 and 4, in addition to your explanations, reference the cells in the accompanying Excel spreadsheet which contain numbers/calculations in support of your answer.3. If production is done in 100-pair batches, what is the factory's daily capacity? If the batch size is reduced to 10 pairs, what would be the factory's daily capacity? Explain how you arrived at your conclusion. Note: The steaming oven is not a constraint since the case says that it has excess capacity.4. Compute the theoretical manufacturing throughput time for a 100-pair batch, the actual average manufacturing throughput time for a 100-pair batch (Hint: Use Little's Law), and the throughput time efficiency for a 100-pair batch. What does the calculated throughput time efficiency say about the performance of the factory? Do not include raw material and finished goods in your calculations.Part C5. Construct two separate graphs in Excel using the scatter chart with a connected line. The first graph should show the relationship between the actual average manufacturing throughput time per batch through the factory (in minutes) and the batch size used (ranging from 5 pairs/batch to 100 pairs/batch in increments of 5 pairs/batch). The second graph should show the relationship between the batch size (ranging from 5 pairs/batch to 100 pairs/batch in increments of 5 pairs/batch) and the overall capacity of the factory (in pairs/day). Do not include the amount of time a batch spends in raw material and finished goods in your throughput time graph.Explain what the graphs illustrate about capacity and lead time at Stonehaven. In addition, explain why the relationships shown in the two graphs occur.6. Specify at least three changes in the process you recommend in order to improve the performance of Stonehaven's Gdansk factory. In doing so:2i) Identify the most relevant performance measures that need