Consider the bill of material for product P and the data given in the following table. The master schedule requirements for Pare 60 units in week 6. Items Q and Rare manufactured internally by the firm and use the lot-for-lot lot-sizing rule. Item S 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. P. Q(2) S(3) R(3) Quantity on Hand Scheduled receipts Item Lead Time P. 15 20 in week 2 R. 2. 2. 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

Consider the bill of material for product P and the data given in the following table. The master schedule requirements for Pare 60 units in week 6. Items Q and Rare manufactured internally by the firm and use the lot-for-lot lot-sizing rule. Item S 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. P. Q(2) S(3) R(3) Quantity on Hand Scheduled receipts Item Lead Time P. 15 20 in week 2 R. 2. 2. 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

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

Whats the correct answer please ?
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?
A single inventory item is ordered from an outside supplier. The anticipateddemand for this item over the next 12 months is 6, 12, 4, 8, 15, 25, 20, 5, 10, 20, 5,12. Current inventory of this item is 4, and ending inventory should be 8. Assume aholding cost of $1 per period and a setup cost of $40. Determine the order policyfor this item based onc. Part period balancing
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
Please solve correctly. Don't solve if you don't know -
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
7
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.
Calculate MPS for all periods
Determine the optimal Q and TC given the following information: D = 30,000 boxes Ch = $2 Co $300 Discount schedule: Quantity (boxes) Price ($ per box) 43 1 to 9,999 10,000 to 14,999 41 15,000 to 19,999 38 20,000 or more 36 Show complete solution.
Exercise 2: The demand per year (D) for product X is 12,100 units. The costs of placing an order (S) are $4.50. The unit cost (C) of the item is $25.00. The maintenance cost (H) per unit per year is 30% of the item's cost. 1. Use the economic order quantity (EOQ) model to determine: *Optimal quantity to order* The expected number of orders*Optimal time between orders*The total annual cost of maintaining that optimal amountNOTE: Show calculations of how you arrived at each amount 2. Answer, what are the potential benefits of using EOQ analysis for inventory management? How can you help businesses strike a balance between inventory holding costs and ordering costs?
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.