Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

MRP for X: 1. Which of the following periods have planned order releases of X? P

ID: 373728 • Letter: M

Question

MRP for X:

1. Which of the following periods have planned order releases of X?

Period 1, 3, 4, 5, 6

2. What is the projected on-hand at the beginning of period 1 for X?

1300 units

3. What is the projected on-hand at the ending of period 8 for X?

500 units

4.) What is the planned order release for X for period 1? 1000 units

5.) What is the planned order release for X for period 2? 0

6.) What is the planned order release for X for period 3? 1000 units

7.) What is the planned order release for X for period 4? 1000 units

8.) What is the planned order release for X for period 5? 1000 units

9.) What is the planned order release for X for period 6? 1000 units

10.) What is the planned order release for X for period 7? 0

11.) What is the planned order release for X for period 8? 0

Period 1 2 3 4 5 6 7 8 Item X Gross Requirements 700 500 800 700 900 1100 500 600 OH= 1300 Scheduled Receipts 0 0 0 0 0 0 0 0 LT = 1 Projected Available Balance (Beginning) 1300 600 1100 300 600 700 600 1100 Projected Available Balance (End) 600 1100 300 600 700 600 1100 500 SS = 300 Net Requirements (Including safety stock) 0 200 0 700 600 700 200 0 Q = 1000 Planned Order Receipt 0 1000 0 1000 1000 1000 1000 0 Planned Order Release 1000 0 1000 1000 1000 1000 0 0

Explanation / Answer

Use the following bill of material information for all the MRP problems that follow. Each X is made up of one Y and 2 Z’s. Each Y is made up of 2 A’s and one B. Each Z is made up of 3 A’s and one C. Use the following information for the MRP problems that follow regarding X. Gross requirements for periods 1-8 are: 700, 500, 800, 700, 900, 1,100, 500, and 600. The inventory information follows: Lot Size: 1,000 On Hand: 1,300 Safety Stock: 300 Allocated: 0 Lead Time: 1 1.) Which of the following periods have planned order releases of X? Check all that apply. Period 1 Period 2 Period 3 Period 4 Period 5 Period 6 Period 7 Period 8 2.) What is the projected on-hand at the beginning of period 1 for X? 3.) What is the projected on-hand at the ending of period 8 for X? 4.) What is the planned order release for X for period 1? If there is no planned order release, enter a zero. 5.) What is the planned order release for X for period 2? If there is no planned order release, enter a zero. 6.) What is the planned order release for X for period 3? If there is no planned order release, enter a zero. 7.) What is the planned order release for X for period 4? If there is no planned order release, enter a zero. 8.) What is the planned order release for X for period 5? If there is no planned order release, enter a zero. 9.) What is the planned order release for X for period 6? If there is no planned order release, enter a zero. 10.) What is the planned order release for X for period 7? If there is no planned order release, enter a zero. 11.) What is the planned order release for X for period 8? If there is no planned order release, enter a zero. ***Please show all steps to get to answers 9i.e. Excel spreadsheet with formula.)***

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Chat Now And Get Quote