| Are the drug companies MRK, PFE, AZN, LLY, GSK and BMY shifting spending from R&D to sales? | | Data source is http://finance.yahoo.com/q/is?s=MRK&annual, and also PFE, AZN, LLY, GSK, and BMY in some-year the companies spent altogether $M some-RD-sum on R&D in that-year the companies spent altogether $M some-sum on sales and admin that-RD-sum / that-sum = a-long-ratio that-long-ratio rounded to 2 place(s) after the decimal point is some-amount --------------------------------------------------------------------------------------------------------------- in that-year the ratio of R&D spend to sales spend was altogether that-amount (MRK, PFE, AZN, LLY, GSK and BMY) we have data for some-year sum a-sales-amount : in some-year some-company spent $M some-RD-amount on R&D and $M some-sales-amount on sales and admin = a-sum ------------------------------------------------------------------------------------------------------------------------------------ in that-year the companies spent altogether $M that-sum on sales and admin we have data for some-year sum an-RD-amount : in some-year some-company spent $M some-RD-amount on R&D and $M some-sales-amount on sales and admin = an-RD-sum ------------------------------------------------------------------------------------------------------------------------------------ in that-year the companies spent altogether $M that-RD-sum on R&D in some-year some-company spent $M some-RD on R&D and $M some-sales-amount on sales and admin ---------------------------------------------------------------------------------------------- we have data for that-year in some-year some-company spent $M some-RD on R&D and $M some-sales-amount on sales and admin in that-year that-company made gross profit $M some-profit on revenue of $M some-rev-amount that-RD is some-RDpc % of that-profit that-sales-amount is some-sales-pc % of that-profit ----------------------------------------------------------------------------------------------- in that-year that-company spent that-RDpc % of gross profit on R&D and that-sales-pc % on sales some-amount1 / some-amount2 = a-ratio that-ratio * 100 = a-long-pc that-long-pc rounded to 2 place(s) after the decimal point is some-pc ------------------------------------------------------------------- that-amount1 is that-pc % of that-amount2 in this-year this-company made gross profit $M this-profit on revenue of $M this-amount ======================================================================================= 2003 MRK 18171 22486 2004 MRK 17979 22939 2005 MRK 16862 22012 2003 PFE 35356 45188 2004 PFE 44975 52516 2005 PFE 42773 51298 2003 AZN 14443 19074 2004 AZN 16633 21960 2005 AZN 18594 23950 2003 LLY 9907 12582 2004 LLY 10634 13858 2005 LLY 11171 14645 2003 GSK 30185 38266 2004 GSK 30922 39224 2005 GSK 29075 37273 2003 BMY 13302 20894 2004 BMY 13391 19380 2005 BMY 13279 19207 in this-year this-company spent $M this-RD on R&D and $M this-amount on sales and admin ======================================================================================= 2003 MRK 3178 6395 2004 MRK 4010 7346 2005 MRK 3848 7155 2003 PFE 7131 15242 2004 PFE 7684 16903 2005 PFE 7442 16997 2003 AZN 3451 6941 2004 AZN 3858 7889 2005 AZN 3429 8801 2003 LLY 2350 4055 2004 LLY 2691 4284 2005 LLY 3025 4497 2003 GSK 4964 13405 2004 GSK 5470 14606 2005 GSK 5396 12465 2003 BMY 2279 6076 2004 BMY 2500 6427 2005 BMY 2746 6619 | This file is an application written in the language Executable English. | You can view, run and change it by pointing a browser | to www.reengineeringllc.com and selecting DrugCompaniesRandD.