Business Case Analysis - 3 (50 points) Instructions: Read the business case given to you (in class) and answer the questions below. Provide your...

Business Case Analysis – 3

(50 points)

Instructions:

Read the business case given to you (in class) and answer the questions below.
Provide your responses on a word document and include your calculations in the document.
Your responses have to be comprehensive. One or two line responses will NOT do.
Your responses should be well thought out with appropriate reasoning.
Include a cover page with your name on it. Be professional!
You can work in teams of 2.

1. Develop an MPS/ATP schedule based on the forecast and order data provided. Use the MPS/ATP table structure for your calculations. Describe how MPS/ATP would be beneficial in the situation mentioned in the case.

2. Develop a rough-cut capacity plan based on the MPS schedule and the data provided. Use a table structure for the capacity plan.

3. What are some of the issues you notice based on the two plans that you have developed? How would you tackle these issues? If you were to tweak your production schedule to work around some of the constraints, how would you do that? Explain and provide ample justification.

(Note: Data provided in the next page)

Data:

Work Center 12

Model	Run Time (per item, in minutes)	Setup Time (per lot)	Lot Size (minimum) qty.	On-hand
A	3.7	90 minutes	150	10
B	5.1	40 minutes	100
C	4.3	60 minutes	120
D	8.4	200 minutes	350	22
E	11.2	120 minutes	400	153

Model	Weeks	1	2	3	4	5	6	7	8	9	10
A	Forecast	45	45	45	45	45	45	45	45	45	45
	Customer Orders	53	41	22	15	4	7	2	0	0	0
B	Forecast	35	35	35	35	35	35	35	35	35	35
	Customer Orders	66	40	31	30	17	6	2	0	0	0
C	Forecast	50	50	50	50	50	50	50	50	50	50
	Customer Orders	52	43	33	21	14	4	7	1	0	0
D	Forecast	180	180	180	180	180	180	180	180	180	180
	Customer Orders	277	190	178	132	94	51	12	7	9	2
E	Forecast	200	200	200	200	200	200	200	200	200	200
	Customer Orders	223	174	185	109	74	36	12	2	0	0