Figure 1 shows the BOM for product A. Table 1 shows the MPS quantity start dates for product A, and Table 2 contains data from inventory records for items B, C, and D. The production planner wants to determmine the material requirements plan for items B, C, and D for the next 8 weeks. What is the planned receipts quantity for item D for week 6? C () D (2) 8(1) D(2) Figure 1. BOM for product A Table 1. MPS quantity start dates for product A Week Product 1 4. 3 70 5. 6. 7. 80 100 70 100 Table 2. Inventory record data Item Data category Lot-sizing rule Lead time Scheduled receipts Beginning inventory Safety stock LAL 2 weeks 100 (week 3) POQ (P-4) 1 week 500 (week 1) 600 100 FOQ-500 1 week 150 (week 1) 200 None 130

1.

8. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble 20 product As and 8 product Bs. a. Given this information and the following product structure diagrams for A and B, fill out the MRP records (inventory status files) for component parts G and Y for the next seven weeks. X A Part G Gross requirements Y Scheduled receipts Projected available balance Planned order release Q = lot for lot; LT = 1; SS=0. 0 Y (2 required) G 10 B Z F Week 1 2 3 4 5 6 7 Part Y Gross requirements Scheduled receipts Projected available balance 67 Planned order release 1 10 Week 23 4 5 6 7 Q=lot-for-lot; LT=2; SS=0. b. Suppose 10 units of safety stock are required for part Y. What changes would result in the records? Would the MRP system produce any exception messages?

Given the following MRP matrix for Item D, the planned order receipt for period 4 is ITEM: D Period Lot Size: Mul 100 LT: 1 1 2 3 4 6 Gross Requirements Schedule Receipts Project on Hand Net Requirements Planned Order Receipts 60 90 150 150 180 270 120 120 Planned Order Releases 100 200 220 DELL

which one would be the optimal production plan for part b?

uestions wi1ps06h.ch06.11 The bill of materials for product A with the associated component parts and planning factors (in parenthesis) are showed below. C (1) B (2) Icon Key D (1) D (3) A C (6) E (4) F (2) D (1) G (4) How many units of the component parts are required to make one unit of the product A? Round your answers to the nearest whole number. Component B: unit(s) Component C: unit(s) Component D: unit(s) Component E: unit(s) Component F: unit(s) Component G: unit(s)

A factory has just received an order for 95 units of an end item, which are to be shipped at the start of week 8. Relevant information of the end item and the components is as follows. Lead Time On Hand Scheduled Item Order Direct (weeks) Inventory receipts Policy Components End item 15 lot for lot A(3), B(2) A 2 10 33 at week 3 lot for lot C(1), D(4) B. 2 20 15 at week 4 lot for lot D(2) min. of 500 lot for lot 100 20 Develop the material requirements plan (please print out an empty MRP table to work with), and determine how many units of component Care needed in the "planned order release". Input should be an exact number.

3. Item Z has a lead time of two weeks; A, B, C and D take one week each and E takes 3 weeks. Fifty units of Z are required in period 10. Assume that there is currently no inventory on hand of any of these items. Consider the following Bill of material and develop an MRP schedule for A, B, C, D and E showing gross and net requirements and order releases and order receipt dates. Assume Lot-for-lot ordering. C(3) A(2) Z D(4) E(2) B(4) Level 0 1 2 3

help please I need it to be done in excel

The MRP gross requirements for Item X are shown here for the next 10 weeks. Lead time for A is two weeks, and setup cost is $10. There is a carrying cost of $0.02 per unit per week. Beginning inventory is 72 units. WEEK 1 2 3 4 5 6 7 8 9 10 Gross requirements 21 12 15 45 10 30 100 20 40 150 Use the least total cost lot-sizing method to determine when and for what quantity the first order should be released. Least total cost method indicates that periods units should be ordered to cover the needs for