A small firm makes three similar products, which all follow the same three-step process, consisting of milling, inspection, and drilling. Product A requires 12 minutes of milling, 5 minutes for inspection, and 10 minutes of drilling per unit; product B requires 10 minutes of milling, 4 minutes for inspection, and 8 minutes of drilling per unit; and product C requires 8 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 $1.80 per unit to profit, B contributes $1.50 per unit, and C contributes $3.00 per unit. Determine the number of units of each product that should be produced in order to maximize profits for the next period.
Use excel output to answer the following
PRODUCTION QUANTITIES: SLACK:
A=_____________ Milling=_________________
B=_____________ Inspection=______________
C=_____________ Drilling=________________
Profits=_________