An end items demand forecasts for the next 6 weeks are 28 units, followed by forecasts of 24 units for weeks 7 through 10 The current on hand inventory is 60 units The order policy is to produce in lots of 80 The booked customer orders for the item, starting with week 1, are 22, 30, 15, 11, 0, 0, 9, 0, 12, and 0 units The lead time is 2 weeks Develop an MPS for this end item The marketing department has received six orders for this item in the following sequence Order 1 is for 40 units to be delivered in period 3 Order 2 is for 60 units to be delivered in period 4 Order 3 is for 45 units to be delivered in period 6 Order 4 is for 35 units to be delivered in period 3 Order 5 is for 20 units to be delivered in period 5 Order 6 is for 65 units to be delivered in period 9 Assuming that the prospective MPS you developed in part (a) does not change, which orders would you be able to accept based on the available to promise (ATP) SHOW ALL WORK IN EXCEL

The Answer is in the image, click to view ...

Question: An end items demand forecasts for the next 6 weeks are 28 units, followed by forecasts of 24 units for weeks 7 through 10. The

An end items demand forecasts for the next 6 weeks are 28 units, followed by forecasts of 24 units for weeks 7 through 10. The current on-hand inventory is 60 units. The order policy is to produce in lots of 80. The booked customer orders for the item, starting with week 1, are 22, 30, 15, 11, 0, 0, 9, 0, 12, and 0 units. The lead time is 2 weeks.

Develop an MPS for this end item.
The marketing department has received six orders for this item in the following sequence:

Order 1 is for 40 units to be delivered in period 3

Order 2 is for 60 units to be delivered in period 4

Order 3 is for 45 units to be delivered in period 6

Order 4 is for 35 units to be delivered in period 3

Order 5 is for 20 units to be delivered in period 5

Order 6 is for 65 units to be delivered in period 9

Assuming that the prospective MPS you developed in part (a) does not change, which orders would you be able to accept based on the available to promise (ATP)?

SHOW ALL WORK IN EXCEL!!!!!!!!!!!!!!!!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Problem 4. (60 points) An end item's demand forecasts for the next 6 weeks are 28 units, followed by forecasts of 24 units for weeks 7 through 10. The current on-hand inventory is 60 units. The order...

Problem 6 ( 30 points) An end item's demand forecasts for the next 3 weeks are 28 units, followed by forecasts of 24 units for weeks 4 to 6 , and forecasts of 32 units for weeks 7 through 10 . The...

An end items demand forecasts for the next 6 weeks are 30 units, followed by forecasts of 25 units for weeks 7 through 10. The current on-hand inventory is 60 units. The order policy is to produce in...

An end items demand forecasts for the next 6 weeks are 30 units, followed by forecasts of 25 units for weeks 7 though 10. The current on-hand inventory is 60 units. The order policy is to produce in...

An end items demand forecasts for the next 6 weeks are 3 0 units, followed by forecasts of 2 5 units for weeks 7 through 1 0 . The current on - hand inventory is 6 0 units. The order policy is to...

Problem 6 (30 points) An end item's demand forecasts for the next 3 weeks are 28 units, followed by forecasts of 24 units for weeks 4 to 6 , and forecasts of 32 units for weeks 7 through 10 . The...

Hello! Please help with ATP on part a as well as part b. thank you!! 2. An end item's demand forecasts for the next 6 weeks are 40 units, followed by forecasts of 30 units for weeks 7 though 10. The...

2. An end item's demand forecasts for the next 6 weeks are 35 units, followed by forecasts of 30 units for weeks 7 though 10. The current on-hand inventory is 70 units. The order policy is to produce...

An end item's demand forecasts for the next 6 weeks are 35 units, followed by forecasts of 30 units for weeks 7 though 10. The current on-hand inventory is 70 units. The order policy is to produce in...

You are on the top management team of a medium-size company that manufactures cardboard boxes, containers, and other cardboard packaging materials. Your company is facing increasing levels of...

Compare the performance of the critically damped controllers shown in Figure P11.30 with the plant Gp(s) = 1 / I s having the following inputs: a. A unit-ramp disturbance b. A sinusoidal disturbance...

Querion w . Which volume of solution would be prepared when the nune receives an order to prepare a solution for administering a deansing enema for an adolescent client? 1 5 0 to 2 5 0 mc . 2 5 0 1 0...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...