Question

please answer 14.17

- Data Table for Problems 14.17 through 14.19* Period 1 2 3 4 5 6 7 8 9 10 11 12 requirements 30 40 30 70 20 10 80 50 8 "Holding cost $2.50/unit/week; setup cost $150; lead time 1 week; beginning n Gross inventory 40 m14.17 Develop a lot-for-lot solution and calculate total rel- s evant costs for the data in the table for Problems 14.17 through d 14.19. Px 14.18 Develop an EOQ solution and calculate total relevant costs for the data in the table for Problems 14.17 through 14.19. stockout costs equal $10 per unit. 14.19 Develop a PPB solution and calculate total relevant costs s for the data in the table for Problems 14.17 through 14.19. PX 14.20 Using the gross requirements schedule in Examples 4, e5, and 6, prepare an alternative ordering system that always orders 100 units the week prior to a shortage (a fixed order quantity of 100) - with the same costs as in the example (setup at $100 each, holding at n $1 per unit per period). What is the cost of this ordering system? x 14.21 Using the gross requirements schedule in Examples 4, pare an alternative ordering system that orders every three weeks for three weeks ahead (a periodic order quantity). 5, and 6, pre PART STRUCTURE TREE A LT1 LT = lead time

Answer 1

In lot-for-lot ordering policy, we order exactly the amount we need. Using this, the MRP is shown below.

Period	0	1	2	3	4	5	6	7	8	9	10	11	12
Gross req		30		40		30	70	20		10	80		50
Inventory	40	10	10	0	0	0	0	0	0	0	0	0	0
Net requirement		0		30		30	70	20		10	80		50
Order release			30		30	70	20		10	80		50
Holding cost		25	25	0	0	0	0	0	0	0	0	0	0
Setup cost			150		150	150	150		150	150		150
Period cost		25	175	0	150	150	150	0	150	150	0	150	0
Total cost	1100