What production schedule would be requested? What delivery could be given to the customer? When will you reach the inventory target?

1. What production schedule would be requested?


2. What delivery could be given to the customer?


3. When will you reach the inventory target?

Problem I Problem Satellite Dish 12 has the following criteria: a) Production lead-time is 90 days (from the end of the current month) b) In-transit time from the factory to the warehouse is 45 days c) Inventory goal is 1.5 months of inventory on hand and in-transit (total) d) Maximum production capacity is 3000 dishes per month…which is a max, less could be made A new customer order from Couch Potato Inc. is received on March 31, 2012 for 2,000 dishes per month starting July 01, 2012 for a total of 23,000 pieces. The customer requests that as much is shipped as possible as soon as possible. A. Generate an Excel spreadsheet to show: 1. What production schedule would be requested? 2. What delivery could be given to the customer? 3. When will you reach the inventory target?