Question

In: Operations Management

A table is assembled using three components, as shown in the accompanying product structure tree. The...

A table is assembled using three components, as shown in the accompanying product structure tree. The company that makes the table wants to ship 100 units at the beginning of day 4, 150 units at the beginning of day 5, and 200 units at the beginning of day 7. Receipts of 100 wood sections are scheduled at the beginning of day 2. There are 120 legs on hand. An additional 10 percent of the order size on legs is added for safety stock. There are 60 braces on hand with no safety stock requirement for braces. Lead times (in days) for all items are shown in the following table. Prepare a material requirements plan using lot-for-lot ordering.

Can someone verify the data for the legs for me?

Solutions

Expert Solution

There are 120 legs on hand. An additional 10 percent of the order size on legs is added for safety stock

See, here logic is simple but adding 10% will make it look complex but really not.

Whatever the net requirement arises for the particular day, to that you need to add 10% as safety stock.

For example consider there is a requirement of 400 legs on day 3.

You had already on hand inventory of 120 units.

Net requirement is 400-120=280

As mentioned you need to keep 10 percent safety stock=280*0.1=28

Actual Net requirement Including safety stock=280+28=308.

Similarly assume you have gross requirement of 600 units on day 4

You have 0 on hand inventory

Then Net requirement will 600 units

10 percent safety stock =600*0.1=60 units

Actual Net requirement = 600+60 =660 Units.

Similarly in this manner safety stock will be maintained every day.

In other words the simple calculation is we require 100% of requirement and maintain 10%stock. We can directly multiple net requirement 1.1 to obtain actual net requirement including safety stock.(1.1 is because to obtain 110%).

I tried my best to give picture without your complete question that MRP tree and other details, else it may be possible to explain some what more easier and clear

If you need any further assistance please drop a message. Thank you.Please like the answer.


Related Solutions

Problem 1. Using the INVOICE table structure shown in table below do the following: INVOICE Attribute...
Problem 1. Using the INVOICE table structure shown in table below do the following: INVOICE Attribute Name Sample Value Sample Value Sample Value Sample Value Sample Value INV_NUM 211347 211347 211347 211348 211349 PROD_NUM AA-E3422QW QD-300932X RU-995748G AA-E3422QW GH-778345P SALE_DATE 15-Jan-2016 15-Jan-2016 15-Jan-2016 15-Jan-2016 16-Jan-2016 PROD_LABEL Rotary sander 0.25-in. drill bit Band saw Rotary sander Power drill VEND_CODE 211 211 309 211 157 VEND_NAME NeverFail, Inc. NeverFail, Inc. BeGood, Inc. NeverFail, Inc. ToughGo, Inc. QUANT_SOLD 1 8 1 2 1...
The components of GDP in the accompanying table were produced by the Bureau of Economic Analysis....
The components of GDP in the accompanying table were produced by the Bureau of Economic Analysis. Category Components of GDP in 2013 (billions of dollars) Consumer spending Durable goods $1,263.0 Nondurable goods 2,622.9 Services 7,615.7 Private investment spending Fixed investment spending 2,564.0 Nonresidential 2,047.1 Structures 456.4 Equipment and intellectual property products 1,590.7 Residential 516.9 Change in private inventories 106.1 Net exports Exports 2,259.9 Imports 2,757.2 Government purchases of goods and services and investment spending Federal 1,245.9 National defense 770.7 Nondefense...
Given the accompanying network diagram, with times shown in days. Use Table B1 and Table B2....
Given the accompanying network diagram, with times shown in days. Use Table B1 and Table B2. a. Determine the expected duration of the project. (Round intermediate calculations to 2 decimal places and final answer to 1 decimal place.) Expected Duration             b. Compute the probability that the project will take at least 18 days. (Round intermediate calculations to 2 decimal places and "Probability" values to 4 decimal places.) Probability             Chuck’s Custom Boats (CCB) builds luxury yachts to...
Data from a small bookstore are shown in the accompanying table. The manager wants to predict...
Data from a small bookstore are shown in the accompanying table. The manager wants to predict Sales from Number of Sales People Working. Complete parts a through h below. Number of ales peaople working sale (in $1000) 2 10 3 12 5 14 8 15 10 19 10 21 13 21 14 22 17 22 19 27 x(bar)= 10.1 y(bar)=18.3 SD(x)=5.74 SD(y)=5.33 A) find the slope etimate, b1. B) What does b1 mean, in thi context? C) Find the intercept,...
A product is being assembled and packaged on three production lines (line A, line B, and...
A product is being assembled and packaged on three production lines (line A, line B, and line C). Each day, the quality control team selects a production line and inspects a batch chosen at random from the output of the selected production line. Line A is selected with probability .5, line B is selected with probability .2, and line C is selected with probability .3. The probability that no defects will be found in a batch selected from line A...
1. The economy of Britannica produces three goods: computers, DVDs, and pizza. The accompanying table shows...
1. The economy of Britannica produces three goods: computers, DVDs, and pizza. The accompanying table shows the prices and output of the three goods for the years 2012, 2013, and 2014. Computers DVDs Pizzas Year Price Quantity Price Quantity Price Quantity 2012 $700 12 $12 120 $22 4 2013 $825 12.5 $14 125 $23 7 2014 1,150 14 $15 138 $24 9 Calculate nominal GDP in Britannica for 2012,2013,2014;What is the GDP Growth rate from 2012 to 2014? Calculate real...
Relationship between future value and present value: Mixed stream. Using the information in the accompanying table,...
Relationship between future value and present value: Mixed stream. Using the information in the accompanying table, answer the questions that follow. Year Cash Flow 0 0 1 800 2 900 3 1000 4 1500 5 2000 a.Determine the present value of the mixed stream of cash flows, using a 5% discount rate. b. Suppose you had a lump sum equal to your answer in part a on hand today. If you invested this sum for 5 years and earned a...
Code using C++ A binary search tree is a data structure designed for efficient item insertion,...
Code using C++ A binary search tree is a data structure designed for efficient item insertion, deletion, and retrieval. These 3 operations share an average run time complexity of O(log(n)). Such time complexities are guaranteed whenever you are working with a balanced binary search tree. However, if you have a tree that begins leaning heavily to either its left or right side, then you can expect the performances of the insertion, deletion, and retrieval operations to degrade. As an example,...
When using the Sequencing and Structure Alignment tool, the degree of the structural similarity is shown...
When using the Sequencing and Structure Alignment tool, the degree of the structural similarity is shown by the superimposition of the backbones. Accordingly, which of the following statement best describes the comparison of deoxyhemoglobin and oxyhemoglobin? A. Only slight differences in the backbone traces occur throughout the aligned proteins. B. The only differences in the backbone traces occur near the oxygen-binding sites. C. The backbone traces of the proteins are drastically different. D. The backbone traces of the proteins are...
Discuss the difference between product cost and period cost. Identify three major components of product cost...
Discuss the difference between product cost and period cost. Identify three major components of product cost Compare and contrast Master budget and flexible budget. Which of the two budgets is more useful for performance evaluations.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT