The partially completed inventory record for the rotor 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 160 units. (Enter your responses as integers. A response of "0" is equivalent to being not applicable)Item: Rotor subassemblyGrossrequirementsScheduledreceiptsProjected on-handinventoryPlannedreceipts15165160H210350435Lot Size: FOQ-160 unitsLead Time: 2 weeksWeek5806807808800000000 0000

Answer) Given:Item: Rotor sub assembly.Lot Size: FOQ = 160units.Lead time = 2 weeks.Project on hand…

Answered: The partially completed inventory…

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

Given the following MRP matrix: LLC: 0 ITEM: X LOT SIZE: MIN 100 Gross Requirements Gross Scheduled Receipts Projected on Hand Net Requirements Net Planned Order Receipts Planned Order Releases Shown smaller: ITEM: X LOT SIZE: MIN 100 Requirements Scheduled Receipts Projected on Hand Requirements Planned Order Receipts Planned Order Releases Answer: LLC: 0 LT: 2 LT: 2 30 PERIOD 1 2 100 PERIOD 50 1 20 10 100 20 2 30 100 50 100 100 30 3 If the ordering cost is $176 and the carrying cost is $1 per unit per period, what is the total inventory related cost for periods 1 through 7? Give answer to 2 decimal WITHOUT the $ symbol. 50 80 20 20 30 50 50 60 80 80 100 30 10 30 80 30 70 90 10 100 100 7 30 10 4 100 100 50 30 5 60 70 6 80 90 30 10 100 100 7 80 10
Completely fill in the MRP matrices for items J, K, and L. Do not complete the matrix for M and be careful to watch lot size restrictions. Item J LLC 0 Lot Size L4L LT 3 1 2 3 4 5 6 7 8 9 Gross Requirements Scheduled Receipts Projected on Hand 100 Net Requirements Planned Order Receipts Planned Order Releases Item K LLC _ Lot Size Mult 200 LT 2 1 2 3 4 5 6 7 8 9 Gross Requirements Scheduled Receipts Projected on Hand 110 Net Requirements Planned…
Complete the MPS record shown in Figure 11.30 for a single item.
• What is the Reorder Point (ROP)? • What is the fill rate? What is the average inventory? • What is the average flow time? Given Data: Coefficient of variation (CV) = 0.24 Average weekly demand = 540 units Standard deviation = 130 units Lead time=2 Lot size = 1641 Safety inventory: NORMSINV(0.95) = 1.64 Standard deviation * sqrt(2) * 1.64 130*√√2*1.64 301.51 301 = 301 units
Consider the bill of material for Product J and the data given in the following table. The gross requirements for J are 200 units in week 6 and 270 units in week 8. Use the min 350 lot-sizing rule for M. What are the quantities of the planned orders for the M for the first seven weeks? K(1) L(4) M (2) Item Lead Time Quantity on Hand Scheduled receipts 1 30 20 30 in week 2 K 2. 40 10 in week 1 O a. 0,0,350,540,0,0,0 O b. 0,0,0,350,0,480,0 Oc. 0,0,290,350,0,0,0 O d. 0,0,290,0,540,0,0 210521224709-39153
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.
Discuss the role of cross-functional collaboration in effective aggregate planning
Complete the master production schedule (enter your responses as whole numbers). On-hand inventory at end of week 1: 190 Week Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 2 280 125 680 770 3 400 170 280 4 290 265 640 650 5 250 150 390 6 260 265 965 840 7 250 240 715 8 290 125 1295 870 555 9 310 190 985
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
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.
Please do not give solution in image format thanku

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