Use This Information to Answer the Following Questions

Essay

Use this information to answer the following questions.
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:

-Refer to the table above.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.