Analytics Exercise: The Pudding Manufacturing Aggregate Plan

$1.$ Prepare an aggregate plan for the coming year, assuming that the sales forecast is perfect. Use the spreadsheet template. There are two areas that you need to complete. Your solution is entered in rows $21$ and $22.$ The second area is where cost calculations are made. These calculations are in rows $33$ to $38.$ You must use formulas in these cells. $2.$ It is important that your spreadsheet calculations are set up so that any values in the number of lines and overtime days rows evaluates correctly. Your spreadsheet will be evaluated based on this. $3.$ Find a solution to the problem that goes beyond just minimizing cost. Prepare a short write$-$up that describes the process you went through to find your solution and that justifies why you think it is a good solution.