Question

There are two (2) Parts to this case.

 

The First part (Part 1) requires you to use the information to:

1.    Build a Bill of Material (BOM) form the given information

2.    Determine the Master Production Schedule (MPS) and

3.    Complete the MRP for all parts including the product.

 

 

 

The Second Part (Part 2) will require you to use an indexed BOM to

1.    Create the correct MPS from the provided information

2.    create the MRP for the unit and all of its assemblies/components

 

 

Product XYZ is described as follows: Quantity of each assembly/component is in (brackets)

 

XYZ are made up of assemblies A(3), B, & C(2)

 

Assembly A contains D(2), E(2), & F(3)

 

Assembly B contains part H(2)

 

Assembly C contains parts G(2) & E(2)

 

Inventory Lead- time and Lot Size Information:

 

	XYZ	A	B	C	D	E	F	G	H
Lead Time	1	2	1	1	1	2	2	2	2
Projected On Hand	93	125	32	92	520	391	600	125	68
Lot Size	LFL	LFL	20	10	LFL	100	200	100	50
Scheduled Receipts	50	0	0	0	0	0	0	100	0
Safety Stock			10			50		25

 

**Note** all scheduled receipts are in week 1

 

1. Create a product structure tree (Multilevel BOM):       (5 marks)

 

Using Blank MRP sheets,

 

2. Create a level loaded (discreet, with no remnants) plan      for XYZ’s based on a MPS of 40 per week (plan must be a minimum of 8      weeks).level 0 MPS  (2 marks)

3. Create and complete an MRP plan for each item in the product tree. (18 marks)

 

 

Bruce’s Fans has just released an order for 500 50-cm fans due week 5 and 800 50-cm fans due week 7. Each fan consists of a housing assembly, 2 grills, a fan assembly, and an electrical unit. The breakdown of the assemblies and components is shown below. Quantities are numbers within (x). Using the information from the following table and the blank MRP sheets, construct the MRP Plan for the 50-cm Fan

Component	Lead   Time	On hand   Inventory	Lot Size	Safety   Stock	Scheduled   Receipts
50-cm Fan	1	100	LFL
Housing	1	100	LFL
Frame	2	0	LFL
Supports (2)	1	50	100
Handle	1	400	500
Grills (2)	2	200	500
Fan Assembly	3	150	LFL
Hub	1	300	LFL
Blades (5)	2	1400	100
Electrical Unit	1	0	LFL
Motor	1	0	LFL
Switch	1	20	12
Knob	1	0	15		200 Week   2

 

Q=

LS=

SS=

LT=

1

XYZ

WK1

WK2

WK3

WK4

WK5

WK6

WK7

WK8

WK9

WK10

WK11

Gross Requirements

Scheduled Receipts

Projected On   Hand

Net Requirements

Planned Order   Receipts

Planned Order   Releases

use the above mentioned excel for product A - G.

these are the other excel.

Q=

1

LS=

SS=

LT=

1

A

WK1

WK2

WK3

WK4

WK5

WK6

WK7

WK8

WK9

WK10

WK11

Gross Requirements

Scheduled Receipts

Projected On   Hand

Net Requirements

Planned Order   Receipts

Planned Order   Releases

Q=

LS=

SS=

LT=

B

Week 1

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Week 10

Week 11

Gross Requirements

Scheduled Receipts

Projected On   Hand

10

Net Requirements

Planned Order   Receipts

Planned Order   Releases

Q=

LS=

SS=

LT=

C

Week 1

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Week 10

Week 11

Gross Requirements

Scheduled Receipts

Projected On   Hand

40

Net Requirements

Planned Order   Receipts

Planned Order   Releases

Q=

LS=

SS=

LT=

D

Week 1

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Week 10

Week 11

Gross Requirements

Scheduled Receipts

Projected On   Hand

180

Net Requirements

Planned Order   Receipts

Planned Order   Releases

Q=

LS=

SS=

LT=

E

Week 1

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Week 10

Week 11

Gross Requirements

Scheduled Receipts

Projected On   Hand

400

Net Requirements

Planned Order   Receipts

Planned Order   Releases

Q=

LS=

SS=

LT=

F

Week 1

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Week 10

Week 11

Gross Requirements

Scheduled Receipts

Projected On   Hand

50

Net Requirements

Planned Order   Receipts

Planned Order   Releases