What is the solution?

Question

A doctor's prescription calls for a daily intake containing 30 mg of vitamin C and 20mg of Vitamin D. Your pharmacy stocks two compounds that can be used: one contains 40% vitamin C and 30% vitamin D, the other 40% vitamin C and 20% vitamin D. How many milligrams of each compound should be mixed to fill the prescription?

Answer 1

This looks a bit like a minimization problem or linear programming problem. However, the problem doesn't ask for that?

Assume that you are trying to minimize the amount of compound 1 and compound 2 but be sure that you still get the required amount of Vitamin C & D.

Putting into EXCEL like that & using SOLVER, you get that you use 75 mg of Compound 1 and 0 mg of Compound 2 and end up with 30 mg of Vitamin C and 22.5 mg of Vitamin D.