Question

MRP IN MANUFACTURING 1. Each E subassembly is made up of 6 G parts, 20 H...

MRP IN MANUFACTURING 1. Each E subassembly is made up of 6 G parts, 20 H parts, and ONE J part. Draw the product structure tree diagram. Using the product structure tree diagram and the information provided below, Completeth e following MRP Report Transaction processing for PART E and PART G ONLY if the following information is provided: ( Do not order more quantity of any resources that are needed to maintain the production)

E subassembly G part H part J part
Order Lot size 200 250 1000 1200
Lead time 0wk 1wk 2wks 2wks
On hand 200 300 700 700
Safety Stock 100 50 150 400
Scheduled Receipt 1000, 200 500, 900 600 500
Part E 1 2 3 4 5 6
Gross Required 1500 1200 800 1000 900 600
Scheduled Receipt 1000 200
Available
Net Requirement
Planned Order Receipt
Planned Order Released
Part G 1 2 3 4 5 6
Gross Required
Scheduled Receipt 500 900
Available
Net Required
Planned Order Receipt
Planned Order Release

Homework Answers

Answer #1

We can solve this question in excel using following formula:

This will give our final solution as :

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Given the following data, develop MRP tables and indicate the Planned order releases for all items....
Given the following data, develop MRP tables and indicate the Planned order releases for all items. A is an MPS item. A needs 2 C's and 3 F’s. F needs 3 C’s. (I eliminated scheduled receipts since the problem did not have scheduled receipts.) Period 6 7 8 GR-A 400 0 300 On hand inventory for all items is 200 and lead time for A is 1 period, and LT for all other items is 2 periods. Use lot-for-lot for...
Product A is assembled from 6 components. The components are B, C, D, E, F, G....
Product A is assembled from 6 components. The components are B, C, D, E, F, G. Components B, D, and F are purchased from a supplier, complete and ready to assemble. Component C is assembled from parts H, I, and J. Component E is assembled from parts K and L. Component G is made in the plant from raw materials. Part H is made from parts M and N. Part L is made from parts P, Q, and R. Part...
Product Y is made from one component P, three components Q, and one 2 components R.  P...
Product Y is made from one component P, three components Q, and one 2 components R.  P is made from two parts S, Q is made from one S, and R is made from two part S and three part T.  Other data includes: Part                 Lead time             Lot size                   On hand                 Scheduled receipts         Safety Stock Y                         1                                 lot-for-lot               30                                              none                                          5 P                        2                                   40                              15                                              none                                          none Q                        2                                 100                               8                                               none                                          8 R                        3                                 120                             30                                              none                                          none S                         2                                 500                             20                                              500, week 1                          20 T                         2                                 600                           370                                             none                                          50 a.    Draw the BOM for product Y. b. Complete the MRP explosion for product Y.  Identify any problems, and discuss possible solutions Master Production Schedule Finished...
Do the following problems. 1. Each of three barrels from a manufacturing line are classified as...
Do the following problems. 1. Each of three barrels from a manufacturing line are classified as either above (a) or below (b) the target weight. Provide the ordered sample space. 2. The heat on each of two soldered parts is measured and labeled as either low (l), medium (m), or high (h). State the number of elements in the ordered sample space. 3. Consider the set of Beatles songs with a primary writer as either Paul McCartney (P) or John...
QUESTION 1 Match the correct answer to the question. Each option may be used more than...
QUESTION 1 Match the correct answer to the question. Each option may be used more than once.    When would Cost of Goods Sold be debited?    When would Manufacturing Overhead be debited? When would Finished Goods be debited?    When would Manufacturing Overhead be credited? When would Finished Goods be credited? A. to record actual indirect labor, actual indirect materials, rent or accumulated depreciation on the plant, actual utility expense incurred. B. when goods are finished. C. when good...
You are required to write a Business Plan Report and you are advised to follow the...
You are required to write a Business Plan Report and you are advised to follow the below given outline.  Part I- Product/service idea Business Plan Report (40%) To make the best impression, a business plan should follow a convention structure, such as the outline shown below. Cover page Table of contents 1. Executive Summary  A succinct highlight of the overall plan- include ownership structure, business address, product/service, the management team and strategy and strengths. 2. Industry Analysis ...
1. What is an ISP (Integrated Service Provider) for supply chains? (1 point) A. A consultant...
1. What is an ISP (Integrated Service Provider) for supply chains? (1 point) A. A consultant agency which integrates the supply chain for companies B. A 2 PL or a 3PL, but not a 4PL C. A company supplying transportation and warehousing services D. A logistics service company specialized in suppling VAS (value added services) 2. What characterizes a 4 PL? (1 point) A. They are non-asset based and provides integrated services primarily supplied by asset based providers, for example...
Tax Return Project James A. Varney and Denise M. Varney James and Denise Varney are married...
Tax Return Project James A. Varney and Denise M. Varney James and Denise Varney are married and file a joint return. James is 48 years of age and Denise is 49. James is employed full-time as an electrical engineer for Livingston Unitech Corporation, Ltd. Denise is a self-employed design consultant. They have two children, Pamela and Vernon, who live at home and receive all of their support from their parents. Pamela is 20 years old and attended college on a...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT