$(30$ points$)$ Refer to the figure given below. Station $19$ and Station $20$ are required to produce $30$ and $25$

units, respectively, by the end of the day. Assume there is no initial after$-$station inventory at each station

on the first day and there is no limit on the labor assignment at each station.

$($a$)$ Develop an excel spread sheet to complete the worker assignment table shown on next page.

$($b$)$ Use the excel spread sheet developed in $($a$)$ to complete the worker assignment table for the second

day assuming that the demands for Station $19$ and Station $20$ are equal to $40$ units on the second day.

Note that the after$-$station inventory from the first day will become the initial after$-$station inventory for

the second day for each station.