Use excel.

Optimization: Your firm has the necessary licenses and can produce either or both of two products, Widgets and Super Widgets. Both are popular and, although you cannot change the price, you'll likely sell all you can make. You are constrained by labor hours (10 people x 8 hours per day x 20 working days per month), raw material (400 pounds per working day), and you can only produce in lots of 100 at a time. What should you produce next month? Attribute Super Widgets Widgets $39 Selling Price per 100 $59 Cost to Produce per 100 $30 $15 Labor Hours per 100 0.9 1 Material per 100 (pounds) 7.8 6.25