Question

In: Operations Management

Problem 12-9 Assume that you are the manager of a shop that assembles power tools. You...

Problem 12-9

Assume that you are the manager of a shop that assembles power tools. You have just received an order for 60 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws is

Item Lead Time (weeks) On Hand Components
Saw 2 15 A(2), B(1), C(4)
A 1 10 E(3), D(1)
B 2 5 D(2), F(3)
C 2 65 E(2), D(2)
D 1 20
E 1 10
F 2 30

  
Develop the material requirements plan for component E using lot-for-lot ordering. (Leave no cells blank - be certain to enter "0" wherever required.)
  

Item: E(3) & E(2) LT = 1 wk. Beg. Inv. 1 2 3 4 5 6 7 8
Gross requirements
Scheduled receipts   
Projected on hand
Net requirements
Planned order receipt
Planned order release

Solutions

Expert Solution

Information given is as under:

Product structure is shown below:

Component E is required in Component A and Component C.

To derive the MRP for Component E, the MRP of Item Saw, Component A and Component C has to be derived first.

60 units of Chain Saw is to be shipped in beginning of week 8, so it should be ready by end of week 7. Hence the gross requirement is 60 in Week 7.

Item: Saw LT = 2 wk.

Beg. Inv.

1

2

3

4

5

6

7

8

Gross requirements

0

0

0

0

0

0

60

0

Scheduled receipts

0

0

0

0

0

0

0

0

Projected on hand

15

15

15

15

15

15

15

0

0

Net requirements

0

0

0

0

0

0

45

0

Planned order receipt

0

0

0

0

0

0

45

0

Planned order release

0

0

0

0

45

0

0

0

Item: A LT = 1 wk.

Beg. Inv.

1

2

3

4

5

6

7

8

Gross requirements

0

0

0

0

90

0

0

0

Scheduled receipts

0

0

0

0

0

0

0

0

Projected on hand

10

10

10

10

10

0

0

0

0

Net requirements

0

0

0

0

80

0

0

0

Planned order receipt

0

0

0

0

80

0

0

0

Planned order release

0

0

0

80

0

0

0

0

Item: C LT = 2 wk.

Beg. Inv.

1

2

3

4

5

6

7

8

Gross requirements

0

0

0

0

180

0

0

0

Scheduled receipts

0

0

0

0

0

0

0

0

Projected on hand

65

65

65

65

65

0

0

0

0

Net requirements

0

0

0

0

115

0

0

0

Planned order receipt

0

0

0

0

115

0

0

0

Planned order release

0

0

115

0

0

0

0

0

Therefore the MRP of Item E is as shown below:

Item: E(3) & E(2) LT = 1 wk.

Beg. Inv.

1

2

3

4

5

6

7

8

Gross requirements

0

0

230

240

0

0

0

0

Scheduled receipts

0

0

0

0

0

0

0

0

Projected on hand

10

10

10

0

0

0

0

0

0

Net requirements

0

0

220

240

0

0

0

0

Planned order receipt

0

0

220

240

0

0

0

0

Planned order release

0

220

240

0

0

0

0

0

Excel working is shown below:


Related Solutions

Assume that you are the manager of a shop that assembles power tools. You have just...
Assume that you are the manager of a shop that assembles power tools. You have just received an order for 50 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws is Item Lead Time (weeks) On Hand Components Saw 2 15 A(2), B(1), C(4) A 1 10 E(3), D(1) B 2 5 D(2), F(3) C 2 65 E(2), D(2) D 1 20 E 1 10 F 2 30 b. Develop the...
Assume that you are the manager of a shop that assembles power tools. You have just...
Assume that you are the manager of a shop that assembles power tools. You have just received an order for 50 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws is Item Lead Time (weeks) On Hand Components Saw 2 15 A(2), B(1), C(4) A 1 10 E(3), D(1) B 2 5 D(2), F(3) C 2 65 E(2), D(2) D 1 20 E 1 10 F 2 30 b. Develop the...
Assume that you are the manager of a shop that assembles power tools. You have just...
Assume that you are the manager of a shop that assembles power tools. You have just received an order for 59 chain saws, which are to be shipped at the start of week 8. Pertinent information on the saws is Item Lead Time (weeks) On Hand Components Saw 2 15 A(2), B(1), C(4) A 1 10 E(3), D(1) B 2 5 D(2), F(3) C 2 65 E(2), D(2) D 1 20 E 1 10 F 2 30    Develop the...
Assume you work for Bass Pro Shop, and your manager requests that you outline the pros...
Assume you work for Bass Pro Shop, and your manager requests that you outline the pros and cons of discontinuing its Golf department. That department appears to be generating losses, and your manager believes that discontinuing it will increase overall store profits, What should management consider when trying to decide whether to discontinue its Golf department?
Assume you are the manager of a small coffee shop. How would knowledge of your production...
Assume you are the manager of a small coffee shop. How would knowledge of your production function aid in your management decisions?
Case study continued (questions 9–12) When you meet with Imogen at a local coffee shop for...
Case study continued (questions 9–12) When you meet with Imogen at a local coffee shop for their regular catch-up, Imogen tells you how things are going. You say, ‘I still get quite wound up sometimes, but I feel pretty good on the whole’. You suggest that Imogen continues to review and monitor her stress management plan and the next time they meet, you can go through and review whether or not it is working effectively. For the next month, Imogen...
You are the manager of a midsized company that assembles personal computers. You purchase most components...
You are the manager of a midsized company that assembles personal computers. You purchase most components – such as memory and hard drives – in a competitive market. Based on your marketing research, consumers earning over $80,000 purchase 1.5 more memory than consumers with lower incomes. Today, you read in the Wall Street Journal that, that there has been a rise in global demand for computer memory. Given the above discussion, what would you expect to happen to the price...
Assume you are sitting down with your manager, or assume you are the manager sitting down...
Assume you are sitting down with your manager, or assume you are the manager sitting down with your employee. Prepare two SMART goals for your employee./Marriott Explain how these two goals meet the SMART criteria.
. 7. You are the manager of a skateboard shop that is losing money. You discover...
. 7. You are the manager of a skateboard shop that is losing money. You discover that one of your main competitors has a contract with a Chinese firm that makes skateboard in China and sells them for low prices, but the Chinese firm refuses to sell skateboards to you. How might you use accusations of restrictive practices to counterattack your competitor?
Problem Set Assume you have just become a marketing manager for the 747 Classic model of...
Problem Set Assume you have just become a marketing manager for the 747 Classic model of Swingline staplers (note that in this case you work for the manufacturer of the product, so your figures need to be from the manufacturer’s viewpoint). Your product carries a retail price of $18.98. Retailers mark up the product 45% based on selling price (a margin of 45%), while wholesalers take a 17% markup based on cost. Variable manufacturing costs for the 747 are $5.63...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT