MECH 3582 Project 3_MRP-1

MECH3582 (Project 3, duration: 2 weeks)
MRP and LP solver
Part 1
Using material requirements planning (MRP) manages production of the motor drive assembly. Using MS Excel solver for the optimization of aggregate production plan
1. Introduction
Material Requirements Planning (MRP) manages production planning and inventory for manufacturing. An MRP system can be used to ensure the availability of materials and products for production and customers, to maintain the lowest possible level of inventory, and to plan manufacturing activities, delivery schedules and purchasing activities.
2. Lab assignments
Week 10 (Oct 28):
- Using the product structure and bill of materials (BOM) of the motor drive assembly used in Project 1, including motor drive assembly, subassembly, and components.
The subassembly includes pneumatic shifting mechanism in TKF02M16A_ASM2, transmission in
TKF02M16A_ASM3,
dual motor assembly in TKF02M16A_ASM4, and output shaft in TKF02M16A_ASM1.
- It is assumed that the motor drive assembly will be delivered to the customer for weeks 9, 10, 11, 13, and 14, the corresponding units are 10, 20, 15, 20 and 25, respectively. The on-hand inventory, the scheduled receipts and the lead time for each item are shown in the following table.
- Develop the MRP order release plan for final assembly, four subassemblies and six components 27, 112, 119, 1, 4, and 120.
Items
Motor drive assembly

Lead time
(week)
3

On hand inventory
(unit)
20

Scheduled receipts (unit) no All 4 subassemblies

2

10

15 at week 2, 3

All components

1

20

20 at week 2

-

You may use the following format:
Motor drive: lead time 3 weeks
1
Gross requirement on-hand inventory
(20)
scheduled receipts net requirements planned order release subassembly: lead time 2

1

2

3

4

5

6

7

8

9
10

10
20

11
15

12

13
20

14
25

2

3

4

5

6

7

8

9

10

11

12

13

14

1

weeks
Gross requirement on-hand inventory
(10)
scheduled receipts
15
net requirements planned order release

Component: lead time 1 weeks
1
Gross requirement on-hand inventory (20) scheduled receipts net requirements planned order release

15

2

3

4

5

6

7

8

9

10

11

12

13

14

20

3. Outcomes to hand in
Assignment No

Type

Mark

Description

A6

Report

3

MRP

4. Report Contents
A6 Week 10 (Due: Nov. 4):
1. The product structure and BOM.
2. MRP results for the assembly, 4 subassemblies, and 6 given components.
3. If an item is required in two subassemblies of a product, discuss how to make MRP plan for such common-use items.
4. What is the objectives of integrated manufacturing planning and control systems?
5. Discuss major elements of a manufacturing planning and control system (MPCS).

2