Please screenshot EXCEL with formulas and solver

Andrew Thomas Office Company (ATOC) has been producing and selling its goods in six product families: Folders, Note Pads, Legal Pads, Hanging Folders, Small Binders and Large Binders. Each product family requires production hours in each of three departments and ATOC only has 2,800 hours available in each department. Given the large volumes of each product family there are all produced in sets of 1,000 units.

In addition, each product family requires its own sales force, which must be supported no matter how large or small the sales volume happens to be if that product family is produced. The following table shows this fixed sales force cost, the profit per set and the demand in sets.

ATOCs management is wondering whether it should continue to produce and market all six product families.

b) How would this solution change if ATOC must order materials such that there is minimum production threshold for each product family (given in the data file) and that they must produce at least five of the product families? (10 points)

Hours Required per Set \begin{tabular}{|l|l|l|l|l|l|l|l|l|} \hline Department A & 3 & 4 & 6 & 4 & 6 & 8 \\ \hline Department B & 4 & 5 & 4 & 4 & 5 & 6 \\ \hline Department C & 3 & 3 & 2 & 5 & 6 & 9 \\ \hline \end{tabular} Additional Information for Part B Hours Required per Set \begin{tabular}{|l|l|l|l|l|l|l|l|l|} \hline Department A & 3 & 4 & 6 & 4 & 6 & 8 \\ \hline Department B & 4 & 5 & 4 & 4 & 5 & 6 \\ \hline Department C & 3 & 3 & 2 & 5 & 6 & 9 \\ \hline \end{tabular} Additional Information for Part B