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

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 ordering for all other items. An MRP format including product structure tree is shpwing in the attached exel worksheet.

given the following data, construct material

Given the following data, construct a 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 ordering for all other items. An MRP format including product structure tree is shown in the attached excel worksheet. Use the format to solve your problem. Once you solve the problem copy the solution and paste it in the space given below for your answer. Please note, Bb will not save any of your answer in the excel

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!

Given the following data, construct a material requirements plan for component C to produce 1 7 5 units of Product FG by week 7 . Use order quantity ( Lot size ) 3 0 0 for producing item C and Lot...

I am having issues working these these 7 accounting problems, I need help answering them Problem 101 Specifications for a part for a DVD player state that the part should weigh between 24.6 and 25.6...

PART a and b please, thank you so much Question 4 (Total 30 marks). GIANT is a company that produces bicycles and sells them to retailers in China and Hong Kong markets. "Flying" (Figure 1) is one of...

The following product structure shows the components needed to assemble one unit of product A. The number in parentheses indicates how many units of that particular item are needed to make one unit...

I need help completing the highlighted "Project Available" and "Planning Releases" rows. Case 4.1: Apix Polybob goes with the Excel spreadsheet AutoSave = Case Study 4-1 MRP Table(1) - Excel Search...

Q1. Given the following diagram for a product, determine the quantity of each component required to assemble one unit of the finished product Q2 . Eighty units of end item E are needed at the...

1. The following table lists the components needed to assemble an end item, the manufacturing or purchase lead times (in weeks) for typical lot sizes, and the direct components of each item and, in...

Can you guys help me all of this questions? Thank you CASE STUDY 4.1 Apix Polybob Company Ken Mack, plant manager for the Apix Polybob Company, was having a heated discussion with Jack Gould, the...

Classify each of the costs as unit- related, batch- related, product- sustaining, or facility- sustaining. Use U for unit- related, B for batch- related, P for product- sustaining, and F for...

Diamond Furnishing inc. is about to start selling a new import coffee table. It estimates the demand curve to be q = D(p) = 1,000/200-2p. The willingness to order such a table is given by the supply...

1 x v v S Accessibility tab summary. A statement for stadent presentation is provided in row 2 . Adata table is provided in r 4 1 \ table [ [ A , B , C , D , E , F , 0 , H , 1 , 1 ] ] Laker Company...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...