Calculate the final discrete available-to-promise quantity for Week 1 using the following table. Weeks 1 2...

Question

Question

Calculate the final discrete available-to-promise quantity for Week 1 using the following table.

a. ATP₁ = 15

b. ATP₁ = 0

c. ATP₁ = 10

Please show the work of how to solve this.

Answer 1

Answer #1

ATP for week 1 = Beginning inventory + MPS for week 1 - Actual customer order at week 1

= 30+10-20 = 20

So correct answer is ATP1 = 20

Answer 2

Similar Homework Help Questions

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...
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...
Given the following information, the Available to Promise will show ________. Week 1 2 3 4...

Given the following information, the Available to Promise will show ________. Week 1 2 3 4 Forecast Demand 120 120 120 120 Actual Customer Orders 85 100 35 20 Available to Promise MPS 250 250 a. 130, 130, 130, 130 b. 165, 65, 30, 230 c. 130, 10, -110, 130 d. 30, 0, 0, 230

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...
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
is my solution correct? 3.15. Given the following data, calculate the projected available balance and the...

is my solution correct? 3.15. Given the following data, calculate the projected available balance and the planned MPS receipts. The lot size is 100. The demand time fence is 2 weeks. 4 2 3 Week 50 50 50 50 Forecast 25 30 65 60 Customer Orders 60 Projected Available Balance MPS 312 3. 15 demand time fence 2 wks lot siza = loo Week Fore cast Customer orders t0 30 Projactd Avaiabe Balano Cbo) 70 (00 LoD

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
3.15. Given the following data, calculate the projected available balance and the planned MPS receipts. The...

3.15. Given the following data, calculate the projected available balance and the planned MPS receipts. The lot size is 100. The demand time fence is 2 weeks. Week Forecast 50 50 Customer Orders 1 60 30 Projected Available Balance MPS
complete the table and then answer the multiple-choice questions. Handwritten solutions, can be submitted as pdfs....

complete the table and then answer the multiple-choice questions. Handwritten solutions, can be submitted as pdfs. Problem 1: MPS and ATP A partial table for end item B is provided below. Compute the MPS for item B and then the ATP values. Complete the table and then answer the multiple-choice questions: you need to complete the table to receive full credit (even if the answers to multiple-choice questions are correct). Item B Lead Time: 1 weeks Lot Size: 80 units...

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