Question: answer in excel with detail please LT = 2 Problem 4: 10 pts The MPS start quantities for product A calls for the assembly department

answer in excel with detail please

LT = 2 Problem 4: 10 pts The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following schedule: 100 units in week 2; 200 units in week 4 120 units in week 6; 180 units in week 7 60 units in week 8. Develop a material requirements plan for the next 8 weeks for items B, C, and D. INVENTORY RECORD DATA B (2) C (1) LT=1 LT 2 D (2) LT3 Data Category Lot-sizing rule Lead time Scheduled receipts Beginning (on-hand) inventory POQ (P3) 1 week None Item LAL 2 weeks 100 (week 1) 0 FOQ 500 units 3 weeks None 20 425

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

topic: production & inv. system please use excel, and provide clear steps Problem 3: 10 pts Companys pays regular-time wages of $5,000 per employee per period for any time worked up to 500 hours...

The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following schedule: 100 units in week 2; 200 units in week 4;120 units in week 6; 180...

Excel please The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following schedule: B 100 units in week 2; 200 units in week 4 120 units...

solve in excel WITH THE EQUATIONS USED LT = 2 B (2) C(1) The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following schedule: 100...

solve in excel and show the equations and steps you used LT = 2 B (2) C(1) The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following...

solve on excel and show the equations used!! LT = 2 B (2) C(1) The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following schedule:...

Use Excel to complete the MRP explosion for Items B, C, and D based on the information collected from the Operations, Engineering, and Purchasing managers. Point: 2.5% of total grade or 25 points out...

Please show how you calculated the answers Use the bill of materials and inventory records to determine the MRP for components A and D for week 1 through week 5. The MPS start quantities for the end...

The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following schedule: 100 units in week 2; 200 units in week 4; 120 units in week 6;...

\ In a one-dimensional system at time t-0, the wave function of a particle is given by the function (-Ar2 for 0SXSL V(x,0) - elsewhere -A LA as sketched in the diagram, where A is a positive...

How might the difficulties of matrix organization change when implementing virtual projects?

16. Every student except Charles and Norman passed the course. The only student who was dismissed was Norman. Every student retook the course if and only if he or she was not dismissed and did not...

What is an example of constructive feedback? provide reference