Prepare a report addressing the questions you may use excel to generate your solutions and add the S&OP plans in your report.

1. Aggregate Planning at Green Mills (Ivey) (S&OP) a) Determine the workforce and production schedule based on a level policy, a chase policy and a mixed policy that meet the forecasted demand at minimum total cost. b) Present a cost comparison between the three plans and recommend the most attractive option based on minimizing total costs. c) Perform a sensitivity analysis on the following based on the mixed policy: i. Hiring costs increase by 25 percent ii. Inventory costs increase by 25 percent iii. Spot market prices decrease by 10 percent d) Which one of the constraints has the largest impact on the case? e) Define the term "under-time" within the context of this case. f) Discuss some of the advantages and disadvantages of the level and chase policies. g) Discuss the impact of economies of scale on this application.