Question

Problem 5 Eighty units of end item E are needed at the beginning of week 6....

Problem 5

Eighty units of end item E are needed at the beginning of week 6. Three cases (30 units per case) of J have been ordered and one case is scheduled to arrive in week 3, one in week 4, and one in week 5. Note: J must be ordered by the case, and B must be produced in multiples of 120 units. There are 60 units of B and 20 units of J now on hand. Lead times are two weeks each for E and B, and one week for J.

a.

Prepare a material requirements plan for component J.

b.

Suppose that in week 4 the quantity of E needed is changed from 80 to 70. The planned-order releases through week 3 have all been executed. How many more Bs and Js will be on hand in week 6?

Can someone please explain the formulas, and how to get the actual numbers needed to complete the problem? I get the concept, but struggling with the calculations needed to complete the problem.

Homework Answers

Answer #1

*Answer:

Step-by-step solution

  1. Step 1 of 4

    Master production schedule (MPS)

    This is the schedule made or plan executed, that determines the level of production, staffing, and inventory required to be maintained. This also helps in determining the bottleneck and estimating the demand level as and when may be needed.

    Material requirements planning (MRP)

    In MRP, requirements for MPS is planned in phased-wise manner thereby planning for components, sub-assemblies and parts.

    Comment

  2. Step 2 of 4

    Formulas used for calculations are as follows:

    POH = Planned-on-hand inventory

    POH (current period) = POH +planned-order receipts – Gross requirements (previous period) + schedule receipts (current period)

    Net requirement = Gross requirements – available inventory

    Available inventory = POH – safety stock – inventory allocated for other items

    Comment

  3. Step 3 of 4

    a.

    Eighty (80) cases of the end item are required at the beginning of week 6.

    Three (3) cases, 30 units per case, of J have been ordered, one each to arrive in weeks 3, 4 and 5.

    Comment

  4. Step 4 of 4

    b.

    Thus, it can be observed that additional units of B and J required are 20 and 30 units respectively.

    ***Please please like this answer so that I can get a small benefit. Please support me. Thankyou***

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
Problem 12-3 The following table lists the components needed to assemble an end item, lead times...
Problem 12-3 The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amount on Hand Direct Components End 3 0 L(2), C(1), K(3) L 3 9 B(2), J(3) C 4 14 G(2), B(2) K 4 19 H(4), B(2) B 3 27 J 4 32 G 4 5 H 2 0 a. If 43 units of the end item are to be assembled, how many additional units of...
The following table lists the components needed to assemble an end item, lead times (in weeks),...
The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item lead time Amount on Hand Direct Components End 3 0 L(2), C(1), K(3) L 3 12 B(2), J(3) C 4 15 G(2), B(2) K 4 21 H(4), B(2) B 3 32 J 4 27 G 4 5 H 3 0 a. If 43 units of the end item are to be assembled, how many additional units of B are...
The following table lists the components needed to assemble an end item, lead times (in weeks),...
The following table lists the components needed to assemble an end item, lead times (in weeks), and quantities on hand. Item Lead Time Amount on Hand Direct Components End 2 0 L(2), C(1), K(3) L 2 8 B(2), J(3) C 3 12 G(2), B(2) K 3 17 H(4), B(2) B 2 32 J 3 27 G 3 5 H 3 0 a. If 43 units of the end item are to be assembled, how many additional units of B are...
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of...
Question 5: Forecasting (8 p) The table below shows the demand (in units per quarter) of a specific product in the past three years. Quarter Year 1 2 3 4 2015 350 254 176 228 2016 367 258 169 236 2017 342 250 166 228 Predict demand in quarter 1 and quarter 2 of 2018, given that the demand forecast for the whole year is a total of 1,040 units. Question 6: DRP (8 p) A central DC supplies a...
In about 300 words, write an essay analyzing the below case study using the SWOT framework....
In about 300 words, write an essay analyzing the below case study using the SWOT framework. Johnson & Johnson Consumer Products, INC. Johnson & Johnson is a household name in baby-care as well as medical products. Nearly every family in the United States has in its house at least one product made by this company. Founded in 1885, Johnson & Johnson is currently an international enterprise, with 170 affiliated companies in fifty-five countries. J&J enjoys a reputation for high-quality products...
ABC Company, a retailer, prepares its master budget on a quarterly basis. The following data has...
ABC Company, a retailer, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master for the first quarter. a. As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances. ASSETS LIABILITIES AND EQUITY Cash $ 47,000 Accounts Payable $ 92,000 Accounts Receivable 224,000 Capital Stock 500,000 Inventory 60,000 Retained Earnings 109,000 Buildings and Equipment (net of depreciation) 370,000 TOTAL ASSETS...
Item 1 In the case below, the original source material is given along with a sample...
Item 1 In the case below, the original source material is given along with a sample of student work. Determine the type of plagiarism by clicking the appropriate radio button. Original Source Material Student Version A communication channel is the means by which messages get from one individual to another. The nature of the information-exchange relationship between a pair of individuals determines the conditions under which a source will or will not transmit the innovation to the receiver and the...
Item 1 In the case below, the original source material is given along with a sample...
Item 1 In the case below, the original source material is given along with a sample of student work. Determine the type of plagiarism by clicking the appropriate radio button. Original Source Material Student Version Major changes within organizations are usually initiated by those who are in power. Such decision-makers sponsor the change and then appoint someone else - perhaps the director of training - to be responsible for implementing and managing change. Whether the appointed change agent is in...
The project has been performing as planned, and the team members have been exhibiting increasing levels...
The project has been performing as planned, and the team members have been exhibiting increasing levels of trust between each other. The sponsor and the buyer have been satisfied with the delivery of business value, and user acceptance testing results are positive. A technical expert consulting with the team has expressed concerns that the team is not in agreement on the best way to deliver to the next review. If the project manager wants to support the team in reaching...
Read the case and answer the following Multiple choice questions. There are 5 questions total, where...
Read the case and answer the following Multiple choice questions. There are 5 questions total, where some of them might have more than one correct answers. You can choose more than one options where you think is suitable for the above question. PERFORMANCE MANAGEMENT Project Manager Oliver Caine skimmed his notes as he waited for Ben Robins to come to the meeting room. He hoped Ben would arrive soon, as he wanted to get the con-versation finished quickly. Ben walked...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT