November 2023 Problem 12 2 The following table lists the components needed to assemble an
CHAPTER 12
Business Finance
Problem 12-2 The following table lists the components needed to assemble an end item, lead times, and quantities on hand. Item End B C D E F G H LT (wk) 1 2 3 3 1 2 1 2 Amount on hand 0 10 10 25 12 30 5 0 ________________________________________ a. If 21 units of the end item are to be assembled, how many additional units of E are needed? (Hint: You don’t need to develop an MRP plan to determine this.) Additional units b. An order for the end item is scheduled to be shipped at the start of week 13. What is the latest week that the order can be started and still be ready to ship on time? (Hint: You don’t need to develop an MRP plan for this part either.) The latest week Problem 12-3 The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amount on Hand Direct Components End 2 0 L(2), C(1), K(3) L 2 8 B(2), J(3) C 3 12 G(2), B(2) K 3 17 H(4), B(2) B 2 32 J 3 27 G 3 5 H 3 0 ________________________________________ a. If 43 units of the end item are to be assembled, how many additional units of B are needed? (Hint: You don’t need to develop an MRP plan.) Additional units b. An order for the end item is scheduled to be shipped at the start of week 13. What is the latest week that the order can be started and still be ready to ship on time? (Hint: You don’t need to develop an MRP plan.) The latest week Problem 12-9 Assume that you are the manager of a shop that assembles power tools. You have just received an order for 59 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws is Item Lead Time (weeks) On Hand Components Saw 2 15 A(2), B(1), C(4) A 1 10 E(3), D(1) B 2 5 D(2), F(3) C 2 65 E(2), D(2) D 1 20 E 1 10 F 2 30 ________________________________________ Develop the material requirements plan for component E using lot-for-lot ordering. (Leave no cells blank – be certain to enter “0” wherever required.) Item: E(3) & E(2) LT = 1 wk. Beg. Inv. 1 2 3 4 5 6 7 8 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release ________________________________________
