Question 2 (Total 20 marks)

Yat Ching Co. is an authorised company to do the packing of Nissin Instant Noodles for supplying private hospitals in Hong Kong. Yat Ching Co. mainly packs two products, namely a) individual pack , and b) bulk pack

For an individual pack, one piece of finished product will require 1 noodle base, 1 seasoning powder aluminum bag, 1 sesame oil sachet, and 1 outside plastic pocket

While for a piece of bulk pack product, there needs 6 noodle bases and one bigger outside plastic pocket (no seasoning powder or sesame oil required) The Bill of Materials for both packing versions can be referred as follows:

The following is the Master Production Schedule (MPS) data of both products as well as the lot size, lead time, safety stock requirement and the minimum order quantity for the Noodle Base. Please also note the scheduled receipt and projected on hand status.

MRP worksheet

MPS Data for Individual Pack Product						Lead Time: 1 week
Week number	1	2	3	4	5		6	7	8
Gross Requirements			400	600			400	600
Planned order releases		400	600		400		600

MPS Data for Bulk Pack Product						Lead Time: 1 week
Week number	1	2	3	4	5		6	7	8
Gross Requirements					70		90		40
Planned order releases				70	90			40

Part name: Noodle Base							Lot size:			L4L
Minimum order quantity:			100	units			Lead time:			1	week
Immediate Parent(s): 1 per Ind. Pack and 6 per Bulk pack							Safety stock:			100	units
Week number				1	2	3	4	5	6	7	8
Gross Requirements
Scheduled Receipts								1000
Projected on hand		200
Net Requirements
Planned order receipts
Planned order releases

1. Complete the MRP sheet regarding only the Noodle Base and enter the final answers in the following table. (7 marks)

(Tips: you may like to use the above worksheet to do the MRP calculations and then copy the last line results to this table)

Week No.	1	2	3	4	5	6	7	8
Planned Order Release								0