Question: How do I solve this problem on Excel or Sheets Problem02: Use the following product structure tree to develop the MRP plan for the components

How do I solve this problem on Excel or Sheets

Problem02: Use the following product structure tree to develop the MRP plan for the components A and B. Finished product X will be shipped 110 quantities at the start of week 6 and 100 quantity at the start the week 7 . One case of A (50 units in one case) is scheduled at week 4,5,6,7 and One case of B ( 30 units in one case) is scheduled at week 5, 6 . There are 30 units of A and 10 units of B now on hand. Lead time for all the components is one week

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!

Please solve the following problems. Problem 0 1 : Use the following product structure tree to develop the MRP plan for components A and B . Finished product x will be shipped 1 2 0 quantities at the...

Problem 0 1 : Use the following product structure tree to develop the MRP plan for components A and B . Finished product x will be shipped 1 2 0 quantities at the start of week 6 and 9 0 quantity at...

Use the following product structure tree to develop the MRP plan for components A and B . Finished product x will be shipped 1 2 0 quantities at the start of week 6 and 9 0 quantity at the start the...

Use the following product structure tree to develop the MRP plan for the components A and B . Finished product X will be shipped 1 1 0 quantities at the start of week 6 and 1 0 0 quantity at the...

Question 0 2 : Use the following product structure tree to develop the MRP plan for the components A and B . Finished product x will be shipped 1 0 0 quantities at the start of week 6 and 9 0...

Case Laila Hasan the production manager for Custom Industrial Mowers was beginning to prepare a net Material Requirements Plan for the next 10 weeks of production for their popular mower, the Grass...

PART # PARENT 1 2 3 4 5 6 LOT SIZE GROSS REQ SCHED. RECEIPTS LEAD TIME ON HAND PROJ. INVENTORY SAF. STOCK NET REQ PLAN ORD. RECEIPT Low level CODE_ PLAN ORD.RELEASE PART # PARENT 1 2 3 4 5 6 LOT SIZE...

A company produces an end item 'C', which is composed of three subassemblies: 3 units of D, 1 unit of E, and 2 units of F. D is made of 1 R and 2 Ss; E is assembled using 1 T and 3 Us; and F is made...

Laboratory: Production Planning (PP, MPS, MRP) Objectives: to perform:- i) Aggregate Production Plan using the level production, step plan, and demand matching" strategies ii) Master Production...

given the following data, construct material requirements plan for component C to produce 200 units of product FG by week 8. use order quantity (lot size) 300 for producing item C and lot for lot...

Consider two days when the air temperature is the same but the humidity is different. Which is more dense, the dry air or the humid air at the same T? Explain.

Following are the issuances of stock transactions. 1. A corporation issued 4,000 shares of $10 par value common stock for $48,000 cash. 2. A corporation issued 2,000 shares of no-par common stock to...

What are the financing options for entrepreneurs looking to start their own business?.

Sketch the activity on arrow arrow network diagrams from each logic table, labeling the activities. Show your different attempts if you wish. Yes you can use additional paper. Be sure to check each...

4. Think of a situation where you would convince someone of an argument or an idea you had. a. What feelings did you want the other person to be left with when you finished? b. When you think about...

7. Think of a situation where you felt that you mastered the situation, i.e. where you had a positive feeling of completing the task you were to perform. A. Now develop a picture in your imaginary...

6. Think of something that you believe in, without the slightest doubt attached to it. How do you imagine this? Is it verbal, in rumours, in metaphors or the like? The answer says something about how...