Suppose that a company that manufactures cell phone coverage has a forecast for the next 4 weeks,
Question:
Suppose that a company that manufactures cell phone coverage has a forecast for the next 4 weeks, 43, 54, 35, and 22. The company has accepted orders for those weeks. The total units promised for the next few weeks are 45, 12, 10, and 5, for weeks 1, 2, 3, and 4, respectively. The company handles fixed batches of 35 units and maintains a safety stock of 15 units. Available inventory at the beginning of week 1 is 35 units. The planning horizon for this product is 4 weeks. Do the following: Clearly identify each item in your answer and evidence to receive credit for the answer on your work evidence and answer the following questions below.
a) Determine how many units are needed and in what period they are needed to meet the demand. Also include the ATP calculation. Copy your table and paste the table below.
b) Suppose that the first week passed and we are now in week 2. Also suppose that during week 1 the following happened: i. Orders were received and fulfilled for 5 additional units for period 1. (In addition to the 45 units promised in that period.) No further orders were received for the other periods. ii. What you planned to receive in the warehouse the first the first week was received in full. iii. Forecast received for week 5; the forecast is 34 units. Determine if you would change the requirements or "schedule" of the product calculated in part a. Copy your table and paste the table below.
c) Determine if you could promise the following orders by presuming everything you have in part b. Evaluate the orders one by one in the order they appear in the table (FIFO).