Side Show View Did AXA - E - 11- IV S. -2.4 am Font Case 3: Toy Discovery's MRP Toy Discovery, Inc. is a relatively small company in Boston. It design, develops, and produces a variety of innovative learning toys, games, and books for early child ducation. The company was founded in 1980 by a preschool educator and, since the creation, continues to grow from the passion for helping children through play. Today, Toy Discovery is a leader in providing toys and games for early childhood education. It is also a foremost direct marketing company of its kind, because most of these toys and games are sold to the customers directly via the Internet One of the company's product lines is dedicated to two types of toy cars, the red and yellow race car (20- CAR RED) and blue retro car (20 CAR BLUE) (see pictures of the cars below). The list of finished units and parts/components used in both toys is shown in table 1 (slide 2), and bills of materials (BOM) for these toys are presented in Figures 1 and 2 (slide 3). Toy Discovery assembles car toys in its Boston Manufacturing facility (112) from several component parts: wheels, axles, and main car body. These components are outsourced from two major suppliers: Seattle Manufacturing (MI) and Dallas Manufacturing (M3) (see Table 2 in slide 4). The master demand schedule (MDS) en week 5 of ks 940 units for the red and yellow car (20-CAR-RED). and 850 units for the blue car (20 CAR-BLUE). You can answer all case questions in Excel Questions. Briefly explain what inputs you will use for the MRP in this case (see lecture materials on MRP, P-7-8). Use Excel to develop the MRP for the toys using the MDS in Week 5 and information presented in slides 24. Provide a brief explanation of the developed MRP schedules for 20-AXLE and 20-WHEEL cese, MRP2 transitions Animations Slide Show Review View Help A Ale =... 12 - BTU SAV - A - LA EST Font Paragraph Shapes Artange Quick Shape Outline Shape Elect- prins Replace Select- Eating Drawing Finished Product and Components Table 1 Component From Descripcion Characters Producer Supplier 20.CAR-RED Rod and yellow racecar Finished product Boston Manufacturing (M) 20-CAR BLUE Ble retro car Finished product Boston Manufacturing (M) 20 BODY-RED Body of the rod and yo low cari Purchased part Sonte Manufacturing (MI) 20-BODY-BLUE Body of the blue rotro car Purchased part Seattle Manufacturing (MI) 20-WHL ASSEM Wheel assembly Sub assembly Boston Manufacturing (M) 20 AXLE Car axle Purchased part Dallas Manufacturing (M) 20 WHEEL Car wheel Purchased part Dallas Manufacturing (M3) Font Paragraph Drawing Bills of Materials Figure 1 Figure 2 20-CAR-RED 20-CAR-BLUE 20-WHL-ASSEM 2 required 20-BODY-RED 1 required 20-WHL-ASSEM 2 required 20-BODY-BLUE 1 required 20-AXLE 1 required 20-WHEEL 2 required 20-AXLE 1 required 20-WHEEL 2 required EEZ12 ' ' I US AV - Aa-e-A- Shape Fill Shapes Arrange Quick Shape Outline Styles Shape Effects Drawing ONE e Find Replace Select Font Paragraph Editing Inventory Items Table 2 Lead Safety Item Item Description Characteristic Producer Supplier Tme.csstock unit 20-CAR-RED Red-and-yellowrace car Finished product Boston Minutacturing (Me) 5 30 20-CAR-BLUE Blue retro car Finished product Boston Manufacturing (Me) 5 25 20-BODY-RED Body of the red-and yelow Purchased part Seattle Manufacturing (MI 5 50 20-BODY-BLUE Body of the blue retro car Purchased part Seattle Manufacturing M 5 75 20-WHL-ASSEM Wheel assembly Sub assembly Boston Manufacturing (M) 5 130 20-AXLE Caraxle Purchased part Dallas Manutacturing MB) 10 100 20-WHEEL Car Wheel Purchased part Dallas Minutacturing (M3) 10 100 Onhand Inventory unt 50 35 100 120 210 180 Orobring Poky Lot-for-lot Lot-for-lot Lot-for-lot Lot-for-lot Loh-or-lot Lot-for-lot Lot-for-lot AutoSave OH 365_Bel_MRP_one_week july_current File Home Insert Page Layout Formulas Data Review View Arial 10 AA EE BIVE a. A 25 Wrap Text Merge & Ce Clipboard Font Alignment 1 B D E UL G Month Demand forecast Week MDS for 01-beli-4000 July 2350 Week 5 Week 6 Week 7 Week 8 Week 9 430.0 376.0 410.0 376.0 376.0 MDS for 01-bell-8000 94.0 105.0 94.0 100.0 94.0 15 38 10 20 Formatting Clipboard Font Alignment Number 5 Al B CID EF G K June July Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 50 145 430 50 145 335 335 376 376 50 50 376 376 410 4101 50 50 410 810 376 376 50 50 376 376 376 376 50 50 376 376 335 2. 301-bell-4000 (finished good, L-1 week) 4 Gross Requirements 5 Safety Stock 6 Amount on Hand T Net Requirements 8 Planned Orders 9 Planned Order Releases 10 11 01-bell-8000 (inished good, L-1 week) 12 Gross Requirements 13 Safety Stock 14 Amount on Hand 15 Net Requirements 16 Planned Orders 17 Planned Order Releases 16 19.01.assembly 4000 subassembly 1 week) 20 Gross Requirements 21 Safety Stock 22 Amount on Hand 23 Not Requirements 24 Planned Orders 25 Planned Order Releases 50 120 94 50 120 24 24 105 105) 50 50 105 105 94 94 50 50 9.4 94 100 50 50 100 100 94 50 50 94 94 24 100 50 84 335 50 84 301 201 376 376 50 50 376 376 410 50 50 410 410 376 50 50 376 370 376 50 50 376 370 301 27 01-sembly-3000 subassembly. L-1week MOS MRP July Toe here to search * Arial 10 - A A General BTU- a-A- 23 Wrap Tort Merge Center - 5 - % *# #1 Conditional Formats Formatting Table- Clipboard Font Alignment Number Al B C DE F G H June July Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 24 94 50 50 50 50 65 65 50 50 9 90 94 9 944 94 9 105 94 100 8 9888 88888a 120 2 28 Gross Requirements 29 Safety Stock 30 Amount on Hand 31 Net Requirements 32 Planned Orders 33 Planned Order Releases 31 35 OT-cpu (Supplier St. Les 36 Gross Requirements 37 Safety Stock 38 Amount on Hand 39 Net Requirements 40 Planned Orders 41 Planned Order Releases 12 43 memory supplier 12-wks) 4 Gross Requirements 45 Safety Stock 46 Amount on Hand 47 Net Requirements 4 Planned Orders 15 Planned Order Releases 170 310 120 170 260 260 504 481 120 120 481 481 476 504 120 120 504 504 470 476 120 120 476 476 470 120 120 470 470 260 481 1628 120 200 120 948 120 200 869 868 1700 1653 120 120 1653 1653 1628 1700 120 120 1700 1700 1598 1201 1628 1629 1598 120 120 1598 1598 868 1653 61 SL- MRP MRP July Type here to search . Arial 05 General Paste 10 - AA za O-A- A 13 BIU- 29 Wrap Text Merge & Center $ - % * 8-98 Conditional Formatting Clipboard Font Alignment Number A1 B D E F G H June July Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 638 1172 1196 1152 1128 1001 100 100 100 100 100 130 130 100 100 100 100 608 1172 1196 1152 1128 608 1172 1196 1152 1128 608 1172 1196 1152 1128 1 2 52 Gross Requirements 53 Safety Stock 54 Amount on Hand 55 Net Requirements 56 Planned Orders 67 Planned Order Releases 58 59 01.kboard Supplier M3, L-fweek) 60 Gross Requirements 61 Safety Stock 62 Amount on Hand 63 Net Requirements 64 Planned Orders 65 Planned Order Releases 66 67 Suontier ML wwel 68 Gross Requirements 59 Safety Stock 70 Amount on Hand 71 Net Requirements 12 Planned Orders 13 Planned Order Releases 100 112 470 100 310 100 112 298 298 481 481 100 100 481 481 504 504 100 100 504 504 476 476 100 100 476 476 470 100 470 470 298 476 120 140 120 3101 120 140 290 290 481 481 120 120 481 481 604 504 120 120 504 504 476 470 120 120 470 120 476 476 470 470 790 TG Rulmans 310 181 504 AT 470 MRP July 5 A Merge & Center $ - %) *88-28 Clipboard Font Conditio Formattir Alignment AL Number B CIDE F G June July Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 120 120 120 120 120 120 150 150 120 120 120 120 280 481 504 476 470 280 481 504 470 280 481 504 476 470 476 2 77 Safety Stock 78 Amount on Hand 79 Net Requirements BO Planned Orders 81 Planned Order Releases B2 83 01-Case (Supplier M3 L 1week! B4 Gross Requirements 85 Safety Stock 85 Amount on Hand 87 Net Requirements B8 Planned Orders 89 Planned Order Releases 90 910cd Supplier MILIweek 92 Gross Requirements 93 Safety Stock 34 Amount on Hand 95 Net Requirements 96 Planned Orders 97 Planned Order Releases 120 180 310 120 180 250 250 481 481 120 120 481 481 504 504 120 120 504 504 676 476 120 120 476 476 470 470 120 120 470 470 250 100 135 359 100 135 324 470) 100 481 100 100 481 481 504 504 100 100 504 5014 476 476 100 100 476 476 870 100 324 470 470 324 481 100 Gross Requirements i Sant Stock 718 100 962 TOO 1000 952 no 540 TO ton MRP foly 16 General BIU 2 Wrap Text A - A. Merge & Center Alignment $ - % -3 Clipboard Condition Formatting Font 15 Number A1 B C D G H K June July Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 120 120 100 100 100 100 698 962 1008 952 940 698 962 1008 952 940 698 962 1008 952 940 1 2 102 Amount on Hand 103 Net Requirements 104 Planned Orders 105 Planned Order Releases 106 107 OT-led Supplier M1, L-1 week) 108 Gross Requirements 109 Safety Stock 110 Amount on Hand 111 Net Requirements 112 Planned Orders 113 Planned Order Releases 114 115 01- adows Supplier SIL2weeks 116 Gross Requirements 117 Safety Stock 110 Amount on Hand 319 Net Requirements 120 Planned Orders 221 Planned Order Releases 100 110 359 100 110 349 349 481 481 100 100 481 481 504 504 100 100 504 504 476 476 100 100 476 476 470 470 100 100 470 470 349 100 120 359 100 120 339 339 504 481 100 100 481 504 100 100 504 504 470 475 100 100 476 270 470 100 100 470 470 339 481 476 524 Gtos Requirements 125 Safety Stock 470 100 1751 MRO 359 100 125 481 100 th SOM 100 100 476 100 100 MOS Chipboard To Font Foming Alignment AI B D G June July Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week Week 481 100 120 2 114 115 01 windows (Supplier SI, L-wooks) 116 Gross Requirements 117 Safety Stock 118 Amount on Hand 119 Net Requirements 120 Planned Orders 121 Planned Order Releases 122 12301-Supplier week) 124 Gros Requirements 125 Safety Stock 126 Amount on Hand 127 Net Requirements 126 Planned Orders 129 Planned Order Releases 130 359 100 120 139 119 504 100 100 401 481 176 504 100 100 504 504 470 476 100 100 476 476 470 100 100 470 470 319 131 100 125 476 100 359 100 125 334 334 sod 481 100 100 481 481 504 100 100 504 604 270 100 470 100 100 470 470 476 176 114 481 178 137 Grous Requirements 130 Salety Stock 134 Amount on Hand 135 Net Requirements Planned Order 199 100 100 115 115 181 100 100 401 401 176 504 100 100 504 so 476 100 100 474 4/8 470 100 100 470 344 944 S02 470 MR Buy Side Show View Did AXA - E - 11- IV S. -2.4 am Font Case 3: Toy Discovery's MRP Toy Discovery, Inc. is a relatively small company in Boston. It design, develops, and produces a variety of innovative learning toys, games, and books for early child ducation. The company was founded in 1980 by a preschool educator and, since the creation, continues to grow from the passion for helping children through play. Today, Toy Discovery is a leader in providing toys and games for early childhood education. It is also a foremost direct marketing company of its kind, because most of these toys and games are sold to the customers directly via the Internet One of the company's product lines is dedicated to two types of toy cars, the red and yellow race car (20- CAR RED) and blue retro car (20 CAR BLUE) (see pictures of the cars below). The list of finished units and parts/components used in both toys is shown in table 1 (slide 2), and bills of materials (BOM) for these toys are presented in Figures 1 and 2 (slide 3). Toy Discovery assembles car toys in its Boston Manufacturing facility (112) from several component parts: wheels, axles, and main car body. These components are outsourced from two major suppliers: Seattle Manufacturing (MI) and Dallas Manufacturing (M3) (see Table 2 in slide 4). The master demand schedule (MDS) en week 5 of ks 940 units for the red and yellow car (20-CAR-RED). and 850 units for the blue car (20 CAR-BLUE). You can answer all case questions in Excel Questions. Briefly explain what inputs you will use for the MRP in this case (see lecture materials on MRP, P-7-8). Use Excel to develop the MRP for the toys using the MDS in Week 5 and information presented in slides 24. Provide a brief explanation of the developed MRP schedules for 20-AXLE and 20-WHEEL cese, MRP2 transitions Animations Slide Show Review View Help A Ale =... 12 - BTU SAV - A - LA EST Font Paragraph Shapes Artange Quick Shape Outline Shape Elect- prins Replace Select- Eating Drawing Finished Product and Components Table 1 Component From Descripcion Characters Producer Supplier 20.CAR-RED Rod and yellow racecar Finished product Boston Manufacturing (M) 20-CAR BLUE Ble retro car Finished product Boston Manufacturing (M) 20 BODY-RED Body of the rod and yo low cari Purchased part Sonte Manufacturing (MI) 20-BODY-BLUE Body of the blue rotro car Purchased part Seattle Manufacturing (MI) 20-WHL ASSEM Wheel assembly Sub assembly Boston Manufacturing (M) 20 AXLE Car axle Purchased part Dallas Manufacturing (M) 20 WHEEL Car wheel Purchased part Dallas Manufacturing (M3) Font Paragraph Drawing Bills of Materials Figure 1 Figure 2 20-CAR-RED 20-CAR-BLUE 20-WHL-ASSEM 2 required 20-BODY-RED 1 required 20-WHL-ASSEM 2 required 20-BODY-BLUE 1 required 20-AXLE 1 required 20-WHEEL 2 required 20-AXLE 1 required 20-WHEEL 2 required EEZ12 ' ' I US AV - Aa-e-A- Shape Fill Shapes Arrange Quick Shape Outline Styles Shape Effects Drawing ONE e Find Replace Select Font Paragraph Editing Inventory Items Table 2 Lead Safety Item Item Description Characteristic Producer Supplier Tme.csstock unit 20-CAR-RED Red-and-yellowrace car Finished product Boston Minutacturing (Me) 5 30 20-CAR-BLUE Blue retro car Finished product Boston Manufacturing (Me) 5 25 20-BODY-RED Body of the red-and yelow Purchased part Seattle Manufacturing (MI 5 50 20-BODY-BLUE Body of the blue retro car Purchased part Seattle Manufacturing M 5 75 20-WHL-ASSEM Wheel assembly Sub assembly Boston Manufacturing (M) 5 130 20-AXLE Caraxle Purchased part Dallas Manutacturing MB) 10 100 20-WHEEL Car Wheel Purchased part Dallas Minutacturing (M3) 10 100 Onhand Inventory unt 50 35 100 120 210 180 Orobring Poky Lot-for-lot Lot-for-lot Lot-for-lot Lot-for-lot Loh-or-lot Lot-for-lot Lot-for-lot AutoSave OH 365_Bel_MRP_one_week july_current File Home Insert Page Layout Formulas Data Review View Arial 10 AA EE BIVE a. A 25 Wrap Text Merge & Ce Clipboard Font Alignment 1 B D E UL G Month Demand forecast Week MDS for 01-beli-4000 July 2350 Week 5 Week 6 Week 7 Week 8 Week 9 430.0 376.0 410.0 376.0 376.0 MDS for 01-bell-8000 94.0 105.0 94.0 100.0 94.0 15 38 10 20 Formatting Clipboard Font Alignment Number 5 Al B CID EF G K June July Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 50 145 430 50 145 335 335 376 376 50 50 376 376 410 4101 50 50 410 810 376 376 50 50 376 376 376 376 50 50 376 376 335 2. 301-bell-4000 (finished good, L-1 week) 4 Gross Requirements 5 Safety Stock 6 Amount on Hand T Net Requirements 8 Planned Orders 9 Planned Order Releases 10 11 01-bell-8000 (inished good, L-1 week) 12 Gross Requirements 13 Safety Stock 14 Amount on Hand 15 Net Requirements 16 Planned Orders 17 Planned Order Releases 16 19.01.assembly 4000 subassembly 1 week) 20 Gross Requirements 21 Safety Stock 22 Amount on Hand 23 Not Requirements 24 Planned Orders 25 Planned Order Releases 50 120 94 50 120 24 24 105 105) 50 50 105 105 94 94 50 50 9.4 94 100 50 50 100 100 94 50 50 94 94 24 100 50 84 335 50 84 301 201 376 376 50 50 376 376 410 50 50 410 410 376 50 50 376 370 376 50 50 376 370 301 27 01-sembly-3000 subassembly. L-1week MOS MRP July Toe here to search * Arial 10 - A A General BTU- a-A- 23 Wrap Tort Merge Center - 5 - % *# #1 Conditional Formats Formatting Table- Clipboard Font Alignment Number Al B C DE F G H June July Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 24 94 50 50 50 50 65 65 50 50 9 90 94 9 944 94 9 105 94 100 8 9888 88888a 120 2 28 Gross Requirements 29 Safety Stock 30 Amount on Hand 31 Net Requirements 32 Planned Orders 33 Planned Order Releases 31 35 OT-cpu (Supplier St. Les 36 Gross Requirements 37 Safety Stock 38 Amount on Hand 39 Net Requirements 40 Planned Orders 41 Planned Order Releases 12 43 memory supplier 12-wks) 4 Gross Requirements 45 Safety Stock 46 Amount on Hand 47 Net Requirements 4 Planned Orders 15 Planned Order Releases 170 310 120 170 260 260 504 481 120 120 481 481 476 504 120 120 504 504 470 476 120 120 476 476 470 120 120 470 470 260 481 1628 120 200 120 948 120 200 869 868 1700 1653 120 120 1653 1653 1628 1700 120 120 1700 1700 1598 1201 1628 1629 1598 120 120 1598 1598 868 1653 61 SL- MRP MRP July Type here to search . Arial 05 General Paste 10 - AA za O-A- A 13 BIU- 29 Wrap Text Merge & Center $ - % * 8-98 Conditional Formatting Clipboard Font Alignment Number A1 B D E F G H June July Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 638 1172 1196 1152 1128 1001 100 100 100 100 100 130 130 100 100 100 100 608 1172 1196 1152 1128 608 1172 1196 1152 1128 608 1172 1196 1152 1128 1 2 52 Gross Requirements 53 Safety Stock 54 Amount on Hand 55 Net Requirements 56 Planned Orders 67 Planned Order Releases 58 59 01.kboard Supplier M3, L-fweek) 60 Gross Requirements 61 Safety Stock 62 Amount on Hand 63 Net Requirements 64 Planned Orders 65 Planned Order Releases 66 67 Suontier ML wwel 68 Gross Requirements 59 Safety Stock 70 Amount on Hand 71 Net Requirements 12 Planned Orders 13 Planned Order Releases 100 112 470 100 310 100 112 298 298 481 481 100 100 481 481 504 504 100 100 504 504 476 476 100 100 476 476 470 100 470 470 298 476 120 140 120 3101 120 140 290 290 481 481 120 120 481 481 604 504 120 120 504 504 476 470 120 120 470 120 476 476 470 470 790 TG Rulmans 310 181 504 AT 470 MRP July 5 A Merge & Center $ - %) *88-28 Clipboard Font Conditio Formattir Alignment AL Number B CIDE F G June July Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 120 120 120 120 120 120 150 150 120 120 120 120 280 481 504 476 470 280 481 504 470 280 481 504 476 470 476 2 77 Safety Stock 78 Amount on Hand 79 Net Requirements BO Planned Orders 81 Planned Order Releases B2 83 01-Case (Supplier M3 L 1week! B4 Gross Requirements 85 Safety Stock 85 Amount on Hand 87 Net Requirements B8 Planned Orders 89 Planned Order Releases 90 910cd Supplier MILIweek 92 Gross Requirements 93 Safety Stock 34 Amount on Hand 95 Net Requirements 96 Planned Orders 97 Planned Order Releases 120 180 310 120 180 250 250 481 481 120 120 481 481 504 504 120 120 504 504 676 476 120 120 476 476 470 470 120 120 470 470 250 100 135 359 100 135 324 470) 100 481 100 100 481 481 504 504 100 100 504 5014 476 476 100 100 476 476 870 100 324 470 470 324 481 100 Gross Requirements i Sant Stock 718 100 962 TOO 1000 952 no 540 TO ton MRP foly 16 General BIU 2 Wrap Text A - A. Merge & Center Alignment $ - % -3 Clipboard Condition Formatting Font 15 Number A1 B C D G H K June July Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 120 120 100 100 100 100 698 962 1008 952 940 698 962 1008 952 940 698 962 1008 952 940 1 2 102 Amount on Hand 103 Net Requirements 104 Planned Orders 105 Planned Order Releases 106 107 OT-led Supplier M1, L-1 week) 108 Gross Requirements 109 Safety Stock 110 Amount on Hand 111 Net Requirements 112 Planned Orders 113 Planned Order Releases 114 115 01- adows Supplier SIL2weeks 116 Gross Requirements 117 Safety Stock 110 Amount on Hand 319 Net Requirements 120 Planned Orders 221 Planned Order Releases 100 110 359 100 110 349 349 481 481 100 100 481 481 504 504 100 100 504 504 476 476 100 100 476 476 470 470 100 100 470 470 349 100 120 359 100 120 339 339 504 481 100 100 481 504 100 100 504 504 470 475 100 100 476 270 470 100 100 470 470 339 481 476 524 Gtos Requirements 125 Safety Stock 470 100 1751 MRO 359 100 125 481 100 th SOM 100 100 476 100 100 MOS Chipboard To Font Foming Alignment AI B D G June July Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week Week 481 100 120 2 114 115 01 windows (Supplier SI, L-wooks) 116 Gross Requirements 117 Safety Stock 118 Amount on Hand 119 Net Requirements 120 Planned Orders 121 Planned Order Releases 122 12301-Supplier week) 124 Gros Requirements 125 Safety Stock 126 Amount on Hand 127 Net Requirements 126 Planned Orders 129 Planned Order Releases 130 359 100 120 139 119 504 100 100 401 481 176 504 100 100 504 504 470 476 100 100 476 476 470 100 100 470 470 319 131 100 125 476 100 359 100 125 334 334 sod 481 100 100 481 481 504 100 100 504 604 270 100 470 100 100 470 470 476 176 114 481 178 137 Grous Requirements 130 Salety Stock 134 Amount on Hand 135 Net Requirements Planned Order 199 100 100 115 115 181 100 100 401 401 176 504 100 100 504 so 476 100 100 474 4/8 470 100 100 470 344 944 S02 470 MR Buy