create materials requirement plan using information below
Control Sheet Chase Level Mix MPS MRP Aggregate Demand Quarter Casual Athletic Running Total 9900 9910 10367 360 1076 10006 1034 31010 11568 11420 11147 12446 14615 14509 41570 16915 18734 16731 5210 18126 20469 19515 58110 1126 14478 14274 20020 10600 13945 14710 39145 Description Maximum regular hours per worker per quarter Maximam overtime hours per worker per quarter Maximum Tumber of workers Starting workforce Hiring cost per worker Firing cost per worker Regular time wape Overtime way Subcontract Cost Hack Order cost Hilding cost per pair of shoes per quarter Ending InventyPerindo Value 40 100 90 75 1900 1200 18 27 60 20 Werk Forecast Orders 1 751 70 Casual Shoe Forecast and Customer Orders 2 3 4 $ 6 862 71690 721 541 107 185 92 40 7 877 0 854 2200 1 Werk Forecast Onders Atletic Shoe Forest and Cestemer Orders 2 6 1167 449 1042 361 175 7 900 1148 50 Axrvgate Planning 1 Work Forecast Onders Running Show Forecast and Customer Orders 3 6 971345 395 578 7 403 0 LEX 775 0 Mini Regimento Running Current Inventory Order Policy Le Time Finished and tastery Recente Athletic 2658 2496 100 1200 F001500 1 Week 2 Weeks F00-1500 2 Weeks MPS MRP Component Box Unlaced Shoes Tissue Laces Shoe Body Assembly Rubber Sole Tongue Insole Lining Shoe Body Kit Eyelet Padding Label Outer Body Kit Inner Body Kit Heal Stripe Logo Stitching Semi-Finished Goods and Raw Material Inventory Records Unit of Measure Current Inventory Order Policy Lead Time Scheduled Receipts EACH 2585 FOQ = 2500 2 Weeks None PAIR 297 L4L 1 Week 524 in Week 1 SHEET 1773 FOQ - 2000 1 Week None EACH 513 FOQ-2500 1 Week None PAIR 409 L4L 1 Week 235 in Week 2 PAIR 0 L4L 2 Weeks 500 in Week2 EACH 184 L4L 1 Week None PAIR 2193 FOQ - 1000 2 Weeks None EACH 0 2 Weeks 1870 in Week 2 PAIR 194 L4L 1 Week None EACH 7840 FOQ = 20,000 2 Weeks 20,000 in Week 1 EACH 818 L4L, Min - 1200 1 Week None EACH 2157 FOQ = 2000 3 Weeks 2000 in Week 1 PAIR 1156 L4L 1 Week 1914 in Week 1 PAIR 1172 L4L 1 Week 1914 in Week 1 EACH 1191 L4L 1 Week 1914 in Week 1 EACH 8613 FOQ = 5000 3 Weeks None INCH 12250 FOQ - 20000 1 Week None LAL Master Production Schedule The production department in Sneakernet wants to plan out the next eight weeks for each line of shoe. They have received customer orders and have constructed forecasts to anticipate the demand by shoe line. Construct a master production schedule for each shoe line. Batch sizes for each shoe line will be given in the spreadsheet. Materials Requirements Planning Now that the MPS has been generated for the casual shoe line, MRP needs to be run to determine how many of each shoe component is needed and when they are needed. Complete MRP for the casual shoe using the Bill of Material, Component Inventory Records and the casual shoe MPS. The inventory records are provided in the spreadsheet. Bat Material: Carlos Lot 1 Lad 2 Local 3 Sa Love 4 Control Sheet Chase Level Mix MPS MRP Period 2 4 $ . 7 Master Production Schedule Pensed 2 Bes Gross Requirements Scheduled Receipts Fred Hand Net Requirement Planned Order Recipes Planned-Order Releases Unlaced Shoes Gross Requirements Scheduled receipts Projected on Hand Nei Requirements Planned Order Recipes Planned-Order Releases Gross Requirements Scheduled Receipts Projected on Hand Net Requirements Planned-Order Recipe Planned-Order Releases Laces Gross Requirements Scheduled Receipts thejected on and Net Requirements Panned Order Receipts Planned-Order Releases Shoe Body Ambly Gross Requirements Scheduled Receipts Projected on Hand Net Requirements Planned-Order Recipe Planned-Order Release Rubber Sale Gruss Requirements Scheduled Receipts Projected on Hand Net Requirement Planned Order Recipes Planned der Releases Tonger Gross Requirements Scheduled Receipts herected on Hand Net Requirements Hanned Order Recept Planned-Order Release lasele Cross Requirements Scheduled Recipes Projected on Hand Net Requirements Planned-Order Receipts Panned Order Releases Lining Cross Required Scheid Recipes Projected on Net Requirements Peder Recept Paned Onder Releases Shoe Body Gros Requirements Scheeper Projected cold Na Rangement Planned andere Planneder Eyelet Cleons Requirements Projected on Hed Nell Requireme Planned der Recipes Planned-Cyder Releases Padding Grow Repairement Sides led-Order Recipes Fanned Ander kleines Label Gross Requirement Scheduled Recipe Projected and Net premier Planned der Receipts Planned Onder Releases Outur Body KH Crown Requirements Projected and Net Requiremcom Plan de |Fran Paneder RS fener Bedy Kit Cross Requirements Projected on fland Nel premte Plannender keep Planeed Onder Heal Stripe Requirement Scheid Recipes Projecte en Hed Net Raurement Plannedder Recep Planned Order Rele Logo Gross Repair Prinde Hand Nel Requirements Planned der Recipes Planned ander Related Stichting Groun Requirement Pred Hand Not Rece Pannender Recept 15 Paragraph Styles 12 Editing Bill of Material: Casual Shoes Pair of Level o Box TE Unice Shoes Lace 21 Level 1 Shoe Asembly Rubber Sole Tongue (2) Insole Level 2 21 Shoe Body Eyelet 24 Padding (21 Level 3 Maching mwy na be Outer Body Kit wer Body Heal Stripe LOPP141 Level 4 Control Sheet Chase Level Mix MPS MRP Aggregate Demand Quarter Casual Athletic Running Total 9900 9910 10367 360 1076 10006 1034 31010 11568 11420 11147 12446 14615 14509 41570 16915 18734 16731 5210 18126 20469 19515 58110 1126 14478 14274 20020 10600 13945 14710 39145 Description Maximum regular hours per worker per quarter Maximam overtime hours per worker per quarter Maximum Tumber of workers Starting workforce Hiring cost per worker Firing cost per worker Regular time wape Overtime way Subcontract Cost Hack Order cost Hilding cost per pair of shoes per quarter Ending InventyPerindo Value 40 100 90 75 1900 1200 18 27 60 20 Werk Forecast Orders 1 751 70 Casual Shoe Forecast and Customer Orders 2 3 4 $ 6 862 71690 721 541 107 185 92 40 7 877 0 854 2200 1 Werk Forecast Onders Atletic Shoe Forest and Cestemer Orders 2 6 1167 449 1042 361 175 7 900 1148 50 Axrvgate Planning 1 Work Forecast Onders Running Show Forecast and Customer Orders 3 6 971345 395 578 7 403 0 LEX 775 0 Mini Regimento Running Current Inventory Order Policy Le Time Finished and tastery Recente Athletic 2658 2496 100 1200 F001500 1 Week 2 Weeks F00-1500 2 Weeks MPS MRP Component Box Unlaced Shoes Tissue Laces Shoe Body Assembly Rubber Sole Tongue Insole Lining Shoe Body Kit Eyelet Padding Label Outer Body Kit Inner Body Kit Heal Stripe Logo Stitching Semi-Finished Goods and Raw Material Inventory Records Unit of Measure Current Inventory Order Policy Lead Time Scheduled Receipts EACH 2585 FOQ = 2500 2 Weeks None PAIR 297 L4L 1 Week 524 in Week 1 SHEET 1773 FOQ - 2000 1 Week None EACH 513 FOQ-2500 1 Week None PAIR 409 L4L 1 Week 235 in Week 2 PAIR 0 L4L 2 Weeks 500 in Week2 EACH 184 L4L 1 Week None PAIR 2193 FOQ - 1000 2 Weeks None EACH 0 2 Weeks 1870 in Week 2 PAIR 194 L4L 1 Week None EACH 7840 FOQ = 20,000 2 Weeks 20,000 in Week 1 EACH 818 L4L, Min - 1200 1 Week None EACH 2157 FOQ = 2000 3 Weeks 2000 in Week 1 PAIR 1156 L4L 1 Week 1914 in Week 1 PAIR 1172 L4L 1 Week 1914 in Week 1 EACH 1191 L4L 1 Week 1914 in Week 1 EACH 8613 FOQ = 5000 3 Weeks None INCH 12250 FOQ - 20000 1 Week None LAL Master Production Schedule The production department in Sneakernet wants to plan out the next eight weeks for each line of shoe. They have received customer orders and have constructed forecasts to anticipate the demand by shoe line. Construct a master production schedule for each shoe line. Batch sizes for each shoe line will be given in the spreadsheet. Materials Requirements Planning Now that the MPS has been generated for the casual shoe line, MRP needs to be run to determine how many of each shoe component is needed and when they are needed. Complete MRP for the casual shoe using the Bill of Material, Component Inventory Records and the casual shoe MPS. The inventory records are provided in the spreadsheet. Bat Material: Carlos Lot 1 Lad 2 Local 3 Sa Love 4 Control Sheet Chase Level Mix MPS MRP Period 2 4 $ . 7 Master Production Schedule Pensed 2 Bes Gross Requirements Scheduled Receipts Fred Hand Net Requirement Planned Order Recipes Planned-Order Releases Unlaced Shoes Gross Requirements Scheduled receipts Projected on Hand Nei Requirements Planned Order Recipes Planned-Order Releases Gross Requirements Scheduled Receipts Projected on Hand Net Requirements Planned-Order Recipe Planned-Order Releases Laces Gross Requirements Scheduled Receipts thejected on and Net Requirements Panned Order Receipts Planned-Order Releases Shoe Body Ambly Gross Requirements Scheduled Receipts Projected on Hand Net Requirements Planned-Order Recipe Planned-Order Release Rubber Sale Gruss Requirements Scheduled Receipts Projected on Hand Net Requirement Planned Order Recipes Planned der Releases Tonger Gross Requirements Scheduled Receipts herected on Hand Net Requirements Hanned Order Recept Planned-Order Release lasele Cross Requirements Scheduled Recipes Projected on Hand Net Requirements Planned-Order Receipts Panned Order Releases Lining Cross Required Scheid Recipes Projected on Net Requirements Peder Recept Paned Onder Releases Shoe Body Gros Requirements Scheeper Projected cold Na Rangement Planned andere Planneder Eyelet Cleons Requirements Projected on Hed Nell Requireme Planned der Recipes Planned-Cyder Releases Padding Grow Repairement Sides led-Order Recipes Fanned Ander kleines Label Gross Requirement Scheduled Recipe Projected and Net premier Planned der Receipts Planned Onder Releases Outur Body KH Crown Requirements Projected and Net Requiremcom Plan de |Fran Paneder RS fener Bedy Kit Cross Requirements Projected on fland Nel premte Plannender keep Planeed Onder Heal Stripe Requirement Scheid Recipes Projecte en Hed Net Raurement Plannedder Recep Planned Order Rele Logo Gross Repair Prinde Hand Nel Requirements Planned der Recipes Planned ander Related Stichting Groun Requirement Pred Hand Not Rece Pannender Recept 15 Paragraph Styles 12 Editing Bill of Material: Casual Shoes Pair of Level o Box TE Unice Shoes Lace 21 Level 1 Shoe Asembly Rubber Sole Tongue (2) Insole Level 2 21 Shoe Body Eyelet 24 Padding (21 Level 3 Maching mwy na be Outer Body Kit wer Body Heal Stripe LOPP141 Level 4
