Resource Planning
Not what you're looking for?
(See attached file for full problem description)
1. Consider the MPS, BOM, and inventory data shown below (15 pts).
Master Production Schedule: the following table shows the MPS start quantities.
Item: A Lot Size: LFL
Lead Time: 1 Week
Safety Stock: 5
Time Period (Weeks)
1 2 3 4 5 6 7 8 9 10
Gross Requirements 10 20 0 40 30 0 20 0 40 0
Scheduled Receipts
On-Hand Inventory 15
Planned Receipts
Planned Order Releases 20 40 30 20 40
Bill of Material:
-Item A uses 2 each of component D, 1 each of component C and 2 each of subassembly B.
-Subassembly B uses 2 each of component E.
Selected Inventory Data:
Item Lot Size Technique Lead Time (weeks) Scheduled Receipts Safety Stock On-Hand
B L4L 1 40 in period 1
C POQ=3 2 10 40
D FOQ=250 1 50 100
E L4L 2 160 in period 2 20 20
Based on the information from the previous page, complete the following inventory records:
Item: B Lot Size:
Lead Time:
Safety Stock:
Time Period (Weeks)
1 2 3 4 5 6 7 8 9 10
Gross Requirements
Scheduled Receipts
On-Hand Inventory
Planned Receipts
Planned Order Releases
Item: C Lot Size:
Lead Time:
Safety Stock:
Time Period (Weeks)
1 2 3 4 5 6 7 8 9 10
Gross Requirements
Scheduled Receipts
On-Hand Inventory
Planned Receipts
Planned Order Releases
Item: D Lot Size:
Lead Time:
Safety Stock:
Time Period (Weeks)
1 2 3 4 5 6 7 8 9 10
Gross Requirements
Scheduled Receipts
On-Hand Inventory
Planned Receipts
Planned Order Releases
Item: E Lot Size:
Lead Time:
Safety Stock:
Time Period (Weeks)
1 2 3 4 5 6 7 8 9 10
Gross Requirements
Scheduled Receipts
On-Hand Inventory
Planned Receipts
Planned Order Releases
Purchase this Solution
Solution Summary
Word document contains Master Production Schedule (MPS). Resource planning functions are analyzed.
Solution Preview
Please see the attached file.
1. Consider the MPS, BOM, and inventory data shown below (15 pts).
Master Production Schedule: the following table shows the MPS start quantities.
Item: A Lot Size: LFL
Lead Time: 1 Week
Safety Stock: 5
Time Period (Weeks)
1 2 3 4 5 6 7 8 9 10
Gross Requirements 10 20 0 40 30 0 20 0 40 0
Scheduled Receipts
On-Hand Inventory 15
Planned Receipts
Planned Order Releases 20 40 30 20 40
Bill of Material:
-Item A uses 2 each of component D, 1 each of component C and 2 each of subassembly B.
-Subassembly B uses 2 each of component E.
Selected Inventory Data:
Item Lot Size Technique Lead Time (weeks) Scheduled Receipts Safety Stock On-Hand
B L4L 1 40 in ...
Purchase this Solution
Free BrainMass Quizzes
Business Processes
This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Motivation
This tests some key elements of major motivation theories.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Introduction to Finance
This quiz test introductory finance topics.