A 1 2 3 4 5 6 7 B C D E F G H I J K Postal worker scheduling Number starting Number available each 4-hour period 8 9 Number required 10 11 Total…

P04_46. NewAge Pharmaceuticals produces the drug NasaMist from four chemicals. Today, the company must produce 1000 pounds of the drug. The three active ingredients in NasaMist are A, B, and C. By weight, at least 8% of NasaMist must consist of A, at least 4% of B, and at least 2% of C. The cost per pound of each chemical and the amount of each active ingredient in1 pound of each chemical are given in the file P04_48.xlsx. It is necessary that at least 100 pounds of chemical 2 be used.a. Determine the cheapest way of producing today’s batch of NasaMist.b.Use solverTable to see how much the percentage of requirement of A is really costing New Age, Let the percentage required vary from 6% to 12%.—————————0000————————————–PO4-48.During each 4-hour period, the Smalltown police force requires the following number of on-duty police officers: 12 midnight to 4 A.M.- 8; 4 to 8 A.M. – 7; 8 A.M. to 12. noon. – 6; 12 noon to 4 P.M. – 6; 4 to 8 P.M. – 5; 8 P.M. to 12 midnight – 4. Each police officer works two consecutive 4-hour shifts. a)