Repco produces three drugs, A, B and C, and can sell these drugs in unlimited quan22es at unit prices $8, $70, and $100, respec2vely. Producing a unit of A requires 1 hours of labor. Producing a unit of B requires 2 hours of labor and 2 units of A. Producing 1 unit of C requires 3 hours of labor and 1 unit of B. Any product A that is used to produce B cannot be sold, and any product B that is used to produce C cannot be sold. A total of 40 hours of labor are available. Repco wants to use LP to maximize its sales revenue. Objective To develop an LP spreadsheet model that relates production decisions to amounts required for production and amounts available for selling, and to use Solver to maximize sales revenue, subject to limited labor hours.
Write an appropriate mathematical model for this problem including Decision Variables and their description, Objective Function, & Constraints.