Question 2 - about MRP and Lot Sizing (Total 20 marks) Winner Foods Co. is selling the Dols Brand Instant Noodles for various flavors to retailers and customers in Hong Kong. For the Cheesy Lobster flavour. Winner mainly packs two products, namely a) individual pack (see Figure 2A, and b) buk pack see Figure 20 for an individus pack, one piece of finished product will require noodie block, 1 seasoning ponder aluminum pouch, 1 sesame oil seches, and 1 small cutside plastic pocket (see Figure 24&25) Figure 2A Figure 28 Figure 2c While for a bulk pack product, there needs Encode blocks (also called the roodie bases and one big outside plastic pocicet no seasoning powder nor sesame oil required) The Bil of Materials for both packing versions can be referred as follows: a ino ) ind Pack Pack Noodle Seasoning Sesame Small Outside Bax! Powder Bags Sachet Pocket Noodle Base Big Outside Pocket The following is the Master Product on Schedule (MPS) data of both products as well as the lot sze, lead time safety stock requirement and minimum order quantity for the Noodle Blog Please also note the scheduled recept and projected on hand status MRP worksheet 1. MPS Data for Individual Pack Prochet Lead Time: I week Weck number 1 2 3 4 5 6 7 8 Gross Requirements 400 600 400 600 Planned order releases 400 600 400 600 2. MPS Data for Bulk Pack Product Lead Time: 1 week wer 1 2 3 4 5 6 7 8 Gruss Requirements 7090 40 Planned order releases 170 50 40 Part name: Noodle Black Lotsi L4L Minimum order quantity 100 units Lead time: 1 1 weck Immediate Parents: per Ind. Pack and per Bulk pack Safety stock: 100 units Weck number 1 2 3 4 5 7 8 Gross Requirements Scheduled Recipes 1000 Projected on hand 200 Net Requirements Planned order receipts Planned order releases * Complete the MRP sheet regarding only the Noodle Block and enter the final answers in the following table. (9 marks) Tips: you may like to use the above worksheer to do the MRP calculations and then copy the last line results to this table) 13 Week No. 23 13 5 137 Planned Order 300 uu Release Following on the above information on the noodle Block, calculate the EOQ and POQlot sizing quantities if the Holding cost - 51/unit/wok and Setup cost - $600. 0 Calculate the Economic Order Quantity (EO, for each order 1) Calculate the periodic time for Periodic Order Quantity IPOH 12 mars (2 marks Please use all the first 5 weeks data. Round the answer of order quantity and order interval to an integer, le decimal place. The following is a comparison of their inventory level termed as Projected on Hand during the 8 weeks for the three different lot string strategies Week 1 1 2 3 4 5 7 8 No 1.4L 200 200 100 100 100 160 100 100 500 200 200 93586166 226 319 319772 FOQ" 200 200 100 100 100 160 340 100 Hint POQ needs to just the order quantity when there is scheduled receipt in Week 5 as well as the inventory on hand Werk out the No. of Planned Order Releases during the B weeks period for the three lat sizing strategies Calculate the total costs consider the setup cost plus holding cost orly based on the holding cost - 51/unit/week and setup cost - 5600 which are the same for all LAL, EOQ and POQ calculations Lot for Lot, ECQ, and 10) POO Show all the steps of your calculations (Total 6 marks)