Question: Consider the master production schedule, BOM, and inventory data shown below. Master Production Schedule Week 1 2 3 4 5 6 7 8 Customer req.

Consider the master production schedule, BOM, and inventory data shown below.

Master Production Schedule
Week 1 2 3 4 5 6 7 8
Customer req. "A" 0 7 0 6 0 0 14 0
Customer req. "B" 0 0 0 0 0 7 0 14
Lead time for Product "A" is 1 week.
Lead time for Product "B" is 3 weeks.
Bills of Materials
Consider the master production schedule, BOM, and
Item File
Item C D E F
Lot sizing rule LFL LFL FOQ (30) POQ (P = 2)
Lead time (weeks) 2 2 3 2
Beginning (on-hand) inventory 10 8 21 3
Scheduled receipts 11 in week 1 None 21 in week 1 16 in week 1

Complete the MPS and MRP explosion. Round your answers to the nearest whole number. Do not leave fields blank, enter zero if applicable.

MPS Product A Lead time = 1 week
Week 1 2 3 4 5 6 7 8
Product Aend item
Planned order releases
MPS Product B Lead time = 3 weeks
Week 1 2 3 4 5 6 7 8
Product Bend item
Planned order releases
Item C Lot size: LFL
Description Lead time: 2 weeks
Week 1 2 3 4 5 6 7 8
Gross requirements
Scheduled receipts
Projected OH inventory 10
Planned order receipts
Planned order releases
Item D Lot size: LFL
Description Lead time: 2 weeks
Week 1 2 3 4 5 6 7 8
Gross requirements
Scheduled receipts
Projected OH inventory 8
Planned order receipts
Planned order releases
Item E Lot size: 30 units
Description Lead time: 3 weeks
Week 1 2 3 4 5 6 7 8
Gross requirements
Scheduled receipts
Projected OH inventory 21
Planned order receipts
Planned order releases
Item F Lot size: POQ = 2 weeks
Description Lead time: 2 weeks
Week 1 2 3 4 5 6 7 8
Gross requirements
Scheduled receipts
Projected OH inventory 3
Planned order receipts
Planned order releases
Bills of Materials F(2) E(2) (F(2)

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!

Q:

I will rate you, thanks Consider the master production schedule, BOM, and inventory data shown below. 1 N 3 4 5 8 6 0 7 140 0 7 0 Master Production Schedule Week Customer req. "A" 6 0 Customer req....

Q:

Consider the master production schedule, BOM shown in Exhibit 14.33, and inventory data shown below. Complete the MPS and MRP explosion and identify what actions, if any, you would take given this...

Q:

Consider the master production schedule, bills of materials, and inventory data shown below. Master Production Schedule Week 1 2 3 4 5 6 7 8 Customer req. "A" 0 7 0 10 0 0 8 0 Customer req. "B" 0 0 0...

Q:

Consider the master production schedule, bills of materials, and inventory data shown below. Master Production Schedule Week 1 2 3 4 5 6 7 8 Customer req. "A" 0 7 0 6 0 0 14 0 Customer req. "B" 0 0 0...

Q:

Consider the master production schedule, bills of materials, and inventory data shown below. Complete the MPS and MRP explosion and identify what actions, if any, you would take given this...

Q:

Consider the master production schedule, bills of materials, and inventory data shown below. 7 8 Master Production Schedule Week 1 2 3 4 5 5 Customer req. "A" 03 0 7 0 Customer reg, "B" 0 0 0 0 0...

Q:

Hello, can I please get help answering this question with all the steps, thank you? Consider the MPS, BOM and inventory data shown. Master Production Schedule: End item A Weeks 1 2 3 4 5 6 7 8 9 10...

Q:

1. (50 points) MRP: Consider the MPS, BOM, and inventory data shown. Master Production Schedule: Table below shows the MPS start quantities (= planned order releases). Time Period 2 3 4 5 6 7...

Q:

Use the above information to answer the following questions. 1. How many planned order releases are there for item C? a. Zero or one b. Two c. Three d. More than three 2. Which one of the following...

Q:

PLEASE SHOW ALL WORK 7. (25 points) Consider the MPS, BOM, and inventory data shown. Master Production Schedule: The following table shows the MPS start quantities for the next 6 weeks. Finished Item...

Q:

Timothy retains Cynthia, an attorney, to bring a lawsuit upon a valid claim against Vincent. Cynthia fails to make herself aware of recently enacted legislation that shortens the statute of...

Q:

The Millers, a family of four (with two young child) filing a joint tax return, have the following information to prepare their federal income tax return for tax year 2020: Total Income $103,000...

Q:

StatementsAnswer 1 . When damage to another is directly attributable to a wrongdoer's act, _ _ _ _ _ _ _ _ _ _ is said to exist . 2 . Unwritten law that has developed through court decisions is...

Q:

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...