Question: An end item's demand forecasts for the next 10 weeks are 45, 45, 45, 45, 20, 20, 45, 45, 45, and 45 units. The current

An end item's demand forecasts for the next 10 weeks are

45,

45,

45,

45,

20,

20,

45,

45,

45,

and

45

units. The current on-hand inventory is

150

units. The order policy is to produce in lots of

95.

The booked customer orders for the item, starting with week 1, are

15,

48,

7,

5,

0,

3,

10,

0,

0,

and

0

units. The lead time is 2 weeks.

a. Develop an MPS for this end item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.)

Lot Size: 95

Lead Time: 2 weeks

Week

1

2

3

4

5

6

7

8

9

10

Forecast

45

45

45

45

20

20

45

45

45

45

Customer orders (booked)

15

48

7

5

0

3

10

0

0

0

Projected on-hand inventory

150

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

MPS quantity

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

MPS start

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

ATP

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. The marketing department has received five orders for this item in the following sequence:

Order

1 is for

20

units to be delivered in period 1.

Order

2 is for

125

units to be delivered in period 4.

Order

3 is for

90

units to be delivered in period 6.

Order

4 is for

125

units to be delivered in period 7.

Order

5 is for

120

units to be delivered in period 10.

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)?

Order

Order Acceptance

1

reject

accept

2

accept

reject

3

reject

accept

4

reject

accept

5

accept

reject

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!