plz solve both parts within 30-40 mins I'll give you multiple upvote 4. Product X is made of two units of Y and three of Z. Y is made of one unit of A and two units of B. Z ismade of two units of A and four units of C.On HandLead Time(week)Item201.Y402.303.502AB1001.2003.a.Draw the bill of material.b. If 100 units of X are needed in week 10, develop a MRP table.2.3.4.6.8.9.Weeks:Gross Requirements

A Small Introduction about MRP Material necessities arranging (MRP) is a PC based stock…

Product X is made of two units of Y and three of Z. Y is made of one unit of A and two units of B. Z is made of two units of A and four units of C. Lead Time(week) On Hand 20 Item Y 40 2 30 3 A 50 2. 100 200 3. Draw the bill of material. If 100 units of X are needed in week 10, develop a MRP table.

Product X is made of two units of Y and three of Z. Y is made of one unit of A and two units of B. Z is made of two units of A and four units of C. Lead Time(week) On Hand 20 Item Y 40 2 30 3 A 50 2. 100 200 3. Draw the bill of material. If 100 units of X are needed in week 10, develop a MRP table.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

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 3 2 2 2 1 2 1 Amount on hand 0 10 9 25 11 32 3 0 a. If 18 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 14. 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
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) 3 1 1 1 1 3 1 3 Amount on hand 0 9 10 24 10 33 4 0 a. If 17 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 15. What is the latest week that the order can be started and still be ready to ship on time?  The latest week is
The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amounton 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
The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amounton Hand Direct Components End 1 0 L(2), C(1), K(3) L 2 11 B(2), J(3) C 3 17 G(2), B(2) K 4 23 H(4), B(2) B 3 34 J 3 25 G 3 7 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.) b.An order for the end item is scheduled to be shipped at the start of week 11. 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 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 ComponentsEnd 1 — L(2), C(1), K(3)L 2 10 B(2), J(3)C 3 15 G(2), B(2)K 3 20 H(4), B(2)B 2 30J 3 30G 3 5H 2 —a. If 40 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.)b. An order for the end item is scheduled to be shipped at the start of week 8. What is the latestweek that the order can be started and still be ready to ship on time? (Hint: You don’t need todevelop an MRP plan.)
A part structure, lead time (weeks), and on-handquantities for product A are shown in Figure 14. 14. From theinformation shown, generate:a) An indented bill of material fo r product A b) Net requirements for each part to produce I0 As in week 8using lot-for-lot. IP
Transcribed Image Text On hand: 35 Planning time fence: 10 Lot size: 200 Demand time fence: 2 Period 2 4 6. 7 9. 10 11 12 Forecast 30 40 40 50 40 40 30 40 40 50 40 40 Customer Orders 31 35 29 21 17 14 33 11 5 2 Projected Available Available to Promise MPS 200 200 3. a. Given the following master schedule, fill in the projected available and availableto promise rows: b. A customer wants an order of 100 in period 4. What can you tell him?c. The customer from part (b) cancels his request, but then says he wants 120 in period 5.What do you tell him now?d. Sales has requested that you add an MPS of 200 in period 9 to cover their needs for a sales promotion. What do you tell them and why?e. What action (if any) should be taken in period 11? Why is it okay to take theaction? I only need question D and E answered
What are some of the main advantages and limitations of MRP?
Your stockroom manager, Mehmet Altag, arrivedat your desk just a fter you had completed the net requirementsplan for product A ( You are product pla nner for product A (in Problem A part structure, lead time (weeks), and on-hand quantities for product A are shown in Figure 14. 14. From theinformation shown, generate:a) An indented bill of material fo r product A b) Net requirements for each part to produce I0 As in week 8 using lot-for-lot. IP).) The field service manager, Mark Moon, has just called and told you that the requirements for B and Fshould each be increased by I 0 units for his repair requi rements in the field.a) Prepare a list showing the quantity of each part required to produce the requirements for the service manager and the production request of I0 Bs and Fs. b) Prepare a net requirement plan by date for the new requirements (for both production and field service), assuming that the field service manager wants…
Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. 14.) A part structure, lead time (weeks), and on-hand quantities for product A are shown in Figure 14. From the information shown, generate: a) An indented bell of material for product A. b) Net requirements for each part to produce 10 As in week 8 using lot-for-lot. Figure 14:
Describe the following types of bills of material:a. Product tree.b. Multilevel bill.c. Single-level bill.d. Indented bill.e. Summarized parts list.f. Planning bill
An end item’s demand forecasts for the next 10 weeks are 30,20, 35, 50, 25, 25, 0, 40, 0, and 50 units. The current on-handinventory is 80 units. The order policy is to produce in lots of100. The booked customer orders for the item, starting withweek 1, are 22, 30, 15, 9, 0, 0, 5, 3, 7, and 0 units. At present,no MPS quantities are on-hand for this item. The lead time is2 weeks. Develop an MPS for this end item.