You are required to:

a) Complete the MRP sheet using Lot-for-Lot technique

b) Calculate total cost of Lot-For-Lot Technique

c) Calculate the value of EOQ using the information given in the MRP sheet

d) Calculate total cost including Setup cost and holding cost of EOQ

e) Find the value of Order Size (New EOQ) using your SAP ID (for SAP ID 70077555, sum all values 7+0+0+7+7+5+5+5=36) Order Size (New EOQ) would be 36

f) Calculate total cost including Setup cost and holding cost of Order Size (New EOQ).

g) Compare the total cost of part b, d and f and select the optimal option

Weeks		1	2	3	4	5	6	7	8
Gross requirements		47	21	63	11	41	21	43	39
Scheduled receipts			10		20		20
Projected on hand	37
Net requirements
Planned order receipts
Planned order releases

Additional Information:

Setup cost $200,

Holding cost $3 per unit/per week,

Lead time 2 weeks.