Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you provide assistance on the following question? The low-level coded BOM is shown in the attached Excel file along with a template to complete
Can you provide assistance on the following question?
The low-level coded BOM is shown in the attached Excel file along with a template to complete for parts A, B and C. The on hand (OH), lead time (LT), safety stock (SS), and production lot size (Q) are shown for each item. Marketing has a gross requirement for 100 part A in week 8. There are scheduled receipts of 50 B in week 1 and 200 C in week 2. | ||||||
a) Complete the sections not filled out on the template for part A. (3 points) | ||||||
b) Complete the sections not filled outon the template for part B. (3 points) | ||||||
c) Complete the sections not filled out on the template for part C. (3 points) |
Low-Level Coded BOM: | |||||||||||
Level 0 | A | ||||||||||
Level 1 | B (3) | ||||||||||
Level 2 | C(2) | C (1) | |||||||||
Part A | Week | ||||||||||
OH | 20 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||
LT | 3 | Gross Requirements | 100 | ||||||||
SS | 0 | Scheduled Receipts | |||||||||
Q = Lot for Lot | Projected Available Balance | ||||||||||
Net Requirements | |||||||||||
Planned Order Receipt | |||||||||||
Planned Order Release | |||||||||||
Part B | Week | ||||||||||
OH | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||
LT | 2 | Gross Requirements | |||||||||
SS | 0 | Scheduled Receipts | 50 | ||||||||
Q | 500 | Projected Available Balance | |||||||||
Net Requirements | |||||||||||
Planned Order Receipt | |||||||||||
Planned Order Release | |||||||||||
Part C | Week | ||||||||||
OH | 400 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | ||
LT | 1 | Gross Requirements | |||||||||
SS | 100 | Scheduled Receipts | 200 | ||||||||
Q | 200 | Projected Available Balance | |||||||||
Net Requirements | |||||||||||
Planned Order Receipt | |||||||||||
Planned Order Release |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started