I need an expert in OM to do this MRP assignment
BIS 312 - Excel, MRP
Forecasted demand for cabinets:
Week 4: 100 Week 7:100 Week 10: 100
| Item |
Beginning Inventory |
Scheduled Receipts |
Lot Size Rule |
LT |
| CD Cabinet |
0 |
None |
L4L |
1 |
| Cabinet Top |
120 |
None |
FOQ= 144 |
3 |
| Cabinet Bottom |
20 |
Week 3- 144 |
FOQ = 144 |
3 |
| Cabinet Door |
120 |
Week 3- 216 |
FOQ= 216 |
3 |
| Cabinet Sides |
0 |
Week 3- 216 |
FOQ=216 |
3 |
| Cabinet Shelves |
0 |
None |
L4L |
2 |
| Shelf Supports |
0 |
None |
FOQ=2500 |
1 |
| Door Magnet |
12 |
None |
FOQ= 250 |
2 |
| Door Hinge |
0 |
Week 3- 932 |
FOQ=932 |
4 |
| Door Handle |
50 |
Week 3- 200 |
FOQ=200 |
3 |
| Door Screws |
500 |
None |
FOQ=2000 |
1 |
| Door Catch |
0 |
None |
FOQ=252 |
1 |
| Feet |
0 |
Week 3- 576 |
L4L |
4 |
Using the MRP Forms I posted, create the MRP tables for all parts of the CD cabinet for a 12 week planning period.
Note: You need to adjust the forms to work with this assignment by adding the required information
Attachment:- Template.xlsx