Optimization Using Healthcare - Report
Added on 2020-05-28
9 Pages1334 Words149 Views
Running head: OPTIMIZATION USING HEALTHCAREOPTIMIZATION USING HEALTHCARE[Author Name(s), First M. Last, Omit Titles and Degrees][Institutional Affiliation(s)]
2OPTIMIZATION USING HEALTHCAREa.Taking into account the pharmaceutical company’s production plan in the manufacture of the two drugs at Indianapolis and Los Angeles, the company has to produce 200 pounds of drug 2 and 1000 pounds of drug 1. The excel sheet will this be implemented as followsPharmaceutical dataDrug 1Drug 2IndianapolisLos AngelesIndianapolisLos AngelesUnit cost$4.10$4.00$4.50$5.20Machine time0.200.240.300.33Units produced010001666334ConstraintsDrug 11000>=1000Drug 22000>=2000Time of MachineIndianapolis499.8≥500Los Angeles350.22≥400Total cost13233.8
3OPTIMIZATION USING HEALTHCAREChanging the cells in the spreadsheet, which the units of drug 1 and drug 2 are as produced in Indianapolis and Los Angles. In so doing;Constraints:Drug 1 units produced=B8+C8 Drug 2 units produced=D8+E8. Bearing in mind that the company has to produces 2000 pounds of drug 2 and 1000 pounds of drug 1, the following constraints would thus be applicable;Drug 1≥1000Drug 2≥2000The time of machine is thus calculated as;Indianapolis,B8×B6+D8×D6Los Angeles,C8×C6+E8×E6The provisions are such that the maximum time available at Los Angles is 400 while that at Indianapolis is 500[ CITATION Dav101 \l 1033 ]. This gives rise to the following constraints;Los Angeles≥400Indianapolis≥500The objective cell of the total cost is determined using the formula
End of preview
Want to access all the pages? Upload your documents or become a member.