Question: QUESTION 3 The MPS start quantities for product A calls for the assembly department to begin final assembly according to the following schedule: 100 units

QUESTION 3 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. LT = 2 B (1) C (2) LT = 1 LT 2 D (1) LT = 3 INVENTORY RECORD DATA Item Data Category B D Lot-sizing rule POQ (P =3) L4L FOQ = 500 units Lead time 1 week 2 weeks 3 weeks Scheduled receipts None 200 (week 1) None Beginning (on-hand) 20 0 425 inventory Use the following tables for you answers tem Lot Sa POP- Lead Time: 1 week Week 1 2 3 4 5 6 T . 10 Gross requirements Scheduled receipt Projected on-hand Inventory Planned receipts Planned order releases Temec Lot S: LAL Lead Time: 2 weeks Week 1 2 3 4 5 6 & 9 10 Gross requirements Scheduled receipts Projected on-hand Inventory Planned receipts Planned order releases Item D Lol Sire: FOO 500 units Lead Time: 1 week Week 1 2 3 4 5 6 7 8 9 Gross requirements Scheduled receipts Projected on hand inventory Planned receipt Planned order releases

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!

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...

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...

It is operations and supply chain management 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;...

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;...

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...

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:...

Repeat Prob. 811 with the addition of one 14R metric plain washer under the nut. Repeat Prob. 811, An M14 2 hex-head bolt with a nut is used to clamp together two 15-mm steel plates. (a) Determine a...

Suppose that x1, . . . , xn form a random sample from a distribution for which the p.d.f. f (x|) is as follows: Also, suppose that the value of is unknown ( -01 for-00

The sum of the carrying costs and the opportunity costs of a particular credit policy is called the Blank _ _ _ _ _ _ . Multiple choice question. credit cost curve carrying cost investment in...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...