Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PRODUCTION PLANNING FOR SUPPLY CHAIN PRODUCTION PLANNING FOR SUPPLY CHAIN ASSIGNMENT 2 - S20 ASSIGNMENT 2 - S20 NAME STUDENT # You are given the
PRODUCTION PLANNING FOR SUPPLY CHAIN | PRODUCTION PLANNING FOR SUPPLY CHAIN | |||||||||||||||||||||||
ASSIGNMENT 2 - S20 | ASSIGNMENT 2 - S20 | NAME | ||||||||||||||||||||||
STUDENT # | ||||||||||||||||||||||||
You are given the following for an item that your company manufactures: | ||||||||||||||||||||||||
Week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | (1) | Week | |||||||||||||
Forecast | 36 | 60 | 72 | 84 | 96 | 84 | 72 | 60 | 36 | On Hand | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | |||||
Forecast | ||||||||||||||||||||||||
(1) | You meet with your production team the week prior to week 1: | Projected Avail. Inventory | ||||||||||||||||||||||
You plan on using a batch size of 72units, as you have in the past with a reorder point of 0. | MPS | |||||||||||||||||||||||
Your On Hand inventory is 30 units. | ||||||||||||||||||||||||
Develop the MPS for weeks 1-9. | ||||||||||||||||||||||||
What will be the issue with supplying the customer? | ||||||||||||||||||||||||
(2) | Week | |||||||||||||||||||||||
On Hand | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | |||||||||||||||
Forecast | ||||||||||||||||||||||||
(2) | To resolve the issue, a member of the production team suggests | Projected Avail. Inventory | ||||||||||||||||||||||
increasing the batch size to 144 and keeping the reorder point at 0. | MPS | |||||||||||||||||||||||
Develop the MPS with the revised batch size. | ||||||||||||||||||||||||
(3) | In week 1 the actual demand is 48 units not the 36 forecast. | |||||||||||||||||||||||
Sales also revises the forecast as follows: | (3) | Week | ||||||||||||||||||||||
Week | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | On Hand | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||||
Forecast | 72 | 84 | 96 | 96 | 84 | 72 | 60 | 36 | 36 | Forecast | ||||||||||||||
What is the on hand inventory at the start of week 2? | Projected Avail. Inventory | |||||||||||||||||||||||
Develop an MPS for weeks 2 - 10 | MPS |
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