Question

Using the following MPS record, what is the MPS start for week 7?MPS Lot Size Lead Time 10 1 3 4 5 6 7 8 9 45 25 20 20 20 20 40 20 T PERIOD Quantity on Hand Forecast Customer Orders Booked 1

0 0
Add a comment Improve this question Transcribed image text
Answer #1

MPS start for week 7 is 130

[ Note for students : Rows marked yellow are rows included in the table to explain the calculation]

4 5 7 8 9 1 2 Period 3 Quantity on hand 4 Forecast 5 Customer Orders Booked 6 Requirement 7 Opening Inventory 25 20 20 20 20

Formula

Add a comment
Know the answer?
Add Answer to:
Using the following MPS record, what is the MPS start for week 7? MPS Lot Size...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • I need the Mps quantity and MPS start % Problem 1 Questi Complete the MPS record...

    I need the Mps quantity and MPS start % Problem 1 Questi Complete the MPS record below for a single item. (Enter your responses as integers. A response of "0" is equivalent to being not applicable.) Item: A Order Policy: 60 units Lead Time: week Quantity Week on Hand: 30 1 2 4 6 7 8 3 28 5 23 22 18 31 27 31 32 13 17 7 17 11 0 9 0 Forecast Customer orders (booked) Projected on-hand...

  • 1. Using the information in the following table, prepare a prospective MPS and calculate the available-to-...

    1. Using the information in the following table, prepare a prospective MPS and calculate the available-to- promise (ATP) quantities on the table below. The order policy is to produce in lots your calculations on the paper to receive full or partial credits. of 100. Show all Week 4 7 50 20 8 50 10 2 5 6 Quantity on hand: 401 404040 50 95 Forecast Customer orders (booked) Projected on-hand Inventory MPS quantity Available-to-promise (ATP) 20 40 45 15 75...

  • Question #3 Georgia Clay and Gravel was updating the MPS record for one of its products,...

    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 8 Forecast 20 20 20 30 30 30 30 30 Orders 5 3 2 Projected available balance 20 50 30 10 30 50 20 40 10 Available to promise MPS 50 50 50 50 MPS Lot Size = 50 The following events...

  • needing help with Excel 3. Complete the master production schedule based on the following information: 1...

    needing help with Excel 3. Complete the master production schedule based on the following information: 1 4 9 2 3 320 100 30 60 50 80 110 5 6 7 40 240 290 60 60 60 410 20 Week Forecast Customer Orders Projected On-Hand Inventory MPS Released MPS Due Available to Promise (ATP) Additional Information: On-hand inventory: 600 Schedule production whenever projected on-hand inventory drops below 30 MPS lot size: 300 Production lead time or lead time for MPS releases:...

  • Show work Spring 2018 Name: LD. #: 1. Using the information in the following table, prepare...

    Show work Spring 2018 Name: LD. #: 1. Using the information in the following table, prepare a prospective MPS and calculate the available-to- promise (ATP) quantities on the table below. The order policy is to produce in lots of 100. Show all your calculations on the paper to receive full or partial credits. Week Quantity on hand: 40 1 Forecast 40|40|40|40|50 50 | 50 | 50 Customer orders (booked)20 95 40 45 15 75 20 10 Projected on-hand Inventory MPS...

  • Prepare a master schedule given this information: It is now the end of week 1; customer...

    Prepare a master schedule given this information: It is now the end of week 1; customer orders are 25 for week 2, 16 for week 3, 11 for week 4, 8 for week 5, and 3 for week 6. Use the MPS rule of ordering production when projected on-hand inventory would be negative without production. Suppose that there are currently 64 pumps in inventory and a production lot size of 70 pumps is used. (Leave no cells blank - be...

  • Prepare a master schedule given this information: It is now the end of week 1; customer...

    Prepare a master schedule given this information: It is now the end of week 1; customer orders are 25 for week 2,16 for week 3, 11 for week 4, 8 for week 5, and 3 for week 6. Use the MPS rule of ordering production when projected on- hand inventory would be negative without production. Suppose that there are currently 64 pumps in inventory and a production lot size of 70 pumps is used (Leave no cells blank - be...

  • Problem 1 Week 1 2 3 4 5 6 7 8 9 10 Forecast 65 70...

    Problem 1 Week 1 2 3 4 5 6 7 8 9 10 Forecast 65 70 60 65 70 65 65 60 55 40 Customer Orders 20 25 10 40 10 30 5 10 0 5 Available 100 Average PAB (w/out starting) ATP Total ATP MPS Total MPS On hand = 100 Lot size = 100 multiples Safety Stock = 25 1. Complete the MPS time-phased record above with the information as given

  • Question 1 (2-Part) a) Complete the MPS record below for a single item. (Enter your responses as integers. A response of 0is equivalent to being not applicable.) Item: A Order Policy: 60 units Lead T...

    Question 1 (2-Part) a) Complete the MPS record below for a single item. (Enter your responses as integers. A response of 0is equivalent to being not applicable.) Item: A Order Policy: 60 units Lead Time: 1 week on Hand: 35 20 28 28 30 35 18 Customer orders 17 17 MPS quantity MPS start b) Shown below is a partially completed MPS record for ball bearings. a. Develop the MPS for ball bearings. (Enter your responses as integers. A response...

  • Part II. TECHHICHI PPUDICMS (SHOW ALL CHICHI WUIS UIT Law Problem 7. (10%) Using the information...

    Part II. TECHHICHI PPUDICMS (SHOW ALL CHICHI WUIS UIT Law Problem 7. (10%) Using the information in the following table, prepare a prospective MPS and calculate the available-to-promise quantities. The order policy is to produce in lots of 300. 1 100 40 2 100 190 3 100 220 Week 4 5 100 120 70 60 6 120 110 7 120 40 8 120 Quantity on hand: 100 Forecast Customer orders (CO) Projected on-hand inventory MPS quantity Available-to-promise (ATP) Assume that...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT