Question

Question B.1

A company has the following master schedule (Table B.1) and master file (Table B.2) for its most popular Lapdesk.

Table B.1 Master Production Schedule

Week	1	2	3	4	5	6
Lapdesk	400	300	450	330	450	400

Table B.2 Master file

	Lapdesk	Pressboard
On hand	200	300
On order	100(week 2)	0
LLC	0	1
Lot Size	L4L	Mult 100
Lead Time	1	1

Each lapdesk has two pressboards. Use MRP to schedule planned order releases for Lapdesk and pressboard.

This question is 25 marks out of 150 in total in a level 6 exam, please consider this when compiling an answer, any additional workings out or extra comments/explanations will receive positive feedback, thank you in advance, the more clear and more descriptive the better. (please note positive review will follow if answer is of high standards)

Answer 1

Below is the MRP plan based on the details given:

Item: Lapdesk
		LT= 1 week		Lot size: L4L
Week	1	2	3	4	5	6
Gross requirements	400	300	450	330	450	400
Scheduled orders		100
On hand inventory: 200		300+200-400-100=0	0	0	0	0
Net requirement		300+200-100=400	450	330	450	400
Planned Order Receipt		400	450	330	450	400
Planned Order Release	400	450	330	450	400
Backorders	400-200=200
Item: Pressboard
2 units of Pressboard needed for 1 unit of Lapdesk		LT= 1 week		Lot size: Mult 100
Week	1	2	3	4	5	6
Gross requirements	400*2=800	450*2=900	330*2=660	450*2=900	400*2=800
Scheduled orders
On hand inventory: 300		0	700-660=40	900+40-900=40	800+40-800=40	40
Net requirement		500+900=1400	660	900-40=860	800-40=760
Planned Order Receipt		1400	700	900	800
Planned Order Release	1400	700	900	800
Backorders	800-300=500

Please give thumbs up/ likes if you find this answer helpful. Thank you!