In the following MRP planning schedule for Item J, indicate the correct net requirements, planned order receipts, and planned orderreleases to meet the gross requirements. Lead time is one week. (Leave no cells blank - be certain to enter "o" wherever required.)WEEK NUMBERITEM JGross requirenentsOn-handNet requirementsPlanned order receiptPlanned order release70456530Perlod2.Gross requirements704565Scheduled receiptsProjected available balanceNet requirementsPlanned order receiptsPlanned order releases

Given data is Lead time = 1 week

Answered: In the following MRP planning schedule…

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

snip
1.
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?
4.11 Given the following product tree, complete the MRP records for parts X, Y, and Z. Note that parts X and Y have specified order quantities. Y(3) Z(1) W(1) Part X Week Gross Requirements Scheduled Receipts Lead Time: 1 week Projected Available 10 Net Requirements Planned Order Receipt Planned Order Release Part Y Gross Requirements Scheduled Receipts Lead Time: 2 weeks Projected Available 30 Net Requirements Lot Size: 50 Planned Order Receipt Part J Planned Order Release Gross Requirements Scheduled Receipts Lead Time: 1 week Projected Available Net Requirements Lot Size: lot-for-lot Planned Order Receipt Part K Planned Order Release Gross Requirements Scheduled Receipts Lead Time: 1 week Projected Available Lot Size: 400 Net Requirements Planned Order Receipt Planned Order Release Z(2) 1 2 3 4 5 285 15 5 15 10 10 15 20 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.
41. __________ is the level of competing messages on that medium. A. Clutter B. Reach C. Frequency D. Impact E. Noise 42. ____________ is an example of sales promotion to channel members. A. Product sampling B. Multiple-purchase offer C. Product placement D. Trade show E. Loyalty program 43. A coupon or special offer would contribute to the goal to _______________. A. Interest B. Remind C. Persuade D. Inform E. Action 44. ___________________ is a reason for Coke to invest in promotion. A. To maintain brand loyalty B. To reduce the tendency to switch to other brands C. To maintain corporate identity D. To encourage brand switching from competitors’ customers E. All of these are good reasons for Coke to promote 45. Major responsibilities of PR include __________. A. Gaining product publicity and buzz B. Securing event sponsorship C. Managing a crisis D. Both gaining product publicity and buzz and securing event sponsorship E. Gaining product publicity and buzz ,…

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