# using the forecasting values you have

1. Pilt Week Wk4 Wk3 Wk2 Wk1 Forecast 3 4 5 4 Available 2 3 3 4 MPS 5 5 5 5 On hand 1

Relt

Week Wk4 Wk3 Wk2 Wk1 Forecast 4 3 4 4 Available 2 4 5 1 MPS 5 5 5
On hand 1

Stun

Week Wk4 Wk3 Wk2 Wk1 Forecast 3 4 4 3 Available 3 4 5 2 MPS 5 5 5
On hand 1

S stun

Week Wk4 Wk3 Wk2 Wk1 Forecast 1 2 2 1 Available 5 3 1 5 MPS 5

5 On hand 1

Generate an MPS for a period of four weeks by using the forecasting values you have generated in your assignment 1.

Depend on assignment 1 , use the forecast number for last four weeks, set the MPS to 5 on hand = 1

2.By using the MPS in question 1 and the above given BOM and Inventory Master File, generate the MRP matrices for all items and identify orders that are past due.

As the bill of material pile need 1A relt need 2 A , depends on this creat the MRP of component A

3.By using the MRP matrices in question 2, the company’s schedule notes and policies to identify two options in meeting the prospective shortages. What are the ramifications of each option? Which option would you recommend and why? Your report should include a copy of the MRP matrices as they would appear after the recommendations have been enacted.

Base on the MRP matrices above, there have a shortage in week 4 , there need 4 pilt relt stun and s.stun. we chose the first policy, the cost increase 10% per week. If we chose policy 3, the cost will increase 50%.

For pilt delay one week

Policy 1

One week per pilt increase 7

The cost will be 4x7x1=28

Policy 3

One week per pilt increase 35

The cost will be 4×35=140

Compare this without consider the capacity we chose the first policy to save money.

After modify (the order will delay one week )the new MRP will be ;

The post using the forecasting values you have appeared first on My Assignment Online.

This essay is written by:

Prof. SirMojo Verified writer

Finished papers: 435

Proficient in:

English, History, Business and Entrepreneurship, Nursing, Psychology, Management

You can get writing help to write an essay on these topics
100% plagiarism-free

Hire This Writer