In the spreadsheet attached to this assignment, you have the monthly demand for the first half of 2022 (remember the demand planning homework?) for each of the three product lines. Additionally, I have provided you with a table that shows the relative outputs of all five employees depending on which line they are operating. Its important to note some deviations from real life: first, we assume every employee can work on every line; second, that they have constant outputs, with the principal employees per line setting the standard output and each additional employee being able to produce half of the standard; third, we assume demand is fixed to our projection instead of fluctuating as the year progresses. Assign the number