Use the following bill of material information for all the MRP problems that follow.

Each X is made up of one Y and 2 Zs. Each Y is made up of 2 As and one B. Each Z is made up of 3 As 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.

Y

Use the following inventory information for the MRP problems that follow regarding Y:

Lot Size: 1,500

On Hand: 0

Safety Stock: 0

Allocated: 0

Lead Time: 0

12.) Which of the following periods have gross requirements for Y? Check all that apply.

Period 1

Period 2

Period 3

Period 4

Period 5

Period 6

Period 7

Period 8

13.) Which of the following periods have planned order releases of Y? Check all that apply.

Period 1

Period 2

Period 3

Period 4

Period 5

Period 6

Period 7

Period 8

14.) What is the projected on-hand at the beginning of period 1 for Y?

15.) What is the projected on-hand at the end of period 8 for Y?

16.) What is the planned order release for Y for period 1? If there is no planned order release, enter a zero.

17.) What is the planned order release for Y for period 2? If there is no planned order release, enter a zero.

18.) What is the planned order release for Y for period 3? If there is no planned order release, enter a zero.

19.) What is the planned order release for Y for period 4? If there is no planned order release, enter a zero.

20.) What is the planned order release for Y for period 5? If there is no planned order release, enter a zero.

21.) What is the planned order release for Y for period 6? If there is no planned order release, enter a zero.

22.) What is the planned order release for Y for period 7? If there is no planned order release, enter a zero.

23.) What is the planned order release for Y for period 8? If there is no planned order release, enter a zero.

Z

Use the following inventory for the MRP problems that follow regarding Z:

Lot Size: 4,000

On Hand: 800

Safety Stock: 0

Allocated: 0

Lead Time: 1

24.) Which of the following periods have planned gross requirements for Z? Check all that apply.

Period 1

Period 2

Period 3

Period 4

Period 5

Period 6

Period 7

Period 8

25.) Which of the following periods have planned order releases of Z? Check all that apply.

Period 1

Period 2

Period 3

Period 4

Period 5

Period 6

Period 7

Period 8

26.) What is the projected on-hand at the beginning of period 1 for Z?

27.) What is the projected on-hand at the end of period 8 for Z?

28.) What is the planned order release for Z for period 1? If there is no planned order release, enter a zero.

29.) What is the planned order release for Z for period 2? If there is no planned order release, enter a zero.

30.) What is the planned order release for Z for period 3? If there is no planned order release, enter a zero.

31.) What is the planned order release for Z for period 4? If there is no planned order release, enter a zero.

32.) What is the planned order release for Z for period 5? If there is no planned order release, enter a zero.

33.) What is the planned order release for Z for period 6? If there is no planned order release, enter a zero.

34.) What is the planned order release for Z for period 7? If there is no planned order release, enter a zero.

35.) What is the planned order release for Z for period 8? If there is no planned order release, enter a zero.

A

Use the following inventory information for the MRP problems that follow regarding A:

Lot size: 10,000

On Hand: 4,000

Safety Stock: 1,000

Allocated: 0

Lead Time: 2

Regardless of the values for Z computed above, use the following MRP grid for Z for the remaining questions. (That is, do not change your earlier answers but use the new values going forward.) These are not the correct answers for the questions above.

36.) Which of the following periods have gross requirements for A? Check all that apply.

Period 1

Period 2

Period 3

Period 4

Period 5

Period 6

Period 7

Period 8

37.) Which of the following periods have planned order releases of A? Check all that apply.

Period 1

Period 2

Period 3

Period 4

Period 5

Period 6

Period 7

Period 8

38.) What is the projected on-hand at the beginning of period 1 for A?

39.) What is the projected on-hand at the end of period 8 for A?

40.) What is the gross requirements for A for period 1? If there is no gross requirement, enter a zero.

41.) What is the gross requirements for A for period 2? If there is no gross requirement, enter a zero.

41.) What is the gross requirements for A for period 3? If there is no gross requirement, enter a zero.

42.) What is the gross requirements for A for period 4? If there is no gross requirement, enter a zero.

43.) What is the gross requirements for A for period 5? If there is no gross requirement, enter a zero.

44.) What is the gross requirements for A for period 6? If there is no gross requirement, enter a zero.

45.) What is the gross requirements for A for period 7? If there is no gross requirement, enter a zero.

46.) What is the gross requirements for A for period 8? If there is no gross requirement, enter a zero.

48.) What is the planned order release for A for period 1? If there is no planned order release, enter a zero.

49.) What is the planned order release for A for period 2? If there is no planned order release, enter a zero.

50.) What is the planned order release for A for period 3? If there is no planned order release, enter a zero.

51.) What is the planned order release for A for period 4? If there is no planned order release, enter a zero.

52.) What is the planned order release for A for period 5? If there is no planned order release, enter a zero.

53.) What is the planned order release for A for period 6? If there is no planned order release, enter a zero.

54.) What is the planned order release for A for period 7? If there is no planned order release, enter a zero.

55.) What is the planned order release for A for period 8? If there is no planned order release, enter a zero.

******Please show all steps to get to answers including formulas in excel.*********

0 2 4 6 7 700 500 700 900 600 800 Gross Requirements Scheduled Receipts Projected on Hand (Beginning) 2000250023001001000300600700 200 Projected on Hand (Ending) | 2300 | 1800 | 1000 300 | 600 700 0 800 Net Requirements Planned Order Receipts Planned Order Releases 1100 500 500 500 600 500 1200 1200 1200 12001200 1200 0 2 4 6 7 700 500 700 900 600 800 Gross Requirements Scheduled Receipts Projected on Hand (Beginning) 2000250023001001000300600700 200 Projected on Hand (Ending) | 2300 | 1800 | 1000 300 | 600 700 0 800 Net Requirements Planned Order Receipts Planned Order Releases 1100 500 500 500 600 500 1200 1200 1200 12001200 1200