Solve the following questions and provide solutions in excel: 

Problem-1: Consider the following forecast data for EG Bottle Company: Period Forecast May June July August September October Total 50 60 70 90 80 70 420 Given Data Cost Table Regular production cost Regular production capacity Overtime production cost Subcontracting cost Holding cost Back ordering cost Beginning inventory Rs 1,500 per unit 40 tank loads/Period Rs 1,400 per tank loads Rs 1,700 per tank loads Rs 1,900 per unit per month Rs 6,000 per month per unit 0 units 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: