Refer to Case Study 4.2 in your textbook for background information on Benzie Products. A simplified product, X-alt, has been introduced providing the sales team and customers with a popular choice that is readily available. No time-fence is considered for production schedules. There are 65 units of X-alt on hand prior to Period 1 and the MPS is set to produce 75 units in week 2, 4, 6 and 8. Use your own worksheet to complete the missing information in the tables starting with Parent X-alt and continuing with MRP planning for the components G & K. Answer the following questions in the space below. a) What is the ATP for week 2, 4, 6 and 8? and What is the corresponding available inventory in those weeks? b) What are the gross requirements for component G, across the 10-week time frame and when does a planned order release occur? (provide quantity for planned order release) c) What are the gross requirements for component K, across the 10-week time frame and when does a planned order release occur? (provide quantity for planned order release) d) Benzie would like to maintain safety stock of 20 units across each planning period for Product X-alt. What considerations do they need to take into account? Component info G K Starting Inv. 25 0 Lead-time (wks) 2-weeks 1-week Lot Size 100 300 Safety Stock NA NA Planning Tables Product X-alt On-hand 65, Lead-time 1-week, no safety stock Week 0 1 2 3 4 5 6 7 8 9 10 Forecast 48 43 30 35 30 30 30 25 30 25 Customer orders 50 45 32 35 25 25 30 25 35 30 Projected Available Balance 65 Master Production Sched 75 75 75 75 Avail. To Promise (ATP) Component G On-hand 25, Lead time 2-weeks, min. qty.100 Week 0 1 2 3 4 5 6 7 8 9 10 Gross Requirements Scheduled receipts 100 Projected Available 25 Planned order receipt Planned order release Component K on-hand 0, lead time 1-week, min qty. 300 Week 0 1 2 3 4 5 6 7 8 9 10 Gross Requirements Scheduled receipts 300 Projected Available 0 Planned order receipt Planned order release