Assignment - Prod Plan \& Control Section A Aggregate planning: It is a technique by which an organization maintains the inventory to avoid the delays and wastage in the process Problem-1: Consider the following forecast data for EG Bottle Company: Given Data Develop three aggregate plans to determine the lowest cost of tank loads. Construct a table in Excel sheet for all three cases as shown below: Case 1. The details for strategy 1 , where Level production is supplemented by up to 10 tank loads a month from overtime. Develop a level production plan Case 2. Construct an aggregate plan as per strategy 2 where a combination of overtime, inventory and subcontracting is done to minimize the cost: Note: In case of doing an overtime irrespective of how many units, there will be an inventory in certain cases and the total cost of holding inventory and overtime is more than the subcontracting cost. So, overtime will not be used unless both the conditions are met i.e. there will be no inventory in the end of any period and demand is also satisfied. In such a case, the optimal decision is to subcontract Case3. Develop a production plan using overtime of up to 15 tank loads and inventory to handle variations as shown below: Note: In the June month a production of extra 5 units will be done to meet the demands of coming period in a way that no backorders/shortages exist