Question

Use the following three MPSs constructed by the master production scheduler of the company to answer the questions related t

Paragraph Orders РАВ ATP MPS 30 20 45 20 5050 10 25 30 50 50 20 0 10 Forecast 30 30 25 20 20 20 Orders 40 10 IL. PAB 5 ATP 50

Use the following three MPS's constructed by the master production scheduler of the company to answer the questions related to this problem. Explain all your answers! 6 30 30 20 20 20 Forecast Orders 10 30 20 IPAB l s | 25 | -5 | 20 | O-30- 60 I. 50 ATP 5 50 50 MPS 50 50 5 6 II. Forecast 30 30 25 20 20 20
Paragraph Orders РАВ ATP MPS 30 20 45 20 5050 10 25 30 50 50 20 0 10 Forecast 30 30 25 20 20 20 Orders 40 10 IL. PAB 5 ATP 50 MPS 50 50 50 50 a) Can you say what are the problems shown in the MPS tableau I that have been corrected in the tableau II? The MPS tableau II was used to decide when to ship a new customer order for 4 items b) i. Can you say from MPS tableau III for when this new order was committed? ii. Can ii. If the lead-time is 3 weeks, what must the master production scheduler do if Assume that partials are accepted by the customer you guess what the lead-time of the product is? Justify your answer. he she is pursuing this plan? Complete the MPS tableau III. The master production scheduler decided to correct the problems with the MPS (tableau I) before accepting the customer order for 45 units. Do you think that this was the right approach or should have he she accepted the order first and then fix the MPS? This is an open ended question; you must justify your answer. c) d)
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ans to Qn. a)

As seen in Table 1, in the second period the Projected Available Balance (PAB) stands as negative 5, which means that the produce/orders in not sufficient to meet the demand requirement in period 2, in case demand follows the forecasts. The same has been rectified in Table II by placing the orders (MPS) in period 2 itself for the 50 lot size of the materials(assumption).

Ans to Qn. b)

i) As per Table II a new order or 45 units can be promised to a customer even if the company does not hold that quantity. As the shipment can take place in installments, and partial orders are accepted by the customer, it becomes difficult to place exactly which period was it in which the order was accepted. However, given the data in Table II, periods 3,4 & 6 can be ruled out.

ii) Lead time of the product is zero period. The order placed in periods 1 & 2 were received immediately, and the one placed in period 5 received in period 5 itself.

ii) If the lead time is 3 weeks, then the MPS should place orders based on forecasted demands, 3 weeks from the current period. In essence it means that the MPS should start from -2 periods to incorporate the complete plan on the materials.

Ans to Qn. c)

Table I Forecast Orders PAB ATP MPS 30 30 30 10 0 30 Table II Forecast Orders PAB ATP MPS 30 30 30 10 10 0 30 Table III Forec

Add a comment
Know the answer?
Add Answer to:
Use the following three MPS's constructed by the master production scheduler of the company to an...
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
  • 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:...

  • Prepare a master production schedule for industrial pumps in the manner of the following table. U...

    Prepare a master production schedule for industrial pumps in the manner of the following table. Use the MPS rule to "schedule production when the projected on-hand inventory would be less than 10 without production, Suppose that a production lot size of 70 pumps is used (Leave no cells blank- be certain to enter "O wherever required.) June 64 Forecast Customer orders (commitied) Projected on-hand inventory MPS ATP 30 30 40 40 30 20 30 10 References eBook & Resources Worksheet...

  • Q1. Develop a Master Production Schedule (MPS) The Forecast is 84 units for first period and...

    Q1. Develop a Master Production Schedule (MPS) The Forecast is 84 units for first period and 80 for the second period, and 60 units for each of the next three periods. The starting Inventory is 20 units. The company uses lot size of 50 units. Committed Orders are as follows: What is the available to promise? Period Customer Orders 1 82 2 82 3 58 4 40 5 20 Q2 Complete the following problem. There are 20 on hand and...

  • Prepare a master production schedule for industrial pumps in the manner of the following ta Use...

    Prepare a master production schedule for industrial pumps in the manner of the following ta Use the MPS rule to "schedule production when the projected on-hand inventory would be le than 10 without production". Suppose that there are currently 64 pumps in inventory and a production lot size of 70 pumps is used. 30 33 Week Forecast Customer orders (committed) Projected on- hand inventory MPS 0 Available to promise (ATP) 70 51 Question 29 (3 points) What is the projected...

  • 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...

  • 15. What is the production system that normally requires the most inventory of raw material items? A. Make-to-order B....

    15. What is the production system that normally requires the most inventory of raw material items? A. Make-to-order B. Assemble-to-order C. Engineer-to-order D. Make-to-stock 16. Inside the demand time fence, which of the following is true? A. It is easy to change the master production schedule (MPS) B. Available-to-promise (ATP) calculations ignore customer orders and forecast C. New customer orders can only occasionally be accepted D. Marketing and logistics people could make any changes 17. The expected demand in October...

  • 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

  • 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...

  • 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...

  • Using the following MPS record, what is the MPS start for week 7? MPS Lot Size...

    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 Projected On Hand Inventory MPS Quantity MPS Start ATP 25 20 25 5 25 8_ 30

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