Answer Happy

The MRP gross requirements for product A in the next 12 weeks are shown in the following table. The lead time for A is two weeks, and the setup cost is $200. The carrying cost is $0.3 per unit per day. Suppose the initial inventory at the beginning of week 1 is 130 units. Gross 4 Lot for lot Planned order receipts Least Total Cost requirements 70 40 20 50 90 80 100 30 60 80 Questions: Planned order receipts 14 Least Unit Cost P 24 34 4 Planned order receipts 14 2 3+ 14 2 3 14 2 54 (1) Determine for what quantity the order should be planned to be received for each week using the following three lot-sizing methods: lot-for-lot, least total costs, and least unit cost. Hint: production should be scheduled when the initial inventory are all consumed. (3 marks for each lot-sizing methods) دیا Week 6 44 st Week 5 74 8 6 Weeke 5 6 Week 44 5 6 74 74 € 74 8 00 8 94 00 8 10 94 4 94 90+ 94 10 114 10 € 50€ 4 104 114 11 114 124¹ 4 2 124 e P 124 42 124 4²
(2) The product structure diagram for producing item A is given as follows. 4 C (2) The beginning inventory in week 1 for item B and C are 100 units and 150 units respectively. The lead time for both item B and item C is one week. There are 50 units of item B scheduled to be received at the beginning of week 2 and 100 units of item C scheduled to be received at the beginning of week 4. A Suppose A is produced based on the lot-for-lot method, and B and C are produced in batches with a fixed batch size of 100 units and 150 units respectively. Complete the MRP schedule for A, B, and C in the following tables. (4 marks for A; 6 marks for B; 6 marks for C)< Lead time= 2 weeks On hand 130 units Order quantity= lot for lote Safety stock <-00 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned 1 42 + 3 3 2 B (1) 3 2 3 2 36 (2 22 t t 4 4 2 2 t Weeke 5 42 C (2) 1 3 6 2 7 42 2 2 P 2 86 e 23 2 9 4 +3 t t P 10 41 11 67 7 t 2 to e 12 2 2 3 16-2 7 2 2
Bel Lead time- 1 week requirements On hand Scheduled -100 units receipts Order quantity= Projected on 100 units hand Safety stock Net Scheduled receipts 50 units (week 2) 6 CH Lead time= 1 week On hand= 150 units Order quantity- 150 units Gross Scheduled receipts 100 units (week 4) requirements Projected on hand Safety stock Net -0 Planned order receipts d Planned order releases 43 Gross requirements Scheduled receipts requirements 43 Planned order receipts Planned order releases + e e a P 3 4 47 t t # t 4 e → + 43 6 47 To t 6 47 2 L P P e P 2 P 2 2 2 t 2 to 7 2 2 to t e 7 a 2 7 A 13 23 10 P t n 13 43 12 7. t L