Question: MRP Problem (A) The MRP record shown below has been partially completed, showing gross requirements, scheduled receipts, and current on-hand inventory. Lead-time and safety stock

MRP Problem (A) The MRP record shown below has been partially completed, showing gross requirements, scheduled receipts, and current on-hand inventory. Lead-time and safety stock factors are also shown. a. b. C. d. Complete the remaining rows of the record using FOQ of 150 units. Complete the remaining rows of the record using POQ Iot-sizing rule with P = 2. Complete the remaining rows of the record using L4L lot sizing rule. If the set-up cost is $200 and holding cost is $1.50 per item per week, what would be the EOQ for this data? Compare the total cost of each of these methods. e. Item: Lot Size = Lead Time 2 Safety Stock - 0 Date 1 2 3 4 5 6 7 00 9 10 100 50 75 50 80 35 40 Gross Requirements Scheduled Receipts On Hand/Proj. Avail = 40 80 Net Requirements Planned Receipts Planned Releases

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

We're going to attempt some MRP Tables with this learning exercise. Let's see how well it goes. (This was a tough one to develop!) We need the following three sources of information for the Material...

please answer question 1,2,3 ? Background - Doug's Dens doghouses Analysis Q1 ( using MRP effectively ?) Q2 Recommedation Q3 (MRP Implementation) 276 PART Tools and Tactical issues CASE STUDY Doug's...

1. 2. 3. Master Production Schedule which shows the quantities of our end item (a flash drive) that have to be shipped each week: 2 6 8 Week Quantity 1 600 450 3 550 4 350 5 600 700 7 650 750 Bill of...

11. Consider the bill of materials (BOM) in Figure 11.33. a. How many immediate parents (one level above) does item I have? How many immediate parents does item \$ \\mathrm{E} \$ have? b. How many...

Mary's Masks Inc. OPER2210 - MRP Case Study Hand-In - Winter 2021. Mary's Mask Inc. had started as a small business in the owner's house, making pet coats and bandanas, Once the COVID pandemic...

Build and describe an Excel model to recommend quantitative target inventory levels under HP's current supply chain design for the 6 European options assuming a weekly (periodic review) replenishment...

Problem 19 Question Help The figure below shows a partially completed inventory record for the real wheel subassembly. Gross requirements, scheduled receipts, lead time, and current on-hand inventory...

please help with all of the blanks w Score: 1.970,97 13 pts Problem 19 Question Help The figure below shows a partially completed inventory record for the real whoel subassembly, Gross requirements,...

please give solution to this whole question 14 chapter 6. coarse instruction 161 Why 1. Usip 14 TMC ABC Coily for the VEI. MES fondu Ye Master Production Schedule 1 2 3 We Number 4 5 6 Product 10 25...

Please help, I need the MRP form completed. If possible, can you also provide the formulas within the cells as well as the numbers? The assignment is due tonight and will be much appreciated if...

Why would a companys return on total assets be different from its return on common shareholders equity?

What is wrong with this statement of purpose? PURPOSE: Determine if a newly designed roller-ball pen is comfortable to hold when writing. Give an improved statement of purpose.

Explain how value engineering could help in this process. Problem 2 Capital investment analysis including environmental factors: manufacturer Olympic Chemicals Ltd wants to purchase cooling systems...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...