1. set up an integer programming model 2. building an aggregate planning spreadsheet via solver 3. building a simple aggregate planning spreadsheet 4. creating a rough master production schedule Apply aggregate planning methodologies on dry native food. The Red Center has six processed native food products at its manufacturing plant, this assignment aims to provide the general manager a series of aggregate units. Red Center sells each (aggregate) try food through retailers for $40/unit. The company has a starting inventory in January of 1,000 stocks. At the beginning of January, the company has a workforce of 80 employees. The plant has a total of 20 working days in each month, and each employee earns $4 per hour regular time. There is a labour rul: no employee works more than 10 hours of overtime per month. Red Center has necessary information to process aggregate planning: