A company manufactures two products, A and B, on two machines, I and II. It has been determined that the company will realize a profit of $3/unit of Product A and a profit of $4/unit of Product B. To manufacture a unit of Product A requires 6 min on Machine I and 5 min on Machine II. To manufacture a unit of Product B requires 9 min on Machine I and 4 min on Machine II. There are 5 hr of machine time available on Machine I and 3 hr of machine time available on Machine II in each work shift. How many units of each product should be produced in each shift to maximize the company's profit? I need assistance with setting this up in excel and using solver.

I've written the objective equation as 3x+4y

Constraints:

6x +9y

5x + 4y

x>= 0

y>=0

Excel File Edit View Insert Format Tools Data Window Help Q Wed May 25 22:31 ... AutoSave . OFF A BE ? C ... Q1.Optimization Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) 12 A A 25 Wrap Text General Insert v Ex Delete v Paste B I U Merge & Center v $ ~ % " Conditional Format Cell Sort & Find & Analyze Formatting as Table Styles Format v Filter Select Data C13 X V fx =[6*B6+87*B7 A B C D E F G H K L M N O P Q R S T U 3 A company manufactures two products, A and B on two machines, I and II. It has been realized that... Amount of Amount of 15 Quantity Profit time 1 time 2 6 A 3 6 5 7 B LD Maximizing equation 8 Production constraint i Max R = 3A + 4 B 9 Production constraint II 10 11 Max profit Constraints 12 Total time Machine I 300 6A + 9B =0 B >= 0 21 Sheet1 + Ready + 100%