Question: The figure below shows a partially completed inventory record for the real wheel subassembly. Gross requirements, scheduled receipts, lead time, and current on-hand inventory are
The figure below shows a partially completed inventory record for the real wheel subassembly. Gross requirements, scheduled receipts, lead time, and current on-hand inventory are shown.
| Item: MQ-09 | Lot Size: | ||||||||||
| Description: Rear wheel | Lead Time: 1 week | ||||||||||
| subassembly | Week | ||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
| Gross requirements | 50 | 120 | 90 | 60 | 15 | 80 | 40 | 20 | |||
| Scheduled receipts | |||||||||||
| Projected on-hand inventory | 75 | ||||||||||
| Planned receipts | |||||||||||
| Planned order releases | |||||||||||
a. Complete the last three rows of the record for an FOQ of
250
units. (Enter your responses as whole numbers. A response of "0" is equivalent to being not
applicable.)
| Item: MQ-09 | Lot Size: FOQ=250 | ||||||||||
| Description: Rear wheel | Lead Time: 1 week | ||||||||||
| subassembly | Week | ||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
| Gross requirements | 50 | 120 | 90 | 60 | 15 | 80 | 40 | 20 | |||
| Scheduled receipts | |||||||||||
| Projected on-hand inventory | 75 | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here |
| Planned receipts | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | |
| Planned order releases | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here |
b. Complete the last three rows of the record by using an FOQ of
100
units. (Enter your responses as whole numbers. A response of "0" is equivalent to being not
applicable.)
| Item: MQ-09 | Lot Size: FOQ=100 | ||||||||||
| Description: Rear wheel | Lead Time: 1 week | ||||||||||
| subassembly | Week | ||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
| Gross requirements | 50 | 120 | 90 | 60 | 15 | 80 | 40 | 20 | |||
| Scheduled receipts | |||||||||||
| Projected on-hand inventory | 75 | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here |
| Planned receipts | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | |
| Planned order releases | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here |
c. Complete the last three rows of the record by using the L4L rule. (Enter your responses as whole numbers. A response of "0" is equivalent to being not
applicable.)
| Item: MQ-09 | Lot Size: L4L | ||||||||||
| Description: Rear wheel | Lead Time: 1 week | ||||||||||
| subassembly | Week | ||||||||||
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||
| Gross requirements | 50 | 120 | 90 | 60 | 15 | 80 | 40 | 20 | |||
| Scheduled receipts | |||||||||||
| Projected on-hand inventory | 75 | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here |
| Planned receipts | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here | |
| Planned order releases | enter your response here | enter your response here | enter your response here | enter your response here | enter your response here |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
