Problem
As the war goes on, your circumstances change. On the good side, you have more budget now. It increased from $1,800 to $2,400. Also, you found a second warehouse that allows you to double your available warehouse space from 21 to 42. But, the price you can charge for a ton of butter has dropped from $150 to $125. That's a big hit. Try putting these changes into the spreadsheet and then run solver to solve for B1. What happens? Your whole front while in France is as a farmer, so you must produce some agricultural products. If you don't, the other side will know you are up to something. Can you build in a constraint into solver that fixes the amount of butter you produce to at least 5 tons?