How do I solve this problem? I need to use solver for the optimal product for Chapter $11$ homework. Curtis Manufacturing produces basketballs, soccer balls, and tennis balls. Manufacturing requirements are as follows: Profit per $1$ ball: Basketballs$($BB$)$ $$60,$ Soccer Balls$($SB$)$ $$50,$ and Tennis balls$($TB$)$ $$5.$ Abbreviations BB$,$ SB$,$ and TB used for the balls. Direct labor time per ball: BB $30$ minutes, SB $45$ minutes, and TB $3$ minutes. Machine A time per ball: BB $10$ minutes, SB $15$ minutes, TB $1$ minute. Machine B time per ball: BB $20$ minutes, SB $10$ minutes, TB $1$ minute. Minimum production each month $(1)$: BB $50,$ SB $100,$ TB $500.$ Maximum demand each month$(2)$: BB $300,$ SB $1500,$ TB $20000.(1)$ Minimum production is required to meet contract requirements with customers. $(2)$ Maximum demand is the most balls that can be sold in a month. Each month Curtis has $20,000$ direct labor hours available. Machine A is available $10,000$ hours per month. Machine B is available $8,000$ hours per month. Requirements: $1.$ Determine how many of each ball Curtis should manufacture to maximum profit each month. Remember to follow all items in the Excel Requirements document.