Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Tabard Industries forecasted the following demand for one of its most profitable

ID: 2748148 • Letter: T

Question

Tabard Industries forecasted the following demand for one of its most profitable products for the next 8 weeks: 140, 140, 140, 120, 120, 120, 60, and 60 unit The booked customer orders for this product, starting in week 1 are: 110, 70, 50, 40, 30, 20, 10, and 0 units. The current on-hand inventory is 250 units, the order quantity is 150 units, and the lead time is one week. a. Develop a MPS for this product. (Enter your responses as whole numbers. A response of "0" is equivalent to being not applicable.) b. The marketing department revised its forecast. Starting with week 1, the new forecasts are: 140, 140, 140, 140,140, 140, 120, and 120 units. Assuming that the prospective MPS you developed in part (a) does not change, prepare a revised MPS record. Comment on the situation that Tabard now faces. Recalculate the projected on-hand inventory for each week. (Enter your responses as whole numbers. A response of "0" is equivalent to being not applicable.) If the new forecasts are accurate, the MPS quantities (1) need to be revised. c. Returning to the original forecasted demand level and the MPS record you developed in part (a), assume that marketing accepted a new customer order for 200 units in week 2 and thereby booked orders in week 2 is now 270 units. Assuming that the prospective MPS you developed in part (a) does not change, prepare a revised MPS record. Comment on the situation that Tabard now faces. Recalculate the projected on-hand inventory for each week. (Enter your responses as whole numbers. A response of "0" is equivalent to being not applicable.) The MPS quantities (2) need to be revised. (1) will will not (2) will will not

Explanation / Answer

The Mps quantities will not be revised here in this case