Need help with problem 11

profilelsctt7
1.
value:
10.00 points
 
 

Problem 11-20

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 a production lot size of 70 pumps is used. (Leave no cells blank - be certain to enter "0" wherever required.)


 

 

June

 

July

  64      1   2    3     4     5    6  7  8
  Forecast30     30     30     30      40     40     40     40     
  Customer orders (committed)33     25     16     11      8     3       
  Projected on-hand inventory[removed]     [removed]     [removed]     [removed]      [removed]     [removed]     [removed]     [removed]     
  MPS[removed]     [removed]     [removed]     [removed]      [removed]     [removed]     [removed]     [removed]     
  ATP[removed]     [removed]     [removed]     [removed]      [removed]     [removed]     [removed]     [removed]     


 

    • 10 years ago
    • 3
    Answer(3)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      11-20.docx
    • attachment
      11-20.pdf

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      problem_11-20.xlsx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      problem_11-20.xlsx