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

PiltWk4Wk3Wk2Wk1
Gross requirements5555
Projected available balance | 1



Net requirements491419
Planned order receipt



Planned order release



ReltWk4Wk3Wk2Wk1
Gross requirements555
Projected available balance | 1



Net requirements4914
Planned order receipt



Planned order release



StunWk4Wk3Wk2Wk1
Gross requirements555
Projected available balance | 1



Net requirements4914
Planned order receipt



Planned order release



S StunWk4Wk3Wk2Wk1
Gross requirements5

5
Projected available balance | 1



Net requirements5

10
Planned order receipt



Planned order release



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.

A. Lt =1 size=1Wk4Wk3Wk2Wk1
Gross requirements1515155
Projected available balance | 0
00
Net requirements15304550
Planned order receipt



Planned order release



B. Lt =1 size=1Wk4Wk3Wk2Wk1
Gross requirements10555
Projected available balance | 0
50
Net requirements10152025
Planned order receipt



Planned order release



C. Lt =1 size=1Wk4Wk3Wk2Wk1
Gross requirements1010105
Projected available balance | 0



Net requirements10203035
Planned order receipt



Planned order release



D. Lt =1 size=1Wk4Wk3Wk2Wk1
Gross requirements10555
Projected available balance | 0



Net requirements10152025
Planned order receipt



Planned order release



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.


E. Lt =1 size=1Wk4Wk3Wk2Wk1
Gross requirements155510
Projected available balance | 0



Net requirements15202535
Planned order receipt



Planned order release



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 ;

PiltWk4Wk3Wk2Wk1
Gross requirements5555
Projected available balance | 1
1
1
Net requirements4
4
Planned order receipt10
10
Planned order release
10
10
ReltWk4Wk3Wk2Wk1
Gross requirements555
Projected available balance | 1
11
Net requirements4


Planned order receipt105

Planned order release
105
StunWk4Wk3Wk2Wk1
Gross requirements555
Projected available balance | 1
11
Net requirements4


Planned order receipt105

Planned order release
105
S StunWk4Wk3Wk2Wk1
Gross requirements5

5
Projected available balance | 1
111
Net requirements4


Planned order receipt5
5
Planned order release
5
5
A. Lt =1 size=1Wk4Wk3Wk2Wk1
Gross requirements1515155
Projected available balance | 0
00
Net requirements15
15
Planned order receipt30
20
Planned order release
30
20
B. Lt =1 size=1Wk4Wk3Wk2Wk1
Gross requirements10555
Projected available balance | 0
5
1
Net requirements10


Planned order receipt20
6
Planned order release
20
6
C. Lt =1 size=1Wk4Wk3Wk2Wk1
Gross requirements1010105
Projected available balance | 0


1
Net requirements10
10
Planned order receipt20
16
Planned order release
20
16
D. Lt =1 size=1Wk4Wk3Wk2Wk1
Gross requirements10555
Projected available balance | 0
5
1
Net requirements10


Planned order receipt20
6
Planned order release
20
6
E. Lt =1 size=1Wk4Wk3Wk2Wk1
Gross requirements155510
Projected available balance | 0

11
Net requirements15


Planned order receipt20610
Planned order release
20610

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
© 2017 theacademicessays. All Rights Reserved. Design & Developed by theacademicessays.
How to Avoid Plagiarism
  • Use multiple resourses when assembling your essay
  • Use Plagiarism Checker to double check your essay
  • Get help from professional writers when not sure you can do it yourself
  • Do not copy and paste free to download essays
Get plagiarism free essay
Loading...