Hi! I am in a dreadful state today morning! I have the spreadsheet programming course exam today and I know a question very similar to this is coming in the exam but I can't seem to figure out the solution Sorry, I am panicking, but can someone post the code to solve this please? Total cost has to be minimized by sticking to the plant capacity and city demand constraints. The shipment values actually seen on the xls are the optimum values, and I am supposed to get those filled in using a VBA code for solver.
Sorry, I am embarassing myself totally on an exam day!
Thanks for the help!