Note:-Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism.Answer completely.You will get up vote for sure. The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand.ItemEndBELCKBLCHLead Time11221222Click here for the Excel Data FileAdditional unitsAmounton Hand071823312840a. 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 anMRP plan.)The latest weekDirect ComponentsL(2), C(1), K(3)B(2), J(3)G(2), B(2)H(4), B(2)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 startedand 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 End L C K B J G H Lead Time 1 Additional units 1 2 2 The latest week 2 2 2 Amount on Hand 0 2 7 18 23 31 28 4 0 Click here for the Excel Data File 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.) Direct Components L(2), C(1), K(3) B(2), 3(3) G(2), B(2) H(4), B(2) 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.)

The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item End L C K B J G H Lead Time 1 Additional units 1 2 2 The latest week 2 2 2 Amount on Hand 0 2 7 18 23 31 28 4 0 Click here for the Excel Data File 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.) Direct Components L(2), C(1), K(3) B(2), 3(3) G(2), B(2) H(4), B(2) 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.)

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, the manufacturing or purchase lead times (in weeks) for typical lot sizes, amount on hand, and the direct components of each item and, in brackets, the number of each component for each parent. Item Lead Time Amount onHand DirectComponents End item 1 - L(2), C(1), K(3) L 2 14 B(2), J(3) C 3 30 G(2), B(2) K 1 25 H(4), B(2) B 4 15 J 2 10 G 4 5 H 2 - a. Not available in Connect.b. If 46 units of the end item are to be assembled, how many additional units of B are needed? (You don’t need to develop the MRP tables.)Additional units ____ c. An order for 46 units of the end item is scheduled to be shipped at the start of week 11. What is the latest week that the components of the order can be started and the order still be ready to ship on time? (You don’t need to develop the MRP tables.)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 Amount on Hand Direct Components End 2 0 L(2), C(1), K(3) L 2 11 B(2), J(3) C 3 15 G(2), B(2) K 3 20 H(4), B(2) B 2 25 J 3 34 G 3 3 H 2 0 Click here for the Excel Data File 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.)
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 1 clamp and 1 housing. Each clamp has 1 handle and 2 castings. Each housing has 1 bearing and 2 shafts. There is no inventory on hand. Part 2 a) Design a product structure noting the quantities for each item and show the low-level coding. Match each number in the structure below with the corresponding item. Number Item I Spring Subscript left parenthesis 2 right parenthesisSpring(2) II Housing Subscript left parenthesis 1 right parenthesisHousing(1) III Casting Subscript left parenthesis 2 right parenthesisCasting(2) IV Shaft Subscript left parenthesis 2 right parenthesisShaft(2) Bracket Base(1) Clamp(1) Handle(1) Clamp(4) Bearing(1) Handle(1) Casting(2) IIIIIIIV Part 3 b) Determine the…
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 1 clamp and 2 housings. Each clamp has 1 handle and 1 casting. Each housing has 2 bearings and 1 shaft. There is no inventory on hand. A. Design a product structure noting the quantities for each item and show the low-level coding. B. Determine the gross quantities needed of each item if you are to assemble 50 brackets. C. Compute the net quantities if there are 25 of the base and 100 of the clamp in stock.
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 1 clamp and 1 housing. Each clamp has 1 handle and 1 casting. Each housing has 2 bearings and 1 shaft. There is no inventory on hand. This exercise contains only parts b and c. Part 2 The product structure is as follows: Bracket Base(1) Clamp(1) Handle(1) Casting(1) Spring(2) Housing(1) Shaft(1) Clamp(4) Bearing(2) Handle(1) Casting(1) Part 3 b) Determine the gross quantities needed of each item if you are to assemble 100 brackets. Base: enter your response here units (enter your response as a whole number). Spring: enter your response here units (enter your response as a whole number). Clamp: enter your response here units (enter your response as a whole number). Housing: enter your response here units (enter your…
As the production planner for Xiangling HuProducts, Inc., you have been given a bill of material fora bracket that is made up of a base, two springs, and fourclamps. The base is assembled from one clamp and twohousings. Each clamp has one handle and one casting. Eachhousing has two bearings and one shaft. There is no inventoryon hand. a) Design a product structure noting the quantities for eachitem and show the low-level coding.b) Determine the gross quantities needed of each item if youare to assemble 50 brackets.c) Compute the net quantities needed if there are 25 of thebase and 100 of the clamp in stock.
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 3 clamps. The base is assembled from 1 clamp and 2 housings. Each clamp has 1 handle and 1 casting. Each housing has 2 bearings and 2 shafts. There is no inventory on hand. This exercise contains only parts b and c. Part 2 The product structure is as follows: Bracket Base(1) Clamp(1) Handle(1) Casting(1) Spring(2) Housing(2) Shaft(2) Clamp(3) Bearing(2) Handle(1) Casting(1) Part 3 b) Determine the gross quantities needed of each item if you are to assemble 125 brackets. Base: 33 units (enter your response as a whole number). Spring: enter your response here units (enter your response as a whole number). Clamp: enter your response here units (enter your response as a whole number). Housing: enter your response here units (enter your response as a whole…
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 1 spring, and 3 clamps. The base is assembled from 2 clamp and 1 housing. Each clamp has 1 handle and 1 casting. Each housing has 2 bearing and 2 shaft. There is no inventory on hand. Part 2 a) Design a product structure noting the quantities for each item and show the low-level coding. Match each number in the structure below with the corresponding item. Number Item I Bracket II Spring Subscript left parenthesis 1 right parenthesis III Clamp Subscript left parenthesis 3 right parenthesis IV Bearing Subscript left parenthesis 2 right
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 2 clamps and 1 housing. Each clamp has 1handle and 1 casting. Each housing has 2 bearings and 2 shafts. There is no inventory on hand. Part 3 b) Determine the gross quantities needed of each item if you are to assemble 150 brackets. Base: enter your response here units (enter your response as a whole number). Spring: enter your response here units (enter your response as a whole number). Clamp: enter your response here units (enter your response as a whole number). Housing: enter your response here units (enter your response as a whole number). Handle: enter your response here units (enter your response as a whole number). Casting: enter your response here units (enter your response as a whole number). Bearing: enter…
The following table lists the components needed to assemble an end item. Assume there is no on-hand inventories. Item Direct Components End item A(4), B(5), C(4) A E(3), F(2) B D(3), E(5) C F(4) D E F E(4) If 3 units of the end item are to be assembled, how many units of component E are needed? Input should be an exact number.
You have developed the following simple product structure of items needed for your gift bag for a rush party for perspective pledges in your organization. You forecast 200 atendees. You are expected to have the gift bags ready at 5 pm. However, you need to personalize the items. The lead time is 1 hour to assemble 20” Js once the other items are prepared. The other items will take a while as well. Given the volunteers you have, the other time estimates are item K ( 1 hour), item L (1 hour), and item M (3 hours). Develop a time-phased assembly plan to prepare the gift bags
You were just hired as the head strength coach at a NAIA school. You are the first strength coach the University has ever hired. Knowing that you have 500 student athletes across 22 different teams, how do you manage programming, load, and needs based workouts across all sports? Write a needs outline for 3 different sports: one in season, one off season, and one pre season.