please solve using solver in excel and show work/ steps so I can better understand the problem. thank you

9. A small firm makes three similar products, which all follow the same three step process, consisting of milling, inspection, and drilling Product requires 12 minutes of milling, 5 minutes for inspection, and 10 minutes of drilling per unit product requires 10 minutes of milling, 4 minutes for inspection, and 8 minutes of drilling per unit and product requires 3 minutes of milling. 4 minutes for inspection, and 16 minutes of drilling. The department has 20 hours available during the next period for milling. 15 hours for inspection, and 24 hours for drilling Product A contributes $2.40 per unit to profit, product B contributes $2.50 per unit, and product contributes $3.00 per unit Determine the optimal mix of products in terms of maximizing contribution to profits for the period. Then, find the range of optimality for the profit coefficient of each variable 10. pepe 849