The demand for subassembly S is 100 units in week 7. Each unit of S requires one unit of Tand 0.5 unit of U. Each unit of T requires one unit of V, two units of W, and one unit of X.Finally, each unit of U requires 0.5 units of Y nd three unit of Z. One from manufacturers allitems. It takes 2 weeks to make S, 1 week to make T, 2 weeks to make U, 2 weeks to make V,3 weeks to make W, 1 week to make X, 2 weeks to make Y and 1 week to make Z.(a) Construct a product structure and a gross material requirements plan for the dependentinventory items. Identify all level, parents and components.(b) Construct a net material requirements plan (Item S & T only) for the product structureand the following on hand inventory.ItemsOn hand inventoryItemsOn hand inventoryS20W30T2025U10Y15V3010

A Small Introduction About Inventory Inventory management software keeps track of item levels and…

Answered: (a) Construct a product structure and a…

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

With radio frequency (RFID) tags, items can be tracked during production and in inventory?
Does a visual labeling system identify and locate inventory, tools, processes, and ﬂow?
Should BestLine’s ordering department have been more involved during the project?2. Sarah used expert interviews for this project. Were there more effective methods for gathering therequirements?3. What crucial step(s) did Sarah skip in the requirements process?4. Which downstream activities would likely be affected by her approach? At what point in the projectwould the problems likely emerge?5. Should Sarah have presented the requirements to the ordering manager at this point? Should the orderingmanager have signed off on them?
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. 5 6 7 30 70 30 9 10 11 12 60 10 70 Period 1 Gross requirements 20 2 Period Gross requirements On-hand at beginning of period 40 On-hand at end of period Order receipt Order release 3 40 1 20 4 *Holding cost = $3.50/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 40. Develop a lot-for-lot solution (enter your responses as whole numbers). 2 3 40 4 8 5 6 30 7 70 30 8 9 10 11 12 10 70 60 corn
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period Gross requirements 1 2 20 3 4 56 7 8 9 10 11 12 30 30 60 20 20 80 60 *Holding cost $1.50/unit/week; setup cost $200; lead time = 1 week; beginning inventory = 40. Develop a lot-for-lot solution (enter your responses as whole numbers). Period Gross requirements On-hand at beginning of period On-hand at end of period 1 2 3 4 56 7 8 9 10 11 12 20 30 30 60 20 20 80 60 40 20 30 20 20 Order receipt Order release
A major automobile manufacturer located in Georgetown, Kentucky, has two certified vendors that produce brake pads with the information shown below. New Albany Manufacturing is located in Columbus, Ohio, and LaPlaya Manufacturing is located in Monterrey, Mexico. The automobile assembly factory is assumed to operate 250 days per year. Certified Supplier New Albany Mfg. LaPlaya Mfg. Order Size (Q) 30,000 60,000 Price per Unit (P) Order quantity: Total procurement cost: Total management oversight cost: Total annual transportation cost: Annual order cost: Annual holding cost: Average annual pipeline inventory cost: Total supply chain costs: $14.38 $13.55 Oversight Cost per Unit (0) $0.00 $0.37 $ LA GA $ LA tA a. Use the Total Supply Chain Cost Excel template to compute the supply chain costs associated with each supplier if the annual demand is 480,000 brake pads. Do not round intermediate calculations. Round your answer to the nearest dollar. 30,000 units 60,000 units tA Transport Cost…
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period Gross requirements Develop a lot-for-lot solution (enter your responses as whole numbers). Period Gross requirements On-hand at beginning of period On-hand at end of period 1 Order receipt Order release 30 2 3 30 1 30 40 || 4 5 2 6 7 40 70 20 *Holding cost = $3.50/unit/week; setup cost = $150; lead time = 1 week; beginning inventory = 40. 3 4 30 8 9 10 11 12 5 6 7 40 70 20 20 80 8 60 9 10 20 80 11 12 60
Develop a EOQ solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 *Holding cost =$ 2.50/unit/week; setup cost =$ 150; lead time =1 week; beginning inventory =40. What is the average demand per week? with 2 decimal places): Calculate Economic Order Quantity (EOQ) Develop a EOQ solution (enter your responses as whole numbers). Period 1 2 3 4 5 6 7 8 9 10 11 12 Gross requirements 20 30 30 30 20 10 40 60 Scheduled receipt…
Pennington Cabinets is a manufacturer of several different lines of kitchen and bathroom cabinets that are sold through major home improvement retailers. Pennington built material requirement planning as follows: Current Jan Feb Mar 1200 1000 Gross requirements Scheduled receipts 800 Projected available balance Net requirements Planned order receipts 820 Planned order release Compute net requirements in Feb. Your Answer: Answer
For the following bill of material, if we need to produce 10 units of finished product P, how many component C do we need? Assume there is no on-hand inventory. P M(3) 80 0 120 O 16 40 160 N(4) B(3) C(4) D(5) C(4)
Robotic Pet Products uses overtime, inventory, and subcon-tracting to absorb fluctuations in demand. As expected, de-mand in the fourth quarter during the holiday season isparticularly high, followed by first quarter demand forcustomers purchasing accessories for their R-pets. Giventhe demand and available capacities shown below, design aproduction plan that will satisfy demand at minimum cost.Regular production cost per unit $10Overtime production cost per unit $15Subcontracting cost per unit $20Inventory holding cost per unit per period $3Beginning inventory 100 Regular Overtime SubcontractingQuarter Demand Capacity Capacity Capacity1 1000 1000 100 5002 800 1000 100 5003 600 1000 100 5004 2600 1000 100 500
Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. 3 9 10 11 12 4 5 6 7 40 60 30 40 20 70 50 Period 1 Gross requirements 20 2 *Holding cost = $1.50/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 40. Develop a lot-for-lot solution (enter your responses as whole numbers). Period Gross requirements On-hand at beginning of period 40 On-hand at end of period Order receipt Order release 1 20 2 3 40 8 4 5 6 7 40 60 30 8 9 10 11 12 20 70 50

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

(a) Construct a product structure and a gross material requirements plan for the dependent inventory items. Identify all level, parents and components. (b) Construct a net material requirements plan (Item S & T only) for the product structure and the following on hand inventory.