i need solution for part d and part e 1. The demand for subassembly S is 100 units in week7.Each unit of S requires 1 unit of T and 2 units of U.Each unit of T requires 1 unit of V, 2 units of W, and 1unit of X. Finally, each unit of U requires 2 units of Yand 3 units of Z. One firm manufactures all items. Ittakes 2 weeks to make S, 1 week to make T,2 weeksto make U, 2 weeks to make V, 3 weeks to make W,1week to make X, 2 weeks to make Y, and 1 week tomake Z.a) Construct a product structure. Identify all levels,parents, andComponents.b) Prepare a time-phased product structure.c) Construct a gross material requirements plan.d) In addition to 100 units of S, there is also a demand for20 units of U, which is a component of S. The 20 units ofU are needed for maintenance purposes. These units areneeded in week 6. Modify the gross material requirementsplan to reflect this change.e) In addition to 100 units of S, there is also a demandfor20 units of U, which is a component of S. The 20 units ofU are neededfor maintenance purposes. These units areneeded in week 6. Modify the net material requirementsplan to reflect this change.

Gross requirements are the amount of free and ward interest for a part prior to mesh close by stock…

d) In addition to 100 units of S, there is also a demandfor 20 units of U, which is a component of S. The 20 units of U are neededfor maintenance purposes. These units are needed in week 6. Modify the gross material requirements plan to reflectthis change. e) In addition to 100 units of S, there is also a demand for 20 units of U, which is a component of S. The 20 units of U are needed for maintenance purposes. These units are needed in week 6. Modify the net material requirements plan to reflect this change.

d) In addition to 100 units of S, there is also a demandfor 20 units of U, which is a component of S. The 20 units of U are neededfor maintenance purposes. These units are needed in week 6. Modify the gross material requirements plan to reflectthis change. e) In addition to 100 units of S, there is also a demand for 20 units of U, which is a component of S. The 20 units of U are needed for maintenance purposes. These units are needed in week 6. Modify the net material requirements plan to reflect this change.

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

Using the information in Problem(The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T,                                                                                                                                                                                                                                2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct agross material requirements plan.
Using the information in Problem (The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T,                                                                                                                                                                                                                                2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct a netmaterial requirements plan using the following on-hand inventory.
The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T,                                                                                                                                                                                                                                2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure.
Explain what happens when you use different lot size rulesin MRP
A Corporation assembles two products as shown in the product structures below. It has orders for 480 on period 8 and 100 units on period 9 of product X.. Develop the MRP table for each of the items. Item Amount on hand Schedule receipts Lot-sizing rule X 180 0 L4L A 100 0 Periodic order quantity (2 weeks) B 50 0 100 C 50 0 200 D 50 0 400 X LT = 2 A (2) LT = 2 B (1) LT = 2 C (3) LT = 1 D (1) LT = 3 D (2) LT =2
Operations Manager of PT Radio Gaga is calculating production costsa telecommunication radio taking into account the following needs:i. Week 1 : 20 unitsii. Week 2 : 36 unitsiii. Week 3 : 46 unitsiv. Week 4 : 45 unitsv. Week 5 : 20 unitsvi. Week 6 : 26 unitsIt is known that there is inventory from the previous week as many as 20 units. Assuming 52week per year, lead time booking for 1 week, setup cost of $40 andholding cost of $0.75 per week, you are required to assist the Operations Manager of PTRadio Gaga to calculate the estimated production cost as follows: a. Calculate EoQ b. Create a 6-week MRP Lot Sizing Table with EoQ method c. Calculate Total Production Cost using EoQ method d. Create a 6-week MRP Lot Sizing Table using the Lot methodfor Lot e. Calculate Total Production cost by using Lot for Lot methodF. Which method will PT Radio Gaga's Operations Manager take?
4. Heather Adams, production manager for a Colorado exercise equipment manufacturer, needs to schedule an order for 50 UltimaSteppers, which are to be shipped in week 8. Assume lot-for- lot ordering. Below is information about the steppers and the quantity required for each parent. Item Lead Time On Hand Inventory Components Stepper 2 20 A(1), B(3), C(2) A 1 10 D(1), F(2) B 2 30 E(1), F(3) C 3 10 D(2), E(3) D 1 15 E 2 5 F 2 20 Develop a net material requirements plan for ( F )
Note: Use the following format for all your MRP matrices: Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipts Planned order releases 0 1 PERIOD 2 3 4
Refer again to Problems( Using the information in Problem(The demand for subassembly Sis 100 units in week 7.Each unit ofS requires 1 unit ofT and 2 units ofU. Each unit ofT requires I unit ofY, 2 units ofW, and 1 unit of X. Finally, eachunit of U requires 2 units of Y and 3 units of Z. One firm manufacturesall items. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make Y, 3 weeks to make W,I week to make X, 2 weeks to make Y, and I week to make Z.a) Construct a product structure. Identify all levels, parents, and components.b) Prepare a time-phased product structure. ), construct agross material requirements plan. ). In addition to100 units of S, there is also a demand for 20 units of U, which isa component of S. The 20 units of U are…
Courtney Kamauf schedules production of a popular Rustic Coffee Table at Kamauf Enterprises, Inc. The tablerequires a top, four legs, 18 gallon of stain, 116 gallon of glue, 2 shortbraces between the legs and 2 long braces between the legs, anda brass cap that goes on the bottom of each leg. She has 100 gallons of glue in inventory, but none of the other components. Allitems except the brass caps, stain, and glue are ordered on a lotfor-lot basis. The caps are purchased in quantities of 1,000, stainand glue by the gallon. Lead time is 1 day for each item. Schedulethe order releases necessary to produce 640 coffee tables on days5 and 6, and 128 on days 7 and 8.
Based on the data in Figure 14.13, complete a netmateria l requirements schedule for:a) AJJ items (10 schedules in aU), assuming the requirement foreach BOM item is I.b) All10 items, assuming the requirement for all items is I, exceptB, C, a nd F , which require 2 each.
(1) This DC value-adding activity allows it to receive full truckloads of one product and ship full truckloads of various products to customers. a. allocation b. mixing c. assembly d. kitting (2) As Q increases for EOQ, the cost per order: a. increases b. decreases c. stays the same d. cannot be determined