A pharmaceutical company manufactures two drugs at Los Angeles and Indianapolis. The cost of manufacturing a pound of each drug depends on the location, as indicated in the file P13_42.xlsx. The machine time (in hours) required to produce a pound of each drug at each city is also shown in this table. The company must produce at least 1000 pounds per week of drug 1 and at least 2000 pounds per week of drug 2. It has 500 hours per week of machine time at Indianapolis and 400 hours per week at Los Angeles.

Hint: This problem has 4 decision variables and 4 constraints

I need to set up the excel for this problem. This is what I have so far but I don't know I am right... I need to fill the other values and then run the Solver Tool.

Given Inputs Constraints Drug 1 Drug 2 Drug 1 1000 Indianapolis Los Angeles Indianapolis Los Angeles Drug 2 2000 42. A pharmaceutical company manufactures two drugs at Los Angeles and Indianapolis. The cost of Unit cost $4.10 $4.00 $4.50 $5.20 achine time 0.20 0.24 0.30 0.33 Indianapolis 500 manufacturing a pound of each drug depends on the location, as indicated in the file P13 42.xlsx. LA 400 The machine time (in hours) required to produce a pound of each drug at each city is also shown in Decision Variables this table. The company must produce at least 1000 pounds per week of drug 1 and at least 2000 Drug 1 Drug 2 pounds per week of drug 2. It has 500 hours per week of machine time at Indianapolis and 400 Indianapolis Los Angeles Indianapolis Los Angeles hours per week at Los Angeles. Units Produced a. Determine how the company can minimize the cost of producing the required drugs. Workspace Indianapolis LA Machine Time = >= 1000 2000 Objective: Minimize Cost Total $