Note that the data from P04_48.xlsx is already put into the attachment in the spreadsheet. I'm wondering why I keep getting the 55% in cell C34 instead of 0.55 which is what it should be. How do I fix this? I know this is the case because you can see that the cells around C34 are decimals (B34 is .77 and D34 is .33)

NewAge Pharmaceuticals produces the drug NasaMist from four chemicals. Today, the company must pro- duce 5000 pounds of the drug. The three active ingre- dients in NasaMist are A, B, and C. By weight, at least 7% of NasaMist must consist of A, at least 5% must consist of B, and at least 3% must consist of C. The cost per pound of each chemical and the amount of each active ingredient in one pound of each chemical are given in the file P04_48.xlsx. At least 600 pounds of chemical 3 must be used.

a. Determine the cheapest way of producing todays batch of NasaMist. b. Use SolverTable to see how much the percentage of requirement of B is really costing NewAge. Let the percentage required vary from 3% to 8%.

021 A 1 Producing drugs 2 3 Cost/lb of chemicals 4 Chemical 1 5 Chemical 2 6 Chemical 3 Chemical 4 7 8 9 Ingredient/lb of chemical 10 11 Chemical 1 12 Chemical 2 13 Chemical 3 14 Chemical 4 15 16 Required percentages of ingredients 17 18 19 20 Production plan 21 22 Chemical 1 23 Chemical 2 24 Chemical 3 25 Chemical 4 26 Total 27 3285258 29 31 32 Actual 30 Percentage constraints (expressed in lbs) 33 34 Required x fx 36 Cost 37 130 Ready P4-46 B P4-48 $10 $11 $14 0.06 0.1 0.12 0.03 Lbs used 3 11 A 58 1.01 $113 0.77 A A P4-50 21 0.52 55.00% B 0.04 0.03 0.09 0.02 B P4-50 part B D Required 0.35 600 5000 0.33 0.01 0.04 0.04 0.01 C P4-50 part C P 021 1 Producing drugs 2 x fx Cost/lb of chemicals 4 Chemical 1 5 Chemical 2 6 Chemical 3 7 Chemical 4 8. 9 Ingredient/lb of chemical 10 11 Chemical 1 12 Chemical 2 13 Chemical 3 14 Chemical 4 15 16 Required percentages of ingredients 17 18 19 20 Production plan 21 34 Required 35 A 22 Chemical 1 23 Chemical 2 24 Chemical 3 25 Chemical 4 26 Total 27 28 29 30 Percentage constraints (expressed in b 31 33 Actual 33 36 Cost 37 0.06 0.1 011 SUMB22 825) Lbs used Ing Functions 0.04 003 01.09 0.0 nes Manager Create from Selection SUPRODUCT HI HA 30322302 TUAN HOOUCTICECIA,3032250929) -818-58526 -C18-58526 das GIN 168 dependents Show Error Walch Remove Arrows Formulas Checking Window Required HUMHOOUCTIOLE A,S652218825). 01859526) 021 1 Producing drup 2 Cost of chemicals 4 Chemical 1 Chemical 2 Chemical 3 7 Chemical 4 9 ingredient/lb of chemical 10 11 Chemical 1 12 Chemical 2 13 Chemical 3 14 Chamical 4 38 15 16 Required percentages of ingredients 17 19 20 Production plan 21 22 Chemical 1 23 Chemical 2 24 Chemical 3 25 Chemical 4 26 Total 27 28 29 A 30 Percentage constraints (expressed in b 31 32 Actual 31 14 Required 12 16 Cat 37 34 BLA BAJA SUMB22 825) 818 58526 Time Reference 56.40 HAUMPRODUCT4AF,822 825) Lbs used More Trig Functions SUMPRODUCTOS3814.58522 58525) SUMPRODUCTIC11C14,5852258525) 504 0.01 0.09 0.05 Name Manager Create from Selection C150526 0.04 Trace Dependents Ax lod Remove Arrow Formulas Checking Window Show Error Watch 01858524) Required I CUA CLAh p143522-23 C Calculation Options dy eine duty it the help lease. Mark 021 A 1 Producing drugs 2 3 Cost/lb of chemicals 4 Chemical 1 5 Chemical 2 6 Chemical 3 Chemical 4 7 8 9 Ingredient/lb of chemical 10 11 Chemical 1 12 Chemical 2 13 Chemical 3 14 Chemical 4 15 16 Required percentages of ingredients 17 18 19 20 Production plan 21 22 Chemical 1 23 Chemical 2 24 Chemical 3 25 Chemical 4 26 Total 27 3285258 29 31 32 Actual 30 Percentage constraints (expressed in lbs) 33 34 Required x fx 36 Cost 37 130 Ready P4-46 B P4-48 $10 $11 $14 0.06 0.1 0.12 0.03 Lbs used 3 11 A 58 1.01 $113 0.77 A A P4-50 21 0.52 55.00% B 0.04 0.03 0.09 0.02 B P4-50 part B D Required 0.35 600 5000 0.33 0.01 0.04 0.04 0.01 C P4-50 part C P 021 1 Producing drugs 2 x fx Cost/lb of chemicals 4 Chemical 1 5 Chemical 2 6 Chemical 3 7 Chemical 4 8. 9 Ingredient/lb of chemical 10 11 Chemical 1 12 Chemical 2 13 Chemical 3 14 Chemical 4 15 16 Required percentages of ingredients 17 18 19 20 Production plan 21 34 Required 35 A 22 Chemical 1 23 Chemical 2 24 Chemical 3 25 Chemical 4 26 Total 27 28 29 30 Percentage constraints (expressed in b 31 33 Actual 33 36 Cost 37 0.06 0.1 011 SUMB22 825) Lbs used Ing Functions 0.04 003 01.09 0.0 nes Manager Create from Selection SUPRODUCT HI HA 30322302 TUAN HOOUCTICECIA,3032250929) -818-58526 -C18-58526 das GIN 168 dependents Show Error Walch Remove Arrows Formulas Checking Window Required HUMHOOUCTIOLE A,S652218825). 01859526) 021 1 Producing drup 2 Cost of chemicals 4 Chemical 1 Chemical 2 Chemical 3 7 Chemical 4 9 ingredient/lb of chemical 10 11 Chemical 1 12 Chemical 2 13 Chemical 3 14 Chamical 4 38 15 16 Required percentages of ingredients 17 19 20 Production plan 21 22 Chemical 1 23 Chemical 2 24 Chemical 3 25 Chemical 4 26 Total 27 28 29 A 30 Percentage constraints (expressed in b 31 32 Actual 31 14 Required 12 16 Cat 37 34 BLA BAJA SUMB22 825) 818 58526 Time Reference 56.40 HAUMPRODUCT4AF,822 825) Lbs used More Trig Functions SUMPRODUCTOS3814.58522 58525) SUMPRODUCTIC11C14,5852258525) 504 0.01 0.09 0.05 Name Manager Create from Selection C150526 0.04 Trace Dependents Ax lod Remove Arrow Formulas Checking Window Show Error Watch 01858524) Required I CUA CLAh p143522-23 C Calculation Options dy eine duty it the help lease. Mark