Question: X=48 Week 1 2 3 4 5 6 7 8 Gross Requirements 35 20 5+X 25 5+X 25 5+X 25 Orders 5 6 4 Projected

X=48

Week

1

2

3

4

5

6

7

8

Gross Requirements

35

20

5+X

25

5+X

25

5+X

25

Orders

5

6

4

Projected Available Balance

X

Available-to-promise

MPS

MPS Lot Size = X

The following events occurred during week 1:

- Actual demand during week 1 was only 32 units

- The forecast for week 9 is 10 + X

- An order for 15 in week 2 was accepted.

- An order for 10 in week 4 was accepted.

- An order for 5 in week 3 was accepted.

- The MPS in week 1 was produced as planned

b. Update the record below after rolling through time.

Week

2

3

4

5

6

7

8

9

Gross Requirements

20

5+X

25

5+X

25

5+X

25

10+X

Scheduled Receipts

50

Projected Available Balance

Planned Order Release

MPS Lot Size = X

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!

Q:

Henry Coupe, the manager of a metropolitan branch office of the state department of motor vehicles, attempted to analyze the drivers license-renewal operations. He had to perform several steps. After...

Q:

a. Complete the following MPS time-phased record: Toaster Week 1 2 3 4 5 6 7 8 Gross requirments 35 20 37 25 37 25 37 25 Orders 5 6 4 Projected avalable balance 32 availble to promise MPS MPS Lot...

Q:

13. Complete the following MRP time-phased record: Week Item: Toaster 1 2 3 4 5 6 7 8 Gross requirements 20 20 35 25 35 35 35 35 Scheduled receipts 50 Projected available balance 10 Planned order...

Q:

40 20 35 15 Lot Size: 80 Lead Time: 1 Quantity on Hand (Period 0): 45 Week 1 2 3 4 5 6 7 8 Forecast 35 35 35 35 30 30 30 30 Customer Orders Projected on-hand 5 50 B 60 C 30 50 20 inventory MPS 80 80...

Q:

3. Excelsior Springs Ltd. schedules production of one end product, Hi-Sulphur, in batches of 70 units whenever the projected ending inventory balance in a period falls below 7 units. It takes one...

Q:

MPS Record Lot Size: 80 Lead Time: 1 Quantity on Hand (Period 0): 45 Week 1 2 3 4 5 6 7 8 Forecast 35 35 35 35 30 30 30 30 Customer Orders 40 20 35 15 Projected on-hand inventory 5 50 B 60 C 30 50 20...

Q:

6. Consider the following three MRP records. Product A comprises two part Bs. One part B requires one part C. Week Product A 1 2 3 4 5 6 7 8 Gross requirements 10 20 0 40 20 10 0 20 Scheduled...

Q:

8. Melnick Mines uses a special type of hardened crusher ball for preparing the ore. Purchasing the balls is managed with time-phased material planning. The following records are for two successive...

Q:

Question #3 Georgia Clay and Gravel was updating the MPS record for one of its products, Smell Fresh Cat Litter. Complete the following MPS time-phased record. Smell Fresh On Hand Week 1 2 3 4 5 6 7...

Q:

MPS Record Lot Size: 130 Lead Time: 1 Quantity on Hand (Period 0): 45 Week 1 2 3 4 5 6 7 8 9 10 Forecast 25 25 25 25 20 20 20 20 40 20 Customer 30 20 5 8 2. Orders Projected on-hand 15 120 B 70 50 30...

Q:

MPS Record Lot Size: 130 Lead Time: 1 Quantity on Hand (Period 0): 45 Week 1 2 3 4 5 6 7 8 9 10 Forecast 25 25 25 25 20 20 20 20 40 20 Customer Orders 30 20 5 8 2 Projected on-hand inventory 15 120 B...

Q:

Below are four different activities. According Porter, which one is a primary activity for a biotech firm? a. Human resource management O b.IT services/ Information systems OC. Finance and accounting...

Q:

Draw a molecular orbital energy level diagram for each of the following species: He+2, HHe, He2+. Compare their relative stabilities in terms of bond orders. (Treat HHe as a diatomic molecule with...

Q:

Which of the following statements regarding property owned as joint tenants with right of survivorship ( JTWROS ) between spouses is CORRECT? The entire value of the property is included in the gross...

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...