Teamwork:This assignment is to be completed as a team with your group members.Textbook Readings:To complete the assignment, you should use course materials $[$Chapter $3$ for Master Schedulingconcepts, Chapter $4$ for MRP$-$ the focus of the case study, and Chapter$-11$ and $12$ for a basicunderstanding of EOQ and OP $($Order Point or Reorder Point$)$ of the textbook$]$ and any neededadditional readings$/$ research.Academic integrity policy:Follow the academic integrity policy of Cambrian College. Using the APA style, properlyacknowledge the material sources on the referencing $($last$)$ page.Length:Assignment length $($Word file$)$ should be around $4$ to $5$ pages, excluding the cover and lastpages $($for referencing$/$ bibliography$).$ Write the student names on the cover page.Weightage:Assignment weightage is $15\%$ of your total marks.Format and Guidelines:Compile your answers in a Microsoft Word file supported by a Microsoft Excel file for thecalculations.Q$1$ Guidelines: The individual issues, their corresponding symptoms and underlyingproblems should be isolated and segregated for clarity.Q$2$ Guidelines: You should calculate the planned order releases for the components Bto F using both the ROP and MRP systems for comparison, as well as performcalculations to analyze the impact of the shortfall of Es and a modified MRP to respondto the shortfall of Es$.$ Use separate sheets of the Excel File to perform the differentcalculations. Your ROP$-$based calculations should show how the system might beinefficient, as it would result in some component stock$-$outs in some periods. Yourcomparison of the reactive ROP$-$based ordering system with the proactive, forward$-$looking MRP system should demonstrate the advantages of the MRP$-$based orderingsystem.Q$3,5$ & $6$ Guidelines: Some case study questions are fairly open$-$ended, with no singlecorrect answer. You are encouraged to think creatively and provide the logic$/$ reasons foryour approach. You may make suitable assumptions if some pertinent information ismissing in the case study. Assumptions made should be mentioned in your response.Q$4$ Guidelines: When changes are confronted, like the discovery of a shortfall in the on$-$hand Es$,$ you should be able to analyze how the MRP$-$based ordering system isequipped to handle such changes and keep the priorities current. To address theproblem of short Es $($Q$4),$ dont hesitate to make the changes to the MPS $($MasterProduction Schedule$)$ of the finished item A if needed when you see that the shortfall ofcomponent E shall not allow the MPCS $($Manufacturing Planning and Control System$)$ tomeet the original delivery promises $($MPS$)$ of As$.$ Again, there could be more than oneway to address the situation, depending on some suitable assumptions you might make,or discuss the possible solutions in consultation with Marketing to get the customer'sapproval on the changes in the MPS of As$.$Some additional guidelines are given in the Assignment$-$ To Do section below.One student from the team shall submit the files $($Microsoft Word and Microsoft Excel$)$ to theassignment submission folder named "Group Assignment$-2(15\%),"$ available in the Moodlesection Assessments.Group member contribution form:The group member contribution form should be submitted along with the other assignment filesmentioned above.Due date:The due date for submission is $15-$Oct$-2023$ at $11$:$59$ PM Eastern Time. A three$-$day graceperiod is applicable, with a $10\%$ reduction in marks for each day of delay; a maximum of $3$ daysof delay attracts a $30\%$ reduction $($if submitted on $18-$Oct$-2023).$ The submission folder will closeon $18-$Oct$-2023,$ and any group$/$ student with pending submission shall receive zero marks.Assignment To DoReview the CASE STUDY $4\mathrm{.}1($Apix Polybob Company$)$ from the textbook chapter $4$ andanswer all six questions.Product tree $($BOM$)$ for Polybob model AAB C $(2$ each$)$F E $(3$ each$)$ F $(2$ each$)$ E DPolybob model A information $($dependent demand information for the components$)$Component Lot Size Inventory Lead Time ScheduledReceiptsReorderPointB $80101$ None $5$C $150401$ None $15$D $2001802$ None $50$E $400400*2$ None $70$F $500502500,$ week $180(*)-$ Your textbook copy might have a typo error for the on$-$hand inventory $($in stock$)$ forcomponent E$.$ The correct on$-$hand inventory of component E is $400.$Note: In your calculations, assume the lead time of parent A as $0.$ This means that $1$ B and $2$Cs are just packed together to create $1$ finished item A$.$Polybob model A MPS Schedule $($Based on independent market demand$)$Week $1234567891011$Qty$.5050606050$