Consider the bill of material for a product, A, and the data given in the table that follows. The gross requirements for A are150 units in week 5 and 200 units in week 8.Item Lead-Time (weeks) On hand quantityABCA. 60 unitsB. 200 unitsC. 90 unitsD. 100 unitsA. 50 unitsB. 10 unitsOC. 40 unitsD. 210 unitsB(1)121What is the planned order release for product A in week four?A. 210 unitsB. 200 unitsC. 170 unitsD. 240 units60400What is the projected on hand inventory for component B in week eight?A. 400 unitsB. 0 unitsC. 480 unitsOD. 140 unitsALot sizeLot-For-Lot60120What is the planned order receipt for component B in week seven?A. 220 unitsB. 120 unitsOC. 140 unitsD. 0 unitsWhat is the gross requirement for component C in week five?What is the planned order receipt for component C in week four?C(1)

The Gross requirements : For A's = 150 Units in week 5 For B's = 200 Units in week 8 To be…

Answered: Consider the bill of material for 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

You have developed the following simple product structure of items needed for your gift bag for a rush party for prospective pledges in your organization. You forecast 200 attendees. Assume that there is no inventory on ha nd of any of the items. Explode the bill of material. (Subscripts indicate the number of units required.)
The president of Hill Enterprises, Terri Hill, projects the firm's aggregate demand requirements over the next 8 months as follows: 2,200 January 1,400 May February 1,600 June 2,200 March April 1,800 1,800 July August 1,800 1,400 Her operations manager is considering a new plan, which begins in January with 200 units of inventory on hand. Stockout cost of lost sales is $100 per unit. Inventory holding cost is $25 per unit per month. Ignore any idle-time costs. The plan is called plan C. Plan C: Keep a stable workforce by maintaining a constant production rate equal to the average gross requirements excluding initial inventory and allow varying inventory levels. Conduct your analysis for January through August.
8. Ajax produces two basic products called A and B. Each week, Paul, the owner, plans to assemble 20 product As and 8 product Bs. a. Given this information and the following product structure diagrams for A and B, fill out the MRP records (inventory status files) for component parts G and Y for the next seven weeks. X A Part G Gross requirements Y Scheduled receipts Projected available balance Planned order release Q = lot for lot; LT = 1; SS=0. 0 Y (2 required) G 10 B Z F Week 1 2 3 4 5 6 7 Part Y Gross requirements Scheduled receipts Projected available balance 67 Planned order release 1 10 Week 23 4 5 6 7 Q=lot-for-lot; LT=2; SS=0. b. Suppose 10 units of safety stock are required for part Y. What changes would result in the records? Would the MRP system produce any exception messages?
K Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 Gross requirements 30 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 Order receipt Order release 2 40 3 40 1 30 U 4 2 *Holding cost = $2.50/unit/week; setup cost = $150; lead time = 1 week; beginning inventory = 40. 5 6 7 30 70 20 3 40 8 4 9 10 10 80 5 6 7 30 70 20 8 11 9 10 D 12 50 10 11 12 80 50
Consider the bill of material for product P and the data given in the following table. The master schedule requirements for P are 60 units in week 6. Items Q and Rare manufactured internally by the firm and use the lot-for-lot lot-sizing rule. Item is purchased from a local distributor, and has a Fixed Order Quantity of 50 pieces per order. Use a blank matrix to solve for the MRP requirements. Q(2) S(3) R(3) Quantity on Hand 5. Scheduled reccipts Item Lead Time 15 20 in week 2 R. S. 25 15 in week 1 Given the following information, how many R's should be ordered? O 180 O 330 O 360 O 165 O 225 -/2/2
A factory has just received an order for 95 units of an end item, which are to be shipped at the start of week 8. Relevant information of the end item and the components is as follows. Lead Time On Hand Scheduled Item Order Direct (weeks) Inventory receipts Policy Components End item 15 lot for lot A(3), B(2) A 2 10 33 at week 3 lot for lot C(1), D(4) B. 2 20 15 at week 4 lot for lot D(2) min. of 500 lot for lot 100 20 Develop the material requirements plan (please print out an empty MRP table to work with), and determine how many units of component Care needed in the "planned order release". Input should be an exact number.
3. Item Z has a lead time of two weeks; A, B, C and D take one week each and E takes 3 weeks. Fifty units of Z are required in period 10. Assume that there is currently no inventory on hand of any of these items. Consider the following Bill of material and develop an MRP schedule for A, B, C, D and E showing gross and net requirements and order releases and order receipt dates. Assume Lot-for-lot ordering. C(3) A(2) Z D(4) E(2) B(4) Level 0 1 2 3
The partially completed inventory record for the driveshaft subassembly in the table below shows gross requirements, scheduled receipts, lead time, and current on-hand inventory. a. Complete the last three rows of the record for an FOQ of 60 units. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Driveshaft subassembly Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts 15 1 30 70 2 25 3 20 4 25 ☐☐ Lot Size: FOQ-60 units Lead Time: 3 weeks Week 5 35 6 35 7 60 8 60 00
The MRP gross requirements for Item X are shown here for the next 10 weeks. Lead time for A is two weeks, and setup cost is $10. There is a carrying cost of $0.02 per unit per week. Beginning inventory is 72 units. WEEK 1 2 3 4 5 6 7 8 9 10 Gross requirements 21 12 15 45 10 30 100 20 40 150 Use the least total cost lot-sizing method to determine when and for what quantity the first order should be released. Least total cost method indicates that periods units should be ordered to cover the needs for
Please do not give solution in image format thanku
Operations Management
Flora’s Fabulous Fountains’ (FFF) top product is its ModelA. Using the information given, draw the product structure treefor the Model A

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

Consider the bill of material for a product, A, and the data given in the table that follows. The gross requirements for A are 150 units in week 5 and 200 units in week 8. Item Lead-Time (weeks) A B 1 2 { B(1) C(2) On hand quantity 60 40 Lot size Lot-For-Lot 60 C(1)