Instructions: Solve using Excel Solver. Create the linear programming model and get the optimal solution to the problem. (Follow the steps and format in the photo below)1. A company manufactures two products X1 and X2 on three machines A, B, and C. X1 requires 1 hour on machine A and 1hour on machine B and yields a revenue of Php 30. Product X2 requires 2 hours on machine A and 1 hour on machine B and 1 hour on machine C and yields revenue of PhP 50. In the coming planning period the available time of three machines A, B, and C are 2000 hours, 1500 hours and 600 hours respectively. Find the optimal product mix. FOR EACH PROBLEM, the following muct be Inoluded in your ancwer:1. Definition of deolcion variablec and LP model2. Boreenchot of input coreen (cimlar to the figure below)1 Eample3 Imput DutaProduct P1Product P2LHS TotasS Constants6 Obective Function7 Machine 18 Machine 29 Machine 310 Nonnegtivity3040800110011123 Dupur Reuts14IS Solution3. Soreenchot of Answer Report (eimilar to figure below; Inolude headinge withtimectamp)Taget CeCelNameOrignl va ial valCetentien HS TetahAdjustae cCrigial valu Final Vale00CellNameSIS SelutionaKS SokatenContrantsCelFormlaseS Not ngs rdng1 se BrdingNameStatanMaksOS Manes TotatSoda Machne 2S TetahMahS Total4. Conoluciondl

Decision Variables: Suppose, x be the amount of product x1 and y be the amount of product…

Answered: Instructions: Solve using Excel Solver.…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

100%

Instructions: Solve using Excel Solver. Create the linear programming model and get the optimal solution to the problem. (Follow the steps and format in the photo below)

1. A company manufactures two products X1 and X2 on three machines A, B, and C. X1 requires 1 hour on machine A and 1hour on machine B and yields a revenue of Php 30. Product X2 requires 2 hours on machine A and 1 hour on machine B and 1 hour on machine C and yields revenue of PhP 50. In the coming planning period the available time of three machines A, B, and C are 2000 hours, 1500 hours and 600 hours respectively. Find the optimal product mix.