Solve the problem below Considering the information below, explode the MRP sched
ID: 432852 • Letter: S
Question
Solve the problem below Considering the information below, explode the MRP schedule for the next 10 weeks and answer the questions Order Sire Lead Time Holding Cost Setup (orderingl Cost 1 week per unit per week 100 per order Solution: Order Sire Lead Time Holding Cost Setup (orderingl Cost Lot for Lat l weck 1 per unit per week 00 per arder 50 50 Questions Total Holding Cost Total Ordering Cost What is the impact if holding costs are $2 per unit per week? Please include all excel formulas for all empty grey cells. Thank you!!Explanation / Answer
ANSWER;-
Week plane.
0
1
2
3
4
5
6
7
8
9
10
Gross Requirement
0
50
50
100
100
50
50
100
100
50
50
Schedule receipt
Projected on hand Inventory
50
0
0
0
0
0
0
0
0
0
0
Net Requirement
50
100
100
50
50
100
100
50
50
0
Planned Receipt
50
100
100
50
50
100
100
50
50
Planned release
50
100
100
50
50
100
100
50
50
Total Holding cost
50
Total Ordering cost
900
If holding cost $2/week
100
If the Lot for lot is also called as discrete ordering process where planned quantities is equal to net requirement & no extra on hand inventory. Basically done for the perishable items.
ANSWER;-
Week plane.
0
1
2
3
4
5
6
7
8
9
10
Gross Requirement
0
50
50
100
100
50
50
100
100
50
50
Schedule receipt
Projected on hand Inventory
50
0
0
0
0
0
0
0
0
0
0
Net Requirement
50
100
100
50
50
100
100
50
50
0
Planned Receipt
50
100
100
50
50
100
100
50
50
Planned release
50
100
100
50
50
100
100
50
50
Total Holding cost
50
Total Ordering cost
900
If holding cost $2/week
100
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.