Question

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 the lot size is 60

Period

1

2

3

4

5

6

Forecast

20

21

22

20

28

25

Customers order

19

18

20

18

30

22

POH

20

MPS

ATP

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

Solution :

Q 1 :

Period Forecast Customer Orders Projected On Hand Inventory MPS Quantity ATP 0 4 Total 80 82 4 50 32 344 82 36 100 38 58 생생 1

Q 2 :

6 Total Period Forecast Customer Orders Proiected On Hand Invento MPS Quanti ATP 136 21 18 39 28 30 27 0 18 19 0 0 20 17 0 57

Add a comment
Know the answer?
Add Answer to:
Q1. Develop a Master Production Schedule (MPS) The Forecast is 84 units for first period and...
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
  • Assignment 8 is due on Sunday 8/2 at 11:00 AM Complete the following MPS record and...

    Assignment 8 is due on Sunday 8/2 at 11:00 AM Complete the following MPS record and find out what is the available-to-promise. There are 20 units in beginning inventory and the lot size is 50. Answer in Excel and submit your answer in the drop box. Period 1 2 3 4 5 6 Forecast 20 22 23 20 25 20 Customers order (committed) 21 20 21 23 208 POH (Projected on hand) MPS (Master production schedule) ATP (Available-to-promise)

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

  • Prepare a master schedule and an available to promise table given customer orders below. MPS is...

    Prepare a master schedule and an available to promise table given customer orders below. MPS is 85 units, and the company has 150 units to begin with. Forecast for the eight-period work duration is 75 units.                 Week 1 2 3 4 5 6 7 8 Customer Order 75 85 90 48 55 72 88 90

  • . Canvas ©OSA The master production schedule (MPS) translates the sales & operationsplan (SOP) into: Specific...

    . Canvas ©OSA The master production schedule (MPS) translates the sales & operationsplan (SOP) into: Specific production orders Forecast demand Specific production plan Efficient lot sizes Question 25 A precedent relationship shows... The number of components required to produce an item The order in which production steps must be accomplished Only the first step of the production process Only the final step of the production process Question 26 In a material requirements planning (MRP) system, gross requirements are time phased,...

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

  • Use the following three MPS's constructed by the master production scheduler of the company to an...

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

  • Management Instructions Beginning Inventory 68 Safety Stock 300 Lot Size 144 Master Production Schedule Period 1...

    Management Instructions Beginning Inventory 68 Safety Stock 300 Lot Size 144 Master Production Schedule Period 1 2 3 4 5 6 7 8 Demand 505 580 575 550 520 480 475 525 Customer Orders 710 660 570 330 100 515 80 40 Projected On-Hand Inventory (POHI) (at the end of the period) Master Production Schedule Available To Promise (1-period look ahead) Discrete Available To Promise (1-period look ahead) Cumulative

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