Question: 1. Using the table provided, complete the inventory sheet for item B. 2. Using the table provided, complete the inventory sheet for item C. 3.

1. Using the table provided, complete the

1. Using the table provided, complete the inventory sheet for item B.

1. Using the table provided, complete the

2. Using the table provided, complete the inventory sheet for item C.

1. Using the table provided, complete the

3. Using the table provided, complete the inventory sheet for item D.

1. Using the table provided, complete the

Information for this assignment: A certain product has the following bill of materials. Note that the number in parentheses refers to the number of respective items needed in the assembly process. A B (3) C (2) D (4) The master production schedule for A for the next 6 weeks is shown below. Weeks 11 12 13 14 15 16 Master production schedule 23 28 24 21 20 29 Use the above information to do your analysis in the next 3 questions. Inventory Sheet for Item B On Hand: 145 Safety Stock: 50 11 12 Lead Time: 3 weeks Lotsize: POQ = 2 weeks Weeks 13 14 15 16 125 Gross Requirements Scheduled Receipts Projected On-Hand 145 Net Requirement Planned Receipt Planned Release Inventory Sheet for Item C On Hand: 95 Safety Stock: 30 Lead Time: 2 weeks Lotsize: FOQ = 100 Weeks 11 12 13 14 15 16 100 Gross Requirements Scheduled Receipts Projected On-Hand 95 Net Requirement Planned Receipt Planned Release Inventory Sheet for Item D On Hand: 350 : Safety Stock: 200 11 12 Lead Time: 1 week Lotsize: L4L 13 14 15 16 420 Weeks Gross Requirements Scheduled Receipts Projected On-Hand 350 Net Requirement Planned Receipt Planned Release

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!