Please kindly solve question in excel and show the steps invloved.

Question 1: (100 points) A beer distributor wants to prepare an aggregate plan for the next 6 weeks. Demand can be met using regular time production, overtime production, or a combination of both as illustrated below: 1. Assume that beginning inventory is zero. Use Excel to formulate and solve this multiperiod production problem to minimize total costs. ( 60 points) 2. Assume that the beer distributor has the option of "subcontracting" beer cases to supplement the existing capacity. Subcontracting can handle a maximum of 5 cases per week. Subcontracting cost per case is $80. Also, due to an upcoming holiday season, the beer distributor wants to maintain a safety stock of at least 5 cases per week. Use Excel to formulate and solve this multiperiod production scheduling problem. (40 points)