This is basically, a WHATIF analysis with multiple constraints thereby overriding the goal-seek feature. I can use the solver tool pack to attain the required figures to minimize total cost, keeping all necessary constraints in mind.
I have used excel extensively as a data analyst and would love to leverage my expertise and aid your course.
Best Regards
Iheanyi