A "Simple" Aggregate Planning Problem - Ip to 7 or 5 evtra pts/curve for exam 1. The demand for the next twelve-month period for XYZ. Inc is given as: The unit cost is $10 and production change (variation) cost is $2 per unit (consider this a proxy for hiring. training. firing costs). The back order (shortage) cost is $5 per unit per month, and the inventory cost is $1 per unit per month (use ending inventories for costing). Develop a spreadsheet to find the lowest cost production plan. Note: The total production must equal to the total demand (9753=9753) and there should not be any inventory or backlog at the end of period 12 . Use the following test figures to check the accuracy of your Excel setup. A "Simple" Aggregate Planning Problem - Ip to 7 or 5 evtra pts/curve for exam 1. The demand for the next twelve-month period for XYZ. Inc is given as: The unit cost is $10 and production change (variation) cost is $2 per unit (consider this a proxy for hiring. training. firing costs). The back order (shortage) cost is $5 per unit per month, and the inventory cost is $1 per unit per month (use ending inventories for costing). Develop a spreadsheet to find the lowest cost production plan. Note: The total production must equal to the total demand (9753=9753) and there should not be any inventory or backlog at the end of period 12 . Use the following test figures to check the accuracy of your Excel setup