this does not require linear programming to solve, are you sure this is all the information?
please post the excel file
use mediafire.com or wikisend and post the sharing link here
or if there is a paper clip icon on the box you are typing into you can use that to attach
that didn't work
I can mock up a linear programming solution in excel if that will be sufficient
please let me know