The partially completed inventory record for the rotor subassembly in the table below shows gross requirements, scheduled receipts, lead time, and current on hand inventorya. 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 subassemblyGrossrequirementsScheduled:receiptsProjected on hand iinventoryPlannedreceipts15165160210335445Lot Size: FOQ-160 unitsLead Time: 2 weeksWeek580680N750880399999

MRP stands for Material Requirements Planning. It is a computer-based inventory management system…

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

Shown below is a partially completed MPS record for hand drills. a. Develop the MPS record for the hand drills. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Hand drills Quantity on Hand: 30 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start 1 15 20 N 40 25 3 15 15 Week Available-to- promise (ATP) inventory b. A distributor of the hand drills places an order for 15 units. What is the appropriate shipping date for the entire order? The order should ship on week (Enter your response as an integer.) 4 20 20 Order Policy: 60 units Lead Time: 1 week 5 55 0 6 35 0
Complete the MPS record below for an end item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Order Policy: 100 units Lead Time: 2 weeks Quantity on Hand: 80 Week 1 2 3 4 5 6 7 8 9 10 Forecast 25 25 35 45 25 20 45 55 Customer orders 25 30 7 11 (booked) Projected on-hand inventory MPS quantity
A factory has just received an order for 100 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. Item Lead Time (weeks) On Hand Inventory Scheduled receipts Order Policy Direct Components End item 2 30 lot for lot A(4), B(3), C(2) A 3 20 54 at week 3 lot for lot D(2) B 2 10 68 at week 4 lot for lot D(5) C 1 100 multiple of 60 D 1 20 min. of 500 Develop the material requirements plan (please print out an empty MRP table to work with), and determine what the "projected available balance" is for component D at week 8. Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
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 subassembly Gross requirements Scheduled receipts Projected on-hand inventory Planned receipts 15 1 65 160 H 2 10 3 50 4 35 Lot Size: FOQ-160 units Lead Time: 2 weeks Week 5 80 6 80 7 80 8 80 000 0000 0000
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
Heather Adams, production manager for a Colorado exercise equipment manufacturer, needs to schedule an order for 50 UltimaSteppers, which are to be shipped in week 9. Subscripts indicate quantity required for each parent. Assumelot-for-lot ordering. c) Develop a net material requirements plan for F (enter your responses as whole numbers). Week Lead Time Item 2 3 4 5 6 7 8 9 (weeks) F Gross req Insert answer insert answer 2 On hand insert answer insert answer Net req insert answer insert answer Order receipt insert answer insert answer Order release insert answer insert answer
Shown below is a partially completed MPS record for ball bearings. Part 2 a. Develop the MPS for ball bearings. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: Ball bearings Order Policy: 500 units Lead Time: 1 week Quantity on Hand: 400 Week 1 2 3 4 5 6 7 8 9 10 Forecast 550 350 350 450 250 300 250 350 400 350 Customer orders (booked) 300 350 250 300 150 150 150 150 100 50 Projected on-hand inventory enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here enter your response here MPS quantity 500 enter your response here enter your response here enter your response here enter your…
Assume you are the manager of a shop that assembles power tools. You have just received an order for 55 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws follows: Item Lead Time (weeks) On Hand Saw A B C D E F 2 1 2 2 1 1 2 Gross requirements Scheduled receipts Projected on hand Net requirements Planned order receipt Planned order release Ĉ E(3) & E(2) LT = 1 week Lot size: Lot-for-Lot 15 10 5 65 20 10 30 Skip Extension Tip: Double click to open in new tab Show Transcribed Text Develop the material requirements plan for component E using lot-for-lot ordering for all items. (Leave no cells blank - be certain to enter "0" wherever required.) Components A(2), B(1), C(4) E(3), D(1) D (2), F(3) E(2), D (2) Beg. Inv. 1 2 3 190 5 210 6
14.26. Calculate the available-to-promise row in the following matrix: Period On Hand = 100 1 2 3 4 5 6 Forecast 50 100 50 100 50 100 Customer Orders 50 125 75 175 45 15 Master Production 200 200 Schedule Available-to-Promise
The partially completed inventory record for the driveshaft subassembly in the table below hows gross requirements, scheduled receipts, lead time, and current on-hand inventory. 1. Complete the last three rows of the record for an FOQ of 55 units. (Enter your responses as ntegers. A response of "0" is equivalent to being not applicable.) tem: Driveshaft subassembly Gross equirements Scheduled eceipts Projected on-hand nventory Planned eceipts 15 1 40 70 2 25 3 10 4 20 Lot Size: FOQ = 55 units Lead Time: 3 weeks Week 5 50 88888 (0) 6 50 7 40 8 40
Complete the MPS record below for a single item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: A Quantity on Hand: 80 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity 1 70 40 ☐☐ January 2 70 65 80 Order Policy: 100 units Lead Time: 1 week February Week 4 40 0 5 45 35 50 70 45 0 8 50 0
The following Table 1 presents the results of the XYZ Company's ERP system for expenditure cycle activities. It shows the number of times each employee performed a specific task. Table 1 Employee A Employee B Employee C Employee D Employee E Employee F Employee G Employee H Employee 1 Order Inventory 150 306 Maintain Supplier Master File (add, delete, edit) 7 Receive Inventory 425 300 Approve Supplier Invoices for Payment 5 10 10 400 Pay Suppliers Via EFT 100 10 Sign Mail Checks Checks 100 10 150 100 125 25 Reconcile Bank Account 1 Requirements: 1. Ready and exam the information provided in Table 1, and pay attention to the tasks performed by each employee (Hint: which employee performed what tasks?) 2. Identify 5 cases where the segregation of duties was violated as employees performed their tasks (Hint: at least 5 employees violated segregation of duties). 3. Then, use Table 2 (provided in next page) to complete this assignment. 4. For each case you have identified, answer questions…

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